Unable to Start MWS

, ,
1

Hi Folks,

Recently we have done data refresh from one (Ex : QA) Environment to another (Ex : Dev) Environment. After date refresh we are not able to start MWS in Dev.

Logs from errors.log (/opt/webMethods822/MWS/server/default/logs):

<log4j:event logger=“messaging” timestamp=“1341536427037” level=“WARN” thread=“Thread-16”>
log4j:message</log4j:message>
log4j:throwable</log4j:throwable>
</log4j:event>

<log4j:event logger=“messaging” timestamp=“1341536427037” level=“WARN” thread=“Thread-16”>
log4j:message</log4j:message>
</log4j:event>

<log4j:event logger=“Framework” timestamp=“1341536435328” level=“FATAL” thread=“Thread-16”>
log4j:message</log4j:message>
log4j:throwable<![CDATA[java.sql.SQLNonTransientConnectionException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

    at com.wm.dd.jdbc.oraclebase.ddb9.b(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.ddb9.a(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.ddb8.b(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.ddb8.a(Unknown Source)
    at com.wm.dd.jdbc.oracle.OracleImplConnection.a(Unknown Source)
    at com.wm.dd.jdbc.oracle.OracleImplConnection.x(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.BaseConnection.a(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.BaseConnection.k(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.BaseConnection.a(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.BaseConnection.a(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.BaseDriver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at com.webmethods.portal.service.sql.core.provider.pool.ConnectionPoolManager.create(ConnectionPoolManager.java:106)
    at com.webmethods.portal.system.pool.impl.LightweightObjectPool.createNewObject(LightweightObjectPool.java:349)
    at com.webmethods.portal.system.pool.impl.LightweightObjectPool.checkOut(LightweightObjectPool.java:277)
    at com.webmethods.portal.service.sql.core.provider.pool.PooledConnectionProvider.getConnection(PooledConnectionProvider.java:181)
    at com.webmethods.portal.service.sql.core.BaseSqlWorker.init(BaseSqlWorker.java:129)
    at com.webmethods.portal.service.sql.DataManager.createWorker(DataManager.java:291)
    at com.webmethods.jms.db.impl.JMSPollThread.onRun(JMSPollThread.java:37)
    at com.webmethods.rtl.util.thread.ControllableThread.run(ControllableThread.java:43)

]]></log4j:throwable>
</log4j:event>

2

Error you are seeing is oracle related and it says database(Oracle is not available)

Try to check in details with DBA what went wrong is DB refresh

My suggestion is to try oracle support/forums/ etc also

3

Hi Sai,

Thanks for reply.

Issue has been resolved now.

4

Nice!!!