J2EE database not available via test

[Nibu]

Hi Experts,

I have installed NW 7.0 portal Ehp2 system on Solaris cluster with logical name  . Now when I try to start SAP with the startsap script . it is not starting the database (Oracle) . It just checks whether DB is running and giving message J2EE database not available via test , and asking to check JdbCon.log .

This is Bootstrap log

*************************************************************************************************

com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB.

        at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:384)

        at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.<init>(DBConnectionPool.java:132)

        at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.<init>(PersistenceHandler.java:38)

        at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init>(ConfigurationCache.java:150)

        at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:214)

        at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.<init>(ConfigurationManagerBootstrapImpl.java:46)

        at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:76)

        at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:474)

        at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:156)

        at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:946)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:331)

        at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Caused by: java.sql.SQLException: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

SVR4 Error: 2: No such file or directory

************************************************************************************************

If I start db manually , then runnig startsap , it runs fine . And also stopsap script , wont stop database .

I checked listener.ora,tnsnames.ora, user profiles, environment variables, permissions etc , nothing found wrong .

When I execute startj2eedb as sidadm , it starts db .

Can you please throw some light on this issue

Regards,

Nibu Antony

[Nibu · Accepted solution]

Hi All,

Thanks for the valuable  suggestions .

Resolved the issue , we tried to  switched to node 2 and there startsap starts the DB .

Then compared everything between node 1 and 2 . Found some difference in /etc/hosts file , where in node 1 , the database hostname was wrongly added by OS team . We did not check host file before , since hostname,ping -a all  were returning the correct DB host logical name , but it seems like startsap first checks the hostfile ,not the DNS .

Changed  /etc/hosts with the logical host name of DB corresponding to IP . Now all works fine , fail over, fail back are fine .

Thanks again for your time.

Regards,

Nibu Antony