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µÄ²Ù×÷ÉèÖá£
²é¿´
Ïà¹ØÎĵµ£º
ÀýÒ»£º·¢ËÍ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 ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
* Èç¹ûij¸öÔ¼ÊøÖ»×÷ÓÃÓÚµ¥¶ÀµÄ×ֶΣ¬¼´¿ÉÒÔÔÚ×ֶμ¶¶¨ÒåÔ¼Êø£¬Ò²¿ÉÒÔÔÚ±í¼¶¶¨ÒåÔ¼Êø£¬µ«Èç¹ûij¸öÔ¼Êø×÷ÓÃÓÚ¶à¸ö×ֶΣ¬
±ØÐëÔÚ±í¼¶¶¨ÒåÔ¼Êø
* ÔÚ¶¨ÒåÔ¼ÊøÊ±¿ÉÒÔͨ¹ýCONSTRAINT¹Ø¼ü×ÖÎªÔ¼ÊøÃüÃû£¬Èç¹ûûÓÐÖ¸¶¨£¬ORACLE½«×Ô¶¯ÎªÔ¼Êø½¨Á¢Ä¬ÈϵÄÃû³Æ
¶¨Òåprimary keyÔ¼Êø(µ¥¸ö×ֶΣ©
create t ......
ÊÂÎï×ÜÓиöºËÐÄ£¬¸´ÔÓµÄÊÂÎï×Ü¿ÉÒÔÄ£¿é»¯¡¢²ã´Î»¯, ǶÈëʽLinuxÒ²Èç´Ë¡£Ñ§Ï°Ç¶ÈëʽLinuxÀ§ÄÑ£¬Ö÷ÒªÒòÎªÉæ¼°ÖªÊ¶ºÍ¸ÅÄî¹ý¶à£¬¼´±È½Ï¸´ÔÓ£¬ËùÒÔѧϰǶÈëʽLinuxµÄ¾ÍÐèÒªÕÒµ½ºËÐÄ£¬ÐèҪģ¿é»¯£¬ÐèÒª½øÐвã´Î»®·Ö¡£
ǶÈëʽLinuxϵͳ×öÄ£¿é»¯´¦Àí¾ÍÊǿɻ®·ÖΪBootloader£¨Òýµ¼³ÌÐò£©£¬Kernel£¨Äںˣ©£¬f ......
Ò»¡¢CVS·þÎñÆ÷µÄ°²×°
Ê×ÏÈÈ·ÈÏϵͳÖÐÊÇ·ñ°²×°CVS·þÎñ£º
[root@localhost /]# rpm -qa|grep cvs
cvs-1.11.17-7.RHEL4
Èç¹ûÃüÁîÊä³öÀàËÆÓÚÉÏÃæµÄÊä³öÔò˵Ã÷ϵͳÒѾ°²×°ÓÐcvs£¬·ñÔò¾ÍÐèÒª´Ó°²×°¹âÅÌÖа²×°cvsµÄrpm°ü£¬»òÕßµ½
http://ww ......