ORA-03113: end-of-file while opening NONASM db with ASM archive dest
Problem Description: Oracle 11.2.0 installation is with ORACLE user.
Oracle 11.2.0 Grid installation is with GRID user.
Now i need my archivelogs should be on ASM destination.
My Database is NONASM
So i changed archivelog LOG_ARCHIVE_DEST_1 to +OBTDG1/arch asm destination.
My ASM is up and running.
SO when i go for starting up database then time i am getting ORA-03113: end-of-file on communication channel
--------------------------------
SQL> startup
ORACLE instance started.
Total System Global Area 275615744 bytes
Fixed Size 2212496 bytes
Variable Size 184552816 bytes
Database Buffers 83886080 bytes
Redo Buffers 4964352 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 2845
Session ID: 125 Serial number: 5
--------------------------------
Alert log says:
==========================
Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/app/11.2.0/grid/bin/oracle)(ARGV0=oracle+ASM_asmb_q112sm1)(ENVS='ORACLE_HOME=/oracle/app/11.2.0/grid,ORACLE_SID=+ASM')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=vm-lnx-btk04)(USER=oracle))))
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 26-SEP-2011 18:38:31
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=/oracle/app/11.2.0/grid/bin/oracle)(ARGV0=oracle+ASM_asmb_q112sm1)(ENVS='ORACLE_HOME=/oracle/app/11.2.0/grid,ORACLE_SID=+ASM')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Starting background process ASMB
Mon Sep 26 18:38:34 2011
ASMB started with pid=22, OS id=2490
Errors in file /qa/data/obt/Q112SM1/admin/bdump/diag/rdbms/q112sm1/Q112SM1/trace/Q112SM1_ora_2468.trc:
ORA-16038: log 3 sequence# 84 cannot be archived
ORA-00254: error in archive control string ''
ORA-00312: online log 3 thread 1: '/qa/data/obt/Q112SM1/data/redo03.log'
ORA-15001: diskgroup "OBTDG1" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact
USER (ospid: 2468): terminating the instance due to error 16038
=======================================
Question 1: What extra settings i need to do to use ASM destination for archivelogs when Grid is installed with GRID user and oracle is installed with ORACLE user?
Thanks in advance for any help