on 08-31-2009 8:32 AM
hi all,
the java process dies down after startup. analyzing the logs, the jvm_bootstrap contains the following text:
-
-
Bootstrap MODE:
<INSTANCE GLOBALS>
determined by parameter [ID0034352].
-
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: ORA-28000: the account is locked
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:790)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:362)
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
[Bootstrap module]> Problem occurred while performing synchronization.
-
checking the database log, i found the ORA-01017 and subsequent ORA-28000 errors. the log reads as follows:
-
<!LOGHEADER[START]/>
<!HELP[Manual modification of the header may cause parsing problem!]/>
<!LOGGINGVERSION[1.5.3.7185 - 630]/>
<!NAME[./log/system/database.log]/>
<!PATTERN[database.log]/>
<!FORMATTER[com.sap.tc.logging.ListFormatter]/>
<!ENCODING[UTF8]/>
<!FILESET[0, 5, 10485760]/>
<!PREVIOUSFILE[database.4.log]/>
<!NEXTFILE[database.1.log]/>
<!LOGHEADER[END]/>
#1.5 #001E0B45D0F6004600000197000037F600045C9F24E45E5A#1227738495312#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory####n/a##1d2e0e50a92311dda473001e0b45d0f6#SAPEngine_System_Thread[impl:5]_27##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#1017#72000#ORA-01017: invalid username/password; logon denied #jdbc:oracle:thin:@nakeqas1:1527:EQA#<null># #1.5 #001E0B45D0F6004600000199000037F600045C9F2505B6B6#1227738497528#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory####n/a##1d2e0e50a92311dda473001e0b45d0f6#SAPEngine_System_Thread[impl:5]_27##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#1017#72000#ORA-01017: invalid username/password; logon denied #jdbc:oracle:thin:@nakeqas1:1527:EQA#<null># #1.5 #001E0B45D0F600460000019B000037F600045C9F25269BAC#1227738499684#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory####n/a##1d2e0e50a92311dda473001e0b45d0f6#SAPEngine_System_Thread[impl:5]_27##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#1017#72000#ORA-01017: invalid username/password; logon denied #jdbc:oracle:thin:@nakeqas1:1527:EQA#<null># #1.5 #001E0B45D0F600460000019D000037F600045C9F2547B441#1227738501853#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory####n/a##1d2e0e50a92311dda473001e0b45d0f6#SAPEngine_System_Thread[impl:5]_27##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#1017#72000#ORA-01017: invalid username/password; logon denied
#jdbc:oracle:thin:@nakeqas1:1527:EQA#<null>#
#1.5 #001E0B45D0F600460000019F000037F600045C9F2568BE7C#1227738504018#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory####n/a##1d2e0e50a92311dda473001e0b45d0f6#SAPEngine_System_Thread[impl:5]_27##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#1017#72000#ORA-01017: invalid username/password; logon denied #jdbc:oracle:thin:@nakeqas1:1527:EQA#<null># #1.5 #001E0B45D0F60046000001A1000037F600045C9F2589BEDD#1227738506181#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory####n/a##1d2e0e50a92311dda473001e0b45d0f6#SAPEngine_System_Thread[impl:5]_27##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#1017#72000#ORA-01017: invalid username/password; logon denied #jdbc:oracle:thin:@nakeqas1:1527:EQA#<null># #1.5 #001E0B45D0F60046000001A3000037F600045C9F25AAA2B5#1227738508336#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory####n/a##1d2e0e50a92311dda473001e0b45d0f6#SAPEngine_System_Thread[impl:5]_27##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#1017#72000#ORA-01017: invalid username/password; logon denied #jdbc:oracle:thin:@nakeqas1:1527:EQA#<null># #1.5 #001E0B45D0F60046000001A5000037F600045C9F25CB6176#1227738510482#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory####n/a##1d2e0e50a92311dda473001e0b45d0f6#SAPEngine_System_Thread[impl:5]_27##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#1017#72000#ORA-01017: invalid username/password; logon denied
#jdbc:oracle:thin:@nakeqas1:1527:EQA#<null>#
#1.5 #001E0B45D0F60046000001A7000037F600045C9F25EC3271#1227738512633#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory####n/a##1d2e0e50a92311dda473001e0b45d0f6#SAPEngine_System_Thread[impl:5]_27##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#1017#72000#ORA-01017: invalid username/password; logon denied #jdbc:oracle:thin:@nakeqas1:1527:EQA#<null># #1.5 #001E0B45D0F60046000001A9000037F600045C9F260D07AE#1227738514785#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory####n/a##1d2e0e50a92311dda473001e0b45d0f6#SAPEngine_System_Thread[impl:5]_27##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#1017#72000#ORA-01017: invalid username/password; logon denied #jdbc:oracle:thin:@nakeqas1:1527:EQA#<null># #1.5 #001E0B45D0F60046000001AB000037F600045C9F262E03A2#1227738516946#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory####n/a##1d2e0e50a92311dda473001e0b45d0f6#SAPEngine_System_Thread[impl:5]_27##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#28000#99999#ORA-28000: the account is locked
-
exactly which user is the system pointing to as locked? can this be the cause of the java process dying down? the R3trans -d check returns 0000 and database connection is normal.
ur help is greatly appreciated.
regards,
Amer
For the error: java.sql.SQLException:ORA-01017: invalid
username/password; logon denied error
Please Perform the following steps to change the password :
1) Open the ConfigTool (~/j2ee/configtool/configtool)
2) In the ConfigTool, browse to the Secure Store
3) Change the password to the correct one for the DB user
(jdbc/pool/<SID>/Password entry)
4) Save and restart the Server
Note: 562863: FAQ: Logon mechanisms is for your reference.
Cheers
SuneeL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amer,
You need to search the support portal first before putting any query. You will get solutions to most of the issues in http://service.sap.com/notes
For the issue above please check Note 951167 - ORA-28000: the account is locked.
Hope this helps.
Regards
Raghu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi raghu,
thanx for your replies.
i found that the user for java instance "SAPSR3DB" was locked and unlocked the user account. additionally, i also tried connecting to the database with this user and got connected successfully.
tried restarting the instance again but no success.
the jvm_bootstrap.out file still shows ORA-01017: invalid username/password - logon denied.
any suggestions?
kind regards,
Amer
Hi,
This happened to me too.
What i did is i applied the whole SAP Note 723909 based on 32/64bit server. Then the issue resolved.
You need to increase the memory parameters as there is a problem in synchronization or You need to change the password of your database schema both ABAP and JAVA level.
Please check again all your settings.
Thanks,
Rohan
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.