Shutting down one instance shuts down the whole RAC database. 2005-09-15 - By Kevin Closson
yeah, looking at this closer, I'd mount with
the "noac" mount option until Oracle implements
O_DIRECT for all NAS opens...or, like I said in my
last email, call HP and get an EFS/CG <smirk>
http://h18006.www1.hp.com/products/storageworks/efs/index.html
>>>-- --Original Message-- --
>>>From: Shreehari Desikan [mailto:shree@(protected)]
>>>Sent: Thursday, September 15, 2005 4:21 PM
>>>To: Bennett Leve
>>>Cc: suse-oracle@(protected)
>>>Subject: Re: [suse-oracle] Shutting down one instance shuts
>>>down the whole RAC database.
>>>
>>>Hi Bennet
>>>Here is NFS mount options.
>>>
>>>db-filer.sjc.estips.com:/vol/oradata /oradata nfs
>>>rw,bg,hard,nointr,tcp,actimeo=0,timeo`0,mountvers=3,nfsvers
>>>=3,rsize2768,wsize2768
>>>0 0
>>>db-filer.sjc.estips.com:/vol/oralog /oralog nfs
>>>rw,bg,hard,nointr,tcp,actimeo=0,timeo`0,mountvers=3,nfsvers
>>>=3,rsize2768,wsize2768
>>>0 0
>>>
>>>The above options were according to the suggestions of
>>>Netapp documents and Oracle documents.
>>>
>>>Shree.
>>>
>>>Bennett Leve wrote:
>>>
>>>> Shreehari,
>>>>
>>>> What are your NFS mount options on the servers? This typically is
>>>> caused by stale read.
>>>>
>>>> -Bennett
>>>>
>>>> Shreehari Desikan wrote:
>>>>
>>>>> Hi All
>>>>> I am running SLES 9 SP2 Linux on a 2 node RAC cluster
>>>configuration,
>>>>> with NFS mounted Netapp filer and Oracle 9.2.0.6 RAC and 9.2.0.6
>>>>> Cluster Manager The problem is when I shut down the
>>>instance on any
>>>>> one of the nodes, the entire database comes to a halt.
>>>The node that
>>>>> I was expecting to be running has the following messgaes in the
>>>>> Alert_sid.log file
>>>>>
>>>>> Errors in file
>>>/var/opt/oracle/admin/.../bdump/gmdb2_smon_18637.trc:
>>>>> ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kclchkblk_3], [0],
>>>>> [733768], [14], [], [], [], [] Fatal internal error
>>>happened while
>>>>> SMON was doing instance transaction recovery.
>>>>> Thu Sep 15 01:17:38 2005
>>>>> Errors in file
>>>/var/opt/oracle/admin/.../bdump/gmdb2_smon_18637.trc:
>>>>> ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kclchkblk_3], [0],
>>>>> [733768], [14], [], [], [], []
>>>>> SMON: terminating instance due to error 600 Thu Sep 15
>>>01:17:38 2005
>>>>> Trace dumping is performing id=[cdmp_20050915011738] Thu Sep 15
>>>>> 01:17:38 2005 Dump system state for local instance only
>>>Thu Sep 15
>>>>> 01:17:38 2005 Trace dumping is performing
>>>id=[cdmp_20050915011738]
>>>>> Thu Sep 15 01:17:43 2005 Instance terminated by SMON, pid = 18637
>>>>>
>>>>> Oracle support suggested a patch "" 2448994 "DIRECT IO
>>>SUPPORT OVER
>>>>> NFS". ""...however that still did not fix the issue.
>>>>>
>>>>> Has anyone come across this situation and fixed it?? Any help is
>>>>> definitely much appreciated.
>>>>>
>>>>>
>>>>> Regards,
>>>>> Shree.
>>>>>
>>>>
>>>>
>>>
>>>
>>>--
>>>To unsubscribe, email: suse-oracle-unsubscribe@(protected) For
>>>additional commands, email: suse-oracle-help@(protected) Please
>>>see http://www.suse.com/oracle/ before posting
>>>
>>>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
