ORA-01033: ORACLE initialization or shutdown in progress in log_archive_dest_2 for standby
SQL> @error
-----------------------------------------------------
Host Name : ora-gold1
Ip Address : 192.168.0.27
Error date : 18-10-2014 12:25:49
Dest ID : 2
Status : ERROR
DB Name : vihaan_stdy
DB Mode : UNKNOWN
Recovery Mode : IDLE
Protection Mode : MAXIMUM PERFORMANCE
SRL Count : 0
SRLActive : 0
Archived Thread# : 0
ArchivedSeq# : 0
Applied Thread# : 0
Destination : stdy
Archiver : LGWR
Transmit Mode : ASYNCHRONOUS
Affirm : NO
Asynchronous Blocks: 61440
Net Timeout : 30
Delay (Mins) : 0
Reopen (Secs) : 300
Register : YES
Binding : OPTIONAL
Compression : DISABLE
Error : ORA-01033: ORACLE initialization or shutdown in progress
----------------------------------------------------
check whether are you able to connect with password primary and standby database with password ?
Check Primary to primary with password [oracle@ora-gold1 ~]$ sqlplus system/sys@prim SQL*Plus: Release 12.1.0.2.0 Production on Sat Oct 18 13:06:12 2014 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Check standby from primary
[oracle@ora-gold1 ~]$ sqlplus system/sys@stdy
SQL*Plus: Release 12.1.0.2.0 Production on Sat Oct 18 13:06:23 2014
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
so problem with password file .
copy password file from primary to standby ...
[oracle@ora-golden2 dbs]$ scp oracle@192.168.0.27:/u01/app/oracle/product/12.1.0/db_1/dbs/ora* .
oracle@192.168.0.27's password:
orapwvihaan 100% 8704 8.5KB/s 00:00
on primary
set linesize 200 pagesize 200
col destination format a30
col ERROR format a40
select dest_id,destination,status,database_mode,recovery_mode,error from V$ARCHIVE_DEST_STATUS
where status != 'INACTIVE';
DEST_ID DESTINATION STATUS DATABASE_MODE RECOVERY_MODE ERROR
---------- ------------------------------ --------- --------------- ----------------------- ----------------------------------------
1 /u01/app/oracle/ArchiveLog VALID OPEN IDLE
2 stdy VALID MOUNTED-STANDBY MANAGED REAL TIME APPLY
