Skip to Content
0
Jan 17, 2012 at 04:13 AM

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

1802 Views

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