Thursday 29 November 2007
Oracle BI - using Oracle ODBC driver
It seems that name of the connection pool has to be the same as the tnsnames entry if you are using the Oracle ODBC driver with Oracle BI. If it is different then all appears to be OK when using the administration tool but all falls apart when you try and run a report with cannot find entry in tnsnames. Put an entry in the relevant tnsnames.ora file which the same as the connection pool name and it all magically starts working. Good eh?
Oracle BI - using Oracle ODBC driver
It seems that name of the connection pool has to be the same as the tnsnames entry if you are using the Oracle ODBC driver with Oracle BI. If it is different then all appears to be OK when using the administration tool but all falls apart when you try and run a report with cannot find entry in tnsnames. Put an entry in the relevant tnsnames.ora file which the same as the connection pool name and it all magically starts working. Good eh?
Thursday 1 November 2007
Oracle Data Miner
I've been trying to get Oracle Data Miner and it's demo database installed.
It would help if I read things before diving in with both feet. To get it going I first installed XE on my PC to discover that it only works with enterprise version of Oracle so I installed 11g to dicover that version 10.2. of data miner only works with version 10.2 of the database
It would help if I read things before diving in with both feet. To get it going I first installed XE on my PC to discover that it only works with enterprise version of Oracle so I installed 11g to dicover that version 10.2. of data miner only works with version 10.2 of the database
Subscribe to:
Posts (Atom)