Instance Startup on Second Node is Failing With ORA-19808
(Doc ID 1481209.1)
Last updated on JULY 09, 2023
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Startup of the Instance on second RAC node is failing with below errors:
PRKP-1001 : Error starting instance <INSTANCE_NAME2> on node <HOSTNAME2>
CRS-0215: Could not start resource 'ora.<DB_NAME>.<INSTANCE_NAME2>.inst'
- Tried to start from sqlplus and it is failing with below errors:
SQL*Plus: Release 11.1.0.7.0 - Production on Mon Aug 6 10:45:16 2012
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> startup
ORACLE instance started.
Total System Global Area 1302769664 bytes
Fixed Size 2159392 bytes
Variable Size 989859040 bytes
Database Buffers 301989888 bytes
Redo Buffers 8761344 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch
- db_recovery_file_dest & db_recovery_file_dest_size parametes are having same value on both the nodes.
- spfile is same as what is specified in OCR.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |