cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Go to solution
Former Member

on ‎10-07-2013 11:08 AM

0 Kudos

Dear ALL,

We are doing System Copy Export in ECC Production System (ECC 6.0) .

Operating System:AIX 6.1

DATABASE: Oracle 11g

Kernel version: 720 401 patch number.

In The Export Preparation Phase, We got the below error.

*******************************************************************************************************************************************************

ERROR      2013-10-07 15:19:12.598 [sixxcstepexecute.cpp:951]
FCO-00011  The step getUsageTypes with step key |NW_Prepare_Export|ind|ind|ind|i
nd|0|0|NW_Java_Prepare_Export_Dialog|ind|ind|ind|ind|5|0|getUsageTypes was execu
ted with status ERROR ( Last error reported by the step :uncaught exception: nw.
usageTypes.utlConnectionError:
Execution of UTL tool '/usr/java14_64/bin/java -classpath /usr/sap/KSP/SYS/globa
l/sltools/sharedlib/launcher.jar -showversion -Xmx256m -Xj9 com.sap.engine.offli
ne.OfflineToolStart com.sap.sl.ut.manager.UtlMain /usr/sap/KSP/SYS/global/securi
ty/lib/tools/iaik_jce.jar:/usr/sap/KSP/SYS/global/security/lib/tools/iaik_jsse.j
ar:/usr/sap/KSP/SYS/global/security/lib/tools/iaik_smime.jar:/usr/sap/KSP/SYS/gl
obal/security/lib/tools/iaik_ssl.jar:/usr/sap/KSP/SYS/global/security/lib/tools/
w3c_http.jar:/usr/sap/KSP/SYS/global/sltools/sharedlib/sap.com~sl.ut.infoprovide
r_lib.jar:/usr/sap/KSP/SYS/global/sltools/sharedlib/sap.com~sl.ut.manager.offlin
e.jar:/usr/sap/KSP/SYS/global/sltools/sharedlib/antlr.jar:/usr/sap/KSP/SYS/globa
l/sltools/sharedlib/exception.jar:/usr/sap/KSP/SYS/global/sltools/sharedlib/jddi
.jar:/usr/sap/KSP/SYS/global/sltools/sharedlib/logging.jar:/usr/sap/KSP/SYS/glob
al/sltools/sharedlib/offlineconfiguration.jar:/usr/sap/KSP/SYS/global/sltools/sh
aredlib/opensqlsta.jar:/usr/sap/KSP/SYS/global/sltools/sharedlib/tc_sec_secstore
fs.jar:/usr/sap/KSP/SYS/global/sltools/sharedlib/sap.com~tc~sdt~cvl~impl.jar:/us
r/sap/KSP/SYS/global/sltools/sharedlib/SDMutil.jar:/usr/sap/KSP/SYS/global/sltoo
ls/sharedlib/SLUtil.jar:/oracle/client/10x_64/instantclient/ojdbc14.jar -export
-type=keydb -expfile=/tmp/sapinst_instdir/ERP/LM/COPY/ORA/EXP/CENTRAL/AS/PREEXP/
usages_data.xml -log=UTL_load_usages.log -sid=KSP -dsn=jdbc/pool/KSP -ssprops=/u
sr/sap/KSP/SYS/global/security/data/SecStore.properties -ssk=/usr/sap/KSP/SYS/gl
obal/security/data/SecStore.key' aborts with return code 64 due to a database co
nnection error. DIAGNOSIS: The connection parameters are wrong or the database s
erver has been shut down. SOLUTION: Check 'UTL_load_usages.log' and '/tmp/sapins
t_instdir/ERP/LM/COPY/ORA/EXP/CENTRAL/AS/PREEXP/UTL.java.log' for more informati
on. (in script unknown, line 0: ???)).

INFO       2013-10-07 15:20:02.476 [sixxcstepexecute.cpp:1004]
An error occured and the user decide to stop.\n Current step "|NW_Prepare_Export
|ind|ind|ind|ind|0|0|NW_Java_Prepare_Export_Dialog|ind|ind|ind|ind|5|0|getUsageT
ypes".

** *********************************************************************************************************************************************************************

We checked the below logs in "/tmp/sapinst_instdir/ERP/LM/COPY/ORA/EXP/CENTRAL/AS/PREEXP/

UTL.java.1.log     

UTL.java.log       

UTL_load_usages.log

LOGS Of UTL_load_usages.log

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

      at com.sap.exception.BaseExceptionInfo.traceAutomatically(BaseExceptionInfo.java:1141)
        at com.sap.exception.BaseExceptionInfo.<init>(BaseExceptionInfo.java:413)
        at com.sap.exception.BaseException.<init>(BaseException.java:302)
        at com.sap.sl.ut.infoprovider.exceptions.UTInfoException.<init>(UTInfoException.java:96)
        at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.connect(DataBaseInfoFactory.java:215)
        at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:624)
        at com.sap.sl.ut.manager.command.Export.executeExportKDB(Export.java:56)
        at com.sap.sl.ut.manager.command.Export.execute(Export.java:80)
        at com.sap.sl.ut.manager.command.Command.exec(Command.java:90)
        at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:49)
        at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:45)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:61)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
        at java.lang.reflect.Method.invoke(Method.java:391)
       at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
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.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)
        at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:522)
        at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)
        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:213)
        at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:624)
        at com.sap.sl.ut.manager.command.Export.executeExportKDB(Export.java:56)
        at com.sap.sl.ut.manager.command.Export.execute(Export.java:80)
        at com.sap.sl.ut.manager.command.Command.exec(Command.java:90)
        at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:49)
        at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:45)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:61)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
        at java.lang.reflect.Method.invoke(Method.java:391)
        at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Oct 7, 2013 3:19:10 PM   Info   : Severe (database) error. Return code: 64

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

We can able to connect SQLPLus with SYSDBA .

Kindly help us how to resolve this issue in the System Copy installation.

Regards,

Gayathri.K

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Reagan
Product and Topic Expert
Product and Topic Expert
‎10-07-2013 11:30 AM

Check whether the Java schema password maintained in the secure store in config tool is correct.

Regards

RB

Show replies
Show replies
Former Member
‎10-10-2013 12:35 PM
0 Kudos

Hello Reagan Benjamin,

As you said, It is true .

Incorrect java schema DB password maintained SAP<SID>DB.

After changing the password, we were able to connect config tool and System Copy JAVA export has been completed Successfully.

Issue resolved now.

Thanks a lot!!

Regards,

Gayathri.K

Answers (3)

Answers (3)

Former Member
‎07-31-2015 8:13 AM
0 Kudos

Hi Gayathri K,

You also can refer to this also :

Show replies
Show replies
Former Member
‎10-10-2013 12:39 PM
0 Kudos

Hello All,

In Config Tool , Secstore , Incorrect java schema DB password ( jdbc/pool/<SID>/Password )  maintained for the User (jdbc/pool/<SID>/User = SAP<SID>DB).

After changing the password, we were able to connect config tool and System Copy JAVA export has been completed Successfully.

Issue resolved now.

Thanks a lot!!

Regards,

Gayathri.K

Show replies
Show replies
AtulKumarJain
Active Contributor
‎10-08-2013 5:44 AM
0 Kudos

Hi Gayathri,

Please check below thread for same issue.

http://scn.sap.com/thread/1765832

BR

Atul

Show replies
Show replies
Ask a Question