Cannot start J2EE server

[Former Member]

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

[vincentlim826 · Accepted solution]

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

[Former Member]

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.

[former_member183984]

This message was moderated.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[vincentlim826]

See also SAP Note 867976 on JDBC driver.