Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
ORA 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA 01722 invalid number
 
RAC ASM error

RAC ASM error

2007-09-04       - By Randy Johnson

 Back
What are you seeing in your ASM alert log? Try starting it just using
sqlplus and check the alert log.

   -Randy

  __ __  

From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]
On Behalf Of Murtuja Khokhar
Sent: Tuesday, September 04, 2007 3:36 AM
To: freelists
Subject: RAC ASM error


Hi,

Environment:

Oracle 10.2.0.1.0 Standrad Edition
Solaris 10 (sparc 64bit)

I am using Oracle Clusterware only.


I have configure ASM instance on two nodes.I can start both ASM instances
without any error.but when I give crs_stat -t

Name Type Target State Host
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
ora....SM2.asm application ONLINE UNKNOWN bull...rac2
ora....C2.lsnr application ONLINE ONLINE bull...rac2
ora....ac2.gsd application ONLINE ONLINE bull...rac2
ora....ac2.ons application ONLINE ONLINE bull...rac2
ora....ac2.vip application ONLINE ONLINE bull...rac2
ora....SM1.asm application ONLINE UNKNOWN catf...rac1
ora....C1.lsnr application ONLINE ONLINE catf...rac1
ora....ac1.gsd application ONLINE ONLINE catf...rac1
ora....ac1.ons application ONLINE ONLINE catf...rac1
ora....ac1.vip application ONLINE ONLINE catf...rac1

so I tried to start ASM using srvctl

srvctl start asm -n bullhead-rac2

It's giving me below error:

PRKS-1009 (See http://RKS-1009.ora-code.com) : Failed to start ASM instance "+ASM2" on node "bullhead-rac2",
[PRKS-1009 (See http://RKS-1009.ora-code.com) : Failed to start ASM instance "+ASM2" on node "bullhead-rac2",
[CRS-1028 (See http://CRS-1028.ora-code.com): Dependency analysis failed because of:
CRS-0223 (See http://CRS-0223.ora-code.com): Resource 'ora.bullhead-rac2.ASM2.asm' has placement error.]]
[PRKS-1009 (See http://RKS-1009.ora-code.com) : Failed to start ASM instance "+ASM2" on node "bullhead-rac2",
[CRS-1028 (See http://CRS-1028.ora-code.com): Dependency analysis failed because of:
CRS-0223 (See http://CRS-0223.ora-code.com): Resource 'ora.bullhead-rac2.ASM2.asm' has placement error.]]



  __ __  

Got a little couch potato?
Check out fun HYPERLINK
"http://us.rd.yahoo.com/evt=48248/*http://search.yahoo.com/search?fr=oni_on_
mail&p=summer+activities+for+kids&cs=bz"summer activities for kids.


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.485 / Virus Database: 269.13.5/988 - Release Date: 9/4/2007
9:14 AM



No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.485 / Virus Database: 269.13.5/988 - Release Date: 9/4/2007
9:14 AM


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1250 (See http://ows-1250.ora-code.com)">


<META content="MSHTML 6.00.6000.16525" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=218291701-05092007>What are you seeing in your ASM alert log? Try
starting
it just using sqlplus and check the alert log.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=218291701-05092007></SPAN></FONT>&nbsp;</DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=218291701-05092007>&nbsp;&nbsp;&nbsp; -Randy</SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>Murtuja
Khokhar<BR><B>Sent:</B> Tuesday, September 04, 2007 3:36 AM<BR><B>To:</B>
freelists<BR><B>Subject:</B> RAC ASM error<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Hi, </DIV>
<DIV>&nbsp;</DIV>
<DIV>Environment:</DIV>
<DIV>&nbsp;</DIV>
<DIV>Oracle 10.2.0.1.0 Standrad Edition</DIV>
<DIV>Solaris 10 (sparc 64bit)</DIV>
<DIV>&nbsp;</DIV>
<DIV>I am using Oracle Clusterware only.</DIV>
<DIV><BR><BR>I have configure ASM instance on two nodes.I can start both ASM
instances without any error.but when I give crs_stat -t <BR><BR>Name Type
Target
State Host <BR>-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
<BR><B>ora....SM2.asm application ONLINE UNKNOWN bull...rac2</B>
<BR>ora....C2.lsnr application ONLINE ONLINE bull...rac2 <BR>ora....ac2.gsd
application ONLINE ONLINE bull...rac2 <BR>ora....ac2.ons application ONLINE
ONLINE bull...rac2 <BR>ora....ac2.vip application ONLINE ONLINE bull...rac2
<BR><B>ora....SM1.asm application ONLINE UNKNOWN catf...rac1</B>
<BR>ora....C1.lsnr application ONLINE ONLINE catf...rac1 <BR>ora....ac1.gsd
application ONLINE ONLINE catf...rac1 <BR>ora....ac1.ons application ONLINE
ONLINE catf...rac1 <BR>ora....ac1.vip application ONLINE ONLINE catf...rac1
<BR><BR>so I tried to start ASM using srvctl <BR><BR><B>srvctl start asm -n
bullhead-rac2</B> <BR><BR>It's giving me below error: <BR></DIV>
<DIV>PRKS-1009 (See http://RKS-1009.ora-code.com) : Failed to start ASM instance "+ASM2" on node "bullhead-rac2",
[PRKS-1009 (See http://RKS-1009.ora-code.com) : Failed to start ASM instance "+ASM2" on node "bullhead-rac2",
[CRS-1028 (See http://CRS-1028.ora-code.com): Dependency analysis failed because of: <BR>CRS-0223 (See http://CRS-0223.ora-code.com): Resource
'ora.bullhead-rac2.ASM2.asm' has placement error.]] <BR>[PRKS-1009 (See http://RKS-1009.ora-code.com) : Failed to
start ASM instance "+ASM2" on node "bullhead-rac2", [CRS-1028 (See http://CRS-1028.ora-code.com): Dependency
analysis failed because of: <BR>CRS-0223 (See http://CRS-0223.ora-code.com): Resource 'ora.bullhead-rac2.ASM2.asm'
has placement error.]] <BR></DIV>
<P>
<HR SIZE=1>
Got a little couch potato? <BR>Check out fun <A
href="http://us.rd.yahoo.com/evt=48248/*http://search.yahoo.com/search?fr=oni
_on_mail&amp;p=summer+activities+for+kids&amp;cs=bz">summer
activities for kids.</A><BR>
<P><FONT size=2>No virus found in this incoming message.<BR>Checked by AVG Free
Edition.<BR>Version: 7.5.485 / Virus Database: 269.13.5/988 - Release Date:
9/4/2007 9:14 AM<BR></FONT></P></BODY></HTML>
<BR>

<P><FONT SIZE=2>No virus found in this outgoing message.<BR>
Checked by AVG Free Edition.<BR>
Version: 7.5.485 / Virus Database: 269.13.5/988 - Release Date: 9/4/2007 9:14
AM<BR>
</FONT> </P>