OraFAQ Forum: RAC & Failsafe » CRS-0215: Could not start resource

Home » Server Options » RAC & Failsafe » CRS-0215: Could not start resource (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CRS-0215: Could not start resource [message #356560]

Fri, 31 October 2008 03:19

grpatwari
Messages: 288
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.

Report message to a moderator

Re: CRS-0215: Could not start resource [message #356605 is a reply to message #356560]

Fri, 31 October 2008 08:06

Mahesh Rajendran
Messages: 10706
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.

Report message to a moderator

Re: CRS-0215: Could not start resource [message #356884 is a reply to message #356560]

Mon, 03 November 2008 00:11

grpatwari
Messages: 288
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.

Report message to a moderator

Re: CRS-0215: Could not start resource [message #357857 is a reply to message #356560]

Thu, 06 November 2008 23:13

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Hi,

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

Please tell me steps.

Report message to a moderator

Re: CRS-0215: Could not start resource [message #365066 is a reply to message #356560]

Wed, 10 December 2008 16:39

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

Report message to a moderator

Re: CRS-0215: Could not start resource [message #541092 is a reply to message #356560]

Fri, 27 January 2012 09:29

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 27 12:21:57 CDT 2023