start oracle with the linux opening
1.ÐÞ¸Ä/etc/oratab £¬Ìí¼Ó$ORACLE_SID:$ORACLE_HOME:Y --
Y´ú±íOSÆô¶¯ÔòDBÆô¶¯±ØÐëÉèÖÃΪY£¬·ñÔòdbstartºÍdbstop²»¿ÉÓã¬NΪ²»Æô¶¯£¬$ORACLE_SIDÊÇDB
SID£¬$ORACLE_HOMEÊÇDB ¾ø¶Ô·¾¶
2.ÐÞ¸Ä/etc/rc.d/rc.loacl,¼ÓÈëÒÔÏ£º
#listener command
COMM_LISTENER=/opt/oracle/product/10.2.0/db_1/bin/lsnrctl
LISTENER_NAME=orctest
su - oracle -c "$COMM_LISTENER start $LISTENER_NAME"
COMM_START=/opt/oracle/product/10.2.0/db_1/bin/dbstart
su - oracle -c "$COMM_START"
echo $COMM_START
ÖØÆô¼´¿É¿´µ½Êý¾Ý¿âºÍ¼àÌýÒѾÆô¶¯¡£
##################################################
1. ´´½¨Îļþ/etc/oratab
#Ìí¼ÓÈçÏÂÄÚÈݵ½/etc/oratabÎļþÖÐ,
#$ORACLE_SIDÊÇÄãµÄOracleÊý¾Ý¿âµÄsid
#$ORACLE_HOMEÊÇÄãµÄOracleÊý¾Ý¿âµÄOracle_home
#Y±íʾҪÇóÔÚϵͳÆô¶¯µÄʱºòÆô¶¯OracleÊý¾Ý¿â.N±íʾ²»ÒªÔÚϵͳÆô¶¯µÄʱºòÆô¶¯Oracle
¸ÄÒÔÏÂΪ
# *:/data/opt/app/oracle/app:N# db1:/data/opt/app/oracle/app:N
*:/data/opt/app/oracle/app:Ydb1:/data/opt/app/oracle/app:Y
2. ÐÞ¸ÄÎļþ/etc/rc.localÌí¼ÓÒ»ÏÂÁ½ÐÐ
su - oracle -c 'dbstart'
su - oracle -c 'lsnrctl start '
3.ÐÞ¸ÄdbstartÕâ¸öÆô¶¯ÎļþµÄoratabµÄĿ¼Ϊ/etc/oratab,ĬÈϵÄÎļþĿ¼ÊDz»¶ÔµÄ¡£Ò»¶¨Òª¸Ä¡£
#ORATAB=/var/opt/oracle/oratab
ORATAB=/etc/oratab
Ö»ÐèÐÞ¸ÄÒÔÉϾͿÉÒԳɹ¦ÁË¡£ºÜEASY!
#######################################################
=== 5. ÉèÖÃÊý¾Ý¿â×Ô¶¯Æô¶¯ ===
-- 5.1 --
±à¼Îļþ /etc/oratab£¬½«“N”ÐÞ¸ÄΪ“Y”
oradb1:/oracle/product/10.2.0:Y
-- 5.2 --
È·ÈÏoracleÓû§ÄÜ·ñÓÃϵͳ×Ô´øµÄShell³ÌÐòdbstart, dbshutÕý³£Æô¶¯ºÍ¹Ø±ÕÊý¾Ý¿â£¬ÒÔoracle
Éí·ÝÖ´ÐÐ dbstart dbshut
-- 5.3 ½¨Á¢Æô¶¯Shell --
ÒÔrootÉí·Ý£¬ÔÚ /etc/rc.d/init.d Ŀ¼Ï½¨Á¢Îļþ oracle£¬ÄÚÈÝΪ£º
#!/bin/sh
OPT_=$1
case "$OPT_" in
start)
/bin/echo "$0 : (start)"
#
# Your service startup command goes here.
#
su - oracle -c "/oracle/product/10.2.0/bin/lsnrctl start"
su - oracle -c "/oracle/product/10.2.0/bin/dbstart"
# NOTE: Must exit with zero unless error is severe.
chmod 177
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ORACLEµÄËø»úÖÆ
×òÌìÈ¥Ò»¸ö¹«Ë¾ÃæÊÔ£¬Îʵ½OracleµÄ·âËø»úÖÆ£¬ºÇºÇ£¬ÀíÂÛÉϵÄÎÊÌâºÃ¾Ã¶¼Ã»ÓÐѧϰÁË£¬Êé±¾µÄ¶«Î÷Ò²²î²»¶à¶¼»¹¸øÁË´óѧµÄÀÏʦ¡£»ØÀ´·ÁËÒ»ÏÂÊé±¾£¬ÕÒµ½Á˹ØÓÚÕⲿ·Ö֪ʶµÄ˵Ã÷£¬Ìù³öÀ´¹©´óѧ²Î¿¼¡££¨ÏÖÔڵĹ«Ë¾£¬ ......
´ó¿é£¬Óŵ㣺
1¡¢Ë³Ðò¶Á¡¢Ë÷Òý¶ÁÐÔÄܺÃ
ÒòΪ´ó¿éÈÝÄɵÄÐÐÏà¶ÔС¿éÊý¾Ý
¶à£¬ÔÚ½øÐÐÈ«±íɨÃèµÄʱºò£¬»òÕßË÷ÒýɨÃèµÄʱºò£¬ËùÐèÒªµÄÎïÀí¶Á¡¢Âß¼¶Á¶¼ÒªÉÙ¡£
ËüÒ²ÄܼõСË÷ÒýµÄÊ÷¸ß¡£¶ÔÓÚË÷Òý·ÃÎÊ
µÄÐÔÄÜÓÐËùÌá¸ß¡£
2¡¢´ó¿éÄÜÈÝÄɱȽϴóµÄÐÐ
ÈÝÄÉ´óÐиöÈËÀí½â£¬Ò»¶¨³Ì¶ÈÉÏ¿ÉÒÔ±ÜÃâÐÐÇ¨ÒÆ¡¢ÐÐÁ´½Ó¡£¼õС´óÐеĶÁÈ¡¿é ......
¹ØÓÚOracle 10g ¹éµµ·½Ê½µÄÌÖÂÛ£º¹Ø±Õ¹éµµ/ÆôÓÃÉÁ»Ø»Ö¸´Çø¹éµµ(Oracle 10gÐÂÌØÐÔ)/ÆôÓÃÀàOracle9iµÄ¹éµµ
×¢£ºÔÚOracle°²×°¹ý³ÌÖУ¬Èç¹ûÊý¾Ý¿âÊÇ×Ô¶¯´´½¨µÄ£¬ÄÇô¸ÃÊý¾Ý¿â×î³õµÄ´æµµÄ£Ê½ÊÇÓɲÙ×÷ϵͳָ¶¨µÄ¡£Í¨³£Çé¿öÏ£¬¹éµµÈÕÖ¾ÔÚOracleÊý¾Ý¿â°²×°½áÊøºóÐèÒªÊÖ¹¤´´½¨¡£
»·¾³£ºOracle 10g 10.2.0.1.0/Windows 2003 ......