Viswamitra's blog

SQL> startup nomount;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2235208 bytes
Variable Size             746587320 bytes
Database Buffers          314572800 bytes
Redo Buffers                5541888 bytes

After that I opened the alert log in another window and tried to mount the database.

SQL> alter database mount;

alter database mount

ERROR at line 1:

ORA-00205: error in identifying control file, check alert log for more info

In the alert log I can see below errors.

******************************************************************

Fatal NI connect error 12547, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/app/oracle_grid/11.2.0.4/grid/bin/oracle)(ARGV0=oracle+ASM_asmb_dpqms)(ENVS=’ORACLE_HOME=/app/oracle_grid/11.2.0.4/grid,ORACLE_SID=+ASM’)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))’))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=rt6000292)(USER=oracle))))

  VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.3.0 – Production

        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 – Production

  Time: 23-FEB-2016 16:06:15

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12547

TNS-12547: TNS:lost contact

    ns secondary err code: 12560

    nt main err code: 517

TNS-00517: Lost contact

    nt secondary err code: 32

    nt OS err code: 0

ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/app/oracle_grid/11.2.0.4/grid/bin/oracle)(ARGV0=oracle+ASM_asmb_dpqms)(ENVS=’ORACLE_HOME=/app/oracle_grid/11.2.0.4/grid,ORACLE_SID=+ASM’)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))’))(enable=setuser))

Starting background process ASMB

Tue Feb 23 16:06:15 2016

ASMB started with pid=20, OS id=3968

******************************************************************

My database instance is not able to communicate with ASM , due to which it is not able to read my controlfile.

Solution :-

There is a file named “oracle” in $ORACLE_HOME/bin/ , the files userid is not set like below.

+ASM:/app/oracle/diag/asm/+asm/+ASM/trace>
ls -l /app/oracle_grid/11.2.0.4/grid/bin/oracle

-rwxr-x–x 1 grid oinstall 209914903 Feb 17 10:19 /app/oracle_grid/11.2.0.4/grid/bin/oracle

I have set the userid using the (chmod 6751 oracle). After that I tried to mount the database and it got mounted, then my database is able to communicate with ASM and I opened the database.

ASM:/app/oracle/diag/asm/+asm/+ASM/trace>
chmod 6751 /app/oracle_grid/11.2.0.4/grid/bin/oracle

ASM:/app/oracle/diag/asm/+asm/+ASM/trace>
ls -l /app/oracle_grid/11.2.0.4/grid/bin/oracle

-rwsr-s–x 1 grid oinstall 209914903 Feb 17 10:19 /app/oracle_grid/11.2.0.4/grid/bin/oracle