on 11-18-2009 3:53 PM
Hi all,
Having problems with my dev sandbox and i'm not sure how to fix it.
Netweaver 2004s, OS: 2003 SR2, DBMS: Oracles 10g
After changing the SAPSR3DB password in secure store via configtool, i can no longer start the J2EE server instance and i cannot connect to the DB via configtool anymore as well although the URL looks fine to me.
The DB is up and running "Services are all started". I can connect to the DB via SQLPLUS with the SAPSR3DB account using the password that i've put in secure store.
Log_Bootstrap:
[Nov 18, 2009 4:08:20 PM ] -
[Nov 18, 2009 4:08:20 PM ] Bootstrap MODE:
[Nov 18, 2009 4:08:20 PM ] <INSTANCE GLOBALS>
[Nov 18, 2009 4:08:20 PM ] determined by parameter [ID0014269].
[Nov 18, 2009 4:08:20 PM ] -
[Nov 18, 2009 4:08:22 PM ] Exception occurred:
com.sap.engine.bootstrap.SynchronizationException: Database initialization failed! Check database properties!
at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:476)
at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:146)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:971)
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: ]==----
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.bootstrap.Synchronizer.<init>(Synchronizer.java:74)
at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:473)
at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:146)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:971)
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)
... 14 more
[Nov 18, 2009 4:08:22 PM ] [Bootstrap module]> Problem occurred while performing synchronization.
Dev_Jcontrol:
-
trc file: "C:\usr\sap\MKD\JC00\work\dev_jcontrol", trc level: 1, release: "700"
-
node name : jcontrol
pid : 3744
system name : MKD
system nr. : 00
started at : Wed Nov 18 16:08:19 2009
arguments :
arg[00] : C:\usr\sap\MKD\JC00\exe\jcontrol.EXE
arg[01] : pf=C:\usr\sap\MKD\SYS\profile\MKD_JC00_NetWeaverBox
[Thr 2432] Wed Nov 18 16:08:19 2009
[Thr 2432] *** WARNING => INFO: Unknown property [instance.box.number=MKDJC00netweaverbox] [jstartxx.c 841]
[Thr 2432] *** WARNING => INFO: Unknown property [instance.en.host=NetWeaverBox] [jstartxx.c 841]
[Thr 2432] *** WARNING => INFO: Unknown property [instance.en.port=3201] [jstartxx.c 841]
[Thr 2432] *** WARNING => INFO: Unknown property [instance.system.id=0] [jstartxx.c 841]
**********************************************************************
JStartupReadInstanceProperties: read instance properties [C:\usr\sap\MKD\JC00\j2ee\cluster\instance.properties;C:\usr\sap\MKD\JC00\SDM\program\config\sdm_jstartup.properties]
-> ms host : NetWeaverBox
-> ms port : 3901
-> OS libs : C:\usr\sap\MKD\JC00\j2ee\os_libs
-> Admin URL :
-> run mode : normal
-> run action : NONE
-> enabled : yes
**********************************************************************
**********************************************************************
Used property files
-> files [00] : C:\usr\sap\MKD\JC00\j2ee\cluster\instance.properties
-> files [01] : C:\usr\sap\MKD\JC00\SDM\program\config\sdm_jstartup.properties
**********************************************************************
**********************************************************************
Instance properties
-> ms host : NetWeaverBox
-> ms port : 3901
-> os libs : C:\usr\sap\MKD\JC00\j2ee\os_libs
-> admin URL :
-> run mode : normal
-> run action : NONE
-> enabled : yes
**********************************************************************
**********************************************************************
Bootstrap nodes
-> [00] bootstrap : C:\usr\sap\MKD\JC00\j2ee\cluster\instance.properties
-> [01] bootstrap_ID1426900 : C:\usr\sap\MKD\JC00\j2ee\cluster\instance.properties
-> [02] bootstrap_ID1426950 : C:\usr\sap\MKD\JC00\j2ee\cluster\instance.properties
**********************************************************************
**********************************************************************
Worker nodes
-> [00] ID1426900 : C:\usr\sap\MKD\JC00\j2ee\cluster\instance.properties
-> [01] ID1426950 : C:\usr\sap\MKD\JC00\j2ee\cluster\instance.properties
-> [02] sdm : C:\usr\sap\MKD\JC00\SDM\program\config\sdm_jstartup.properties
**********************************************************************
[Thr 2432] JControlExecuteBootstrap: execute bootstrap process [bootstrap]
[Thr 2432] [Node: bootstrap] java home is set by profile parameter
Java Home: C:\j2sdk1.4.2_13
[Thr 2432] JStartupICheckFrameworkPackage: can't find framework package C:\usr\sap\MKD\JC00\exe\jvmx.jar
**********************************************************************
JStartupIReadSection: read node properties [bootstrap]
-> node name : bootstrap
-> node type : bootstrap
-> node execute : yes
-> java path : C:\j2sdk1.4.2_13
-> java parameters : -Djco.jarm=1
-> java vm version : 1.4.2_13-b06
-> java vm vendor : Java HotSpot(TM) Server VM (Sun Microsystems Inc.)
-> java vm type : server
-> java vm cpu : x86
-> heap size : 256M
-> root path : C:\usr\sap\MKD\JC00\j2ee\cluster
-> class path : .\bootstrap\launcher.jar
-> OS libs path : C:\usr\sap\MKD\JC00\j2ee\os_libs
-> main class : com.sap.engine.offline.OfflineToolStart
-> framework class : com.sap.bc.proj.jstartup.JStartupFramework
-> registr. class : com.sap.bc.proj.jstartup.JStartupNatives
-> framework path : C:\usr\sap\MKD\JC00\exe\jstartup.jar;C:\usr\sap\MKD\JC00\exe\jvmx.jar
-> parameters : com.sap.engine.bootstrap.Bootstrap ./bootstrap ID0014269
-> debuggable : yes
-> debug mode : no
-> debug port : 60000
-> shutdown timeout : 120000
**********************************************************************
**********************************************************************
JControlStartJLaunch: program = C:\usr\sap\MKD\JC00\exe\jlaunch.exe
-> arg[00] = C:\usr\sap\MKD\JC00\exe\jlaunch.exe
-> arg[01] = pf=C:\usr\sap\MKD\SYS\profile\MKD_JC00_NetWeaverBox
-> arg[02] = -DSAPINFO=MKD_00_bootstrap
-> arg[03] = -nodeId=-1
-> arg[04] = -file=C:\usr\sap\MKD\JC00\j2ee\cluster\instance.properties
-> arg[05] = -syncSem=JSTARTUP_WAIT_ON_3744
-> arg[06] = -nodeName=bootstrap
-> arg[07] = -jvmOutFile=C:\usr\sap\MKD\JC00\work\jvm_bootstrap.out
-> arg[08] = -stdOutFile=C:\usr\sap\MKD\JC00\work\std_bootstrap.out
-> arg[09] = -locOutFile=C:\usr\sap\MKD\JC00\work\dev_bootstrap
-> arg[10] = -mode=BOOTSTRAP
-> arg[11] = pf=C:\usr\sap\MKD\SYS\profile\MKD_JC00_NetWeaverBox
-> lib path = PATH=C:\j2sdk1.4.2_13\jre\bin\server;C:\j2sdk1.4.2_13\jre\bin;C:\oracle\MKD\102\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\SAPJco;C:\Program Files\SAP\JDT\eclipse\plugins;C:\usr\sap\MKD\SYS\exe\uc\NTI386
-> exe path = PATH=C:\j2sdk1.4.2_13\bin;C:\usr\sap\MKD\JC00\j2ee\os_libs;C:\oracle\MKD\102\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\SAPJco;C:\Program Files\SAP\JDT\eclipse\plugins;C:\usr\sap\MKD\SYS\exe\uc\NTI386
**********************************************************************
[Thr 2432] Wed Nov 18 16:08:23 2009
[Thr 2432] *** ERROR => invalid return code of process [bootstrap] (exitcode = 66) [jstartxx.c 1642]
[Thr 2432] JControlExecuteBootstrap: error executing bootstrap node [bootstrap] (rc = 66)
[Thr 2432] JControlCloseProgram: started (exitcode = 66)
[Thr 2432] JControlCloseProgram: good bye... (exitcode = 66)
Instance.properties:
ID1426900.ClassPath=./bin/boot/boot.jar:./bin/system/bytecode.jar:.
ID1426900.Debuggable=no
ID1426900.JLaunchParameters=
ID1426900.JavaParameters=-Djava.security.policy=./java.policy -Djava.security.egd=file:/dev/urandom -Dorg.omg.CORBA.ORBClass=com.sap.engine.system.ORBProxy -Dorg.omg.CORBA.ORBSingletonClass=com.sap.engine.system.ORBSingletonProxy -Djavax.rmi.CORBA.PortableRemoteObjectClass=com.sap.engine.system.PortableRemoteObjectProxy -Xms170m -XX:NewSize=57m -XX:MaxNewSize=57m -XX:NewRatio=3 -XX:+DisableExplicitGC -verbose:gc
ID1426900.JavaPath=C:/j2sdk1.4.2_13
ID1426900.LogName=dispatcher
ID1426900.MainClass=com.sap.engine.boot.Start
ID1426900.MaxHeapSize=170
ID1426900.Name=dispatcher
ID1426900.Parameters=
ID1426900.RootPath=C:/usr/sap/MKD/JC00/j2ee/cluster/dispatcher
ID1426900.Type=dispatcher
ID1426950.ClassPath=./bin/boot/boot.jar:./bin/boot/jaas.jar:./bin/system/bytecode.jar:.
ID1426950.DebugMode=no
ID1426950.DebugPort=50021
ID1426950.Debuggable=no
ID1426950.JLaunchParameters=
ID1426950.JavaParameters=-Djava.security.policy=./java.policy -Djava.security.egd=file:/dev/urandom -Dorg.omg.CORBA.ORBClass=com.sap.engine.system.ORBProxy -Dorg.omg.CORBA.ORBSingletonClass=com.sap.engine.system.ORBSingletonProxy -Djavax.rmi.CORBA.PortableRemoteObjectClass=com.sap.engine.system.PortableRemoteObjectProxy -Djco.jarm=1 -XX:MaxPermSize=256M -XX:PermSize=256M -Xms1024M -XX:NewSize=171M -XX:MaxNewSize=171M -XX:DisableExplicitGC -verbose:gc -XX:PrintGCDetails -XX:+PrintGCTimeStamps -Djava.awt.headless=true -Dsun.io.useCanonCaches=false -XX:SoftRefLRUPolicyMSPerMB=1 -XX:SurvivorRatio=2 -XX:TargetSurvivorRatio=90 -Dorg.omg.PortableInterceptor.ORBInitializerClass.com.sap.engine.services.ts.jts.ots.PortableInterceptor.JTSInitializer
ID1426950.JavaPath=C:/j2sdk1.4.2_13
ID1426950.LogName=server0
ID1426950.MainClass=com.sap.engine.boot.Start
ID1426950.MaxHeapSize=1024
ID1426950.Name=server0
ID1426950.Parameters=
ID1426950.RootPath=C:/usr/sap/MKD/JC00/j2ee/cluster/server0
ID1426950.Type=server
bootstrap.ClassPath=./bootstrap/launcher.jar
bootstrap.JavaParameters=-Djco.jarm=1
bootstrap.JavaPath=C:/j2sdk1.4.2_13
bootstrap.MainClass=com.sap.engine.offline.OfflineToolStart
bootstrap.MaxHeapSize=256
bootstrap.Name=bootstrap
bootstrap.Parameters=com.sap.engine.bootstrap.Bootstrap ./bootstrap ID0014269
bootstrap.RootPath=C:/usr/sap/MKD/JC00/j2ee/cluster
bootstrap.Type=bootstrap
bootstrap_ID1426900.ClassPath=./bootstrap/launcher.jar
bootstrap_ID1426900.JLaunchParameters=
bootstrap_ID1426900.JavaParameters=-Djco.jarm=1
bootstrap_ID1426900.JavaPath=C:/j2sdk1.4.2_13
bootstrap_ID1426900.MainClass=com.sap.engine.offline.OfflineToolStart
bootstrap_ID1426900.MaxHeapSize=256
bootstrap_ID1426900.Name=dispatcher bootstrap
bootstrap_ID1426900.Parameters=com.sap.engine.bootstrap.Bootstrap ./bootstrap ID001426900
bootstrap_ID1426900.RootPath=C:/usr/sap/MKD/JC00/j2ee/cluster
bootstrap_ID1426900.Type=bootstrap
bootstrap_ID1426950.ClassPath=./bootstrap/launcher.jar
bootstrap_ID1426950.JLaunchParameters=
bootstrap_ID1426950.JavaParameters=-Djco.jarm=1
bootstrap_ID1426950.JavaPath=C:/j2sdk1.4.2_13
bootstrap_ID1426950.MainClass=com.sap.engine.offline.OfflineToolStart
bootstrap_ID1426950.MaxHeapSize=256
bootstrap_ID1426950.Name=server0 bootstrap
bootstrap_ID1426950.Parameters=com.sap.engine.bootstrap.Bootstrap ./bootstrap ID001426950
bootstrap_ID1426950.RootPath=C:/usr/sap/MKD/JC00/j2ee/cluster
bootstrap_ID1426950.Type=bootstrap
instance.box.number=MKDJC00netweaverbox
instance.en.host=NetWeaverBox
instance.en.port=3201
instance.enabled=yes
instance.install.dir=C:/usr/sap/MKD/JC00/j2ee
instance.ms.host=NetWeaverBox
instance.ms.port=3901
instance.osLibsPath=C:/usr/sap/MKD/JC00/j2ee/os_libs
instance.runAction=NONE
instance.runMode=normal
instance.system.id=0
Edited by: MonkD on Nov 18, 2009 4:55 PM
Hi,
Do you check whether the connection string is set properly in 'secure store'. You can check it with configtool.
Check also ports the listener is running on..
cheers,
Vincent
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Problem resolved.
The correct port for the listener is 1521 and not 1527, not sure how it got changed since i never touch it...
I had to unlock the SAPSR3DB account and the admin account on portal afterwards. The AS is now up and running and i can log in to portal.
Thanks for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have faced the same issue and resolved after setting Listener port number.
- In configtool -> secure store the connection string is pointing Listener port 1528
- When I check in Listener.ora and tnsnames.ora showing port 1527.
I adjusted both (Listener and tnsnames) file in /oracle/SID/112_64/network/admin and /usr/sap/SID/SYS/profile/oracle and changed the Listener port to 1528.
Then I started SAP and my both ABAP and JAVA engine working fine now.
Thanks for the replies.
As stated in the original message, the DB is up and running and i can connect via SQLPLUS.
I cannot connect to the DB via configtool but the URL is as far as i can tell correct "jdbc:oracle:thin:@NetWeaverBox:1527:MKD"
The password is secure store is correct, i can login to the DB via SQLPLUS using the SAPSR3DB account with the same password that i put in the secure store.
Note 867976 does not seem to be relevant to my issue.
This is a sandbox where DB/AS/Portal are on the same machine, I don't understand the error.
Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
Since everything is on the same machine, shouldn't be connecting to the DB via pipe/ipc? It sounds like it's using TCP.
Thanks for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think the password you entered in Secure Store does not match the sapsr3db password. So its not able to connect to database. Please re-enter the password in secure store and then try.
Best Regards
Raghu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Look for the last caused by in the above error:
Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
This means that either the Oracle DB is not working or the connection string in the Secure Store is wrong.
The config tool is also using the Secure Store to connect to the DB, so you could try connect with it and edit the Secure Store properties from there.
Here is more info about the Secure Store:
http://help.sap.com/saphelp_nw70/helpdata/en/cd/14c93ec2f7df6ae10000000a114084/frameset.htm
Regards,
Ventsi Tsachev
See also SAP Note 867976 on JDBC driver.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
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.