Skip to Content
0
Former Member
Aug 20, 2010 at 04:20 PM

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

2021 Views

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