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µÄ²Ù×÷ÉèÖá£
²é¿´
Ïà¹ØÎĵµ£º
1. ѧ»áд¼òµ¥µÄmakefile
2. ±àһЩӦÓÃ
³ÌÐò
£¬¿ÉÒÔÓÃmakefileÅÜÆðÀ´
3. ѧ»áдÇý¶¯
µÄmakefile
4. дһ¼òµ¥charÇý¶¯£¬makefile±àÒëͨ¹ý£¬¿ÉÒÔinsmod£¬ lsmod£¬ rmmod. ÔÚÇý¶¯µÄinitº¯ÊýÀï´òÓ¡hello world£¬insmodºóÓ¦¸ÃÄܹ»Í¨¹ýdmesg¿´µ½Êä³ö
¡£
5. дһÍêÕûÇý¶¯£¬ ¼ÓÉÏread£¬ write£¬ ioctl£¬ pollingµÈ¸ ......
ʹÓÃselectº¯Êý¿ÉÒÔÒÔ·Ç×èÈûµÄ·½Ê½ºÍ¶à¸ösocketͨÐÅ¡£³ÌÐòÖ»ÊÇÑÝʾselectº¯ÊýµÄʹÓ㬹¦Äܷdz£¼òµ¥£¬¼´Ê¹Ä³¸öÁ¬½Ó¹Ø±ÕÒÔºóÒ²²»»áÐ޸ĵ±Ç°Á¬½ÓÊý£¬Á¬½ÓÊý´ïµ½×î´óÖµºó»áÖÕÖ¹³ÌÐò¡£
1. ³ÌÐòʹÓÃÁËÒ»¸öÊý×éfd_A£¬Í¨ÐÅ¿ªÊ¼ºó°ÑÐèҪͨÐŵĶà¸ösocketÃèÊö·û¶¼·ÅÈë´ËÊý×é¡£
2. Ê×ÏÈÉú³ÉÒ»¸ö½Ðsock_fdµÄsocketÃèÊö·û£¬ÓÃÓÚ¼àÌý¶Ë¿ ......
LinuxÖкǫִ́ÐÐÈÎÎñ·½Ê½:
cron
ÊÇϵͳÖ÷ÒªµÄµ÷¶È½ø³Ì£¬¿ÉÒÔÔÚÎÞÐèÈ˹¤¸ÉÔ¤µÄÇé¿öÏÂÔËÐÐ×÷Òµ¡£crontabÃüÁîÔÊÐíÓû§Ìá½»¡¢±à¼»òɾ³ýÏàÓ¦µÄ×÷Òµ¡£Ã¿Ò»¸öÓû§¶¼¿ÉÒÔÓÐÒ»¸ö
crontabÎļþÀ´±£´æµ÷¶ÈÐÅÏ¢¡£¿ÉÒÔʹÓÃËüÔËÐÐÈÎÒâÒ»¸öshell½Å±¾»òij¸öÃüÁÿСʱÔËÐÐÒ»´Î£¬»òÒ»ÖÜÈý´Î£¬ÕâÍêȫȡ¾öÓÚÄ㡣ÿһ¸öÓû§¶¼¿ÉÒÔÓÐ
......
Ò»¡¢CVS·þÎñÆ÷µÄ°²×°
Ê×ÏÈÈ·ÈÏϵͳÖÐÊÇ·ñ°²×°CVS·þÎñ£º
[root@localhost /]# rpm -qa|grep cvs
cvs-1.11.17-7.RHEL4
Èç¹ûÃüÁîÊä³öÀàËÆÓÚÉÏÃæµÄÊä³öÔò˵Ã÷ϵͳÒѾ°²×°ÓÐcvs£¬·ñÔò¾ÍÐèÒª´Ó°²×°¹âÅÌÖа²×°cvsµÄrpm°ü£¬»òÕßµ½
http://ww ......
1.¹Ø±ÕÓ뿪ÆôÍøÂ·¶Ë¿Ú£º
¿ªÆô81¶Ë¿Ú£º
iptables -I INPUT -i eth0 -p tcp --dport 81 -j ACCEPT
iptables -I OUTPUT -o eth0 -p tcp --sport 81 -j ACCEPT
¹Ø±Õ81¶Ë¿Ú£º
iptables -I INPUT -i eth0 -p tcp --dport 81 -j DROP
iptables -I OUTPUT -o eth0 -p tcp --sport 81 -j DROP
2.¹Ø±ÕºÍ¿ªÆôÎïÀí¶Ë¿Ú
UP ......