Wednesday 15 August 2012

Simple shellscript for Crontab


#!/bin/bash
export ORACLE_SID=$1
export PATH=$PATH:/usr/local/bin
export ORAENV_ASK=NO
. /usr/local/bin/oraenv

testsh() {
        $ORACLE_HOME/bin/sqlplus /nolog <
        conn / as sysdba
        alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
        select sysdate from dual;
        exit
EOF
        return $?
}

testsh



Tuesday 14 August 2012

srvctl commands


What is srvctl? it is the Server Control Utility, we use SRVCTL to start and stop the database and instances, manage configuration information, and to add, move or remove instances and services.
These are some of the srvctl commands I frequently use, this is not a complete reference guide.
I organized the commands as follow:
  • To start a rac database
  • To stop a rac database
  • To check status and configurations
  • To start and stop instances
  • To start, stop and manage services
Start a rac database (order: nodeapps – asm – database)
srvctl start nodeapps -n nodename
srvctl start asm -n 
nodename
srvctl start database -d dbname
options are: srvctl start database -d 
dbname -o open | -o mount | -o nomount
Stop a rac database (order: database – asm – nodeapps)
srvctl stop database -d dbname -o immediate
options are: srvctl stop database -d dbname -o normal | -o transactional | -o immediate | -o abort
srvctl stop asm -n nodename
options are: 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
srvctl relocate service -d dbname -s servicename -i instancename -t newinstancename [-f]
srvctl documentation for Oracle 10G R2 and 11G