Database Not Started with ORA-00205 After Applying GI PSU
(Doc ID 1487382.1)
Last updated on AUGUST 15, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
1. Role separation for ASM and RDBMS is implemented.
Example> grid OS user for GRID and oracle OS user for databases
2. After applying GI PSU, ASM instance is up but the database instance is not coming up with the following similar error.
sqlplus screen
SQL> startup
ORACLE instance started.
Total System Global Area 1.3362E+10 bytes
Fixed Size 2240984 bytes
Variable Size 7247760936 bytes
Database Buffers 6106906624 bytes
Redo Buffers 4935680 bytes
ORA-00205: error in identifying control file, check alert log for more info
ORACLE instance started.
Total System Global Area 1.3362E+10 bytes
Fixed Size 2240984 bytes
Variable Size 7247760936 bytes
Database Buffers 6106906624 bytes
Redo Buffers 4935680 bytes
ORA-00205: error in identifying control file, check alert log for more info
RDBMS alert.log
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATADG/sg3pd/controlfile/current.260.790090209'
ORA-17503: ksfdopn:2 Failed to open file +DATADG/sg3pd/controlfile/current.260.790090209
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
ORA-205 signalled during: ALTER DATABASE
ORA-00202: control file: '+DATADG/sg3pd/controlfile/current.260.790090209'
ORA-17503: ksfdopn:2 Failed to open file +DATADG/sg3pd/controlfile/current.260.790090209
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
ORA-205 signalled during: ALTER DATABASE
3. ASM instance is up with grid user
$ps -ef| grep smon
root 26666 1 0 16:25 ? 00:00:34 /apps/opt/grid/product/11.2.0/bin/osysmond.bin
grid 27105 1 0 16:26 ? 00:00:00 asm_smon_+ASM2
oracle 27223 32077 0 19:26 pts/0 00:00:00 grep smon
root 26666 1 0 16:25 ? 00:00:34 /apps/opt/grid/product/11.2.0/bin/osysmond.bin
grid 27105 1 0 16:26 ? 00:00:00 asm_smon_+ASM2
oracle 27223 32077 0 19:26 pts/0 00:00:00 grep smon
4. oracle binary from RDBMS HOME has read and write permission for ASM devices.
$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle oinstall 232458772 Aug 28 13:39 /apps/opt/oracle/product/11.2.0/db203/bin/oracle
$ ls -l /dev/oracleasm/disks/*
brw-rw---- 1 grid oinstall 8, 16 Aug 28 19:26 /dev/oracleasm/disks/DATA
brw-rw---- 1 grid oinstall 8, 48 Aug 28 16:26 /dev/oracleasm/disks/FLASH
brw-rw---- 1 grid oinstall 8, 128 Aug 28 16:28 /dev/oracleasm/disks/REDO
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 |
| Cause |
| Solution |