Home » Server Options » RAC & Failsafe » Steps to stop and start RAC instance (Oracle 11.2.0.3.0 , Linux 5)
Steps to stop and start RAC instance [message #582633] Sat, 20 April 2013 08:38 Go to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Hi,

What is the hierarchy to stop and start oracle RAC instance ? It will be helpful if you could
provide the steps along with commands.

Thank you,
Suhas

[Updated on: Sat, 20 April 2013 08:39]

Report message to a moderator

Re: Steps to stop and start RAC instance [message #582636 is a reply to message #582633] Sat, 20 April 2013 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
srvctl stop -d <dbname> -i <instancename>

Regards
Michel
Re: Steps to stop and start RAC instance [message #582637 is a reply to message #582636] Sat, 20 April 2013 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle® Real Application Clusters Administration and Deployment Guide

C:\>srvctl -h
Syntaxe : srvctl [-V]
Syntaxe : srvctl add database -d <db_unique_name> -o <oracle_home> [-m <domain_name>] [-p <spfile>]
[-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s <start_options>] [-t <sto
p_options>] [-n <db_name>] [-y {AUTOMATIC | MANUAL}] [-a "<diskgroup_list>"]
Syntaxe : srvctl config database [-d <db_unique_name> [-a]]
Syntaxe : srvctl start database -d <db_unique_name> [-o <start_options>]
Syntaxe : srvctl stop database -d <db_unique_name> [-o <stop_options>] [-f]
Syntaxe : srvctl status database -d <db_unique_name> [-f] [-v]
Syntaxe : srvctl enable database -d <db_unique_name>
Syntaxe : srvctl disable database -d <db_unique_name>
Syntaxe : srvctl modify database -d <db_unique_name> [-n <db_name>] [-o <oracle_home>] [-u <oracle_u
ser>] [-m <domain>] [-p <spfile>]  [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STAN
DBY}] [-s <start_options>] [-t <stop_options>] [-y {AUTOMATIC | MANUAL}] [-a "<diskgroup_list>"|-z]
Syntaxe : srvctl remove database -d <db_unique_name> [-f] [-y] [-v]
Syntaxe : srvctl getenv database -d <db_unique_name> [-t "<name_list>"]
Syntaxe : srvctl setenv database -d <db_unique_name> {-t <name>=<val>[,<name>=<val>,...] | -T <name>
=<val>}
Syntaxe : srvctl unsetenv database -d <db_unique_name> -t "<name_list>"
Syntaxe : srvctl add service -d <db_unique_name> -s <service_name> [-l [PRIMARY][,PHYSICAL_STANDBY][
,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}][-q {true|false}] [-j {SHORT|LONG}] [
-B {NONE|SERVICE_TIME|THROUGHPUT}][-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}][-z <failover_retries>
] [-w <failover_delay>]
Syntaxe : srvctl config service -d <db_unique_name> [-s <service_name>] [-a]
Syntaxe : srvctl start service -d <db_unique_name> [-s "<service_name_list>" [-o <start_options>]
Syntaxe : srvctl stop service -d <db_unique_name> [-s "<service_name_list>" [-f]
Syntaxe : srvctl status service -d <db_unique_name> [-s "<service_name_list>"] [-f] [-v]
Syntaxe : srvctl enable service -d <db_unique_name> -s "<service_name_list>"
Syntaxe : srvctl disable service -d <db_unique_name> -s "<service_name_list>"
Syntaxe : srvctl modify service -d <db_unique_name> -s <service_name> [-P {BASIC|PRECONNECT|NONE}] [
-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}][-q {
true|false}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {N
ONE|BASIC}] [-z <integer>] [-w <integer>]
Syntaxe : srvctl remove service -d <db_unique_name> -s <service_name> [-f]
Syntaxe : srvctl add asm [-l <lsnr_name>] [-p <spfile>] [-d <asm_diskstring>]
Syntaxe : srvctl config asm [-a]
Syntaxe : srvctl start asm [-o <start_options>]
Syntaxe : srvctl stop asm [-o <stop_options>] [-f]
Syntaxe : srvctl status asm [-a]
Syntaxe : srvctl enable asm
Syntaxe : srvctl disable asm
Syntaxe : srvctl modify asm [-l <lsnr_name>] [-p <spfile>] [-d <asm_diskstring>]
Syntaxe : srvctl remove asm [-f]
Syntaxe : srvctl getenv asm [-t <name>[, ...]]
Syntaxe : srvctl setenv asm -t "<name>=<val> [,...]" | -T "<name>=<value>"
Syntaxe : srvctl unsetenv asm -t "<name>[, ...]"
Syntaxe : srvctl start diskgroup -g <dg_name>
Syntaxe : srvctl stop diskgroup -g <dg_name> [-f]
Syntaxe : srvctl status diskgroup -g <dg_name> [-a]
Syntaxe : srvctl enable diskgroup -g <dg_name>
Syntaxe : srvctl disable diskgroup -g <dg_name>
Syntaxe : srvctl remove diskgroup -g <dg_name> [-f]
Syntaxe : srvctl add listener [-l <lsnr_name>] [-s] [-p "[TCP:]<port>[, ...][/IPC:<key>][/NMP:<pipe_
name>][/TCPS:<s_port>] [/SDP:<port>]"] [-o <oracle_home>]
Syntaxe : srvctl config listener [-l <lsnr_name>]
Syntaxe : srvctl start listener [-l <lsnr_name>]
Syntaxe : srvctl stop listener [-l <lsnr_name>]
Syntaxe : srvctl enable listener [-l <lsnr_name>]
Syntaxe : srvctl disable listener [-l <lsnr_name>]
Syntaxe : srvctl modify listener [-l <lsnr_name>] [-o <oracle_home>] [-p "[TCP:]<port>[, ...][/IPC:<
key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]"]
Syntaxe : srvctl remove listener [-l <lsnr_name> | -a] [-f]
Syntaxe : srvctl getenv listener [-l <lsnr_name>] [-t <name>[, ...]]
Syntaxe : srvctl setenv listener [-l <lsnr_name>] -t "<name>=<val> [,...]" | -T "<name>=<value>"
Syntaxe : srvctl unsetenv listener [-l <lsnr_name>] -t "<name>[, ...]"
Syntaxe : srvctl start home -o <oracle_home> -s <state_file>
Syntaxe : srvctl stop home -o <oracle_home> -s <state_file> [-t <stop_options>] [-f]
Syntaxe : srvctl status home -o <oracle_home> -s <state_file>
Syntaxe : srvctl add ons [-l <ons-local-port>]  [-r <ons-remote-port>] [-t <host>[:<port>][,<host>[:
<port>]...]] [-v]
Syntaxe : srvctl remove ons [-f] [-v]
Syntaxe : srvctl enable ons [-v]
Syntaxe : srvctl disable ons [-v]
Syntaxe : srvctl modify ons [-l <ons-local-port>]  [-r <ons-remote-port>] [-t <host>[:<port>][,<host
>[:<port>]...]] [-v]
Syntaxe : srvctl config ons
Syntaxe : srvctl status ons
Syntaxe : srvctl start ons [-v]
Syntaxe : srvctl stop ons [-v]
Syntaxe : srvctl add eons [-p <portnum>] [-m <multicast-ip-address>] [-e <eons-listen-port>] [-v]
Syntaxe : srvctl remove eons [-f] [-v]
Syntaxe : srvctl enable eons [-v]
Syntaxe : srvctl disable eons [-v]
Syntaxe : srvctl modify eons [-p <portnum>] [-m <multicast-ip-address>] [-e <eons-listen-port>] [-v]

Syntaxe : srvctl config eons
Syntaxe : srvctl status eons
Syntaxe : srvctl start eons [-v]
Syntaxe : srvctl stop eons [-v]

Regards
Michel
Re: Steps to stop and start RAC instance [message #582650 is a reply to message #582637] Sat, 20 April 2013 16:55 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
MIchel,

I want the hierarchy to stop and start RAC instance.

Thank you
Re: Steps to stop and start RAC instance [message #582651 is a reply to message #582650] Sat, 20 April 2013 17:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I want the hierarchy to stop and start RAC instance.
Things only occur when you actually take the required actions so that they do occur.

I want to win the lottery.

Re: Steps to stop and start RAC instance [message #582652 is a reply to message #582651] Sat, 20 April 2013 18:07 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Blackswan,

<I want to win the lottery.>

I dont want to win any lotteries.I want the steps to stop and start RAC instance. Smile
Re: Steps to stop and start RAC instance [message #582653 is a reply to message #582652] Sat, 20 April 2013 18:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
when all else fails, Read The Fine Manual

http://docs.oracle.com/cd/B28359_01/rac.111/b28252/intro_tdprc.htm

why should we write here when existing documentation contains all the details?
Re: Steps to stop and start RAC instance [message #582687 is a reply to message #582653] Sun, 21 April 2013 12:49 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Quote:
why should we write here when existing documentation contains all the details?

I dont find your answer relevant to my question.

When we are asked to stop and start Oracle RAC instance how do we do that.
Is it enough that we issue the following

srvctl stop instance -d db_name -i inst_name

srvctl start instance -d db_name -i inst_name

With Regards,
Re: Steps to stop and start RAC instance [message #582688 is a reply to message #582687] Sun, 21 April 2013 13:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, the was my answer but you did not trust it.
Now try it and see it with your eyes.

If you don't believe the answer in the forum why do you post then?

This is also in the documentation we pointed you to.
But you don't believe it too.

You should better take a course on RAC.
But will you believe the trainer?

Regards
Michel

[Updated on: Sun, 21 April 2013 13:41]

Report message to a moderator

Re: Steps to stop and start RAC instance [message #582689 is a reply to message #582688] Sun, 21 April 2013 15:06 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Michel,

I heard to stop and start RAC instance, we need to stop services,asm and listeners too.So what to clarify with you
i posted my question here but you are pointing me to document.
Can you provide the link where i could find the answer to my question?

With Regards,
Re: Steps to stop and start RAC instance [message #582690 is a reply to message #582689] Sun, 21 April 2013 15:35 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
We already pointed you to the documentation, read it.

Regards
Michel
Previous Topic: sqlplus / as sysdba -- does not work
Next Topic: Oracle cluster
Goto Forum:
  


Current Time: Thu Mar 28 07:24:59 CDT 2024