Expert Status on OTN

Kranthi K has been kind enough to create a special OTN Forum item because of the fact I have reached the ‘Expert’-level status. Thanks Kranthi for doing this. It’s nice to see when people are appreciating the things you do.

Unfortunately I had to change my email-address lately. I thought that wouldn’t be a problem. Wrong!! When you change your email-address, Oracle creates a new profile for you. So my old ‘Expert’-profile looks like this:

I used to be a person, but I am a number now………….

As from now on I have a second profile. I am a name again…….but a ‘Newbie’.

Hopefully those two profiles can be merged. Otherwise I will have a long way to go, to reach the ‘Expert’-level status again. I might be the first one reaching this level twice.

Connect to the Database from Oracle BI 11g

I ran into the following issue when I upgraded from Oracle BI 10g to Oracle BI 11g. Although the upgrade went smoothly, all of a sudden I was not able to reach the database anymore. After doing some research on the internet I stumbled upon the following thread on OTN.

The main difference between Oracle BI 10g and Oracle BI 11g is the fact that Oracle BI 11g has it’s own Oracle_Home.

Thanks to Dirk and Venkat for the possible solutions:

1.

navigate to; {ORACLE_INSTANCE}\bifoundation\OracleBIApplication\coreapplication\setup,

alter user.cmd or user.sh depending on your OS,

set your TNS_ADMIN location to point to; {MIDDLEWARE_HOME}\Oracle_BI1\network\admin

2.

Copy your tnsnames.ora to {MIDDLEWARE_HOME}\Oracle_BI1\network\admin directory

3.

Use the full expanded tnsnames as shown below and use this one as the datasource name in your Connection Pool:

(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = host_name/ip_address)(PORT = port_number))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = service_name)))