My Oracle Support Banner

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 and later
Information in this document applies to any platform.


 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


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  


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


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



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.