Home > Oracle Rac > Administering Databases using srvctl

Administering Databases using srvctl

Starting a Database

srvtcl start database -d [-o ] [-c | -q]
where start_options include open (the default), mount, and nomount.

Eg: srvtcl start database -d NESE52DV

Stopping a Database
srvctl stop database -d [-o ] [-c | -q]
where stop_options include normal, transactional, immediate (the default), and abort.

Eg: srvctl stop database –d NESE52DV

Checking the configuration of a database

oracle@nesdbts01:>srvctl config database
NESE52TS
NESREPTS

oracle@nesdbts01:> srvctl config database -d NESE52TS -a

nesdbts01 AEGE52DV1 /opt/app/oracle/product/10.2.0EE
nesdbts02 AEGE52DV2 /opt/app/oracle/product/10.2.0EE
DB_NAME: null
ORACLE_HOME: /opt/app/oracle/product/10.2.0EE
SPFILE: null
DOMAIN: null
DB_ROLE: null
START_OPTIONS: null
POLICY: AUTOMATIC
ENABLE FLAG: DB ENABLED

Checking the status of a Database

oracle@nesdbts01:> srvctl status database -d NESE52TS
Instance NESE52TS1 is running on node nesdbts01
Instance NESE52TS2 is running on node nesdbts02

Disabling a Database

srvctl disable database -d <name>

Eg: [oracle@nesdbts01 oracle]$ srvctl disable database -d NESE52TS

Enabling a Database

srvctl enable database -d <name>

For example, to enable a database called NESE52TS use
[oracle@nesdbts01 oracle]$ srvctl enable database -d NESE52TS

 

Advertisements
Categories: Oracle Rac
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: