Sunday, September 28, 2014

BEA-001129: Received exception while creating connection for pool



While starting the Weblogic Admin / Managed servers, we get the Connection pool error 

Error Message - 

<Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "conpoolname": ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

<Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "Conpoolname" failed with exception: "oracle.jdbc.xa.OracleXAException".>
<Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "Conpoolname": ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Solution - 

The issue mostly is that the Datasource is not able to connect to the Oracle Database.

1. Login to the Admin server, navigate to Services -> Datasources
2. Go to Monitoring tab -> and do a Test Datasource.
3. If the issue still persists, go to the putty session, navigate to the <domain path>, and select 'config', 'jdbc' folders. check the jdbc.xml if the datasource values are correctly entered.
 4. After validation, restart the admin/managed server

1 comment:

  1. Observing the same error even after TNS listener is available. Weblogic managed servers had to be restarted to fix the connectivity to DB.Highly appreciate if you can advise how to check if the DB connections are cached and how to fix the issue.

    ReplyDelete