Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-03113: end-of-file while opening NONASM db with ASM archive dest

user2015671Sep 27 2011 — edited Sep 27 2011
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2011
Added on Sep 27 2011
3 comments
292 views