Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

28.4.2 ¿ª»ú×Ô¶¯Æô¶¯OracleÊý¾Ý¿â·þÎñ

28.4.2  ¿ª»ú×Ô¶¯Æô¶¯OracleÊý¾Ý¿â·þÎñ
OracleÌṩÁË3¸öÎļþ£¬ÓÃÓÚÅäÖÃOracleÊý¾Ý¿â·þÎñµÄ×Ô¶¯Æô¶¯£¬ËüÃÇ·Ö±ðÊÇ/etc/oratab¡¢$ORACLE_HOME/bin/dbstartÒÔ¼°$ORACLE_HOME/bin/dbshut¡£¹ØÓÚÕâ3¸öÎļþµÄ˵Ã÷ÈçÏÂËùʾ¡£
q      /etc/oratab£ºÔÚ¸ÃÎļþÖÐÖ¸¶¨ÐèÒª×Ô¶¯Æô¶¯ºÍ¹Ø±ÕµÄÊý¾Ý¿â¡£
q      $ORACLE_HOME/bin/dbstart£º¶ÁÈ¡oratabÎļþÖеÄÄÚÈÝ£¬Æô¶¯ÏàÓ¦µÄÊý¾Ý¿â²¢Æô¶¯ÍøÂç¼àÌý³ÌÐò¡£
q      $ORACLE_HOME/bin/dbshut£º¶ÁÈ¡oratabÎļþÖеÄÄÚÈÝ£¬¹Ø±ÕÏàÓ¦µÄÊý¾Ý¿â²¢¹Ø±ÕÍøÂç¼àÌý³ÌÐò¡£
¾ßÌåÅäÖò½ÖèÈçÏÂËùÊö¡£
£¨1£©±à¼­oratabÎļþ¡£¸ÃÎļþ±£´æÁËϵͳÖÐËùÓÐÒÑ´´½¨µÄÊý¾Ý¿âµÄÐÅÏ¢£¬Ã¿¸öÊý¾Ý¿â¶ÔÓ¦Ò»ÐмǼ£¬ÒÔ#ºÅ¿ªÍ·µÄÊÇ×¢ÊÍÐС£ÀýÈçorclÊý¾Ý¿âµÄ¶ÔÓ¦¼Ç¼ÈçÏÂËùʾ¡£
 
orcl:/u01/app/oracle/product/11.1.0/db_1:N
 
Èç¹ûÒªÉèÖÃorclÊý¾Ý¿âÔÚ¿ª»úʱ×Ô¶¯Æô¶¯£¬°Ñ¸Ã¼Ç¼×îºóµÄN¸ÄΪY£¬¸ü¸ÄºóµÄ½á¹ûÈçÏÂËùʾ¡£
 
orcl:/u01/app/oracle/product/11.1.0/db_1:Y
 
£¨2£©ÔÚ/etc/init.dĿ¼Ï´´½¨Îļþoracle£¬¼ÓÈëÈçÏÂÄÚÈÝ£º
 
#!/bin/sh
# chkconfig: 345 90 10
# description: Oracle auto start-stop script.
#
ORA_HOME=/u01/app/oracle/product/11.1.0/db_1
                                    # ʹÓÃORA_HOME±äÁ¿ÉèÖÃOracleÖ÷Ŀ¼µÄλÖÃ
ORA_OWNER=oracle                    # ʹÓÃORA_OWNER±äÁ¿ÉèÖÃOracleÓû§
# Èç¹ûdbstart½Å±¾Îļþ²»´æÔÚ£¬Ôò·µ»Ø´íÎóÐÅÏ¢
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"# Êä³öOracleÎÞ·¨Æô¶¯µÄ´íÎó
exit
fi
case "$1" in
'start')                            # Èç¹û²ÎÊýΪstart
# Ö´ÐÐdbstart½Å±¾Æô¶¯OracleÊý¾Ý¿â
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME"
;;
'stop')  &n


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

28.1 Oracle 11g¼ò½é

28.1  Oracle 11g¼ò½é
¾­¹ýÁËÈýÄêµÄ×¼±¸£¬Oracle£¨¼×¹ÇÎÄ£©¹«Ë¾ÓÚ2007Äê7ÔÂ12ÈÕÔÚÈ«Çò·¶Î§ÄÚͬ²½ÍƳöÁËÆä×îа汾µÄÊý¾Ý¿â²úÆ·——Oracle 11g¡£ÐµÄOracleÊý¾Ý¿âÈÔÈ»ÒÔg×÷Ϊ°æ±¾ºó׺£¬ÒÔ´ú±íÕâÊÇÒ»¸ö°üº¬ÁËÍø¸ñ¼ÆËã¼¼ÊõµÄÊý¾Ý¿âÈí¼þ£¨Oracle×Ô10°æ±¾¿ªÊ¼ÒÔg×÷Ϊ°æ±¾ºó׺£¬¶øÔÚÕâ֮ǰÊÇʹÓÃi£¬ÈçOracle 8i¡¢ ......

¡¾×ª¡¿oracleÖÐhintÓ÷¨

hints 這個東ʹÓõĺõÄ話ºÜºÃÓá£ÔÚ½øÐÐsqlÖ´Ðйý³ÌÖУ¬ÓÉÓÚÓÐʱºòϵͳ×Ô¶¯ÓÅ»¯µÄ·½Ê½²¢²»ÊÇ×îÓŵġ£ÐèÒªÎÒÃÇÊÖ¹¤Ìí¼ÓhintÀ´Ìá¸ß²éѯЧÂÊ¡£ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ­³£»áÓõ½hint,ÏÖ×ܽáÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracle HINTµÄÓ÷¨£º
1. /*+ALL_ROWS*/±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñ ......

ѧϰOracleÖеĹý³ÌÒ»µãС½á£¡

×î½ü½Ó´¥OracleµÄ¶«Î÷£¬¸Õ¸Õ¿ªÊ¼Ñ§Ï°²¢Í¬Ê±×öµã¶«Î÷£¬×î½üÀÏÊÇʹÓô洢¹ý³Ì¡£ÏÖÔÚͨ¹ýÎÒ¸öÈ˵ÄʹÓüòµ¥ËµÏÂ×Ô¼ºµÄ¸ÐÊÜ£¡
ÔÚÉè¼Æ´æ´¢¹ý³ÌÖУ¬Ò»±¾Í¨¹ý¶þ¸ö·½Ê½ÊµÏÖ£º
1£º¾ÍÊǼòµ¥µÄʵÏÖÓαê
             ---¹ý³ÌµÄÉùÃ÷---
      ......

Oracle´´½¨±í¿Õ¼ä¡¢´´½¨Óû§ÒÔ¼°ÊÚȨ¡¢²é¿´È¨ÏÞ

´´½¨ÁÙʱ±í¿Õ¼ä
´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
´´½¨Óû§±í¿Õ¼ä
C ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ