Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Weblogic server crashes as soon as it starts...

Saurabh GJan 21 2014 — edited Feb 5 2014

Hi,

I have been doing POC on various adapters including the new addition Healthcare adapter extensively. Before I explain my problem, I would provide the Environment details:

1. Oracle Database XE

2. SOA Suite with adapters

3. RAM : 8 GB

4. OS : 64 bit Windows7

All the installables used are 32 bit windows installers.

Problem:

For quite sometime now I am struggling with the SOA server. The Weblogic server crashes as soon as it starts.

Remediation Tried at my end :

1. Delete all the configuration and all the composites removed.

2. Truncating all the tables storing BPEL, Composite, Mediator etc data and also used the shrink space option in the database to reclaim the freed space.

3. Purged metadata using the Purge option in EM console.

4. Increased the sessions count and processes count in the Oracle database.

Earlier just doing step 1, was able to suffice and I could get the server back online.

But this time even after performing all these steps I am not able to get it online in a stable state.

Apart from the below mentioned error, I have been getting this error in weblogic server for quite sometime. I am not sure but thougt to share since this might help anyone point out the issue and its resolution:

weblogic.common.ResourceException: ORA-28001: the password has expired

I am posting below the error so that if anybody has any solution or idea that he can share:

[2014-01-20T20:21:39.585+05:30] [AdminServer] [WARNING] [ADF_FACES-00007] [oracle.adf.view.rich.render.RichRenderer] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 249b89447200f8d1:2e0a7ffb:143afeb8c12:-8000-000000000000151a,0] [APP: Healthcare UI] [DSID: 0000KEk80dc9tXizl4IbK31IrIbU00000C] Attempt to synchronized unknown key: viewportSize.

[2014-01-20T21:18:45.022+05:30] [AdminServer] [NOTIFICATION] [] [oracle.mds] [tid: AutoPurgeThread-2] [userId: weblogic] [ecid: 249b89447200f8d1:2e0a7ffb:143afeb8c12:-8000-000000000000134d,1:25151] Purge-Repos Diagnostics [auto-purge, partition-name, partition-id, #versions purged]: [true, soa-infra, 1, 7].

[2014-01-20T21:37:21.844+05:30] [AdminServer] [ERROR] [] [org.quartz.core.ErrorLogger] [tid: FabricScheduler_QuartzSchedulerThread] [userId: <anonymous>] [ecid: 0000KEjuu709tXizl4IbK31IrIbU000002,1:25145] [APP: soa-infra] An error occured while scanning for the next trigger to fire.[[

org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'soaNonManagedDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SOALocalTxDataSource' weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SOALocalTxDataSource' weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection]

at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:167)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3757)

at oracle.integration.platform.blocks.scheduler.FabricJobStoreCMT.acquireNextTrigger(FabricJobStoreCMT.java:51)

at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266)

Caused by: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SOALocalTxDataSource' weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection

at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:166)

at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)

at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:164)

... 3 more

]]

[2014-01-20T21:37:37.769+05:30] [AdminServer] [NOTIFICATION] [] [oracle.mds] [tid: MDSPollingThread-[soa-infra, jdbc/mds/MDS_LocalTxDataSource]] [userId: <anonymous>] [ecid: 0000KEjuu709tXizl4IbK31IrIbU000002,1:25137] [APP: ShareSoaInfraPartition] [[

oracle.mds.exception.MDSRuntimeException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection

at oracle.mds.internal.persistence.db.BaseReposAccess.<init>(BaseReposAccess.java:453)

at oracle.mds.internal.persistence.db.shredded.ShreddedReposAccess.<init>(ShreddedReposAccess.java:301)

at oracle.mds.internal.persistence.db.shredded.ShreddedDBMSConnection.createReposAccess(ShreddedDBMSConnection.java:450)

at oracle.mds.internal.persistence.db.BaseDBMSConnection.getOrCreateReposAccess(BaseDBMSConnection.java:3502)

at oracle.mds.internal.persistence.db.DBPChangeProvider.setMultiTenant(DBPChangeProvider.java:541)

at oracle.mds.internal.persistence.db.DBPChangeProvider.getChanges(DBPChangeProvider.java:126)

at oracle.mds.internal.persistence.db.DBMetadataStoreCommunicator.signalChanges(DBMetadataStoreCommunicator.java:178)

at oracle.mds.internal.persistence.db.ChangePollingThread.run(ChangePollingThread.java:128)

Caused by: oracle.mds.internal.persistence.db.fcf.MDSDBIOException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection

at oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl.fetchConnection(JNDIConnectionManagerImpl.java:102)

at oracle.mds.internal.persistence.db.ConnectionManager.getConnection(ConnectionManager.java:352)

at oracle.mds.internal.persistence.db.BaseReposAccess.<init>(BaseReposAccess.java:433)

... 7 more

Caused by: weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection

at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:250)

at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:456)

at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:538)

at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498)

at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491)

at oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl.fetchConnection(JNDIConnectionManagerImpl.java:97)

... 9 more

]]

[2014-01-20T21:37:42.056+05:30] [AdminServer] [ERROR] [] [oracle.soa.hc.engine] [tid: Workmanager: , Version: 0, Scheduled=false, Started=false, Wait time: 0 ms\r\n] [userId: <anonymous>] [ecid: 0000KEjuu709tXizl4IbK31IrIbU000002,0] [APP: soa-infra] oracle.mds.exception.MDSRuntimeException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection[[

at oracle.mds.internal.persistence.db.BaseReposAccess.<init>(BaseReposAccess.java:453)

at oracle.mds.internal.persistence.db.shredded.ShreddedReposAccess.<init>(ShreddedReposAccess.java:301)

at oracle.mds.internal.persistence.db.shredded.ShreddedDBMSConnection.createReposAccess(ShreddedDBMSConnection.java:450)

at oracle.mds.internal.persistence.db.BaseDBMSConnection.getOrCreateReposAccess(BaseDBMSConnection.java:3502)

at oracle.mds.internal.persistence.db.BaseDBMSCVersionSupport.getDocument(BaseDBMSCVersionSupport.java:360)

at oracle.mds.persistence.DelegatingMSConnectionVersionSupport.getDocument(DelegatingMSConnectionVersionSupport.java:77)

at oracle.mds.internal.persistence.PManagerVersionSupportImpl.getDocument(PManagerVersionSupportImpl.java:330)

at oracle.mds.core.MOState.getTipPDocument(MOState.java:1040)

at oracle.mds.core.MOState.checkStaleVersion(MOState.java:950)

at oracle.mds.core.MOState.checkStalenessDocFromBuilder(MOState.java:748)

at oracle.mds.core.MOState.getIsStaleLastModified(MOState.java:562)

at oracle.mds.core.MOContent.getIsStaleLastModified(MOContent.java:278)

at oracle.mds.core.MetadataObject.isStale(MetadataObject.java:838)

at oracle.tip.b2b.mds.QueryManager._getHostMO(QueryManager.java:1310)

at oracle.tip.b2b.mds.QueryManager.getHostMO(QueryManager.java:1337)

at oracle.tip.b2b.mds.QueryManager.getHostedTP(QueryManager.java:2042)

at oracle.tip.b2b.mds.QueryManager.getHostedTP(QueryManager.java:2086)

at oracle.tip.b2b.mds.QueryManager.getNotificationContactInfo(QueryManager.java:7488)

at oracle.tip.b2b.messaging.MessagingServiceImpl.getAllContacts(MessagingServiceImpl.java:255)

at oracle.tip.b2b.messaging.MessagingServiceImpl.notify(MessagingServiceImpl.java:172)

at oracle.tip.b2b.transport.basic.FileSourceMonitor.run(FileSourceMonitor.java:492)

at oracle.tip.b2b.transport.basic.FileReceiver.init(FileReceiver.java:483)

at oracle.tip.b2b.transport.b2b.B2BTransport.init(B2BTransport.java:577)

at oracle.tip.b2b.engine.ThreadWorkExecutor.run(ThreadWorkExecutor.java:240)

at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:120)

at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)

at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)