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
Ïà¹ØÎĵµ£º
Ò». Ora-24801:ÔÚOCI_lobº¯ÊýÖзǷ¨µÄ²ÎÊýÖµ
°ÑÒ»Õź¬ÓГ±¸×¢”×ֶεıíͨ¹ýODBCµ¼³öµ½OracleµÄʱºòÒ»Ö±³öÏÖÈçÉÏͼËùʾµÄÌáʾÐÅÏ¢¡£³¢ÊÔÈ¥µôÏà¹Ø×Ö¶ÎÖпոñ×Ö·û£¬È¥µô×Ö¶ÎΪ¿ÕµÄ¼Ç¼£¬»¹Êǵ¼³öʧ°Ü¡£×îºóżȻ·¢ÏÖ£¬ÖØÐ½¨Ò»ÕÅÏàͬ½á¹¹µÄ¿Õ±í£¬È»ºó¸´ÖÆÔ±íµÄ¼Ç¼£¬ÔÙÕ³Ìùµ½Ð±íÖУ¬µ¼³öµ½Oracle¾ ......
decode()º¯數ʹÓü¼ÇÉ
·Èí¼þ»·¾³£º
1¡¢Windows NT4.0+ORACLE 8.0.4
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORANT
·º¬Òå½âÊÍ£º
decode(Ìõ¼þ,Öµ1,·ÒëÖµ1,Öµ2,·ÒëÖµ2,...Öµn,·ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·ÒëÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡¡¡¡¡¡RETURN ......
28.2.4 °²×°Oracle 11g
Oracle 11gÌṩÁËͼÐλ¯µÄ°²×°½çÃæ£¬Óû§¿Éͨ¹ýÒÆ¶¯ºÍµ¥»÷Êó±êÍê³É°²×°¹ý³Ì¡£¾ßÌå°²×°²½ÖèÈçÏÂËùʾ¡£
£¨1£©½âѹOracle 11g°²×°°üÎļþ¡£
unzip linux_11gR1_database_1013.zip
Îļþ½«»á±»½âѹµ½linux_11gR1_database_1013Ŀ¼Ï£¬ÈçÏÂËùʾ¡£
# ls
doc inst ......
´´½¨ÁÙʱ±í¿Õ¼ä
´´½¨ÁÙʱ±í¿Õ¼ä
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 ......
28.4.1 ÊÖ¹¤Æô¶¯ºÍ¹Ø±ÕOracle·þÎñ
OracleÊý¾Ý¿â·þÎñÓÉÁ½²¿·Ö×é³É£ºÊý¾Ý¿â½ø³ÌºÍÍøÂç¼àÌýÆ÷½ø³Ì£¬ËüÃÇ·Ö±ð¿Éͨ¹ýsqlplusºÍlsnrctlÃüÁî¿ØÖÆÆô¶¯¹Ø±Õ¡£
1£®Êý¾Ý¿â½ø³Ì
ʹÓÃDBCA¹¤¾ß´´½¨Êý¾Ý¿âºó£¬Æä½ø³ÌÒѾ×Ô¶¯Æô¶¯£¬ÕâЩ½ø³Ì¶¼ÊÇÒÔÊý¾Ý¿âÃû³Æ£¨ÔÚ±¾ÀýÖÐΪorcl£©ÃüÃû£¬ÈçÏÂËùʾ¡£
$ ps -ef|grep orcl
orac ......