ORA-01017: invalid username/password; logon denied in Standby Server

[former_member199632]

Hello,

In Standby Server , when executing brapply process it shows an error.

It happens suddenly

Now logs from PRD to standby is not applying.

Error log is as follows:

-

---

BR0002I BRARCHIVE 7.00 (42)

BR0006I Start of offline redo log processing: aehrjpck.svd 2012-01-17 08.38.34

BR0484I BRARCHIVE log file: /oracle/PRD/saparch/aehrjpck.svd

BR0280I BRARCHIVE time stamp: 2012-01-17 08.38.34

BR0301W SQL error -1017 at location BrDbConnect-2, SQL statement:

'CONNECT system/********@PRD.WORLD'

ORA-01017: invalid username/password; logon denied

BR0310W Connect to database instance PRD/PRIMARY failed.

BR0338E Applying offline redo log file /oracle/PRD/oraarch/standby/PRDarch1_24090_696018700.dbf failed

BR0338E Applying offline redo log file /oracle/PRD/oraarch/standby/PRDarch1_24091_696018700.dbf failed

BR0016I 0 offline redo log files processed, total size 0.000 MB

BR0280I BRARCHIVE time stamp: 2012-01-17 08.38.36

BR0301W SQL error -1017 at location BrDbConnect-2, SQL statement:

'CONNECT system/********@PRD.WORLD'

ORA-01017: invalid username/password; logon denied

BR0310W Connect to database instance PRD/PRIMARY failed

BR0007I End of offline redo log processing: aehrjpck.svd 2012-01-17 08.38.36

BR0280I BRARCHIVE time stamp: 2012-01-17 08.38.36

BR0005I BRARCHIVE terminated with errors

-

---

Standby DB is in mount state

I have checked from v$instance.

1. select status from v$instance;

MOUNTED

brapply commant is as follows;

1. brarchive -u system/systempwd -c -f -d disk -m 30 -sd

How can i check whether , the status of SYSTEM user?

Since Standby is in mount state, im not allowed to query DBA_USERS

How can i check whether , SYSTEM user is locked or not.

Is it possible to change the password of SYSTEM , while DB is in mount state.

I have tried like this;

#sqlplus

/ as sysdba

<It logon as sys - success>

conn SYSTEM

Enter password: systempwd

ERROR:

ORA-01033: ORACLE Initialization or shutdown in progress

Warning: You are not longer connected to ORACLE

Im not able to connect as SYSTEM user.

What should be the solution for this;

regards,

Zerandib

[former_member188883 · Accepted solution]

Hi,

In a standby database, you can only login with sys user account and not with others. You can login with other accounts once you cancel the recovery and open the database

Please check with user SYS.

Regards,

Deepak Kori

[former_member199632 · Accepted solution]

Hello Deepak,

I have tried with SYS user as well

But still no success

1. brarchive -u /-c -f -d disk -m 30 -sd

and

1. brarchive -u sys/syspwd -c -f -d disk -m 30 -sd

regards,

Zerandib

[former_member188883 · Accepted solution]

Hi,

How can i check whether , the status of SYSTEM user?
Since Standby is in mount state, im not allowed to query DBA_USERS
How can i check whether , SYSTEM user is locked or not.

Can you connect to database using SYS user and perform above operations.

Regards,

Deepak Kori

[former_member189725]

It seems your standby database is shutting down .

Please check inyour alert log if there is any info.

If so , then shutdown the database (shutdown abort) and mount it again and start the application of redo logs . Also check if brconnect is running before shutting down the standby database.

If you abort brconnect , please ensure the lock file in the working directory of brarchive is removed , so that brarchive can again start applying the logs.

[former_member199632]

Hi

Issue Solved.

Actually the issue was not incorrect username / password

Since the Standby Database is in MOUNT state, SYSTEM user is not able to login. - Therefore Its expected

"The problem was one log file was corrupted."

After recovering that log file, problem solved

regards,

zerandib