Sachin's RAC Blog

RAID 5 vs RAID 0+1 and Standalone vs Cluster

2010-09-16T16:44:00.015+05:30

The below picture will help us to find out the differences between

(a) Standalone database and Clustered database

(b) RAID 0 and RAID 1

Related Articles: cluvfy commands crsctl commands srvctl commands

RAC 1Z0-048 dumps

2010-07-12T17:29:00.018+05:30

Click on the links to download the dumps.

Oracle Database 10g: Real Application Clusters Administrator Certified Expert

PRIOR CERTIFICATION
10g DBA OCP
or 11g DBA OCP

EXAM
1Z0-048 Oracle Database 10g R2: RAC for Administrators

[OR]

TRAINING
Complete one of the approved instructor-led online or in-class courses.

EXAM
1Z0-048 Oracle Database 10g R2: RAC for Administrators

FORM
Submit the Hands On Course Requirement Form

Related Articles: RAC (1Z0-048) Certification

New features in 9i/10g/11g RAC

2010-07-07T13:00:00.028+05:30

Oracle 9i RAC

OPS (Oracle Parallel Server) was renamed as RAC
CFS (Cluster File System) was supported
OCFS (Oracle Cluster File System) for Linux and Windows
watchdog timer replaced by hangcheck timer

Oracle 10g R1 RAC

Cluster Manager replaced by CRS
ASM introduced
Concept of Services expanded
ocrcheck introduced
ocrdump introduced
AWR was instance specific

Oracle 10g R2 RAC

CRS was renamed as Clusterware
asmcmd introduced
CLUVFY introduced
OCR and Voting disks can be mirrored
Can use FAN/FCF with TAF for OCI and ODP.NET

Oracle 11g R1 RAC

Oracle 11g RAC parallel upgrades - Oracle 11g have rolling upgrade features whereby RAC database can be upgraded without any downtime.
Hot patching - Zero downtime patch application.
Oracle RAC load balancing advisor - Starting from 10g R2 we have RAC load balancing advisor utility. 11g RAC load balancing advisor is only available with clients who use .NET, ODBC, or the Oracle Call Interface (OCI).
ADDM for RAC - Oracle has incorporated RAC into the automatic database diagnostic monitor, for cross-node advisories. The script addmrpt.sql run give report for single instance, will not report all instances in RAC, this is known as instance ADDM. But using the new package DBMS_ADDM, we can generate report for all instances of RAC, this known as database ADDM.
ADR command-line tool - Oracle Automatic Diagnostic repository (ADR) has a new command-line interface named ADRCI, ADR Command Interface. ADRCI can be used to access the 11g alert log:
$adrci
adrci> show alert
Optimized RAC cache fusion protocols - moves on from the general cache fusion protocols in 10g to deal with specific scenarios where the protocols could be further optimized.
Oracle 11g RAC Grid provisioning - The Oracle grid control provisioning pack allows us to "blow-out" a RAC node without the time-consuming install, using a pre-installed "footprint".
Data Guard - Standby snapshot - The new standby snapshot feature allows us to encapsulate a snapshot for regression testing. We can collect a standby snapshot and move it into our QA database, ensuring that our regression test uses real production data.
Quick Fault Resolution - Automatic capture of diagnostics (dumps) for a fault.

Oracle 11g R2 RAC

We can store everything on the ASM. We can store OCR & voting files also on the ASM.
ASMCA
Single Client Access Name (SCAN) - eliminates the need to change tns entry when nodes are added to or removed from the Cluster. RAC instances register to SCAN listeners as remote listeners. SCAN is fully qualified name. Oracle recommends assigning 3 addresses to SCAN, which create three SCAN listeners.
AWR is consolidated for the database.
11g Release 2 Real Application Cluster (RAC) has server pooling technologies so it’s easier to provision and manage database grids. This update is geared toward dynamically adjusting servers as corporations manage the ebb and flow between data requirements for datawarehousing and applications.
By default, LOAD_BALANCE is ON.
GSD, gsdctl introduced.
RAC OneNode is a new option that makes it easier to consolidate databases that aren’t mission critical, but need redundancy.

Source: Internet

Related Articles: cluvfy commands crsctl commands srvctl commands

diagcollection.pl commands

2010-01-08T15:40:00.006+05:30

DIAGCOLLECTION:

Tool to collect diagnosis information.

#$ORA_CRS_HOME/bin/diagcollection.pl

#$ORA_CRS_HOME/bin/diagcollection.pl --collect

#$ORA_CRS_HOME/bin/diagcollection.pl --collect --crs $ORA_CRS_HOME

#$ORA_CRS_HOME/bin/diagcollection.pl --collect --oh $ORACLE_HOME

#$ORA_CRS_HOME/bin/diagcollection.pl --collect --ob $ORACLE_BASE

#$ORA_CRS_HOME/bin/diagcollection.pl --collect --all

#$ORA_CRS_HOME/bin/diagcollection.pl --coreanalysis

--- analyze all the trace & log files and summarizes in a text file

#$ORA_CRS_HOME/bin/diagcollection.pl --clean --- cleans gathered info

Related Articles: cluvfy commands crsctl commands srvctl commands

racgons commands

2010-01-08T15:29:00.008+05:30

RACGONS:

racgons add_config node_name:port [node_name:port] [node_name:port] ...

racgons add_config eg5242:4948
racgons add_config cell1:3333 cell08:4444 cell13:5555

racgons remove_config node_name[:port] [node_name[:port]] [node_name[:port]] ...

racgons remove_config lnx03
racgons remove_config lnx01 lnx04 lnx07:1234

Related Articles: cluvfy commands crsctl commands crs_stat commands

clscfg commands

2010-01-06T19:03:00.002+05:30

CLSCFG: -- Oracle cluster configuration tool

clscfg -help or clscfg -h

clscfg -install -- creates a new configuration

clscfg -add -- adds a node to the configuration

clscfg -delete -- deletes a node from the configuration

clscfg -upgrade -– upgrades an existing configuration

clscfg -downgrade -- downgrades an existing configuration

clscfg -local -- creates a special single-node configuration for ASM

clscfg -concepts -- brief listing of terminology used in the other modes

clscfg -trace -- may be used in conjunction with any mode above for tracing

Related Articles: cluvfy commands crsctl commands crs_stat commands

gsdctl commands

2010-01-06T19:01:00.002+05:30

GSDCTL: - Global Service Daemon Control

gsdctl start -- start the GSD service

gsdctl stop -- stop the GSD service

gsdctl stat -- To obtain the status of the GSD service

$ gsdctl start
$ gsdctl stop
$ gsdctl stat

Log file will be at $ORACLE_HOME/srvm/log/gsdaemon_node_name.log

Related Articles: crsctl commands srvctl commands crs_stat commands

cluvfy commands

2010-01-06T18:22:00.016+05:30

CLUVFY: Cluster Verification Utility

cluvfy [-help] or cluvfy -h

cluvfy stage {-pre|-post} stage_name stage_specific_options [-verbose]

cluvfy stage -post hwos -n node_list [-verbose]

./runcluvfy.sh stage -post hwos -n node1,node2 -verbose

cluvfy stage -pre cfs -n node_list [-verbose]

cluvfy stage -post cfs -n node_list [-verbose]

cluvfy stage -pre crsinst -n node_list [-c ocr_location] [-r {10gR1|10gR2|11gR1|11gR2}] [-q voting_disk] [-osdba osdba_group]

[-orainv orainventory_group] [-verbose]

cluvfy stage -pre crsinst -n node1,node2,node3

./runcluvfy.sh stage -pre crsinst -n all -verbose

cluvfy stage -post crsinst -n node_list [-verbose]

cluvfy stage -pre dbinst -n node_list [-r {10gR1|10gR2|11gR1|11gR2}] [-osdba osdba_group] [-orainv orainventory_group] [-verbose]

cluvfy stage -pre dbcfg -n node_list -d oracle_home [-verbose]

====================================

cluvfy comp component_name component_specific_options [-verbose]

cluvfy comp nodereach -n node_list [-srcnode node] [-verbose]

cluvfy comp nodecon -n node_list [-i interface_list] [-verbose]

cluvfy comp nodecon -n node1,node2,node3 –i eth0 -verbose

cluvfy comp nodeapp [-n node_list] [-verbose]

cluvfy comp peer [-refnode node] -n node_list [-r {10gR1|10gR2|11gR1|11gR2}] [-orainv orainventory_group] [-osdba osdba_group] [-verbose]

cluvfy comp peer -n node1,node2 -r 10gR2 -verbose

cluvfy comp crs [-n node_list] [-verbose]

cluvfy comp cfs [-n node_list] -f file_system [-verbose]

cluvfy comp cfs -f /oradbshare –n all -verbose

cluvfy comp ocr [-n node_list] [-verbose]

cluvfy comp clu -n node_list -verbose

cluvfy comp clumgr [-n node_list] [-verbose]

cluvfy comp sys [-n node_list] -p {crs|database} [-r {10gR1|10gR2|11gR1|11gR2}] [-osdba osdba_group] [-orainv orainventory_group] [-verbose]

cluvfy comp sys -n node1,node2 -p crs -verbose

cluvfy comp admprv [-n node_list] [-verbose] |-o user_equiv [-sshonly] |-o crs_inst [-orainv orainventory_group] |-o db_inst [-orainv orainventory_group] [-osdba osdba_group] |-o db_config -d oracle_home

cluvfy comp ssa [-n node_list] [-s storageID_list] [-verbose]

cluvfy comp space [-n node_list] -l storage_location -z disk_space{B|K|M|G} [-verbose]

cluvfy comp space -n all -l /home/dbadmin/products –z 2G -verbose

Related Articles: crsctl commands srvctl commands crs_stat commands

onsctl commands

2010-01-06T18:08:00.015+05:30

ONSCTL: -- to manage ONS (Oracle Notification Service)

ONS - A publish and subscribe service for communicating information about all FAN events.

onsctl or onsctl help or onsctl -h
onsctl start -- to start ONS
onsctl stop -- to stop ONS
onsctl ping -- to find out the status of ONS
onsctl debug -- to display debug information for the ons daemon
onsctl reconfig -- to reload the ons configuration
onsctl detailed -- to print a verbose syntax description

from 11g release 2
onsctl command [options]

onsctl or onsctl help or onsctl -h
onsctl start -- to start ONS
onsctl shutdown -- to shutdown ONS
onsctl ping [max-retry] -- to ping local ons
onsctl debug [attr=val ...] -- to display ons server debug information
onsctl reload -- to trigger ons to reread its configuration file
onsctl set [attr=val ...] -- to set ons log parameters
onsctl query [attr=val] -- to query ons log parameters
onsctl usage [command] -- to print detailed usage description

Related Articles: oifcfg commands crsctl commands srvctl commands

olsnodes commands

2010-01-06T18:05:00.005+05:30

OLSNODES:

provides the list of nodes and other information for all nodes participating in the cluster

#olsnodes [node_name] [-g] [-i] [-l] [-n] [-p] [-s] [-t] [-v]

node_name -- displays information for the particular node

g -- more details

i -- with VIP

l -- local node name

n -- with node number

p -- private interconnect

s -- status of the node (ACTIVE or INACTIVE)

t -- type of the node (PINNED or UNPINNED)

v -- verbose

#olsnodes -- will list the nodes in the cluster

#olsnodes -n

#olsnodes node44 -v

#olsnodes -n -p -i

node1-pub 1 node1-prv node1-vip

node2-pub 2 node2-prv node2-vip

Related Articles: oifcfg commands onsctl commands srvctl commands

oifcfg commands

2010-01-06T15:37:00.009+05:30

OIFCFG: -- Oracle Interface Configuration tool

A command line tool for both single instance Oracle databases and RAC databases that enables us to allocate and deallocate network interfaces to components, direct components to use specific network interfaces, and retrieve component configuration information.

oifcfg [-help] -- will give help

oifcfg iflist [-p [-n]]

-p includes description of the subnet, -n includes subnet mask

oifcfg iflist -- display a list of current subnets

etho 147.43.1.60

ethl 192.168.1.150

oifcfg iflist -p -n

etho 147.43.1.60 UNKNOWN 255.255.255.0 (public interfaces are UNKNOWN)

ethl 192.168.1.150 PRIVATE 255.255.255.0

oifcfg getif [-node node_name|-global] [-if if_name[/subnet] [-type {cluster_interconnect|public|storage}]]

-- To display a list of networks

oifcfg getif

eth1 192.168.1.150 global cluster_interconnect

eth0 192.168.0.150 global public

oifcfg setif {-node node_name|-global} {if_name/subnet:{cluster_interconnect|public|storage}}...

oifcfg setif -global eth0/10.50.99.0:public

oifcfg delif [-node node_name|-global] [if_name[/subnet]]

oifcfg delif -global eth0

Related Articles: olsnodes commands onsctl commands srvctl commands

ocrconfig commands

2010-01-06T15:23:00.013+05:30

OCRCONFIG: -- OCR (Oracle Cluster Registry) CONFIGuration tool

#ocrconfig -help or ocrconfig -h

#ocrconfig -showbackup [auto|manual]

-- default location is $ORA_CRS_HOME/cdata/cluster_name

#ocrconfig -backuploc dir_name -- change OCR autobackup directory location

#ocrconfig -manualbackup -- 11g command, to perform OCR backup manually
#ocrconfig -restore backup_file.ocr -- recovering from autobackup file

#ocrconfig -export file_name.dmp [-s online]

-- exports OCR content to a file

#ocrconfig -import file_name.dmp

-- recover OCR logically, must be done on all nodes

#ocrconfig -replace ocr [file_name] -- adding/replacing an OCR file

#ocrconfig -replace ocrmirror [file_name]

#ocrconfig -repair ocr file_name

#ocrconfig -repair ocrmirror file_name

#ocrconfig -upgrade [user [group]] -- upgrades OCR

#ocrconfig -downgrade [-version version_string] -- downgrades OCR

#ocrconfig -overwrite

Log file will be $ORACLE_HOME/log/node_name/client/ocrconfig_pid.log

Debugging can be controlled through $ORA_CRS_HOME/srvm/admin/ocrlog.ini

Related Articles: ocrdump commands ocrcheck commands

ocrdump commands

2010-01-06T15:19:00.010+05:30

OCRDUMP: -- dumps OCR (Oracle Cluster Registry) contents to a file

#ocrdump -help or ocrdump -h

#ocrdump [file_name|-stdout] [-backupfile backup_filename] [-keyname key_name] [-xml] [-noheader]

#ocrdump -- default filename is OCRDUMPFILE

#ocrdump MYFILE

#ocrdump ${HOST}_OCRDUMP

#ocrdump -backupfile my_file

#ocrdump -stdout -keyname SYSTEM

#ocrdump -stdout -xml

Log file will be $ORACLE_HOME/log/node_name/client/ocrdump_pid.log

Debugging can be controlled through $ORA_CRS_HOME/srvm/admin/ocrlog.ini

Related Articles: ocrconfig commands ocrcheck commands

ocrcheck commands

2010-01-06T14:59:00.007+05:30

OCRCHECK: -- Displays health of OCR (Oracle Cluster Registry).

$ocrcheck -help or ocrcheck -h

$ocrcheck

Version : 2

Total space (kbytes) : 262144

Used space (kbytes) : 16256

Available space (kbytes) : 245888

ID : 1918913332

Device/File Name : /dev/raw/raw1

Device/File integrity check succeeded

Device/File Name : /dev/raw/raw2

Device/File integrity check succeeded

Cluster registry integrity check succeeded

Log file will be $ORACLE_HOME/log/node_name/client/ocrcheck_pid.log

Debugging can be controlled through $ORA_CRS_HOME/srvm/admin/ocrlog.ini

Related Articles: ocrconfig commands ocrdump commands

crs_profile crs_register crs_unregister crs_setperm crs_getperm crs_start crs_stop crs_relocate

2010-01-06T12:33:00.013+05:30

CRS_PROFILE:

crs_profile -create resource_name -t application [-a action_script]

[-B executable_pathname] [-dir directory] [-d description]

[-p placement_policy] [-h hosting_nodes] [-r required_resources]

[-l optional_resources] [-o option,[...]]

[attribute_flag attribute_value] [...] [-f] [-q]

crs_profile -create resource_name -I template_file [-f] [-q]

crs_profile -template resource_name [-O template_file] [-q]

crs_profile -validate resource_name [-q]

crs_profile -update resource_name [option [...]] [-q]

crs_profile -delete resource_name [-q]

crs_profile -create demovip -t application -a $ORA_CRS_HOME/bin/usrvip -o oi=eth0,ov=147.43.1.200,on=255.255.0.0

crs_profile -create demo -t application -d "Demo" -r demovip -a /tmp/DemoAction -o ci=5,ra=60

CRS_REGISTER:

crs_register resource_name [-dir directory_path] [...] [-u] [-f] [-q]

crs_register -u resource_name

crs_register demovip

CRS_UNREGISTER:

crs_unregister resource_name [...] [-q]

crs_unregister demovip

CRS_SETPERM:

crs_setperm resource_name -u aclstring [-q]

crs_setperm resource_name -x aclstring [-q]

crs_setperm resource_name -o user_name [-q]

crs_setperm resource_name -g group_name [-q]

#crs_setperm demovip -o root

#crs_setperm demovip -u user:oracle:r-x

CRS_GETPERM:

crs_getperm resource_name [-u user|-g group]

#crs_getperm demovip -u root

CRS_START:

crs_start resource_name [...] [-c cluster_node] [-q] [-f]

crs_start -all [-q] -- Starts all registered resources

crs_start [USR_attribute_name=value] [..] resource_name [-c node_name] [-q]

crs_start demovip

CRS_STOP:

crs_stop resource_name [...] [-f] [-q]

crs_stop -c cluster_node [...] [-q]

crs_stop -all [-q]

-- Stops all registered resources, and leaves the CRS running

crs_stop [USR_attribute_name=value] [...] resource_name [-q] -c cluster_node [...]

crs_stop demovip

crs_stop ora.node_name.ons

crs_stop ora.node_name.gsd

crs_stop ora.node_name.LISTENER_node_name.lsnr

crs_stop ora.node_name.vip

CRS_RELOCATE:

crs_relocate resource_name [...] [-c cluster_node] [-f][-q]

crs_relocate resource_name [-c cluster_node] [-q]

crs_relocate [USR_attribute_name=value] [...] resource_name [-c cluster_node] [-q]

crs_relocate -s source_node [-c cluster_node] [-q]

crs_relocate ora.db_name.db

Related Articles: crsctl commands crs_stat commands clscfg commands

srvconfig commands

2010-01-06T11:23:00.012+05:30

SRVCONFIG:

srvconfig [options]

srvconfig or srvconfig -help or srvconfig -?

srvconfig -exp file_name

-- exports the contents of the configuration information/cluster registry

srvconfig -imp file_name

-- imports the configuration information/cluster registry

srvconfig -init -- initialize cluster registry (if not already initialized)

srvconfig -init -f -- force initialization of configuration even if initialized

srvconfig -upgrade -dbname db_name -orahome ORACLE_HOME

-- upgrade the database configuration

srvconfig -downgrade -dbname db_name -orahome ORACLE_HOME -version ver_str

-- downgrade the database configuration

Related Articles: srvctl commands crsctl commands cluvfy commands

crs_stat commands

2010-01-05T18:41:00.007+05:30

CRS_STAT:

crs_stat [resource_name [...]] [-v] [-l] [-q] [-c cluster_node]

crs_stat [resource_name [...]] -t [-v] [-q] [-c cluster_node]

crs_stat -p [resource_name [...]] [-q]

crs_stat [-a] resource_name -g

crs_stat [-a] resource_name -r [-c cluster_node]

crs_stat -f [resource_name [...]] [-q] [-c cluster_node]

crs_stat -ls resource_name

crs_stat or crs_stat -u or crs_stat -l

crs_stat -t -- tabular format

crs_stat -v -- verbose

crs_stat -p -- more details

AUTO_START = 0 restore

= 1 always restart

= 2 never restart

RESTART_ATTEMPTS = n -- How many times Clusterware should attempt to start the resource?

crs_stat -ls

crs_stat -t/v/p resource_name or crs_stat -t/v/p|grep keyword -- will show the entries with that keyword

crs_stat -p lnx02

crs_stat -v | grep eg6245

crs_stat -p resource_name > filename.cap -- generate resource profile file

Related Articles: crsctl commands crs_profile crs_register crs_unregister crs_setperm crs_getperm crs_start crs_stop crs_relocate commands

crsctl commands

2010-01-05T17:03:00.011+05:30

CRSCTL:

$crsctl -- to get help

$crsctl query crs activeversion

$crsctl query crs softwareversion [node_name]

#crsctl start crs

#crsctl stop crs

(or)

#/etc/init.d/init.crs start

#/etc/init.d/init.crs stop

#crsctl enable crs

#crsctl disable crs

(or)

#/etc/init.d/init.crs enable

#/etc/init.d/init.crs disable

$crsctl check crs

$crsctl check cluster [-node node_name] -- 11g command, checks the viability of CSS across nodes

$crsctl check cssd

$crsctl check crsd

$crsctl check evmd

$crsctl check oprocd

$crsctl check ctss

#/etc/init.d/init.cssd stop

#/etc/init.d/init.cssd start

#/etc/rc.d/init.d/init.evmd

#/etc/rc.d/init.d/init.cssd

#/etc/rc.d/init.d/init.crsd

#mv /etc/rc3.d/S96init.cssd /etc/rc3.d/_S96init.cssd -- to stop cssd from autostarting after reboot

#crsctl check css votedisk

#crsctl query css votedisk -- lists the voting disks used by CSS

#crsctl add css votedisk PATH

#crsctl add css votedisk PATH -force -- if Clusterware is not running

#crsctl delete css votedisk PATH

#crsctl delete css votedisk PATH -force -- if Clusterware is not running

#crsctl set css parameter_name value -- set parameters on OCR

#crsctl set css misscount 100

#crsctl unset css parameter_name -- sets CSS parameter to its default

#crsctl unset css misscount

#crsctl get css parameter_name -- gets the value of a CSS parameter

#crsctl get css disktimeout

#crsctl get css misscount

#crsctl get css reboottime

#crsctl start resources -- starts Clusterware resources

#crsctl stop resources -- stops Clusterware resources

$crsctl lsmodules crs -- lists CRS modules that can be used for debugging

CRSUI

CRSCOMM

CRSRTI

CRSMAIN

CRSPLACE

CRSAPP

CRSRES

CRSCOMM

CRSOCR

CRSTIMER

CRSEVT

CRSD

CLUCLS

CSSCLNT

COMMCRS

COMMNS

$crsctl lsmodules css -- lists CSS modules that can be used for debugging

CSSD

COMMCRS

COMMNS

$crsctl lsmodules evm -- lists EVM modules that can be used for debugging

EVMD

EVMDMAIN

EVMCOMM

EVMEVT

EVMAPP

EVMAGENT

CRSOCR

CLUCLS

CSSCLNT

COMMCRS

COMMNS

OCR Modules -- cannot be listed with crsctl lsmodules command

OCRAPI

OCRCLI

OCRSRV

OCRMAS

OCRMSG

OCRCAC

OCRRAW

OCRUTL

OCROSD

#crsctl debug statedump crs -- dumps state info for crs objects

#crsctl debug statedump css -- dumps state info for css objects

#crsctl debug statedump evm -- dumps state info for evm objects

#crsctl debug log crs [module:level]{,module:level} ...

-- Turns on debugging for CRS

#crsctl debug log crs CRSEVT:5,CRSAPP:5,CRSTIMER:5,CRSRES:5,CRSRTI:1,CRSCOMM:2

#crsctl debug log css [module:level]{,module:level} ...

-- Turns on debugging for CSS

#crsctl debug log css CSSD:1

#crsctl debug log evm [module:level]{,module:level} ...

-- Turns on debugging for EVM

#crsctl debug log evm EVMCOMM:1

#crsctl debug trace crs -- dumps CRS in-memory tracing cache

#crsctl debug trace css -- dumps CSS in-memory tracing cache

#crsctl debug trace evm -- dumps EVM in-memory tracing cache

#crsctl debug log res resource_name:level -- turns on debugging for resources

#crsctl debug log res "ora.lnx04.vip:1"

#crsctl trace all_the_above_commands -- tracing by adding a "trace" argument.

#crsctl trace check css

Related Articles: cluvfy commands srvctl commands crs_stat commands

srvctl commands

2009-12-31T16:36:00.106+05:30

SRVCTL:

srvctl command target [options]

commands: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config

targets:  database/db|instance/inst|service/serv|nodeapps|asm|listener

targets: database/db|instance/inst|service/serv|nodeapps|asm|listener   |diskgroup|home|ons|eons|filesystem|gns|oc4j|scan|scan_listener |srvpool|server|VIP -- From 11gR2

srvctl -help or srvctl -v

srvctl -V   -- prints version

   srvctl version: 10.2.0.0.0 (or) srvctl version: 11.2.0.1.0

srvctl -h   -- print usage

srvctl status service –h

Database:

srvctl add database -d db_name -o ORACLE_HOME [-m domain_name][-p spfile] [-A name|ip/netmask]

[-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] 

[-s start_options] [-n db_name] [-y {AUTOMATIC|MANUAL}]

srvctl add database -d prod -o /u01/oracle/product/102/prod

srvctl remove database -d db_name [-f]

srvctl remove database -d prod

srvctl start database -d db_name [-o start_options] [-c connect_str|-q]

srvctl start database -d db_name [-o open]

srvctl start database -d db_name -o nomount

srvctl start database -d db_name -o mount

srvctl start db -d prod

srvctl start database -d apps -o open

srvctl stop database -d db_name [-o stop_options] [-c connect_str|-q]

srvctl stop database -d db_name [-o normal]

srvctl stop database -d db_name -o transactional

srvctl stop database -d db_name -o immediate

srvctl stop database -d db_name -o abort

srvctl stop db -d crm -o immediate

srvctl status database -d db_name [-f] [-v] [-S level]

srvctl status database -d db_name -v service_name

srvctl status database -d hrms

srvctl enable database -d db_name

srvctl enable database -d vis

srvctl disable database -d db_name

srvctl disable db -d vis

srvctl config database

srvctl config database -d db_name [-a] [-t]

srvctl config database

srvctl config database -d HYD -a

srvctl modify database -d db_name [-n db_name] [-o ORACLE_HOME] [-m domain_name] [-p spfile]

[-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] [-s start_options] [-y {AUTOMATIC|MANUAL}]

srvctl modify database -d hrms -r physical_standby

srvctl modify db -d RAC -p /u03/oradata/RAC/spfileRAC.ora -- moves p file

srvctl modify database –d HYD –o /u01/app/oracle/product/11.1/db –s open

srvctl getenv database -d db_name [-t name_list]

srvctl getenv database -d prod

srvctl setenv database -d db_name {-t name=val[,name=val,...]|-T name=val}

srvctl setenv database –d HYD –t “TNS_ADMIN=/u01/app/oracle/product/11.1/asm/network/admin”

srvctl setenv db -d prod -t LANG=en

srvctl unsetenv database -d db_name [-t name_list]

srvctl unsetenv database -d prod -t CLASSPATH

In 11g Release 2, some command's syntax has been changed:

srvctl add database -d db_unique_name -o ORACLE_HOME  [-x node_name] [-m domain_name] [-p spfile] [-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] [-s start_options] [-t stop_options] [-n db_name] [-y {AUTOMATIC|MANUAL}] [-g server_pool_list] [-a "diskgroup_list"]

srvctl add database -d prod -o /u01/oracle/product/112/prod -m foo.com -p +dg1/prod/spfileprod.ora -r PRIMARY -s open -t normal -n db2 -y AUTOMATIC -g svrpool1,svrpool2 -a "dg1,dg2"

srvctl remove database -d db_unique_name [-f] [-y] [-v]

srvctl remove database -d prod -y

srvctl stop database -d db_unique_name [-o stop_options] [-f]

srvctl stop database -d dev -f

srvctl status database -d db_unique_name [-f] [-v]

srvctl status db -d sat -v

srvctl enable database -d db_unique_name [-n node_name]

srvctl enable database -d vis -n lnx01

srvctl disable database -d db_unique_name [-n node_name]

srvctl disable db -d vis -n lnx03

srvctl config database [-d db_unique_name [-a]]

srvctl config db -d db_erp -a

srvctl modify database -d db_unique_name [-n db_name] [-o ORACLE_HOME] [-u oracle_user] [-m domain] [-p spfile] [-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] [-s start_options] [-t stop_options] [-y {AUTOMATIC|MANUAL}] [-g "server_pool_list"] [-a "diskgroup_list"|-z]

srvctl modify db -d prod -r logical_standby

srvctl modify database -d racTest -a "SYSFILES,LOGS,OLTP"

Instance:

srvctl add instance –d db_name –i inst_name -n node_name

srvctl add instance -d prod -i  prod01 -n linux01

srvctl remove instance –d db_name –i inst_name [-f]

srvctl remove instance -d prod -i prod01

srvctl start instance -d db_name -i inst_names [-o start_options] [-c connect_str|-q]

srvctl start instance –d db_name –i inst_names [-o open]

srvctl start instance –d db_name –i inst_names -o nomount

srvctl start instance –d db_name –i inst_names -o mount

srvctl start instance –d dev -i dev2

srvctl stop instance -d db_name -i inst_names [-o stop_options] [-c connect_str|-q]

srvctl stop instance –d db_name –i inst_names [-o normal]

srvctl stop instance –d db_name –i inst_names -o transactional

srvctl stop instance –d db_name –i inst_names -o immediate

srvctl stop instance –d db_name –i inst_names -o abort

srvctl stop inst –d vis -i vis

srvctl status instance –d db_name –i inst_names [-f] [-v] [-S level]

srvctl status inst –d racdb -i racdb2

srvctl enable instance –d db_name –i inst_names

srvctl enable instance -d prod -i "prod1,prod2"

srvctl disable instance –d db_name –i inst_names

srvctl disable inst -d prod -i "prod1,prod3"

srvctl modify instance -d db_name -i inst_name {-s asm_inst_name|-r} -- set dependency of instance to ASM

srvctl modify instance -d db_name -i inst_name -n node_name  -- move the instance

srvctl modify instance -d db_name -i inst_name -r  -- remove the instance

srvctl getenv instance –d db_name –i inst_name [-t name_list]

srvctl setenv instance –d db_name [–i inst_name] {-t "name=val[,name=val,...]" | -T "name=val"}

srvctl unsetenv instance –d db_name [–i inst_name] [-t name_list]

In 11g  Release 2, some command's syntax has been changed:

srvctl start instance -d db_unique_name {-n node_name -i "instance_name_list"} [-o start_options]

srvctl start instance -d prod -n node2

srvctl start inst -d prod -i "prod2,prod3"

srvctl stop instance -d db_unique_name {[-n node_name]|[-i "instance_name_list"]} [-o stop_options] [-f]

srvctl stop inst -d prod -n node1

srvctl stop instance -d prod -i prod1

srvctl status instance -d db_unique_name {-n node_name | -i "instance_name_list"} [-f] [-v]

srvctl status instance -d prod -i "prod1,prod2" -v

srvctl modify instance -d db_unique_name -i instance_name {-n node_name|-z}

srvctl modify instance -d prod -i prod1 -n mynode

srvctl modify inst -d prod -i prod1 -z

Service:

srvctl add service -d db_name -s service_name -r pref_insts [-a avail_insts] [-P TAF_policy]

srvctl add service -d db_name -s service_name -u {-r "new_pref_inst" | -a "new_avail_inst"}

srvctl add service -d RAC -s PRD -r RAC01,RAC02 -a RAC03,RAC04

srvctl add serv -d CRM -s CRM -r CRM1 -a CRM3 -P basic

srvctl remove service -d db_name -s service_name [-i inst_name] [-f]

srvctl remove serv -d dev -s sales

srvctl remove service -d dev -s sales -i dev01,dev02

srvctl start service -d db_name [-s service_names [-i inst_name]] [-o start_options]

srvctl start service -d db_name -s service_names [-o open]

srvctl start service -d db_name -s service_names -o nomount

srvctl start service -d db_name -s service_names -o mount

srvctl start serv -d dwh -s dwh

srvctl stop service -d db_name [-s service_names [-i inst_name]] [-f]

srvctl stop serv -d dwh -s dwh

srvctl status service -d db_name [-s service_names] [-f] [-v] [-S level]

srvctl status service -d dev -s dev

srvctl enable service -d db_name -s service_names [–i inst_name]

srvctl enable service -d apps -s apps1

srvctl disable service -d db_name -s service_names [–i inst_name]

srvctl disable serv -d dev -s dev -i dev1

srvctl config service -d db_name [-s service_name] [-a] [-S level]

srvctl config service -d db_name -a -- -a shows TAF configuration

srvctl config service -d TEST -s test PREF:TST1 AVAIL:TST2

srvctl modify service -d db_name -s service_name -i old_inst_name -t new_inst_name [-f]

srvctl modify service -d db_name -s service_name -i avail_inst_name -r [-f]

srvctl modify service -d db_name -s service_name -n -i preferred_list [-a available_list] [-f]

srvctl modify service -d db_name -s service_name -i old_inst_name -a avail_inst -P TAF_policy

srvctl modify serv -d PROD -s DWH -n -i I1,I2,I3,I4 -a I5,I6

srvctl relocate service -d db_name -s service_name –i old_inst_name -t target_inst [-f]

srvctl getenv service -d db_name -s service_name -t name_list

srvctl setenv service -d db_name [-s service_name] {-t "name=val[,name=val,...]" | -T "name=val"}

srvctl unsetenv service -d db_name -s service_name -t name_list

In 11g   Release 2, some  command's syntax has been changed:

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]

srvctl add service -d rac -s rac1 -q TRUE -m BASIC -e SELECT -z  180 -w 5 -j LONG

srvctl add service -d db_unique_name -s service_name -u {-r preferred_list | -a available_list}

srvctl add service -d  db_unique_name -s service_name

   -g server_pool [-c {UNIFORM|SINGLETON}] [-k network_number]

   [-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}] [-P  {BASIC|NONE|PRECONNECT}] [-x {TRUE|FALSE}]

   [-z failover_retries] [-w failover_delay]

srvctl add service -d db_unique_name -s service_name -r preferred_list [-a available_list] [-P {BASIC|NONE|PRECONNECT}]

   [-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}] [-x {TRUE|FALSE}] [-z failover_retries] [-w failover_delay]

srvctl add serv -d dev -s sales -r dev01,dev02 -a dev03 -P PRECONNECT

srvctl start service -d db_unique_name [-s "service_name_list" [-n node_name | -i instance_name]] [-o start_options]

srvctl start serv -d dev -s dev

srvctl start service -d dev -s dev -i dev2

srvctl stop service -d db_unique_name [-s "service_name_list"]  [-n node_name | -i instance_name] [-f]

srvctl stop service -d dev -s dev

srvctl stop serv -d dev -s dev -i dev2

srvctl status service -d db_unique_name [-s "service_name_list"] [-f]  [-v]

srvctl status service -d dev -s dev -v

srvctl enable service -d db_unique_name -s "service_name_list" [-i instance_name | -n node_name]

srvctl enable service -d dev -s dev

srvctl enable serv -d dev -s dev -i dev1

srvctl disable service -d db_unique_name -s "service_name_list" [-i instance_name | -n node_name]

srvctl disable service -d dev -s "dev,marketing"

srvctl disable serv -d dev -s dev -i dev1

srvctl config service -d db_unique_name [-s service_name] [-a]

srvctl config service -d dev -s dev

srvctl modify service -d db_unique_name -s service_name

 [-c {UNIFORM|SINGLETON}] [-P {BASIC|PRECONNECT|NONE}]

 [-l {[PRIMARY]|[PHYSICAL_STANDBY]|[LOGICAL_STANDBY]|[SNAPSHOT_STANDBY]} [-q {TRUE|FALSE}] [-x {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z failover_retries] [-w failover_delay] [-y {AUTOMATIC|MANUAL}]

srvctl modify service -d db_unique_name -s service_name -i old_instance_name -t new_instance_name [-f]

srvctl modify service -d db_unique_name -s service_name -i avail_inst_name -r [-f]

srvctl modify service -d db_unique_name -s service_name -n -i preferred_list [-a available_list] [-f]

srvctl modify service -d dev -s dev -i dev1 -t dev2

srvctl modify serv -d dev -s dev -i dev1 -r

srvctl modify service -d dev -s dev -n -i dev1 -a dev2

srvctl relocate service -d db_unique_name -s service_name {-c source_node -n target_node|-i old_instance_name -t new_instance_name} [-f]

srvctl relocate service -d dev -s dev -i dev1 -t dev3

Nodeapps:

#srvctl add nodeapps -n node_name -o ORACLE_HOME -A name|ip/netmask[/if1[|if2|...]]

#srvctl add nodeapps -n lnx02 -o $ORACLE_HOME -A 192.168.0.151/255.255.0.0/eth0

#srvctl remove nodeapps -n node_names [-f]

#srvctl start nodeapps -n node_name     -- Starts GSD, VIP, listener & ONS

#srvctl stop nodeapps -n node_name [-r] -- Stops GSD, VIP, listener & ONS

#srvctl status nodeapps -n node_name

#srvctl config nodeapps -n node_name [-a] [-g] [-o] [-s] [-l]

    -a                  Display VIP configuration

    -g                  Display GSD configuration

    -s                  Display ONS daemon configuration

    -l                  Display listener configuration

#srvctl modify nodeapps -n node_name [-A new_vip_address]

#srvctl modify nodeapps -n lnx06 -A 10.50.99.43/255.255.252.0/eth0

#srvctl getenv nodeapps -n node_name [-t name_list]

#srvctl setenv nodeapps -n node_name {-t "name=val[,name=val,...]"|-T "name=val"}

#srvctl setenv nodeapps –n adcracdbq3 –t “TNS_ADMIN=/u01/app/oracle/product/11.1/asm/network/admin”

#srvctl unsetenv nodeapps -n node_name [-t name_list]

In  11g    Release 2, some   command's syntax has been changed:

srvctl add nodeapps -n node_name -A {name|ip}/netmask[/if1[|if2|...]] [-m multicast_ip_address] [-p multicast_port_number] [-l ons_local_port] [-r ons_remote-port] [-t host[:port][,host[:port],...]] [-v]

srvctl add nodeapps -S subnet/netmask[/if1[|if2|...]] [-d dhcp_server_type] [-m multicast_ip_address] [-p multicast_port_number] [-l ons_local_port] [-r ons_remote-port] [-t host[:port][,host[:port],...]] [-v]

#srvctl add nodeapps -n devnode1 -A 1.2.3.4/255.255.255.0

srvctl remove nodeapps [-f] [-y] [-v]

srvctl remove nodeapps

srvctl start nodeapps [-n node_name] [-v]

srvctl start nodeapps

srvctl stop nodeapps [-n node_name] [-r] [-v]

srvctl stop nodeapps

srvctl status nodeapps

srvctl enable nodeapps [-g] [-v]

srvctl enable nodeapps -g -v

srvctl disable nodeapps [-g] [-v]

srvctl disable nodeapps -g -v

srvctl config nodeapps [-a] [-g] [-s] [-e]

srvctl config nodeapps -a -g -s -e

srvctl modify nodeapps [-n node_name -A new_vip_address] [-S subnet/netmask[/if1[|if2|...]] [-m multicast_ip_address] [-p multicast_port_number] [-e eons_listen_port] [-l ons_local_port] [-r ons_remote_port] [-t host[:port][,host:port,...]] [-v]

srvctl modify nodeapps -n mynode1 -A 100.200.300.40/255.255.255.0/eth0

srvctl getenv nodeapps [-a] [-g] [-s] [-e] [-t "name_list"] [-v]

srvctl getenv nodeapps -a

srvctl setenv nodeapps {-t "name=val[,name=val][...]" | -T "name=val"} [-v]

srvctl setenv nodeapps -T "CLASSPATH=/usr/local/jdk/jre/rt.jar" -v

srvctl unsetenv nodeapps -t "name_list" [-v]

srvctl unsetenv nodeapps -t "test_var1,test_var2"

ASM:

srvctl add asm -n node_name -i asminstance -o ORACLE_HOME [-p spfile]

srvctl remove asm -n node_name [-i asminstance] [-f]

srvctl remove asm -n db6

srvctl start asm -n node_name [-i asminstance] [-o start_options] [-c connect_str|-q]

srvctl start asm -n node_name [-i asminstance] [-o open]

srvctl start asm -n node_name [-i asminstance] -o nomount

srvctl start asm -n node_name [-i asminstance] -o mount

srvctl start asm -n linux01

srvctl stop asm -n node_name [-i asminstance] [-o stop_options] [-c connect_str|-q]

srvctl stop asm -n node_name [-i asminstance] [-o normal]

srvctl stop asm -n node_name [-i asminstance] -o transactional

srvctl stop asm -n node_name [-i asminstance] -o immediate

srvctl stop asm -n node_name [-i asminstance]-o abort

srvctl stop asm -n racnode1

srvctl stop asm -n devnode1 -i +asm1

srvctl status asm -n node_name

srvctl status asm -n racnode1

srvctl enable asm -n node_name [-i asminstance]

srvctl enable asm -n lnx03 -i +asm3

srvctl disable asm -n node_name [-i asminstance]

srvctl disable asm -n lnx02 -i +asm2

srvctl config asm -n node_name

srvctl config asm -n lnx08

srvctl modify asm -n node_name -i asminstance [-o ORACLE_HOME] [-p spfile]

srvctl modify asm –n rac6 -i +asm6 –o /u01/app/oracle/product/11.1/asm

In   11g     Release 2, some    command's syntax has been changed:

srvctl add asm [-l lsnr_name] [-p spfile] [-d asm_diskstring]

srvctl add asm

srvctl add asm -l LISTENERASM -p +dg_data/spfile.ora

srvctl remove asm [-f]

srvctl remove asm -f

srvctl start asm [-n node_name] [-o start_options]

srvctl start asm -n devnode1

srvctl stop asm [-n node_name] [-o stop_options] [-f]

srvctl stop asm -n devnode1 -f

srvctl status asm [-n node_name] [-a]

srvctl status asm -n devnode1 -a

srvctl enable asm [-n node_name]

srvctl enable asm -n devnode1

srvctl disable asm [-n node_name]

srvctl disable asm -n devnode1

srvctl config asm [-a]

srvctl config asm -a

srvctl modify asm [-l lsnr_name] [-p spfile] [-d asm_diskstring]

srvctl modify asm [-n node_name] [-l listener_name] [-d asm_diskstring] [-p spfile_path_name]

srvctl modify asm -l lsnr1

srvctl getenv asm [-t name[, ...]]

srvctl getenv asm

srvctl setenv asm {-t "name=val [,...]" | -T "name=value"}

srvctl setenv asm -t LANG=en

srvctl unsetenv asm -t "name[, ...]"

srvctl unsetenv asm -t CLASSPATH

Listener:

srvctl add listener -n node_name -o ORACLE_HOME [-l listener_name]  -- 11gR1 command

srvctl remove listener -n node_name [-l listener_name] -- 11gR1 command

srvctl start listener -n node_name [-l listener_names]

srvctl start listener -n node1

srvctl stop listener -n node_name [-l listener_names]

srvctl stop listener -n node1

srvctl status listener [-n node_name] [-l listener_names] -- 11gR1  command

srvctl status listener -n node2

srvctl config listener -n node_name

srvctl modify listener -n node_name [-l listener_names] -o ORACLE_HOME               -- 11gR1   command

srvctl modify listener -n racdb4 -o /u01/app/oracle/product/11.1/asm -l "LISTENER_RACDB4"

In   11g      Release 2, some     command's syntax has been changed:

srvctl add listener [-l lsnr_name] [-s] [-p "[TCP:]port[, ...][/IPC:key][/NMP:pipe_name][/TCPS:s_port] [/SDP:port]"] [-k network_number] [-o ORACLE_HOME]

srvctl add listener -l LISTENERASM -p "TCP:1522" -o $ORACLE_HOME

srvctl add listener -l listener112 -p 1341 -o /ora/ora112

srvctl remove listener [-l lsnr_name|-a] [-f]

srvctl remove listener -l lsnr01

srvctl stop listener [-n node_name] [-l lsnr_name] [-f]

srvctl enable listener [-l lsnr_name] [-n node_name]

srvctl enable listener -l listener_dev -n node5

srvctl disable listener [-l lsnr_name] [-n node_name]

srvctl disable listener -l listener_dev -n node5

srvctl config listener [-l lsnr_name] [-a]

srvctl config listener

srvctl modify listener [-l listener_name] [-o oracle_home] [-u user_name] [-p "[TCP:]port_list[/IPC:key][/NMP:pipe_name][/TCPS:s_port][/SDP:port]"] [-k network_number]

srvctl modify listener -n node1 -p "TCP:1521,1522"

srvctl getenv listener [-l lsnr_name] [-t name[, ...]]

srvctl getenv listener

srvctl setenv listener [-l lsnr_name] {-t "name=val [,...]" | -T "name=value"}

srvctl setenv listener -t LANG=en

srvctl unsetenv listener [-l lsnr_name] -t "name[, ...]"

srvctl unsetenv listener -t "TNS_ADMIN"

New srvctl commands in 11g Release 2

Diskgroup:

srvctl remove diskgroup -g diskgroup_name [-n node_list] [-f]

srvctl remove diskgroup -g DG1 -f

srvctl start diskgroup -g diskgroup_name [-n node_list]

srvctl start diskgroup -g diskgroup1 -n node1,node2

srvctl stop diskgroup -g diskgroup_name [-n node_list] [-f]

srvctl stop diskgroup -g ASM_FRA_DG

srvctl stop diskgroup -g dg1 -n node1,node2 -f

srvctl status diskgroup -g diskgroup_name [-n node_list] [-a]

srvctl status diskgroup -g dg_data -n node1,node2 -a

srvctl enable diskgroup -g diskgroup_name [-n node_list]

srvctl enable diskgroup -g diskgroup1 -n node1,node2

srvctl disable diskgroup -g diskgroup_name [-n node_list]

srvctl disable diskgroup -g dg_fra -n node1, node2

Home:

srvctl start home -o ORACLE_HOME -s state_file [-n node_name]

srvctl start home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt

srvctl stop home -o ORACLE_HOME -s state_file [-t stop_options] [-n node_name] [-f]

srvctl stop home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt

srvctl status home -o ORACLE_HOME -s state_file  [-n node_name]

srvctl status home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt

ONS (Oracle Notification Service) :

srvctl add ons [-l ons-local-port]  [-r ons-remote-port] [-t host[:port][,host[:port]...]] [-v]

srvctl add ons -l 6200

srvctl remove ons [-f] [-v]

srvctl remove ons -f

srvctl start ons [-v]

srvctl start ons -v

srvctl stop ons [-v]

srvctl stop ons -v

srvctl status ons

srvctl enable ons [-v]

srvctl enable ons

srvctl disable ons [-v]

srvctl disable ons

srvctl config ons

srvctl modify ons [-l ons-local-port]  [-r ons-remote-port] [-t host[:port][,host[:port]...]] [-v]

srvctl modify ons

EONS:

srvctl add eons [-p portnum] [-m multicast-ip-address] [-e eons-listen-port] [-v]

#srvctl add eons -p 2018

srvctl remove eons [-f] [-v]

srvctl remove eons -f

srvctl start eons [-v]

srvctl start eons

srvctl stop eons  [-f] [-v]

srvctl stop eons -f

srvctl status eons

srvctl enable eons [-v]

srvctl enable eons

srvctl disable eons [-v]

srvctl disable eons

srvctl config eons

srvctl modify eons [-m multicast_ip_address] [-p multicast_port_number] [-e eons_listen_port] [-v]

srvctl modify eons -p 2018

FileSystem:

srvctl add filesystem -d volume_device -v volume_name -g diskgroup_name [-m mountpoint_path] [-u user_name]

srvctl add filesystem -d /dev/asm/d1volume1 -v VOLUME1 -d RAC_DATA -m /oracle/cluster1/acfs1

srvctl remove filesystem -d volume_device_name [-f]

srvctl remove filesystem -d /dev/asm/racvol1

srvctl start filesystem -d volume_device_name [-n node_name]

srvctl start filesystem -d /dev/asm/racvol3

srvctl stop filesystem -d volume_device_name [-n node_name] [-f]

srvctl stop filesystem -d /dev/asm/racvol1 -f

srvctl status filesystem -d volume_device_name

srvctl status filesystem -d /dev/asm/racvol2

srvctl enable filesystem -d volume_device_name

srvctl enable filesystem -d /dev/asm/racvol9

srvctl disable filesystem -d  volume_device_name

srvctl  disable filesystem -d /dev/asm/racvol1

srvctl config filesystem -d volume_device_path

srvctl modify filesystem -d volume_device_name -u user_name

srvctl modify filesystem -d /dev/asm/racvol1 -u sysadmin

SrvPool:

srvctl add srvpool -g server_pool [-i importance] [-l min_size] [-u max_size] [-n node_list] [-f]

srvctl add srvpool -g SP1 -i 1 -l 3 -u 7 -n node1,node2

srvctl remove srvpool -g server_pool

srvctl remove srvpool -g srvpool1

srvctl status srvpool [-g server_pool] [-a]

srvctl status srvpool -g srvpool2 -a

srvctl config srvpool [-g server_pool]

srvctl config srvpool -g dbpool

srvctl modify srvpool -g server_pool [-i importance] [-l min_size] [-u max_size] [-n node_name_list] [-f]

srvctl modify srvpool -g srvpool4 -i 0 -l 2 -u 4 -n node3, node4

Server:

srvctl status server -n "server_name_list" [-a]

srvctl status server -n server11 -a

srvctl relocate server -n "server_name_list" -g server_pool_name [-f]

srvctl relocate server -n "linux1, linux2" -g sp2

Scan (Single Client Access Name):

srvctl add scan -n scan_name [-k network_number] [-S subnet/netmask[/if1[|if2|...]]]

#srvctl add scan -n scan.mycluster.example.com

srvctl remove scan [-f]

srvctl remove scan -f

srvctl start scan [-i ordinal_number] [-n node_name]

srvctl start scan -i 1 -n node1

srvctl stop scan [-i ordinal_number] [-f]

srvctl stop scan -i 1

srvctl status scan [-i ordinal_number]

srvctl status scan -i 1

srvctl enable scan [-i ordinal_number]

srvctl enable scan -i 1

srvctl disable scan [-i ordinal_number]

srvctl disable scan -i 3

srvctl config scan [-i ordinal_number]

srvctl config scan -i 2

srvctl modify scan -n scan_name

srvctl modify scan -n scan1

srvctl relocate scan -i ordinal_number [-n node_name]

srvctl relocate scan -i 2 -n node2

ordinal_number=1,2,3

Scan_listener:

srvctl add scan_listener [-l lsnr_name_prefix] [-s] [-p "[TCP:]port_list[/IPC:key][/NMP:pipe_name][/TCPS:s_port] [/SDP:port]"]

#srvctl add scan_listener -l myscanlistener

srvctl remove scan_listener [-f]

srvctl remove scan_listener -f

srvctl start scan_listener [-n node_name] [-i ordinal_number]

srvctl start scan_listener -i 1

srvctl stop scan_listener [-i ordinal_number] [-f]

srvctl stop scan_listener -i 3

srvctl status scan_listener [-i ordinal_number]

srvctl status scan_listener -i 1

srvctl enable scan_listener [-i ordinal_number]

srvctl enable scan_listener -i 2

srvctl disable scan_listener [-i ordinal_number]

srvctl disable scan_listener -i 1

srvctl config scan_listener [-i ordinal_number]

srvctl config scan_listener -i 3

srvctl modify scan_listener {-p [TCP:]port[/IPC:key][/NMP:pipe_name] [/TCPS:s_port][/SDP:port] | -u }

srvctl modify scan_listener -u

srvctl relocate scan_listener -i ordinal_number [-n node_name]

srvctl relocate scan_listener -i 1

ordinal_number=1,2,3

GNS (Grid Naming Service):

srvctl add gns -i ip_address -d domain

srvctl add gns -i 192.124.16.96 -d cluster.mycompany.com

srvctl remove gns [-f]

srvctl remove gns

srvctl start gns [-l log_level] [-n node_name]

srvctl start gns

srvctl stop gns [-n node_name [-v] [-f]

srvctl stop gns

srvctl status gns [-n node_name]

srvctl status gns

srvctl enable gns [-n node_name]

srvctl enable gns

srvctl disable gns [-n node_name]

srvctl disable gns -n devnode2

srvctl config gns [-a] [-d] [-k] [-m] [-n node_name] [-p] [-s] [-V] [-q name] [-l] [-v]

srvctl config gns -n lnx03

srvctl modify gns [-i ip_address] [-d domain]

srvctl modify gns -i 192.000.000.007

srvctl relocate gns [-n node_name]

srvctl relocate gns -n node2

VIP (Virtual Internet Protocol):

srvctl add vip -n node_name -A {name|ip}/netmask[/if1[if2|...]] [-k network_number] [-v]

#srvctl add vip -n node96 -A 192.124.16.96/255.255.255.0 -k 2

srvctl remove vip -i "vip_name_list" [-f] [-y] [-v]

srvctl remove vip -i "vip1,vip2,vip3" -f -y -v

srvctl start vip {-n node_name|-i vip_name} [-v]

srvctl start vip -i dev1-vip -v

srvctl stop vip {-n node_name|-i vip_name} [-r] [-v]

srvctl stop vip -n node1 -v

srvctl status vip {-n node_name|-i vip_name}

srvctl status vip -i node1-vip

srvctl enable vip -i vip_name [-v]

srvctl enable vip -i prod-vip -v

srvctl disable vip -i vip_name [-v]

srvctl disable vip -i vip3 -v

srvctl config vip {-n node_name|-i vip_name}

srvctl config vip -n devnode2

srvctl getenv vip -i vip_name [-t "name_list"] [-v]

srvctl getenv vip -i node1-vip

srvctl setenv vip -i vip_name {-t "name=val[,name=val,...]" | -T "name=val"}

srvctl setenv vip -i dev1-vip -t LANG=en

srvctl unsetenv vip -i vip_name -t "name_list" [-v]

srvctl unsetenv vip -i myvip -t CLASSPATH

OC4J (Oracle Container for Java):

srvctl add oc4j [-v]

srvctl add oc4j

srvctl remove oc4j [-f] [-v]

srvctl remove oc4j

srvctl start ocj4 [-v]

srvctl start ocj4 -v

srvctl stop oc4j [-f] [-v]

srvctl stop oc4j -f -v

srvctl status oc4j [-n node_name]

srvctl status oc4j -n lnx01

srvctl enable oc4j [-n node_name] [-v]

srvctl enable oc4j -n dev3

srvctl disable oc4j [-n node_name] [-v]

srvctl disable oc4j -n dev1

srvctl config oc4j

srvctl modify oc4j -p oc4j_rmi_port [-v]

srvctl modify oc4j -p 5385

srvctl relocate oc4j [-n node_name] [-v]

srvctl relocate oc4j -n lxn06 -v

Related Articles: cluvfy commands crsctl commands crs_stat commands

RAC Administrator Certified (1Z0-048) Expert

2009-10-31T11:26:00.008+05:30

Oracle Database 10g: Real Application Clusters Administrator Certified Expert

	PRIOR CERTIFICATION Oracle 10g DBA OCP OR 11g DBA OCP		EXAM 1Z0-048 Oracle Database 10g R2: RAC for Administrators		Oracle Database 10g: Real Application Clusters Administrator Certified Expert


	TRAINING Complete one of the approved instructor-led online or in-class courses.		EXAM 1Z0-048 Oracle Database 10g R2: RAC for Administrators		FORM Complete the Course Submission Form		Oracle Database 10g: Real Application Clusters Administrator Certified Expert

Source: http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=186