Basic Unix/Linux commands in RAC Administration

Basic Unix/Linux commands in RAC Administration

SRVCTL Utility is used to start and stop the database and instances and configuration management etc.

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>

Check Clusterware version

crsctl query crs softwareversion

Identification of t voting disk location:
# crsctl query css votedisk

Comments

Post a Comment

Popular posts from this blog

Interview Questions and Answers of Oracle DBA

There are some important question and answer for Oracle DBA. 1. What are the components of SGA? SGA is used to store shared information across all database users. It mainly includes Library cache, Data Dictionary cache, Database Buffer Cache, Redo log Buffer cache, Shared Pool. 2. Difference between SGA and PGA. SGA (System Global Area) is a memory area allocated during an instance start up. SGA is allocated as 40% of RAM size by default. SGA size is controlled by DB_CACHE_SIZE parameter defined in initialization parameter file (init.ora file or SPFILE).  PGA (Program or Process Global Area) is a memory area that stores a user session specific information. PGA is allocated as 10% of RAM size by default. 3. What is System Change Number (SCN)?  SCN is a unique ID that Oracle generates for every committed transaction.  It is recorded for every change in the redo entry. 4. What is Database Writer (DBWR) and when does DBWR write to the data file? -D...
Read more

Oracle 12c load testing withThe Silly Little Oracle Benchmark(SLOB)

SLOB is the best SQL workload to drive maximum physical random I/O from a database platform. SLOB is an I/O intensive SQL generator, instead of a synthetic I/O generator, with the following characteristics: Ø   Supports testing physical, random single-block reads (database file sequential read/DB file parallel read) Ø   Supports testing random single-block writes (database file parallel write) Ø   Supports testing extreme REDO logging I/O Ø   Consists of simple PL/SQL Installation: Installation steps are below: 1.        Install the latest SLOB RPM yum install http://yum.outrun.nl/outrun-extras.rpm 2.        Go to the url "https://kevinclosson.net/slob/" and then click on SLOB 2.3: Click Here link. This link will redirect on " https://my.syncplicity.com/share/ize90aqgqy9yj1d/2015.07.16.slob_2.3.0.3-1.tar " page, then click on download button to download the SLOB 2.3 in .tar file ...
Read more