Blog has been moved to

http://www.AlTwaijiry.com,

please join us.


1. Run the following command create the Oracle listener resource:

scrgadm -a -j ctl-ora-lsnr-res -g ctlprod-rg -t SUNW.oracle_listener:5 \
-x ORACLE_HOME=/oracle/ctlprod/9.2.0 \
-y Resource_dependencies=ctl-db-hasp-res1,ctl-db-hasp-res2,ctl-db-hasp-res3

A. ctl-ora-lsnr-res is the new resource name for the oracle listener

B. ORACLE_HOME=/oracle/ctlprod/9.2.0 Oracle home directory.

C. Resource_dependencies:  Any resource dependency

D. ctlprod-rg: resource group name

2. The command above will create the resource and will leave it offline, you will have to online it manually.

scswitch -e -j ctl-ora-lsnr-res

3. Run the following command create the Oracle Server resource:

scrgadm -a -j ctl-ora-srv-res -g ctlprod-rg -t SUNW.oracle_server:5 \
-x ORACLE_HOME=/oracle/ctlprod/9.2.0 \
-x ORACLE_SID=ctlprod \
-x Alert_log_file=/oracle/ctlprod/admin/bdump/alert_ctlprod.log \
-x Connect_string=suncluster/password \
-y Resource_dependencies=ctl-db-hasp-res1,ctl-db-hasp-res2,ctl-db-hasp-res3

A. ctl-ora-srv-res-g: the new resource name for the oracle server/database

B. ORACLE_HOME=/oracle/ctlprod/9.2.0 Oracle home directory.

C. Resource_dependencies:  Any resource dependency

D. ctlprod-rg: resource group name

E. ORACLE_SID: Oracle database SID name

F. Alert_log_file: Oracle database alert log file full path

G. Connect_string: Connection string , the user name and the password that the cluster will use it to connect to the database in order to monitor it.

4. The command above will create the resource and will leave it offline, you will have to online it manually.

scswitch -e -j ctl-ora-srv-res

Advertisement