Home » Server Options » RAC & Failsafe » CRS-0215: Could not start resource (Oracle 10g)
CRS-0215: Could not start resource [message #356560] Fri, 31 October 2008 03:19 Go to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
Hi,

I want to change the processes parameter in RAC system.I am using spfile.I have ASM environment and two instances.

I followed the below steps from first server but i m getting error.

1) connected as sys user
2) alter system set cluster_database=false scope=spfile sid='<firstinstanceid>';
3) exited from oracle
4) stoped second instance from linux.
$ srvctl stop instance -d <DBname> -i <secondinstanceid>
5) Again i connected as sys user.
6) create spfile from pfile;
7) shutting down the db and started.
Cool checked the processes.
show parameter processes;
9) Again i created pfile from spfile.
create pfile from spfile;
10) shutting down the db and started with mount state.
11) Changed processes to 900
alter system set processes=900 scope=spfile sid='<firstinstanceid>';

12) I made cluster database as true.
alter system set cluster_database=true scope=spfile sid='<firstinstanceid>';
13) opened the db. shutting down the db and started again.
14) checked the processes. It is changed to 900.
15) come out of oracle.
16) Now I started the second instance
srvctl start instance -d <DBname> -i <secondinstanceid>

But second instance is not starting and it is giving error.
PRKP-1001 : Error starting instance <sencondinstanceid> on node st-habam-db2
CRS-0215: Could not start resource 'ora.<DBname>.<secondInstanceid>.inst'.

Are above steps are correct?
Please give the steps to follow.
Re: CRS-0215: Could not start resource [message #356605 is a reply to message #356560] Fri, 31 October 2008 08:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I am completely lost in your 16 step procedure to change just an init parameter.
You no need to set it individually for instance.
If you have backup/clean copy of init file or spfile file
just start over. use scope=spfile and restart or
create pfile from spfile.
set process parameter.
mount single instance (not with srvctl).
check if value is effected.
create spfile from pfile.
shutdown.
start rac databases using srvctl.


Re: CRS-0215: Could not start resource [message #356884 is a reply to message #356560] Mon, 03 November 2008 00:11 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
Hi Mahesh,

I am not setting the parameter individually but I stoped second instance and changing parameter from first instance.Again starting second instance.

As per your reply,I followed below steps but not changed the processes parameter.

create pfile from spfile;
alter system set processes=900 scope=spfile;
shutdown immediate;
startup mount;
show parameter processes;
create spfile from pfile;
alter database open;
shutdown immediate;
startup;
exit;

srvctl start database -d <DBname>

Please reply ASAP.
Re: CRS-0215: Could not start resource [message #357857 is a reply to message #356560] Thu, 06 November 2008 23:13 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
Hi,

I want to change processes in HA environment.I have two instances.

Please tell me steps.
Re: CRS-0215: Could not start resource [message #365066 is a reply to message #356560] Wed, 10 December 2008 16:39 Go to previous messageGo to next message
sonumalhi
Messages: 62
Registered: April 2008
Member
You can simply change the parameter one by one on each node...
1. alter system set cluster_database=false scope=spfile sid='<firstinstanceid>';
2 Bounce the instance.

As this parameter need not to be same acrross the cluster.
You can have one instance up and running while bouncing other instance
Re: CRS-0215: Could not start resource [message #541092 is a reply to message #356560] Fri, 27 January 2012 09:29 Go to previous message
parthokonar
Messages: 17
Registered: September 2006
Location: india
Junior Member
if the instances are running in the spfile, then no worries

connect in one instance..

ALTER SYSTEM SET = scope=spfile sid='*';
srvctl stop database -d "db name"
srvctl start database -d "db name"

check the status..

Thanks
Partho


Previous Topic: Expdp/Impdp performs slow in RAC oracle11gR2
Next Topic: VOTING DiSK 11Gr1
Goto Forum:
  


Current Time: Sun Dec 04 20:44:16 CST 2016

Total time taken to generate the page: 0.14644 seconds