RE: RAC instance bring up Terminating after "SMON: enabling cache recovery" .... Help
- From: "John Hallas" <john.hallas@xxxxxxxxxx>
- To: <VIVEK_SHARMA@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- 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
-d PNB70MB
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of VIVEK_SHARMA
Sent: 11 January 2008 09:25
To: oracle-l@xxxxxxxxxxxxx
Subject: RAC instance bring up Terminating after "SMON: enabling cache
recovery" .... Help
Folks
In a Benchmark Setup:-
STEPS
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
