ORA-03113: end-of-file on communication channel

**Dave44** · Feb 21 '08, 03:25 AM

Originally posted by Ajay2000

Hello There !!

After removing dataguard configuration from primary and standby database , the startup of primary db fails with the below mentioned error message .

SQL> startup;
ORACLE instance started.

Total System Global Area 209715200 bytes
Fixed Size 2019672 bytes
Variable Size 88084136 bytes
Database Buffers 113246208 bytes
Redo Buffers 6365184 bytes
Database mounted.
ORA-03113: end-of-file on communication channel

Alert log :-

LGWR: Primary database is in MAXIMUM AVAILABILITY mode
LGWR: Destination LOG_ARCHIVE_DES T_3 is using asynchronous network I/O
LGWR: Destination LOG_ARCHIVE_DES T_2 is not serviced by LGWR
LGWR: Destination LOG_ARCHIVE_DES T_1 is not serviced by LGWR
LGWR: Minimum of 1 synchronous standby database required
Wed Feb 20 18:26:45 2008
Errors in file /u03/app/admin/oracle/admin/ORCL/bdump/orcl_lgwr_4251. trc:
ORA-16072: a minimum of one standby database destination is required
Wed Feb 20 18:26:45 2008
Errors in file /u03/app/admin/oracle/admin/ORCL/bdump/orcl_lgwr_4251. trc:
ORA-16072: a minimum of one standby database destination is required
LGWR: terminating instance due to error 16072
Instance terminated by LGWR, pid = 4251

could somebody have a look plz .

Regards ,Ajay

you need to add a standy archive log location in the init parameter file.

when you run this:
select value From v$parameter where name = 'standby_archiv e_dest';
is value null?

ORA-03113: end-of-file on communication channel

ORA-03113: end-of-file on communication channel

Comment