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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Ò». Ora-24801:ÔÚOCI_lobº¯ÊýÖзǷ¨µÄ²ÎÊýÖµ
°ÑÒ»Õź¬ÓГ±¸×¢”×ֶεıíͨ¹ýODBCµ¼³öµ½OracleµÄʱºòÒ»Ö±³öÏÖÈçÉÏͼËùʾµÄÌáʾÐÅÏ¢¡£³¢ÊÔÈ¥µôÏà¹Ø×Ö¶ÎÖпոñ×Ö·û£¬È¥µô×Ö¶ÎΪ¿ÕµÄ¼Ç¼£¬»¹Êǵ¼³öʧ°Ü¡£×îºóżȻ·¢ÏÖ£¬ÖØÐ½¨Ò»ÕÅÏàͬ½á¹¹µÄ¿Õ±í£¬È»ºó¸´ÖÆÔ±íµÄ¼Ç¼£¬ÔÙÕ³Ìùµ½Ð±íÖУ¬µ¼³öµ½Oracle¾ ......
1) Instance in RESTRICTED SESSIONS mode?
¡¡¡¡Check if the instance is in restricted sessions mode:
¡¡¡¡select instance_name,logins from v$instance;
¡¡¡¡If logins=RESTRICTED, then:
¡¡¡¡alter system disable restricted session;
¡¡¡¡^-- Checked!
¡¡¡¡2) JOB_QUEUE_PROCESSES=0
¡¡¡¡Make sure th ......
Êý¾Ýµ¼³ö£º
1 ½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂëmanager µ¼³öµ½D:\daochu.dmpÖÐ
exp system/manager@TEST file=d:\daochu.dmp full=y
2 ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
exp system/manager@TEST file=d:\daochu.dmp owner=(system,sys)
3 ½«Êý¾Ý¿âÖеıíin ......
[ÕªÒª]Ö÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
[¹Ø¼ü´Ê]ORACLEÊý¾Ý¿â¡¢»·¾³µ÷Õû¡¢ÓÅ»¯Éè¼Æ¡¢·½°¸
ÖÐͼ·ÖÀàºÅ£ºTP3 ÎÄÏ×±êʶÂ룺A ÎÄÕ±àºÅ£º1671£7597(2008)0720043£01
¡¡¡¡
¡¡¡¡ORACLEÊý¾Ý¿âÖÐÊý¾Ý´æÈ¡ÐÔÄ ......