Post Installation
Edit file /etc/oratab
DEMO1:/u01/app/oracle/product/10.1.0/db_1:Y
(asumsi: ORACLE_HOME di /u01/app/oracle/product/10.1.0/db_1)
Buat file di /etc/init.d/dbora
dengan isi sbb
#!/bin/sh
# description: Oracle auto start-stop script.
# chkconfig: - 20 80
#
# 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/app/oracle/product/10.1.0/db_1
ORA_OWNER=oracle
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/lsnrctl start"
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
;;
'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
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
;;
esac
Use chmod to set the privileges to 750:
chmod 750 /etc/init.d/dbora
Link the file into the appropriate run-level script directories:
ln -s /etc/init.d/dbora /etc/rc0.d/K10dbora
ln -s /etc/init.d/dbora /etc/rc3.d/S99dbora
Associate the dbora service with the appropriate run levels:
chkconfig --level 345 dbora on
The relevant instances should now startup/shutdown automatically at
system startup/shutdown.
Referensi diambil dari web (oracle-base)
Bowo
--- In [email protected], Milis <[EMAIL PROTECTED]> wrote:
>
> Dear Miliser,
>
> minta bantuan nih, saya sudah berhasil install Oracle10g di RHEL 3,
> sewaktu pertama install saya juga sertakan create database dengan
nama
> "demo1" dan jalan baik instance maupun listner nya, sehingga bisa
> dipakai untuk create table di db tsb
>
> ketika saya restart PC tsb, oracle tidak langsung start, lewat Mas
> Google saya udah berusaha nyari tapi belum solved. pertanyaan saya
>
> 1. kalau tidak salah PROSES starting listner dan instance itu ada
> berapa tahap? lsnrctl sudah berhasil menjalankan, tapi dbstart nya
> masih belum bisa jalan.
> ini tampilan log di startup.log saya
>
> Thu Dec 29 10:01:53 WIT 2005
> SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 29 10:01:53
2005
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> SQL> Connected to an idle instance.
> SQL> ORACLE instance started.
>
> Total System Global Area 281018368 bytes
> Fixed Size 1218944 bytes
> Variable Size 88082048 bytes
> Database Buffers 184549376 bytes
> Redo Buffers 7168000 bytes
> Database mounted.
> Database opened.
> SQL> Disconnected from Oracle Database 10g Enterprise Edition
Release 10.2.0.1.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> ./dbstart: Database instance "demo1" warm started.
>
> apakah ada yg masih kurang di settingan server saya ?
>
> Mohon pencerahan nya,
>
> --
> Tks & Best regards,
> Andi EP
> IT Engineer
> mailto:[EMAIL PROTECTED]
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
