on 01-18-2007 3:12 AM
Hi,
i have changed my MAXDB user(SAPJ2EDB) password in config tool in secure store node (parameter: jdbc/pool/J2E/Password). After the password changes, when i re-started the server, my J2E instance is not started running. The jcontrol.exe file is stopped with the following trace log
trace file log
**********************************************************************
JStartupStartJLaunch: program = C:\usr\sap\J2E\JC02/j2ee/os_libs/jlaunch.exe
-> arg[00] = C:\usr\sap\J2E\JC02/j2ee/os_libs/jlaunch.exe
-> arg[01] = pf=C:\usr\sap\J2E\SYS\profile\J2E_JC02_us21217509
-> arg[02] = -DSAPINFO=J2E_02_bootstrap
-> arg[03] = -file=C:\usr\sap\J2E\JC02\j2ee\cluster\instance.properties
-> arg[04] = -nodeName=bootstrap
-> arg[05] = -nodeId=-1
-> arg[06] = -syncSem=JSTARTUP_WAIT_ON_3124
-> arg[07] = -jvmOutFile=C:\usr\sap\J2E\JC02\work\jvm_bootstrap.out
-> arg[08] = -stdOutFile=C:\usr\sap\J2E\JC02\work\std_bootstrap.out
-> arg[09] = -locOutFile=C:\usr\sap\J2E\JC02\work\dev_bootstrap
-> arg[10] = -mode=BOOTSTRAP
-> arg[11] = pf=C:\usr\sap\J2E\SYS\profile\J2E_JC02_us21217509
-> lib path = PATH=C:\j2sdk1.4.2_08\jre\bin\server;C:\j2sdk1.4.2_08\jre\bin;c:\sapdb\programs\bin;c:\sapdb\programs\pgm;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Support Tools\;C:\Program Files\Schlumberger\Smart Cards and Terminals\Cyberflex Access Kits\v4\;C:\Program Files\Executive Software\Diskeeper\;C:\usr\sap\J2E\SCS03\exe;C:\usr\sap\J2E\JC02\exe;C:\usr\sap\J2E\SYS\exe\run
-> exe path = PATH=C:\j2sdk1.4.2_08\bin;C:\usr\sap\J2E\JC02\j2ee\os_libs;c:\sapdb\programs\bin;c:\sapdb\programs\pgm;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Support Tools\;C:\Program Files\Schlumberger\Smart Cards and Terminals\Cyberflex Access Kits\v4\;C:\Program Files\Executive Software\Diskeeper\;C:\usr\sap\J2E\SCS03\exe;C:\usr\sap\J2E\JC02\exe;C:\usr\sap\J2E\SYS\exe\run
**********************************************************************
[Thr 1708] Wed Jan 17 18:33:59 2007
[Thr 1708] *** ERROR => invalid return code of process [bootstrap] (exitcode=66) [jstartxx.c 1452]
[Thr 1708] JControlExecuteBootstrap: error executing bootstrap node [bootstrap] (rc=66)
[Thr 1708] JControlCloseProgram: started (exitcode = 66)
[Thr 1708] JControlCloseProgram: good bye... (exitcode=66)
Bootstrp file log below
-
Bootstrap MODE:
<INSTANCE GLOBALS>
determined by parameter [ID0256613].
-
Exception occured:
com.sap.engine.bootstrap.SynchronizationException: Database initialization failed! Check database properties!
at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:422)
at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:144)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:814)
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:147)
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:66)
at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:419)
at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:144)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:814)
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.dbtech.jdbc.exceptions.DatabaseException: [-4008]: Unknown user name/password combination
at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:72)
at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:852)
at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:511)
at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:375)
at com.sap.dbtech.jdbc.ConnectionSapDB.doConnect(ConnectionSapDB.java:313)
at com.sap.dbtech.jdbc.ConnectionSapDB.<init>(ConnectionSapDB.java:108)
at com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:189)
at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:219)
at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:577)
at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:263)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:302)
... 14 more
[Bootstrap module]> Problem occured while performing synchronization.
From the system log, i noticed ,
log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#-4008#08004#[-4008]: Unknown user name/password combination#jdbc:sapdb://us21217509/J2E?timeout=0&spaceoption=true&unicode=true#<null>#
because of the changes done by me in config tool, the username / password combination is not considered by the system properly i think. Anyways not sure what went on wrong ?
Any idea ?
Raja
Hi,
To change the password of SAPJ2EDB User open the MaxDB database Manager. Log on with user control <your_password>. Be sure that the db is in status online!
Then go to configuration -> database users. You will be prompted to log in as a db administrator (use SUPERDBA). Then you can change the password of SAPJ2EDB. After that restart the db and SAP. this should normally work.
Regards
daniel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes , its worked for me , Thanks for the help
Hence i have rewarded the points ..
Raja S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If so , then how do i do it at database level .
Also today i noticed the simillar problem in SDN.but solution is not provided there
When i search sap.dom fo the same ( as per the above thread says ) , i could see few relevant documents(http://help.sap.com/saphelp_nw2004s/helpdata/en/cd/14c93ec2f7df6ae10000000a114084/frameset.htm ) , but not able to follow the instructions. because i couldnt able to open the visual admin to create new user or group .
Any one have any idea ?
Thanks
Raja S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Be sure that you also change the password on the database. In SecureStore you only change the password on file level!!!.
Regards
daniel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.