RE: RAC instance bring up Terminating after "SMON: enabling cache recovery" .... Help
Date: Fri, 11 Jan 2008 11:03:43 -0000
Al I can think of is to stop the problematic instance using srvctl with
-o option (abort) and restart the instance again using srvctl
The next option would be to stop the database using srvctl stop database
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA Sent: 11 January 2008 09:25
Subject: RAC instance bring up Terminating after "SMON: enabling cache recovery" .... Help
In a Benchmark Setup:-
1) CPUs increased to 80 from from 24 on 1 of the RAC Nodes. CPUs increased to 30 from 24 on 2 Other Nodes. 2) 3 RAC instances brought up normally. The 3 RAC Nodes are normal. 3) On initiating a Benchmark Application Transaction Run, % sys became 100 only on 1 Node containing 80 CPUs. (On the Other 2 Nodes normal - % sys is normal). % sys going to 100 % seems to be an O.S. Bug. 4) RAC Instance brought down manually using "sqlplus / as sysdba" -> "shutdown immediate" on the node showing 100 % sys usage 5) % sys immediately became normal after instance shutdown & continues to be normal now.
6) Thereafter startup of RAC using srvctl start instance -d PNB70MB -i "PNB70MB2" terminating After MOUNT at "SMON: enabling cache recovery". Thus Rollback Tablespace is not brought up & Database OPEN is NOT fully Completed. 2 corresponding .trc files are dumped with time stamp greater that alert_PNB70MB2.log in such a case.
7) However Manual startup of the respective RAC instance using "sqlplus / as sysdba" -> "startup" is completing FULLY
The information included in this email and any files transmitted with it may contain information that is confidential and it must not be used by, or its contents or attachments copied or disclosed, to persons other than the intended addressee. If you have received this email in error, please notify BJSS. In the absence of written agreement to the contrary BJSS’ relevant standard terms of contract for any work to be undertaken will apply. Please carry out virus or such other checks as you consider appropriate in respect of this email. BJSS do not accept responsibility for any adverse effect upon your system or data in relation to this email or any files transmitted with it. BJSS Limited, a company registered in England and Wales (Company Number 2777575), VAT Registration Number 613295452, Registered Office Address, First Floor, Coronet House, Queen Street, Leeds, LS1 2TW
http://www.freelists.org/webpage/oracle-l Received on Fri Jan 11 2008 - 05:03:43 CST