I am working on a new cognos install. I finally have the server up and running and I have created and tested the datasource connection to our oracle 11g database just fine from the web interface. RHEL three tier setup, gateway 32bit, app 64bit, cm64bit.
I have installed Framework Manager along with oracle instant client on my PC. Cognos confiuration saves fine.
When I create a new project, login, select language, then select my data source I get the following error.
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
KCDEV31
UDA-SQL-0031 Unable to access the "KCDEV31" database.
UDA-SQL-0107 A general exception has occurred during the operation "attach".
ORA-12170: TNS:Connect timeout occurred
I have oracle configured with TNS_ADMIN set to the location of my tnsnames.ora file.
Any ideas on how to fix this?
We found our issue it was a problem with the oracle client install on the 64bit machine. We moved our install to a 32bit machine to make things simple and it installed the first time without issue. Install Java, Install oracle 11g client, add env variables for both, install Framework Manager and it worked fine.