ASM instance will not open HELP!

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

ASM instance will not open HELP!

ASM instance will not open HELP!

2006-07-27 - By Steve Perry

Reply: 1 2 3 4 5

If you haven't found it, I think Pete was referring to Note:300472.1
how to delete archive log files out of +ASM

On Jul 26, 2006, at 07:13 PM, Johan Muller wrote:

> From the alert log (rac 2 node cluster on solaris with shared raw
> device):
>
> Wed Jul 26 16:43:15 2006
> Errors in file /u01/app/oracle/admin/rac1db/udump/
> rac1db1_ora_6522.trc:
> ORA-19504 (See ORA-19504.ora-code.com): failed to create file "+ORA_DATA/rac1db/
> 1_244_571764559.dbf"
> ORA-17502 (See ORA-17502.ora-code.com): ksfdcre:4 Failed to create file +ORA_DATA/rac1db/
> 1_244_571764559.dbf
>
> It seems to be at the point where the archiver is stuck; I need to
> add a disk to the archive diskgroup but the instance will not open.
>
> Wed Jul 26 16:43:15 2006
> ARCH: Error 19504 Creating archive log file to '+ORA_DATA/rac1db/
> 1_244_571764559.dbf'
> Reconfiguration complete
> Wed Jul 26 16:43:15 2006
> ARCH: Failed to archive thread 1 sequence 244 (19504)
> Wed Jul 26 16:43:15 2006
> Errors in file /u01/app/oracle/admin/rac1db/udump/
> rac1db1_ora_6522.trc:
> ORA-16038 (See ORA-16038.ora-code.com): log 2 sequence# 244 cannot be archived
> ORA-19504 (See ORA-19504.ora-code.com): failed to create file ""
> ORA-00312 (See ORA-00312.ora-code.com): online log 2 thread 1: '+ORA_DATA/rac1db/onlinelog/
> group_2.258.571764567'
> USER: terminating instance due to error 16038
> Wed Jul 26 16:43:15 2006
> Errors in file /u01/app/oracle/admin/rac1db/bdump/
> rac1db1_lms0_6087.trc:
> ORA-16038 (See ORA-16038.ora-code.com): log sequence# cannot be archived
> Wed Jul 26 16:43:15 2006
> Errors in file /u01/app/oracle/admin/rac1db/bdump/
> rac1db1_lmd0_6082.trc:
> ORA-16038 (See ORA-16038.ora-code.com): log sequence# cannot be archived
> Wed Jul 26 16:43:15 2006
> Errors in file /u01/app/oracle/admin/rac1db/bdump/
> rac1db1_pmon_6063.trc:
> ORA-16038 (See ORA-16038.ora-code.com): log sequence# cannot be archived
> Wed Jul 26 16:43:15 2006
> System state dump is made for local instance
> System State dumped to trace file /u01/app/oracle/admin/rac1db/
> bdump/rac1db1_diag_6065.trc
> Wed Jul 26 16:43:16 2006
> Trace dumping is performing id=[cdmp_20060726164315]
> Wed Jul 26 16:43:21 2006
> Instance terminated by USER, pid = 6522
>
> I have searched high and low but no obvious answers - any ideas how
> to work around/out of this mess
>
>

<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line
-break: after-white-space; ">If you haven't found it, I think Pete was referring
to Note:300472.1�<DIV>how to delete archive log files out of +ASM</DIV><DIV> </DIV><DIV> <DIV><DIV>On Jul 26, 2006, at 07
:13 PM, Johan Muller wrote:</DIV> 
<BLOCKQUOTE type="cite"><SPAN class="Apple-style-span" style="border-collapse:
separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica;
font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal;
letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text
-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto;
text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing:
0px; ">From the
alert log (rac 2 node cluster on solaris with shared raw device):
Wed Jul 26 16:43
:15 2006 Errors in file /u01/app/oracle
/admin/rac1db/udump/rac1db1_ora_6522.trc: ORA-19504 (See ORA-19504.ora-code.com): failed to create file "+ORA_DATA/rac1db/1_244_571764559.dbf"
 
ORA-17502 (See ORA-17502.ora-code.com): ksfdcre:4 Failed to create file +ORA
_DATA/rac1db/1_244_571764559.dbfIt seems to be at the point where the
archiver is stuck; I need to add a disk to the archive diskgroup but the
instance will not open.
Wed Jul 26 16:43:15 2006 ARCH: Error 19504 Creating archive log file to '+ORA_DATA/rac1db
/1_244_571764559.dbf' Reconfiguration
complete Wed Jul 26 16:43:15 2006
 
ARCH: Failed to archive thread 1 sequence 244
(19504) Wed Jul 26 16:43:15 2006 
Errors in file /u01/app/oracle/admin/rac1db
/udump/rac1db1_ora_6522.trc: ORA-16038 (See ORA-16038.ora-code.com):
log 2 sequence# 244 cannot be archived ORA
-19504: failed to create file "" ORA-00312 (See ORA-00312.ora-code.com):
online log 2 thread 1: '+ORA_DATA/rac1db/onlinelog/group_2.258.571764567' USER: terminating instance due to error 16038 Wed Jul 26 16:43:15 2006 Errors in file /u01/app/oracle/admin/rac1db/bdump
/rac1db1_lms0_6087.trc: ORA-16038 (See ORA-16038.ora-code.com): log�
sequence#� cannot be archived Wed Jul 26
16:43:15 2006 Errors in file /u01/app
/oracle/admin/rac1db/bdump/rac1db1_lmd0_6082.trc: ORA-16038 (See ORA-16038.ora-code.com): log� sequence#� cannot be archived Wed Jul 26 16:43:15 2006 Errors in
file /u01/app/oracle/admin/rac1db/bdump/rac1db1_pmon_6063.trc: ORA-16038 (See ORA-16038.ora-code.com): log� sequence#� cannot be archived 
Wed Jul 26 16:43:15 2006 System state dump is made for local instance System State dumped to trace file /u01/app/oracle/admin
/rac1db/bdump/rac1db1_diag_6065.trc Wed
Jul 26 16:43:16 2006 Trace dumping is
performing id=[cdmp_20060726164315] Wed
Jul 26 16:43:21 2006 Instance terminated
by USER, pid = 6522 I have searched
high and low but no obvious answers - any ideas how to work around/out of this
mess </BLOCKQUOTE
></DIV> </DIV></BODY></HTML>