Database Not Started with ORA-00205 After Applying GI PSU (Doc ID 1487382.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.4 [Release 10.1 to 11.2]
Information 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

 

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

 
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms