Monday, June 11, 2018

RAC node2 instance not coming up error - "ora-03113 end-of-file on communication channel while startup"

RAC node2 instance not coming up error - "ora-03113 end-of-file on communication channel while startup"


When:- 

During Clone

Issue:


SYS@TTRN2>startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-03113: end-of-file on communication channel

Problem :-

SYS@TTRN2>startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-03113: end-of-file on communication channel


On node1 protocol correctly changed to rds , but on node2 it is udp

[oracle@del1os1 ~]$ . ./ttrn.env
[oracle@del1os1 trace]$ $ORACLE_HOME/bin/skgxpinfo
rds


[oracle@del1os2 ~]$ . ./ttrn.env
[oracle@del1os2 ~]$  $ORACLE_HOME/bin/skgxpinfo
udp      ---- >>>>>>   In our case issue is wrong protocol

Solution:-


On node2 execute below

[oracle@del1os2 ~]$ cd $ORACLE_HOME/rdbms/lib
[oracle@del1os2 lib]$ make -f ins_rdbms.mk ipc_rds ioracle
---
----
-----
[oracle@del1os2 lib]$  $ORACLE_HOME/bin/skgxpinfo
rds


Able to start now :

SYS@TTRN2>startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 4856257425 bytes
Fixed Size                  54658762 bytes
Variable Size            5648524575 bytes
Database Buffers         6325487115 bytes
Redo Buffers               11476992 bytes
Database mounted.
Database opened.
SYS@TTRN2>

This error is very common and we might have different solution, it is one of the scenario which I faced so share here , might help someone.

Thanks,
searchinoracle



No comments:

Post a Comment