on 11-23-2007 12:00 PM
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
Hi Raj,
Can you paste the contents of batchconfig.log
Regards,
Siddhesh
Message was edited by:
Siddhesh Ghag
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.