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 ......
ÀýÒ»£º·¢ËÍSignaling Packet£º
Signaling CommandÊÇ2¸öBluetoothʵÌåÖ®¼äµÄL2CAP²ãÃüÁî´«Êä¡£ËùÒÔµÃSignaling CommandʹÓÃCID 0x0001.
¶à¸öCommand¿ÉÒÔÔÚÒ»¸öC-frame£¨control frame£©Öз¢ËÍ¡£
Èç¹ûÒªÖ±½Ó·¢ËÍSignaling Command.ÐèÒª½¨Á¢SOCK_RAWÀàÐ͵ÄL2CAPÁ¬½ÓSocket¡£ÕâÑù²ÅÓлú»á×Ô¼ºÌî³äCommand Code£¬Identi ......
ʹÓÃselectº¯Êý¿ÉÒÔÒÔ·Ç×èÈûµÄ·½Ê½ºÍ¶à¸ösocketͨÐÅ¡£³ÌÐòÖ»ÊÇÑÝʾselectº¯ÊýµÄʹÓ㬹¦Äܷdz£¼òµ¥£¬¼´Ê¹Ä³¸öÁ¬½Ó¹Ø±ÕÒÔºóÒ²²»»áÐ޸ĵ±Ç°Á¬½ÓÊý£¬Á¬½ÓÊý´ïµ½×î´óÖµºó»áÖÕÖ¹³ÌÐò¡£
1. ³ÌÐòʹÓÃÁËÒ»¸öÊý×éfd_A£¬Í¨ÐÅ¿ªÊ¼ºó°ÑÐèҪͨÐŵĶà¸ösocketÃèÊö·û¶¼·ÅÈë´ËÊý×é¡£
2. Ê×ÏÈÉú³ÉÒ»¸ö½Ðsock_fdµÄsocketÃèÊö·û£¬ÓÃÓÚ¼àÌý¶Ë¿ ......
ARMµÄǶÈëʽLinuxÒÆÖ²ÌåÑéÖ®BootLoader
2006-08-12 08:00×÷ÕߣºËᦻª³ö´¦£ºÌ켫¿ª·¢ÔðÈα༣º·½ÖÛ
BootLoaderָϵͳÆô¶¯ºó£¬ÔÚ²Ù×÷ϵͳÄÚºËÔËÐÐ֮ǰÔËÐеÄÒ»¶ÎС³ÌÐò¡£Í¨¹ýBootLoader£¬ÎÒÃÇ¿ÉÒÔ³õʼ»¯Ó²¼þÉ豸¡¢½¨Á¢ÄÚ´æ¿Õ¼äµÄÓ³Éäͼ£¬´Ó¶ø½«ÏµÍ³µÄÈíÓ²¼þ»·¾³´øµ½Ò»¸öºÏÊʵÄ״̬£¬ÒÔ±ãΪ×îÖÕµ÷ÓòÙ×÷ϵͳ ......
2007Äê12ÔÂ05ÈÕ ÐÇÆÚÈý 05:36
Linux×ö´úÀíÉÏÍø·þÎñÆ÷
Linux×ö´úÀíÉÏÍø·þÎñÆ÷--Ë͸øÄÇЩÏëÓÃLinux×öÍø°É´úÀíÉÏÍø·þÎñÆ÷µÄÅóÓÑ
Ê×ÏÈÉùÃ÷£¬»áÕâ¸öµÄÀÏÄñ²»Óÿ´£¬ÎÒÕâÖ»ÊǸøÐÂÊÖ¿´µÄ
Ê×ÏÈ°²×°ºÃLinux£¬×¼±¸Ò»Ì¨ÓÐÁ½¿éÍø¿¨µÄ·þÎñÆ÷£¬Ò»Íø¿¨½ÓÄÚÍø£¬ÁíÒ»Íø¿¨½ÓÍâÍø£¬±ÈÈçÍø°ÉÍâÍøIPΪ61.178.89.234 ÄÚÍøIP¶ÎΪ192.16 ......