Category Archives: Uncategorized

Date in ISO8601 Format in Oracle DB

Below the code example how to get date format as ISO8601. First example is current time zone. Second example is valid if your database is actually in UTC time zone.

SELECT to_char(SYSTIMESTAMP, 'YYYY-MM-DD"T"HH24:MI:SS.FF6TZH:TZM') AS ISO8601 FROM dual;
SELECT to_char(SYSTIMESTAMP, 'YYYY-MM-DD"T"HH24:MI:SS.FF6"Z"') AS ISO8601_UTC_format FROM dual;

How Different RAM Consumption OBIEE11g by Installation Type

As we all know OBIEE 11g has three install types: Simple Install, Enterprise Install, Software Install.

We had low end PC with 2GB RAM and RHEL6 and OBIEE Standard Editon One Licence 11.1.1.7.0 64bit linux.  So we had to make decision which install type to use to stay minimal.

Here are results for OBIEE + Publisher only installation. No EssBase or Real Time Decisions:

Enterprise Install consumes less RAM than Simple Install – by ~200 MB. Would be nice to prove with more tests. That’s a bit controversy as enterprise install has node manager running, extra managed server running. So it’s at least two more services running than Simple Install case.

Enterprise Install

=0.172+1.5+4.1+1.3+15+9.8+0.684=32.556 MB

=0.004+3.1+0.004+696.7+0.004+408.2=1108.012 MB

Total = 1140 MB

Simple Install

=0.008+1.7+0.852+8+23.4+1.7+6.7=42.36 MB

=0.044+0.044+1300=1300.088 MB

Total = 1343.14 MB

Kaip importuoti egzistuojančias lenteles į Oracle Warehouse Builder

Į Oracle Warehouse Builder 10g importuoti lenteles tenka, kai lentelės sukuriamos per SQL skriptus, o ne per OWB įrankį. OWB11g versijoje labai panašiai vyksta lentelės importas. Daroma prielaida, kad lentelė jau yra duomenų sandėlio schemoje.

Atsidarome Design Center. Ant duomenų sandėlio duomenų bazės modulio spaudžiame dešinį ir Import…

image

Atsidariusiame lange spausti Next>

image

Palikti pažymėta tik Tables ir “Use a synonym to lookup objects”. Bus atrinktos tik lentelės. Spausti Next>

 image

Išskleisti šaką “Tables” ir sąraše surasti norimą lentelę. Šiuo atveju TIME_DIMENSION

image

Permesti pažymėtą lentelę į dešinę pusę ir spausti Finish

image

Lentelė įkeliama

image

Įkėlimo būsenos langas. Spaudžiamas OK

image

Lentelė atsiranda duomenų sandėlio modulio lentelių sąraše.

image

Dabar ją reikia sukonfigūruoti, kad nebūtų iš naujo diegiama į schemą. Apsisaugome nuo sukurtos lentelės ištrynimo ar perrašymo. Ant lentelės spaudžiame dešinį ir Configure…

image

Nuimame varnelę ties Deployable. Ši lentelė bus matoma ir galima naudoti OWB projekte, bet ji nebus diegiama iš OWB įrankio, nes ji buvo sukurta per SQL skriptus.

image

Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to da tabase unique name

emctl status dbconsole command gives error “Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name”. How to fix this error? Add environment variable.

Go to Start > Control Panel > System

image

On the left press Advanced System Options

image

Go to Environment Variables…

image

Pres New…

image

Enter Variable name “ORACLE_UNQNAME” and Variable value “orcl”. Variable value you can find in Control Panel > Services list. Find service OracleServiceXXX, where suffix XXX is your Oracle service name. This suffix goes as environment variable value.

image 

In New System Variable dialog box press OK. In Environment variables window press OK. In System Properties window press OK. Close System window in Control Panel.

Start command window again and enter command

echo %ORACLE_UNQNAME%

Output line should show

ORCL

How to Determine Number of Sockets for OBISE1

One of Oracle Business Intelligence Standard Edition One requirements (or limitations) is max 2 socket server. How to determine that? On windows machines I run WinAudit program. In summary page “Number of processors” it shows physical number of CPU, that means physical number of sockets. However, I know that I have two cores 🙂 So, I think program shows correct information.

image

Two cores in one socket CPU:

image