LinuxÏÂÆô¶¯Oracle·þÎñºÍ¼àÌý³ÌÐò(»ù´¡ÖªÊ¶)
oracleÊý¾Ý¿âÊÇÖØÁ¿¼¶µÄ£¬Æä¹ÜÀí·Ç³£¸´ÔÓ£¬½«ÆäÔÚlinuxƽ̨ÉϵÄÆô¶¯ºÍ¹Ø±Õ²½ÖèÕûÀíһϡ£
°²×°Íê±ÏoracleÒÔºó£¬ÐèÒª´´½¨oracleϵͳÓû§£¬
²¢ÔÚ/home/oracleÏÂÃæµÄ.bash_profileÌí¼Ó¼¸¸ö»·¾³±äÁ¿£º
ORACLE_SID,ORACLE_BASE,ORACLE_HOME¡£
±ÈÈ磺
export ORACLE_SID=test export ORACLE_BASE=oracle_install_dir export ORACLE_HOME=xxx
Æô¶¯²½Ö裺עÒâ$´ú±íshellÃüÁîÌáʾ·û£¬ÕâÀïµÄoracleÊÇ9.0ÒÔÉÏ°æ±¾¡£
$ su - oracle
$ sqlplus / nolog
sql> conn / as sysdba
sql> startup (Ò»°ã²»ÐèÒª¼Ó²ÎÊý£¬Ö»ÒªÉèÖúû·¾³±äÁ¿£©
sql> quit (Í˳ösqlģʽ)
$ lsnrctl start (Æô¶¯¼àÌýÆ÷£©¹Ø±Õoracle
$ lsnrctl stop(¹Ø±Õ¼àÌýÆ÷£¬ÔÚÕâ֮ǰ£¬Ó¦¸ÃÏȹرÕÓ¦ÓóÌÐò£©
$ sqlplus /nolog
sql>shutdown Æä²ÎÊý £ºshutdownÓÐËĸö²ÎÊý£¬Ëĸö²ÎÊýµÄº¬ÒåÈçÏ£º
Normal ÐèÒªµÈ´ýËùÓеÄÓû§¶Ï¿ªÁ¬½Ó
Immediate µÈ´ýÓû§Íê³Éµ±Ç°µÄÓï¾ä
Transactional µÈ´ýÓû§Íê³Éµ±Ç°µÄÊÂÎñ
Abort ²»×öÈκεȴý£¬Ö±½Ó¹Ø±ÕÊý¾Ý¿â
normalÐèÒªÔÚËùÓÐÁ¬½ÓÓû§¶Ï¿ªºó²ÅÖ´ÐйرÕÊý¾Ý¿âÈÎÎñ£¬ËùÒÔÓеÄʱºò¿´ÆðÀ´ºÃÏóÃüÁîûÓÐÔËÐÐÒ»Ñù£¡ÔÚÖ´ÐÐÕâ¸öÃüÁîºó²»ÔÊÐíеÄÁ¬½Ó
immediateÔÚÓû§Ö´ÐÐÍêÕýÔÚÖ´ÐеÄÓï¾äºó¾Í¶Ï¿ªÓû§Á¬½Ó£¬²¢²»ÔÊÐíÐÂÓû§Á¬½Ó¡£
transactional ÔÚÓµ»¤Ö´ÐÐÍ굱ǰÊÂÎïºó¶Ï¿ªÁ¬½Ó£¬²¢²»ÔÊÐíеÄÓû§Á¬½ÓÊý¾Ý¿â¡£
abort Ö´ÐÐÇ¿ÐжϿªÁ¬½Ó²¢Ö±½Ó¹Ø±ÕÊý¾Ý¿â¡£
Ç°ÈýÖÖ·½Ê½²»»Ø¶ªÊ§Óû§Êý¾Ý¡£µÚËÄÖÖÔÚ²»µÄÒѵÄÇé¿öÏ£¬²»½¨Òé²ÉÓã¡
SGAÉèÖÃ
oracleÖÐÓÐʱºò»áÓöµ½ÈçϵĴíÎó£¬ÎÞ·¨Á¬½ÓÊý¾Ý¿â
È磺ORA-04031:unable to allocate 2216 bytes of shared memory ("shared pool"... ...
ÕâÊDZíÃ÷oracleÖÐSGA(ϵͳȫ¾ÖÇø[°üÀ¨»º³å¸ßËÙ»º´æ¡¢¹²Ïí³Ø¡¢Java ³Ø¡¢´óÐͳغÍÖØ×öÈÕÖ¾»º³å])ÖÐij¸ö³ØÄÚ´æ²»×ãµ¼Ö£¬
ËùÒԾ͵úÏÀíµÄÅäÖÃSGAºÍSGA¸÷¸ö³Ø´óС¡£ÅäÖÿÉÒÔͨ¹ýEMÀ´½øÐС£¡£¡£¡£
oracle10gÌṩÁËEM¹ÜÀí¹¤¾ß£¬¿ÉÒÔÔÚûÓа²×°oracle¿Í»§¶ËµÄÇé¿öÏÂͨ¹ýweb·ÃÎÊÉèÖÃÊý¾Ý¿â¸÷ÖÖ²ÎÊý¡£¡£¡£
Æô¶¯EM £ºemctl start dbconsole;
Í£Ö¹EM £ºemctl stop dbconsole;
²é¿´×´Ì¬: emctl status dbconsole;
È»ºó¿ÉÒԹ۲쵽web·¾¶£¬Í¨¹ýweb·ÃÎʲ¢½øÐÐÏàÓ¦µÄ²Ù×÷¡£
Ò²¿ÉÒÔͨ¹ý¿ØÖÆ̨À´µÇ½oracle½øÐÐSGAµÄ²Ù×÷ÉèÖá£
²é¿´
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Service Discovery Protocol(SDP)ÌṩһÖÖÄÜÁ¦£¬ÈÃÓ¦ÓóÌÐòÓз½·¨·¢ÏÖÄÄÖÖ·þÎñ¿ÉÓÃÒÔ¼°ÕâÖÖ·þÎñµÄÌØÐÔ¡£
·þÎñ·¢ÏÖÐÒé(SDP»òBluetooth SDP)ÔÚÀ¶ÑÀÐÒéÕ»ÖжÔÀ¶ÑÀ»·¾³ÖеÄÓ¦ÓóÌÐòÓÐÌØÊâµÄº¬Ò⣬·¢ÏÖÄĸö·þÎñÊÇ¿ÉÓõĺÍÈ·¶¨ÕâЩ¿ÉÓ÷þÎñµÄÌØÕ÷¡£SDP¶¨ÒåÁËbluetooth client·¢ÏÖ¿ÉÓÃbluetooth server·þÎñºÍËüÃǵÄÌØÕ÷µÄ·½·¨¡£ ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
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
L ......
ÊÂÎï×ÜÓиöºËÐÄ£¬¸´ÔÓµÄÊÂÎï×Ü¿ÉÒÔÄ£¿é»¯¡¢²ã´Î»¯, ǶÈëʽLinuxÒ²Èç´Ë¡£Ñ§Ï°Ç¶ÈëʽLinuxÀ§ÄÑ£¬Ö÷ÒªÒòΪÉ漰֪ʶºÍ¸ÅÄî¹ý¶à£¬¼´±È½Ï¸´ÔÓ£¬ËùÒÔѧϰǶÈëʽLinuxµÄ¾ÍÐèÒªÕÒµ½ºËÐÄ£¬ÐèҪģ¿é»¯£¬ÐèÒª½øÐвã´Î»®·Ö¡£
ǶÈëʽLinuxϵͳ×öÄ£¿é»¯´¦Àí¾ÍÊÇ¿É»®·ÖΪBootloader£¨Òýµ¼³ÌÐò£©£¬Kernel£¨Äںˣ©£¬f ......