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
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.
rc.d:
init.d rc0.d rc2.d rc4.d rc6.d rc.sysinit
rc rc1.d rc3.d rc5.d rc.local
[root@nijam etc]# chkconfig –add –level 35 dbora
[root@nijam etc]# du -a |grep dbora
0 ./rc.d/rc2.d/S80dbora
0 ./rc.d/rc1.d/K30dbora
0 ./rc.d/rc3.d/S80dbora
0 ./rc.d/rc0.d/K30dbora
0 ./rc.d/rc6.d/K30dbora
4 ./rc.d/init.d/dbora
0 ./rc.d/rc4.d/S80dbora
0 ./rc.d/rc5.d/S80dbora
[root@nijam etc]# chkconfig –list dbora
dbora 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[oracle@nijam bin]$ ps -ef|grep pmon
ordacle 4722 1 0 16:54 ? 00:00:00 ora_pmon_nijam
oracle 4769 4190 0 16:54 pts/1 00:00:00 grep pmon
[root@nijam etc]# init 6
oracle 4769 4190 0 16:54 pts/1 00:00:00 grep pmon
postgres 
