cancel
Showing results for 
Search instead for 
Did you mean: 

System copy : ORA-01017: invalid username/password; logon denied

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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