Thursday 23 January 2014

Generally used unix/linux commands in RAC Cluster



Generally used unix/linux commands in RAC Cluster

SRVCTL or Server Control Utility is used to start and stop the database and instances, manage configuration information, and to add, move or remove instances and services.
To Start a RAC database
srvctl start nodeapps -n <nodename>
srvctl start asm -n <nodename>
srvctl start database -d <dbname>
options: srvctl start database -d <dbname> -o open | -o mount | -o nomount

Stop a RAC database
srvctl stop database -d <dbname> -o immediate
options: srvctl stop database -d <dbname> -o normal | -o transactional | -o immediate | -o abort

srvctl stop asm -n <nodename>
options: srvctl stop asm -n <nodename> -o immediate

srvctl stop nodeapps -n <nodename>
To check status and configurations
Nodeapps:
srvctl status nodeapps -n <nodename>

srvctl config nodeapps -n <nodename>
ASM:
srvctl status asm -n <nodename>
srvctl config asm -n <nodename>

Database:
srvctl status database -d <dbname>
srvctl config database -d <dbname> (shows instances name, node and oracle home)

Instance:
srvctl status instance -d <dbname> -i instancename

Services:
srvctl status service -d <dbname>



To start and stop instances
srvctl start instance -d <dbname> -i instancename
srvctl stop instance -d <dbname> -i instancename

To start, stop and manage services
srvctl status service -d <dbname>
srvctl config service -d <dbname>
srvctl start service -d <dbname> -s servicename
srvctl stop service -d <dbname> -s servicename





#Disclaimer: - These commands are general purpose commands. Please contact me over mail or phone for implementing in any production System.


Author – Akash Pramanik.
Database Administrator – IBM
Phone – +91 9804944189

5 comments:

  1. Thanks for this information.

    Can you help me with some Idea how to set up a clustureware. Or if there is some basic checkpoints of starting a clusterware. Each time I start up I see a lot of issues. Most of the time I have to engage Oracle.

    ReplyDelete
  2. This is very good Stuff.

    ReplyDelete
  3. Excellent one

    ReplyDelete
  4. I've read some good stuff here. Definitely value bookmarking for revisiting.
    I wonder how so much effort you set to create this kind
    of excellent informative website.

    Here is my web site: free porn

    ReplyDelete