TM1 9.1.4 64bit Oracle Drivers

[shorsted]

Hi

We are about to upgrade from v8.4.5 32bit to v9.1.4 64bit on a windows 2003 64bit server (x64) and are in the process of getting the machine setup and everything installed ready to go live next week.

We are however having some difficulty getting the Oracle ODBC drivers installed. We need either 9 or 10 client I am aware that we need to install the 32bit drivers but there seems to be some problem installing these on a 64bit server.

Has anyone experienced this and had similar issues which they have managed to resolve?

Many thanks
Sarah Horsted
TM1 Developer
RBS Insurance

[mattgoff]

Can you be more specific about the problems? What have you tried and where is it going wrong?

Matt

[shorsted]

Hi Matt

The steps we've taken are:

Installed oracle client 9.2 to e:\oracle\ora92 on 64bit server
Copied correct tnsnames and sqlnet to ora92\network\admin (64 bit odbcad can correctly create connections for Oracle)
Unpacked instant client basic and odbc to e:\oracle\instantclient
Executed odbc_install.exe (at this point the driver is listed correctly in 32bit odbcad)
Added tns_admin as an environment variable to point to ora92\network\admin (this correctly lists the names within the odbcad application)
Added the instant client directory to the path environment variable
Also added network\admin to this directory and every entry for tns_admin found in the registry just in case

This results in the following error when testing a connection:

12154 Could not resolve the connect identifier specified

Many thanks
Sarah

[mattgoff]

Try putting a second copy of the TNS file in e:\oracle\ora92. I recall struggling a bit to get this sorted. Is ORACLE_HOME set too?

Matt

[shorsted]

Thanks Matt

We now have the connection working within ODBCad32 but TM1 is still struggling to connect to it. It does appear to be thinking about it now but it still doesn't connect

in order to get it to connect using the test connection involved appending the default name to the tns names entry in the tnsnames file eg database.domain

So although it feels like we are making progress TM1 will still not connect and we are supposed to be going liveon Wednesday evening! I have raised a service request with Cognos but am yet to get a response so will be chasing them today.

Regards
Sarah

[mattgoff]

Hi Sarah,

Just read back through the thread again. Did I read correctly that you're installing 64-bit TM1 on a 64-bit Windows server but installing the 32-bit Oracle driver? If so, that's likely the problem-- you want the 64-bit drivers. The "bitiness" of the driver should match that of the local "client"-- in this case the TM1 server. It doesn't matter what the Oracle server is running.

Matt

[KevinB]

I am having the exact same problem and could use some help.

I am installing TM1 9.1.4 (x64) on Windows 2003 Server x64 and have had major issues with ODBC processes in Turbo Integrator.

The Oracle DB I am connecting to is 9i and I downloaded and installed the Instant Client Package - Basic 10.2.0.3 and then the ODBC package (the same version). TM1 is connecting to Oracle and the query is being executed. However, the TM1 Process hangs for a very long time even though the query has finished. For example. I ran a query in Oracle that took less then a second to fetch 800 rows and then ran the process in TM1 and it took 5 minutes for the process to complete. I am getting the data into TI but the time it takes is crazy. I have the same processess running on a 32bit server and it takes less than a second to finish.

Any ideas?

~Kevin