RAC node2 instance not coming up error - "ora-03113 end-of-file on communication channel while startup"
SYS@TTRN2>startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-03113: end-of-file on communication channel
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
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
When:-
During CloneIssue:
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>startupORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-03113: end-of-file on communication channel
[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