ORA-01017: invalid username/password; logon denied

[Former Member]

Hi,

I am trying to generate the control.sql and control.trc files for my SAP database restoration.

Note that I have successfully restored my SAP database a year ago without having an error.

Could anyone help me with this error?

In PROD server (AIX), using an admin account, I have executed the script below to generate the control.sql and control.trc files:

./ora_br_copy.sh -generateFiles -targetSid WEQ -password mypassword listenerPort 1521

But the script returned me with an error ORA-01017.

+ /usr/java14_64/bin/java -showversion -cp ./.:./orabrcopy.jar:/oracle/WEP/102_64/jdbc/lib/classes12.jar com.sap.inst.lib.app.SecureStartup  com.sap.inst.orabrcopy.OraBRCopy -oracleHome /oracle/WEP/102_64 -sourceSid WEP -generateFiles -targetSid WEQ -password mypassword listenerPort 1521

java version "1.4.2"

Java(TM) 2 Runtime Environment, Standard Edition (build 2.3)

IBM J9 VM (build 2.3, J2RE 1.4.2 IBM J9 2.3 AIX ppc64-64 j9ap64142ifx-20070510a (JIT enabled)

J9VM - 20070425_12492_BHdSMr

JIT  - 20070223_1804ifx1_r8

GC   - 20070227_AA)

Required system resources are missing or not available:

  Cannot establish connection to Oracle database as user SYSTEM using URL 'jdbc:oracle:oci8:@':

ORA-01017: invalid username/password; logon denied

[former_member188883 · Accepted solution]

Hi Marvin,

Please check the status of use SYSTEM . Connect to sqlplus and run the command

SQL> Select username, account_status from dba_users ;

If possible share the output of this command.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

Here it is.

SQL> select username, account_status from dba_users;

USERNAME                       ACCOUNT_STATUS

------------------------------ --------------------------------

OPS$SR3ADM                     OPEN

OPS$ORABIP                     OPEN

OPS$BIPADM                     OPEN

OPS$SAPSERVICEBIP              OPEN

SYS                            OPEN

SYSTEM                         OPEN

SAPSR3                         OPEN

SAPSR3DB                       OPEN

OUTLN                          LOCKED

TSMSYS                         EXPIRED & LOCKED

DIP                            EXPIRED & LOCKED

USERNAME                       ACCOUNT_STATUS

------------------------------ --------------------------------

DBSNMP                         EXPIRED & LOCKED

12 rows selected.

[former_member188883 · Accepted solution]

Hi Marvin,

In the command above SID being Production SID being used is WEP while in the select command we could see references of database instance BIP ??

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

Sorry for that, I was looking at the wrong server, but WEP also has the same output as above.

Thanks.

[former_member188883 · Accepted solution]

Hi Marvin,

Try out this

> sqlplus /nolog

> connect

> username: SYSTEM

> password: < password of SYSTEM user>

Check whether it connects ?

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

I cant execute that because I do not know the password of user SYSTEM.

I am using the wep admin user and passwork when logging to unix.

[former_member188883 · Accepted solution]

Hi Marvin,

Specify the hostname as in the listener.ora in the -localhost option:

./ora_br_copy.sh -generateFiles -targetSid WEQ -password ****** -listenerPort 1521  -localhost xxxxxxx

localhost should be same as mentioned in listerner.ora file.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

Thanks for your efforts but the error is still there when I execute it with localhost.

Required system resources are missing or not available:

  Cannot establish connection to Oracle database as user SYSTEM using URL 'jdbc:oracle:oci8:@':

ORA-01017: invalid username/password; logon denied

[former_member188883 · Accepted solution]

Hi Marvin,

Could you download latest orabrcopy.sh file from SAP marketplace and use the command mentioned above along with -localhost

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

I think that would not be possible as the source system is a Production system.

Do you have any other ways of generating controlfiles from my source sap system and then use it for resotring my QA system?

[former_member188883 · Accepted solution]

Hi Marvin,

You may connect to Oracle database using sqlplus

> sqlplus "/as sysdba"

SQL> Alter database backup controlfile to trace;

SQL>exit

It will generate a controlfile in the /oracle/<SID>/saptrace/usertrace folder. You may identify this file with the timestamp when you run the commend.

You may use this tracefile to prepare control.sql script which in turn will generate controlfiles in the target system.

Note: You need to modify the SID to target system SID in this control.sql script.

Regards,

Deepak Kori

[Former Member]

follow the video. its very clear in there. you will definately get your problem solved.

ORA-01017: invalid username/password; login denied. - YouTube

[Former Member]

i had same issue while using SAP, the error is like :

OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

C     ORA-01017: invalid username/password; logon denied

C  *** ERROR => CONNECT failed with sql error ’1017′

so i follow this solution and its solved my problem.

[Former Member]

Thank you Deepak.