Dear Mas Arie,
Mas saya juga pakai RHEL5, ada kok /etc/oratab... Berikut langkah2 yg sy
gunakan;
1. Edit /etc/oratab
vi /etc/oratab
contohnya seperti berikut;
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
$ORACLE_SID:$ORACLE_HOME:<N|Y>:Y <=====(beritanda Y dan remarks "#" di depan
sebelum tanda dollar "$" dihilangkan)
# atau ALTERNATIVE LAIN juga bisa dengan kita menuliskan langsung ORACLE SID
dan ORACLE_HOME nya... CONTOH;
PROD:/OraHome/oracle11g/product/11.1.0/db_1:Y <======== (ini contoh lho)
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
2. Langkah berikutnya Tambahkan pula script auto startup dan shutdown
Sebagai user oracle, pastikan dbstart dan dbshut ada (available)
which dbstart
which dbshut
Kemudian coba buat init script,
vi /etc/init..d/dbora
contoh isinya seperti berikut,
#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.
ORA_HOME=/u01/11g/product/11.1.0/OraDb11g_home1 <==== (sesuaikan dg path anda)
ORA_OWNER=oracle <===== (sesuaikan dg yg anda miliki)
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
'start')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME"
;;
'stop')
# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME"
;;
esac
setelah anda membuat script diatas save dan kemudian ikuti langkah berikut,
chmod 750 /etc/init.d/dbora
chkconfig --level 345 dbora on
CATATAN:
Jangan lupa edit .bash_profile terlebih dahulu di /home/oracle dan sesuaikan
path ORACLE_HOME dan ORACLE_SID
cd /home/oracle
vi .bash_profile
contohnya;
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_HOME=/OraHome/oracle11g/product/11.1.0/db_1;export ORACLE_HOME
ORACLE_LIB_PATH=$ORACLE_HOME/lib;export ORACLE_LIB_PATH
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
ORACLE_SID=PROD;export ORACLE_SID
export PATH
Semoga membantu..
Regards,
Wisnu
~Newbie~
________________________________
From: arie sandy <[email protected]>
To: [email protected]
Sent: Mon, January 4, 2010 6:40:33 PM
Subject: Re: [indo-oracle] oracle di linux
mas ko gk ada ada ya /etc/oratab
apa sy harus buat dulu oratab'y di /etc secara manual..
Pada 4 Januari 2010 01:05, Wadi Achmed <wadiach...@gmail. com> menulis:
>
>
> Hi Arie,
>
> Di /etc/oratab set column terakhir dari database instance yang mau auto
> start
> dengan Y.
>
> Cheers,
> Wadi Achmed
>
>
> On Sat, Jan 2, 2010 at 5:43 PM, arie sandy <zonea...@gmail.
> com<zonearie%40gmail. com>>
> wrote:
>
> > Halo semua,
> >
> > Mau tanya ... kan sy install oracle 10g di linux RHEL5...biar c oracle'y
> > startup saat abis di restart sintax'y apa ya...
> > karna sy masih belajar...minta tutorial'y DBA dunk yang bhs indo aja agar
> > mudah di mengerti...
> >
> > terima kasih semua...^^
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------ --------- --------- ------
>
> >
> > --
> > -----------I. N.D.O - O.R.A.C.L.E- --------- -----
> > Keluar: indo-oracle- unsubscribe@ yahoogroups. com<indo-oracle-
> > unsubscribe% 40yahoogroups. com>
> > Website: http://indooracle. wordpress. com
> > http://www.facebook .com/group. php?gid=51973053 515
> > ------------ --------- --------- --------- --------
> >
> > Bergabung dengan Indonesia Thin Client User Groups,
> > Terminal Server, Citrix, New Moon Caneveral, di:
> > http://indo- thin.blogspot. comYahoo! Groups Links
>
> >
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
