(SOLVED) Cannot import oracle data sources to Framework Manager

[bonniehsueh]

Hi All,
I have C10.1.1 Framework Manager 32bit installed. I can connect to the environment with no issues, however, cannot import any Oracle data sources. I have a 64 bit laptop running windows 7. Oracle Client 10.2.0

I can access and query the Oracle databases from sql developer. This suggests to me that my tns names files is correct.
Installed Framework into the Program Files directory instead of the Program Files (x86) (not sure if this matters)
I can run reports that use this data source. This tells me that my login has read access to this data source. Not sure if importing data sources from Framework needs additional rights other than read.
Created a Java_Home variable C:\oracle\product\10.2.0\client_1
Checked if the 32 bit or 64 bit oracle client was installed by seeing if there is lib directory or both a lib and a lib 32 directory in Oracle Home. The 32 bit was installed.
Rebooted each time after steps above.

After trying all the steps, I still get the error below. Can import Cognos cubes with no issues.

QE-DEF-0285 The logon failed.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
EPDB_DS

UDA-SQL-0031 Unable to access the "EPDB_DS" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
UDA-SQL-0532 Data Source is not accessible: "epdbdvp2.world".
ORA-12154: TNS:could not resolve the connect identifier specified

Any ideas are appreciated!

[MFGF]

Hi,

It sounds like the TNSNAMES.ORA file on your FM machine might not be correctly defined? The fact that you can run reports ok means that it is properly set up on your Cognos server, but FM connects directly from the FM machine, so you need the same 32-bit Oracle client and TNSNAMES.ORA on your FM machine too.

Cheers!

MF.

[bonniehsueh]

Hi MFGF,

It sounds like the TNSNAMES.ORA file on your FM machine might not be correctly defined? The fact that you can run reports ok means that it is properly set up on your Cognos server, but FM connects directly from the FM machine, so you need the same 32-bit Oracle client and TNSNAMES.ORA on your FM machine too.

Thank you for your response. I have already confirmed that my tnsnames file has the correct connection string as I can write queries against theses databases using sql developer (like TOAD) with no issues. This tool would not work without the correct tnsnames file.  I also confirmed that its a 32 bit Oracle client as per my post. Any other ideas?

[blom0344]

Perhaps Cognos has a problem with the SID definition  as SID.World instead of SID  .  You should check the SQLNET.ORA file for an entry like :  NAME.DEFAULT_ZONE = world  
SQL developer will not have any problems with either syntax, which is why you can connect through this and fire queries against the database..

[bonniehsueh]

Thanks for your response Blom! You were close. It was related to the sqlnet.ora file.

Issue Solved. Turns out the sqlnet.ora file was named sqlnet.ora with the extension as .ora, resulting in being sqlnet.ora.ora instead of sqlnet.ora. I found earlier that these files had a type of backup which may have occurred while copying and pasting over these configuration files.  I tried to modify the file so that the file type would be ORA which I was succesful at changing the file type but used an incorrect file name. Lesson learned is to check the extension and the file name.

Thanks to all for your help!

[Grim]

Awesome, good to hear. If you could take a second and edit your original post and add (SOLVED) to the title that would be great!
:)

[sakthivelmani]

Hi MFGF,

I have Oracle Client installed on a C drive and because i had some issue with the framework manager, i re-installed it on D drive. My framework manager freezes when i try to select the datasource. Does it freeze because i have Oracle and Framework manager installed on different directories ? But I can ping the database from the cmd prompt. Please help me


Thanks

[MFGF]

Hi MFGF,

I have Oracle Client installed on a C drive and because i had some issue with the framework manager, i re-installed it on D drive. My framework manager freezes when i try to select the datasource. Does it freeze because i have Oracle and Framework manager installed on different directories ? But I can ping the database from the cmd prompt. Please help me


Thanks

I guess it's looking in the wrong place for the client? It's ok to have them on different drives - but your config has to reflect this. Have you checked PATH?

MF.

[sakthivelmani]

Thank you, MFGF . Could you please tell me where should i check the PATH ? I looked at the Cognos configuration and all i see is Gateway URI and Dispatcher URI.

Thanks again,
Sakthi

[MFGF]

Thank you, MFGF . Could you please tell me where should i check the PATH ? I looked at the Cognos configuration and all i see is Gateway URI and Dispatcher URI.

Thanks again,
Sakthi

I'm referring to the PATH environment variable - the Oracle bin directory should be included in it.

Take a look at the document below for troubleshooting Oracle connection issues:

http://www-01.ibm.com/support/docview.wss?uid=swg21341734

Cheers!

MF.

[sakthivelmani]

Thank you, MFGF. I will read them