[URGENT]Problems to configure Datawarehouse DB to RRDI
Hi All,
We have installed the RRDI in our POC environement and running out problems while connecting the CLM datawarehouse database from RRDI. As per the installation giuide, created the signon, configured the RRPTUSER and updated the Oracle SQL*Net connection string, but it fails to establish the connection.
When I try to manually conenct to the CLM datawarehouse database with the same user credentails, it worked.
sqlplus <UserName>/<Password>@<DBNAME>
SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 2 11:57:41 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
SQL> exit
Error:
RQP-DEF-0285 The Logon Failed
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
testDataSourceConnection
UDA-SQL-0432 Unable to locate the gateway "libcogudaor"
BME-EX-0144 Trace back:
I have checked we have oralce client 32 bit and no idea about this eeror.
Have you got any hin to this issue?
Thanks in advance.
Cheers,
Jose
We have installed the RRDI in our POC environement and running out problems while connecting the CLM datawarehouse database from RRDI. As per the installation giuide, created the signon, configured the RRPTUSER and updated the Oracle SQL*Net connection string, but it fails to establish the connection.
When I try to manually conenct to the CLM datawarehouse database with the same user credentails, it worked.
sqlplus <UserName>/<Password>@<DBNAME>
SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 2 11:57:41 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
SQL> exit
Error:
RQP-DEF-0285 The Logon Failed
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
testDataSourceConnection
UDA-SQL-0432 Unable to locate the gateway "libcogudaor"
BME-EX-0144 Trace back:
I have checked we have oralce client 32 bit and no idea about this eeror.
Have you got any hin to this issue?
Thanks in advance.
Cheers,
Jose