Showing posts with label Server. Show all posts
Showing posts with label Server. Show all posts

Saturday, January 12, 2013

Shutting Down a Exadata DB Node [same on normal RAC]


While we need to shutdown any of exadata(same for any RAC DB) DB Nodes I normally follow below checklist. 

1. from DB & ASM node run below query and cahek all the nodes are in open staus
select * from gv$instance;
2. login to the target DB node with oracle user and set .oracrs.sh env

3. now shutdown the instance on the target node using below command
/u01/app/11.2.0/grid/bin/srvctl stop instance -d ORADB -i

4. FROM DB node run belwo quert to be sure that target instance is now down
select * from gv$instance;

5. now login as root and run below command to shudown CRS
/u01/app/11.2.0/grid/bin/crsctl stop crs

-- from DB node run below command and make sure that crs is down [CRS-0184]
/u01/app/11.2.0/grid/bin/crs_stat -t
CRS-0184: Cannot communicate with the CRS daemon.

6. FROM ASM run below query to make sure that ASM on tgaret hots is down
select * from gv$instance;

7. shutdown the DB machine

8. startup the DB machine

9. check with below command the all the cluster services are online except .gsd and .oc4j
/u01/app/11.2.0/grid/bin/crs_stat -t|grep OFFLINE
--from DB node with oracle user and .oracrs.sh env run below command to make sure that all the ASM disks are online
asmcmd
ASMCMD> ls

. oracrs.sh
sqlplus / as sysasm

10. if any disk is missing the from ASM instance of the target machine run below command to make the perticular disk online
alter diskgroup mount;

11. chek that DB instance is online or not if not automatically online use below command to make it online
srvctl start -d axdw -i

12. from ASM & DB instance user below query to check all the ASM and DB instances are online
select * from gv$instance;

13. from ASM & DB instance user below query to check all the ASM DISKS are online from all the instance
select header_status,mode_status,state,failgroup,count(*) from gv$asm_disk group by header_status,mode_status,state,failgroup;

14. check alertlog of both db & asm for the target node

Thursday, July 14, 2011

Install Oracle Workflow Server on 11gR2 Database

We have just installed Oracle Workflow Server on 11gR2 Database using below steps:

1. Go to $ORACLE_HOME\owb\wf\install

2. run below script:
Linux: $ ./wfinstall.csh
Windows: wfinstall.bat

3. insert values as below on the form displayed with the above command:
Install Option : Server Only
Workflow Account : owf_mgr
Workflow Password : Specify a password for owf_mgr
SYS Password : Enter SYS password for the database on which we are installing Oracle Workflow.
TNS Connect Descriptor : Descriotion of TNS of Target Database
[ (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME/IP)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MYDB)))]
LDAP Parameters : [If needed]
Mailer Parameters : [If needed]
Tablespace : Default tablespace for worlflow server

4. Submit to start

5. After Successful installation a completion message will be displayed

Thanks to below links:
http://download.oracle.com/docs/cd/B28359_01/owb.111/b31280/install_opts05.htm#i1008852
http://forums.oracle.com/forums/thread.jspa?threadID=663891