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
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