Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Instance startup issue on node 2

we are facing an issue with node2 while starting up the instance using srvctl command, and also while starting up from SQLPLUS it shows end-of-communication error, and the database starts up using "startup pfile" command, errors are mentioned below
------ Starting Database on node3 using SQLPLUS --------------
SQL> startup
ORA-03113: end-of-file on communication channel
SQL> startup pfile=$ORACLE_HOME/dbs/initepaydb2.ora
ORACLE instance started.
Total System Global Area 9999220736 bytes
Fixed Size 3035040 bytes
Variable Size 9688842336 bytes
Database Buffers 272629760 bytes
Redo Buffers 34713600 bytes
Database mounted.
Database opened.
------ Starting instance through srvctl ----------------------------
[oracle@db-19ctestenv2 log]$ srvctl start instance -d epaydbx -i epaydb2
PRCR-1013 : Failed to start resource ora.epaydbx.db
PRCR-1064 : Failed to start resource ora.epaydbx.db on node db-19ctestenv2
CRS-5017: The resource action "ora.epaydbx.db start" encountered the following error:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3651
Additional information: 97244571
Process ID: 0
Session ID: 0 Serial number: 0
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/db-19ctestenv2/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.epaydbx.db' on 'db-19ctestenv2' failed
-------------------------------------------------------------------------------------------------------

Comments

Post Details

Added on Nov 12 2022
1 comment
435 views