on 08-20-2010 5:20 PM
Hello SAPiens,
I have to perform a system copy of Bank analyzer 6, NW7.1, ABAP stack only on AIX 5.3, MCOD oracle 10.2.0.4 DB. I'm arriving to the sapinst parameters screen asking for the securestore key. The key is accepted, then it asks for the JAVA components DVD. An issue occurs after this step (JVM is uncompressed then tries to access the DB). Here is th UTL_load_usage :
cat UTL_load_usages.log
<!--LOGHEADER[START]/-->
<!--HELP[Manual modification of the header may cause parsing problem!]/-->
<!--LOGGINGVERSION[1.5.7.1006]/-->
<!--NAME[UTL_load_usages.log]/-->
<!--PATTERN[UTL_load_usages.log]/-->
<!--FORMATTER[com.sap.tc.logging.TraceFormatter(%24d %7s: %m)]/-->
<!--ENCODING[UTF8]/-->
<!--LOGHEADER[END]/-->
Aug 20, 2010 5:51:50 PM Info : Successfully parsed!
Aug 20, 2010 5:51:50 PM Info : Executing command Export...
Aug 20, 2010 5:51:50 PM Info : Establishing DB connection...
Aug 20, 2010 5:51:53 PM Path : Exception : The DataBase is down or the connection parameters are wrong: -sid=BA3 -dsn=jdbc/pool/BA3 -ssprops=/usr/sap/BA3/SYS/global/security/data/SecStore.properties -ssk=/usr/sap/BA3/SYS/global/security/data/SecStore.key -keyphrase=null
java.lang.Exception
at com.sap.exception.BaseExceptionInfo.traceAutomatically(BaseExceptionInfo.java:1230)
at com.sap.exception.BaseExceptionInfo.<init>(BaseExceptionInfo.java:457)
at com.sap.exception.BaseException.<init>(BaseException.java:303)
at com.sap.sl.ut.infoprovider.exceptions.UTInfoException.<init>(UTInfoException.java:99)
at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.connect(DataBaseInfoFactory.java:373)
at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:776)
at com.sap.sl.ut.manager.command.Export.executeExportKDB(Export.java:57)
at com.sap.sl.ut.manager.command.Export.execute(Export.java:81)
at com.sap.sl.ut.manager.command.Command.exec(Command.java:88)
at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:59)
at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:55)
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:585)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:161)
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
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.connect.factory.DriverPooledConnectionFactory.createVendorConnection(DriverPooledConnectionFactory.java:50)
at com.sap.sql.connect.factory.DriverPooledConnectionFactory.getPooledConnection(DriverPooledConnectionFactory.java:37)
at com.sap.sql.connect.datasource.DBDataSourceImpl.createPooledConnection(DBDataSourceImpl.java:677)
at com.sap.sql.connect.datasource.DBDataSourceImpl.newPooledConnection(DBDataSourceImpl.java:626)
at com.sap.sql.connect.datasource.DBDataSourceImpl.getConnection(DBDataSourceImpl.java:105)
at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:202)
at com.sap.sl.ut.manager.persistence.db.DBConnection.connectViaSecureStore(DBConnection.java:159)
at com.sap.sl.ut.manager.persistence.db.DBConnection.connect(DBConnection.java:171)
at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.connect(DataBaseInfoFactory.java:371)
at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:776)
at com.sap.sl.ut.manager.command.Export.executeExportKDB(Export.java:57)
at com.sap.sl.ut.manager.command.Export.execute(Export.java:81)
at com.sap.sl.ut.manager.command.Command.exec(Command.java:88)
at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:59)
at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:55)
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:585)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:161)
Aug 20, 2010 5:51:53 PM Info : Severe (database) error. Return code: 64
I guess sapinst retreives the connection data from the securestore, but fails using it...
The DB is up and running. I checked Oracle users, none of them are locked.
Can anyone kindly advice or provide a search path for shooting this issue ?
Thank you already,
Eric
Hi
Login to ur source system and run the below command
\usr\sap\SID\SYS\global\sltools>checkKeyPhrase.sh -f \usr\sap\SID\SYS\globa
l\security\data\SecStore.properties
give the password what u gave for securestore key in target system. If that came up success ur good
else
Login to the configtool of the source system and change the password
configtool ->Tool->editsecurity store -> changekeyphrase
After that you have to do the (HSC)database copy again and then run the sapinst on the target system giving the new securestore key.
I hope it will work for you
Thanks
Kiran Nekkanti
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kiran,
Thank you for your advice.
the password is correct :
#/sapmnt/BA3/global/sltools> ./checkKeyPhrase.sh -f /sapmnt/BA3/global/security/data/SecStore.properties
INFO: Loading tool launcher...
INFO: [OS: AIX] [VM vendor: SAP AG] [VM version: 5.1.015] [VM type: SAP Java 64-Bit Server VM]
INFO: Main class to start: "com.sap.inst.checkKeyPhrase.CheckKeyPhrase"
INFO: Loading 27 JAR files: [./sharedlib/checkKeyPhrase.jar, ./sharedlib/jdbc.jar, ./sharedlib/jload.jar, ./sharedlib/jload_core.jar, ./sharedlib/jperflib.jar, ./sharedlib/jsizecheck.jar, ./sharedlib/sap.com~sl.ut.infoprovider_lib.jar, ./sharedlib/sap.com~sl.ut.manager.offline.jar, ./sharedlib/sap.com~tc~antlr.jar, ./sharedlib/sap.com~tc~bl~iqlib~impl.jar, ./sharedlib/sap.com~tc~bl~jdsr~jdsr.jar, ./sharedlib/sap.com~tc~bl~offline_launcher~impl.jar, ./sharedlib/sap.com~tc~bl~opensql~implStandalone.jar, ./sharedlib/sap.com~tc~bl~sl~utility.jar, ./sharedlib/sap.com~tc~dd~db~dictionarydatabase~implDictionaryDatabase.jar, ./sharedlib/sap.com~tc~exception.jar, ./sharedlib/sap.com~tc~je~configtool.jar, ./sharedlib/sap.com~tc~je~offlineconfiguration~impl.jar, ./sharedlib/sap.com~tc~logging~java~impl.jar, ./sharedlib/sap.com~tc~sapxmltoolkit~sapxmltoolkit.jar, ./sharedlib/sap.com~tc~sdt~cvl~impl.jar, ./sharedlib/sap.com~tc~sec~secstorefs~java~core.jar, ./../security/lib/tools/iaik_jce.jar, ./../security/lib/tools/iaik_jsse.jar, ./../security/lib/tools/iaik_smime.jar, ./../security/lib/tools/iaik_ssl.jar, ./../security/lib/tools/w3c_http.jar]
INFO: Start
Key phrase::::::::::::
The key phrase is correct.
I guess sapinst is retrieving the DB password from the securestore, tries to connect but gives back the incorrect password error message. But how can that DB password be incorrect if the system is up and running?
What is the DB user name sapinst retreives from the securestore ?
Kind regards,
Eric
Hello Kiran,
Thanks once more for your answer.
I can't get any info about db connectors id. How may I check that ?
I don't get either what you mean about SAPSIDAB and SAPSIDDB. Could you be more explicit ?
Thank you already & nice day,
Eric
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear team,
I had an issue in a system copy of an ECC ABAP+JAVA system.
After we did the restore of the database using database tools (brtools), sapinst was throwing this issue. My issue was the SAPSR3DB password stored in securestore. I just updated SAPSR3DB password from configtool and fixed the problem.
sapinst read the password from the securestore and the securestore had an old password for the old database, since we restored the database we had a mismatch and that's why we had the problem.
Basically we reset the SAPSR3DB password using brconnect and then we set this new password in configtool and that's all folks
best Regards
Javier Manzano
SAP Netweaver Administrator & JEE Architect
Hi
Can you please check the Database Connector id's
SAPSIDAB and SAPSIDDB password are correct. Make sure u have provided the same password of the source system.
Thanks
kiran Nekkanti
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
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.