Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

DB AUTOMATIC STARTUP - SHUTDOWN in Oracle Linux



DATABAES NAME : nijam
[oracle@nijam ~]$ ps -ef |grep pmon
oracle 3630 1 0 16:42 ? 00:00:00 ora_pmon_nijam
oracle 4297 4190 0 16:44 pts/1 00:00:00 grep pmon
[root@nijam ~]# vi /etc/oratab
nijam:/u01/app/oracle/product/10.2.0/db_1:Y
[oracle@nijam bin]$ dbshut
[oracle@nijam ~]$pwd
[oracle@nijam ~]$ cd /u01/app/oracle/product/10.2.0/db_1/bin/
[oracle@nijam ~]$ ps -ef |grep pmon
oracle 4297 4190 0 16:44 pts/1 00:00:00 grep pmon
[oracle@nijam bin]$ dbstart
[oracle@nijam ~]$ ps -ef |grep pmon
oracle 3630 1 0 16:42 ? 00:00:00 ora_pmon_nijam
oracle 4297 4190 0 16:44 pts/1 00:00:00 grep pmon

[root@nijam ~]# cd /etc/init.d/

[root@nijam init.d]# vi dbora

#!/bin/sh -x
#
# file: /etc/init.d/dbora
# chkconfig: 2345 80 30
# description:  nijam
#
#

# the user that oracle runs as (default: oracle)
ORACLE=oracle

# database instance id
ORACLE_SID=nijam

# ORACLE_HOME (file system) path
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

PATH=${PATH}:$ORACLE_HOME/bin

export ORACLE_SID ORACLE_HOME PATH

case $1 in
  'start')
    su - $ORACLE -c $ORACLE_HOME/bin/dbstart
  ;;
  'stop')
    su - $ORACLE -c $ORACLE_HOME/bin/dbshut
  ;;
  *)
    echo "usage: $0 {start|stop}"
  ;;
esac

exit

[root@nijam etc]# chmod +x dbora


 There are 7 run levels in Linux environment.
Run-level          Name                    Description

0                     Halt                   Shuts down the system.
1                 Single-User Mode     Mode for administrative tasks.
2                 Multi-User Mode      No network interfaces and services
3                 Multi-User Mode      Networking  Starts the system normally.
4                  Not used               For special purposes.
5                 With Display           As runlevel 3 + Gui
6                   Reboot                 Reboots the system.

Chkconfig command will create start and kill scripts in /etc/rc[runlevel].d folders.
[root@nijam etc]# ls rc*

Comments

Popular posts from this blog

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

Ora2PG - Oracle/MySQL to Postgres DB migration Version 20.0

PostgreSQL Introduction