Total Pageviews

Wednesday, September 3, 2014

installation of OID 11.1.1.6 connector at OIM 11gR2ps2 showing Invalid Oracle URL error

seeing below error after installing OIM -OID connector. OID connector version 11.1.1.6 and  OIM version 11.1.2.2.*


NFO: from getXmlFiles method of verifydirectory
SEVERE: Class/Method: DBPoolManager/getConnection/Exception encounter some problems: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Invalid Oracle URL specified
java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Invalid Oracle URL specified

second error
SEVERE: Class/Method: DBPoolManager/getConnection/Exception encounter some problems: Error while retrieving database connection.Please check for the following
 Database server is up.
 DirectDB settings in configuration file are correct.
SEVERE: Class/Method: DirectDB/getConnection encounter some problems: Error while retrieving database connection.Please check for the follwoing
 Database server is running.
 Datasource configuration settings are correct.
java.sql.SQLException: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Invalid Oracle URL specified

Solution:
it is because your oim-config.xml file that is in metadata directory don't have correct db name and username

<METADATA_HOME>/db/oim-config.xml
vi oim-config.xml

change
<directDBConfigParams driver="oracle.jdbc.OracleDriver"  url="@dburl" username="@dbuser"

to correct value of url and username(as per your environment.

<directDBConfigParams driver="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@orasystems.com:1521/oimdb"
username="DEV_OIM


if you don't know value of your database parameter you can run
$lsnrctl status
 

No comments:

Post a Comment