Oh ya .., ini file /etc/init.d/oracle-nya ------ #!/bin/bash # #Run-level Startup script for the Oracle Instance and Listener # #chkconfig: 345 91 19 #Penjelasan : Startup/Shutdown Oracle Listener dan instance ORA_HOME="/opt/oracle/product/10.1.1" ORA_OWNER="oracle"
#kalau excutable nya gak ada -- tampilin error if [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ] then echo "Nyalain Oracle: Tetiasa GUGAH !!1 )-:" exit 1 fi # tergantung parameternya -- startup, shutdown, restart # dari instance dan listener case "$1" in start) # ngebangunin Oracle listener dan instance echo "Nyalain Oracle: " su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" su - $ORA_OWNER -c $ORA_HOME/bin/dbstart touch /var/lock/subsys/oracle echo "OK Choy.." ;; stop) # Maehan Oracle listener dan instance echo "Maehan Oracle:" su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop" su - $ORA_OWNER -c $ORA_HOME/bin/dbshut rm -f /var/lock/subsys/oracle echo "Ok Choy ..." ;; reload|restart) $0 stop $0 start ;; *) echo "Cara makenya: $0 start|stop|restart|reload" exit 1 esac exit 0 ------------------------------------------- Ketika saya coba men-start listener beserta db nya : ------ [EMAIL PROTECTED]:/opt/oracle/product/10.1.1/network/admin$ wajig start oracle Nyalain Oracle: LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 06-JUL-2005 20:08:22 Copyright (c) 1991, 2004, Oracle. All rights reserved. Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message 12545 not found; No message file for product=network, facility=TNS TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS TNS-00515: Message 515 not found; No message file for product=network, facility=TNS Linux Error: 2: No such file or directory SQL*Plus: Release 10.1.0.2.0 - Production on Wed Jul 6 20:08:22 2005 Copyright (c) 1982, 2004, Oracle. All rights reserved. SQL> Connected to an idle instance. SQL> ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance started. Total System Global Area 121634816 bytes Fixed Size 777716 bytes Variable Size 86708748 bytes Database Buffers 33554432 bytes Redo Buffers 593920 bytes ORA-00201: controlfile version 10.1.0.2.0 incompatible with ORACLE version 10.0.0.0.0 ORA-00202: controlfile: '/var/lib/oradata/DLABKOM/controlfile/o1_mf_1d1yc236_.ctl' SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options Database "Ilabkom" warm started. OK Choy.. ------------------------------ Salah dimana yah ? ini db buat oprekan doang .... (-: -- ************************************************* "Choose a job you love, and you will never have to work a day in your life." -- Confucius "How do I work? I grope." -- Albert Einstein "Experience is the best teacher, enrolling in the class is the biggest problem." -- Anonymous ------ Y! hawking_123 HP : 08561124986 ------ Dept. of Physics | Cisco Networking Academy Univ. of Indonesia | Program Depok | Telp. 021-9205371 | Fax. 021-78849007 | http://labkom.fisika.ui.ac.id ************************************************* [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- 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/
