Central Instance not starting and unable to install Dialog Instance

[Former Member]

Hi There,

environment:WIndows Cluster MSCS

operating system windows 2003 EE sp2

database oracle 10g

Im having problem in bringing my CEntral instance online on my first mscs node and i also im unable to install dailog instance on 2nd node.The error i believe is common on both nodes,it says unable to connect DB.

Central Instance error: message server disconnected

Dailog instance error: unable to connect to DB

sapinst.log for Dailog Instance

Error while connecting to DB.

ERROR 2007-11-22 16:17:07

CJS-30059 Java EE Engine configuration error.<br>DIAGNOSIS: Error when configuring J2EE Engine. See output of logfile batchconfig.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:360)

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

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:149)

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

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

at com.sap.engine.configtool.batch.BatchConfig.go(BatchConfig.java:47)

at com.sap.engine.configtool.batch.BatchConfig.main(BatchConfig.java:83)

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:324)

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

Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:285)

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

... 12 more

Regards

raj

[former_member185954]

Hi Raj,

Can you paste the contents of batchconfig.log

Regards,

Siddhesh

Message was edited by:

Siddhesh Ghag

[Former Member]

Hi SIddesh,

Thank you for the reply, any urgent help would be realyl appreaciated and points will be awarded.

im posting batch log files of both node1 and node2

<b>NODE 1</b>

PerfTimes : loadNativeLayer: loading jperflib failed. no jperflib in java.library.path

L:/usr/sap/PPI/DVEBMGS02/j2ee\admin\adminCFG.properties doesn't exist and will be created by batchconfig.

L:/usr/sap/PPI/DVEBMGS02/j2ee\admin\cfg\adminCFG.properties doesn't exist and will be created by batchconfig.

L:\usr\sap\PPI\DVEBMGS02\j2ee\deploying\dplOptions.options doesn't exist and will be created by batchconfig.

L:\usr\sap\PPI\DVEBMGS02\j2ee\configtool\config.properties doesn't exist and will be created by batchconfig.

L:/usr/sap/PPI/DVEBMGS02/j2ee\deploying\rdb.properties doesn't exist and will be created by batchconfig.

ChangeServicePropsTask has finished successfully. Service: ssl on dispatcher

ChangeManagerPropsTask has finished successfully. Manager: LockingManager on dispatcher

ChangeManagerPropsTask has finished successfully. Manager: ClusterManager on dispatcher

ElementInfoTask has finished successfully on server

ChangeServicePropsTask has finished successfully. Service: dbpool on server

ChangeServicePropsTask has finished successfully. Service: classpath_resolver on server

ChangeServicePropsTask has finished successfully. Service: com.sap.security.core.ume.service on server

ChangeManagerPropsTask has finished successfully. Manager: LockingManager on server

ChangeManagerPropsTask has finished successfully. Manager: ClusterManager on server

os.name: ntamd64

os.bit.length: 64

os.unicode: false

-

---

Port Offset (by system number)= 200

-

---

disp cluster id = 25146100

disp group id = 51461

disp cluster name = SAP J2EEngine Cluster 2

disp element name = Dispatcher 0 2_51461

-

---

http port = 50200

http over ssl port = 50201

p4 port = 50204

p4 over http port = 50205

p4 over ssl port = 50206

iiop port = 50207

telnet port = 50208

iiop initial context port = 50202

iiop ssl socket = 50203

jms port = 50210

-

---

serv 0 cluster id = 25146150

serv 0 group id = 51461

serv 0 cluster name = SAP J2EEngine Cluster 2

serv 0 element name = Server 0 2_51461

-

---

serv 0 join port = 50220

serv 0 debug port = 50221

-

---

r3startup elements = 0

r3startup element_0_id = 25146150

r3startup element_0_dir = L:\usr\sap\PPI\DVEBMGS02\j2ee\cluster\server0

-

---

L:/usr/sap/PPI/DVEBMGS02/j2ee\admin\adminCFG.properties doesn't exist and will be created by batchconfig.

L:/usr/sap/PPI/DVEBMGS02/j2ee\admin\cfg\adminCFG.properties doesn't exist and will be created by batchconfig.

L:\usr\sap\PPI\DVEBMGS02\j2ee\deploying\dplOptions.options doesn't exist and will be created by batchconfig.

L:\usr\sap\PPI\DVEBMGS02\j2ee\configtool\config.properties doesn't exist and will be created by batchconfig.

L:/usr/sap/PPI/DVEBMGS02/j2ee\deploying\rdb.properties doesn't exist and will be created by batchconfig.

ChangeServicePropsTask has finished successfully. Service: ssl on dispatcher

ChangeManagerPropsTask has finished successfully. Manager: LockingManager on dispatcher

ChangeManagerPropsTask has finished successfully. Manager: ClusterManager on dispatcher

ElementInfoTask has finished successfully on server

ChangeServicePropsTask has finished successfully. Service: dbpool on server

ChangeServicePropsTask has finished successfully. Service: classpath_resolver on server

ChangeServicePropsTask has finished successfully. Service: com.sap.security.core.ume.service on server

ChangeManagerPropsTask has finished successfully. Manager: LockingManager on server

ChangeManagerPropsTask has finished successfully. Manager: ClusterManager on server

os.name: ntamd64

os.bit.length: 64

os.unicode: false

-

---

Port Offset (by system number)= 200

-

---

disp cluster id = 25146100

disp group id = 51461

disp cluster name = SAP J2EEngine Cluster 2

disp element name = Dispatcher 0 2_51461

-

---

http port = 50200

http over ssl port = 50201

p4 port = 50204

p4 over http port = 50205

p4 over ssl port = 50206

iiop port = 50207

telnet port = 50208

iiop initial context port = 50202

iiop ssl socket = 50203

jms port = 50210

-

---

serv 0 cluster id = 25146150

serv 0 group id = 51461

serv 0 cluster name = SAP J2EEngine Cluster 2

serv 0 element name = Server 0 2_51461

-

---

serv 0 join port = 50220

serv 0 debug port = 50221

-

---

r3startup elements = 0

r3startup element_0_id = 25146150

r3startup element_0_dir = L:\usr\sap\PPI\DVEBMGS02\j2ee\cluster\server0

-

---

<b>NODE 2</b>

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:360)

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

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:149)

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

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

at com.sap.engine.configtool.batch.BatchConfig.go(BatchConfig.java:47)

at com.sap.engine.configtool.batch.BatchConfig.main(BatchConfig.java:83)

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:324)

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

Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:285)

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

... 12 more

Error while connecting to DB.

Regards

Raj

[former_member185954]

Hi Raj,

While installing , the SAPINST must have asked you a IP Address: <virtual_IP_address_for_the_cluster_group_SAP-R/3> This IP address is a "virtual address" and valid only for the node.

Is this virtual IP address pingable ? or can you ping the IP of your Node A from the node itself.

If not, you need to make an entry in the c:\windows\system32\drivers\etc\hosts file.

I am asking this, cause in your Node 2 log , i found the following error:

<b>Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection</b>

Regards,

Siddhesh

Message was edited by:

Siddhesh Ghag

[Former Member]

Hi Siddesh,

All my Ip address's are pinging with out any problem.

My central instance do not want to start aswell saying message serve disconnecte/j2ee status unavailable...

any ideas about this aswell pls

Below is the developer trace

Fri Nov 23 12:20:18 2007

***LOG Q0I=> NiIRead: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 4235]

• ERROR => NiIRead: SiRecv failed for hdl 6 / sock 324

(SI_ECONN_BROKEN; I4; ST; 127.0.0.1:2265) [nixxi.cpp 4235]

DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)

DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=4884)

• ERROR => DpProcKill: kill failed [dpntdisp.c 371]

DpIJ2eeShutdown: j2ee state = SHUTDOWN

Fri Nov 23 12:20:36 2007

J2EE server info

start = TRUE

state = STARTED

pid = 5000

argv[0] = L:\usr\sap\PPI\DVEBMGS02\exe\jcontrol.EXE

argv[1] = L:\usr\sap\PPI\DVEBMGS02\exe\jcontrol.EXE

argv[2] = pf=
sapxpi\sapmnt\PPI\SYS\profile\PPI_DVEBMGS02_s5

argv[3] = -DSAPSTART=1

argv[4] = -DCONNECT_PORT=2275

argv[5] = -DSAPSYSTEM=02

argv[6] = -DSAPSYSTEMNAME=PPI

argv[7] = -DSAPMYNAME=s5_PPI_02

argv[8] = -DSAPPROFILE=
sapxpi\sapmnt\PPI\SYS\profile\PPI_DVEBMGS02_s5

argv[9] = -DFRFC_FALLBACK=ON

argv[10] = -DFRFC_FALLBACK_HOST=localhost

start_lazy = 0

start_control = SAP J2EE startup framework

DpJ2eeStart: j2ee state = STARTED

DpJ2eeLogin: j2ee state = CONNECTED

Fri Nov 23 12:20:38 2007

***LOG Q0I=> NiIRead: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 4235]

• ERROR => NiIRead: SiRecv failed for hdl 4 / sock 320

(SI_ECONN_BROKEN; I4; ST; 127.0.0.1:2276) [nixxi.cpp 4235]

DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)

DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=5000)

• ERROR => DpProcKill: kill failed [dpntdisp.c 371]

DpIJ2eeShutdown: j2ee state = SHUTDOWN

regards

raj

[Former Member]

HI,

Check the std_server<nr>.out in the work folder. u can get the what might be reason.

Thanks,

Mahesh