Data Source Connection Test Failure
I am doing a POC of Insight on Windows 2008 x64 Server. I installed Oracle 11g EE database, then Rational Insight 1.0.1.1 with all the options on the same server. The installation was successful. However, whe I tested the data source connection to RIDW using the rptusr logon, it failed. The error message is:
QE-DEF-0285 The logon failed.
QE-DEF-0385 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attch to 1 database(s) in testDataSourceConnection
UDA-SQL-0432 Unable to locate the gateway cogudaor
I googled the web and found some info that suggested the "Unable to locate the gateway cogudaor " error was because I didn't install Oralce client. I installed Oracle client and restarted the server. But still got the same error.
I guess I need to change the configuration somewhere. Can someone help me on this?
Many thanks in advance.
QE-DEF-0285 The logon failed.
QE-DEF-0385 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attch to 1 database(s) in testDataSourceConnection
UDA-SQL-0432 Unable to locate the gateway cogudaor
I googled the web and found some info that suggested the "Unable to locate the gateway cogudaor " error was because I didn't install Oralce client. I installed Oracle client and restarted the server. But still got the same error.
I guess I need to change the configuration somewhere. Can someone help me on this?
Many thanks in advance.
2 answers
I am doing a POC of Insight on Windows 2008 x64 Server. I installed Oracle 11g EE database, then Rational Insight 1.0.1.1 with all the options on the same server. The installation was successful. However, whe I tested the data source connection to RIDW using the rptusr logon, it failed. The error message is:
QE-DEF-0285 The logon failed.
QE-DEF-0385 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attch to 1 database(s) in testDataSourceConnection
UDA-SQL-0432 Unable to locate the gateway cogudaor
I googled the web and found some info that suggested the "Unable to locate the gateway cogudaor " error was because I didn't install Oralce client. I installed Oracle client and restarted the server. But still got the same error.
I guess I need to change the configuration somewhere. Can someone help me on this?
Many thanks in advance.
Insight only supports 32bit Oracle client. So if you need use Oracle11g 64bit server to store data warehouse, you also need install Oracle32bit client in same computer. Then create listner in oracle server, and create create name service in oracle client. After all, you could use data manager to connect oracle32bit client firstly, and oralce32bit client connects oracle64bit server.
Thanks for the reply, Wei. The 64 bit client indeed was the issue. I uninstalled the 64 bit Oracle client, installed the 32 bit Oracle client, created the listener for the SAMPLEDW database, then restarted the server. The data source connection is now working, and I can run the sample reports. Problem solved.
May I suggest that the Insight Installation Guide be updated to capture this requirement? The Insight installation guide doesn't say that only 32 bit Oracle client is supported.
http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/index.jsp?topic=%2Fcom.ibm.rational.raer.install.doc%2Ftopics%2Ft_prereq_reportalserver.html
Thanks again.
May I suggest that the Insight Installation Guide be updated to capture this requirement? The Insight installation guide doesn't say that only 32 bit Oracle client is supported.
http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/index.jsp?topic=%2Fcom.ibm.rational.raer.install.doc%2Ftopics%2Ft_prereq_reportalserver.html
Thanks again.