¶ÔÓÚUnixϵÁеIJÙ×÷ϵͳ£¬´ó¶à¶¼ÓÐv½Úµã¡£µ«ÊǶÔÓÚlinuxÀ´Ëµ£¬Ö»ÓÐͨÓõÄi½Úµã£¬È´Ã»ÓÐv½Úµã¡£
ÏÂÃæÀ´Ì½ÌÖһϣ¬linuxϵÄi½Úµã¡£
linuxÖУ¬Îļþ²éÕÒ²»ÊÇͨ¹ýÎļþÃû³ÆÀ´²éÕҵġ£Êµ¼ÊÉÏÊÇͨ¹ýi½ÚµãÀ´ÊµÏÖÎļþµÄ²éÕÒ¶¨Î»µÄ¡£ÎÒÃÇ¿ÉÒÔÐÎÏóµÄ½«i½Úµã¿´×öÊÇÒ»¸öÖ¸Õëfip¡£µ±Îļþ´æ´¢µ½´ÅÅÌÉÏÈ¥µÄʱºò£¬Îļþ¿Ï¶¨»á´æ·Åµ½Ò»¸ö´ÅÅÌλÖÃÉÏ£¬¿ÉÒÔÕâÑùÏëÏ󣬼ÈÈ»ÎļþÊý¾ÝÊÇ´æ·ÅÔÚ´ÅÅÌÉϵģ¬Èç¹ûÎÒÃÇÖªµÀÕâ¸öÎļþÊý¾ÝµÄµØÖ·£¬µ±ÎÒÃÇÏëÒª¶ÁдÎļþµÄʱºò£¬ÎÒÃÇÊDz»ÊÇÖ±½ÓʹÓÃÕâ¸öµØÖ·È¥ÕÒµ½Îļþ¾Í¿ÉÒÔÁËÄØ£¿
Êǵģ¬linuxÏ£¬i½ÚµãÆäʵ¾ÍÊÇ¿ÉÒÔÕâôÈÏΪ£¬°Ñi½Úµã¿´×÷ÊÇÒ»¸öÖ¸Ïò´ÅÅÌÉϸÃÎļþ´æ´¢ÇøµÄµØÖ·¡£Ö»²»¹ýÕâ¸öµØÖ·ÎÒÃÇÒ»°ãÊÇû°ì·¨Ö±½ÓʹÓõ쬶øÊÇͨ¹ýÎļþÃûÀ´¼ä½ÓʹÓõġ£ÊÂʵÉÏ£¬i½Úµã²»½ö°üº¬ÁËÎļþÊý¾Ý´æ´¢ÇøµÄµØÖ·£¬»¹°üº¬Á˺ܶàÐÅÏ¢£¬±ÈÈçÊý¾Ý´óС£¬µÈµÈÎļþÐÅÏ¢¡£µ«ÊÇi½ÚµãÊDz»±£´æÎļþÃûµÄ¡£ÎļþÃûÊDZ£´æÔÚÒ»¸öĿ¼ÏîÖС£Ã¿Ò»¸öĿ¼ÏîÖж¼°üº¬ÁËÎļþÃûºÍi½Úµã¡£
ÎÒÃÇ¿ÉÒÔͨ¹ýÒ»¸öͼÀ´¿´¿´Ä¿Â¼Ïi½Úµã£¬Îļþ ......
config.h
/*--
Copyright (c) 2004 Shenzhen Huaren Education Co.Ltd
File Name:
config.h
Version:
2.0
Abstract:
declarations/definitions for reading configuration file.
Author:
Gang He
Created on:
2003-12-23
Modified History:
2004-09-02
Modified Person:
--*/
#ifndef _HEGANG_CONFIG_H_
#define _HEGANG_CONFIG_H_
#ifd ......
1.Ê×ÏÈÒªÖªµÀʲôÊÇORACLEµÄ¿Í»§¶Ë£º
Oracle Instant client ÊÇoracleÌṩµÄ¼ò±ã¿Í»§¶Ë, Ö§³Ö¶àÖÖÆ½Ì¨. ¿É´ÓoracleÍøÕ¾ÏÂÔØ, ÏÂÔØµØÖ·Îª
http://www.oracle.com/technology/tech/oci/instantclient/index.html
ÕâʱÄã°´¸ölibaioµÄ¿â¾Í¿ÉÒÔÁË¡£
2. [root@localhost sdk]# ./occidml
./occidml: error while loading shared libraries: /usr/lib/oracle/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied
Õâ¸öÎÊÌâ¿É¾ÍÂé·³ÁË£¬Ò»¿ªÊ¼²»¶®£¬³¢ÊÔÏÈÉú³É.oÎļþ£¬ÔÙÁ¬½Ó³É¿ÉÖ´ÐÐÎļþ£¬¿É»¹ÊDz»ÐС£
ÔÀ´ÊÇSElinuxµÄÊ£º
[root@localhost sdk]# chcon -t texerl_shlib_t/usr/lib/oracle/lib/libnnz11.so
chcon: too few arguments
Çë³¢ÊÔÖ´ÐГchcon --help”À´»ñÈ¡¸ü¶àÐÅÏ¢¡£
»¹ÊDz»ÐУ¬²»¶®chconÊǸÉÂïµÄ£¬ÉÏÍø¿´×îºóÖªµÀ
½â¾ö°ì·¨£º
chcon /usr/lib/oracle/lib/libnnz11.so -t shlib_t
ÔÒòÊÇLinuxÓÐÒ»¸öSELinux±£»¤Ä£Ê½ÒýÆðµÄ¡£
¹Ø±ÕSELINUXµÄ·½·¨:
vi /etc/selinux/config ½«SELINUX=enforcing ¸Ä³ÉSELINUX=disabled
±£´æ,ÖØÆðµçÄÔ¼´¿É.
FC5 ÖеÄSELinux ´ú±íÁËÓû§£¬³ÌÐòÒÔ¼°½ø³Ì¼äÏ໥½»Á÷µÄÖ÷Òª±ä»¯¡£
×îºóÔËÐл¹ ......
1.Ê×ÏÈÒªÖªµÀʲôÊÇORACLEµÄ¿Í»§¶Ë£º
Oracle Instant client ÊÇoracleÌṩµÄ¼ò±ã¿Í»§¶Ë, Ö§³Ö¶àÖÖÆ½Ì¨. ¿É´ÓoracleÍøÕ¾ÏÂÔØ, ÏÂÔØµØÖ·Îª
http://www.oracle.com/technology/tech/oci/instantclient/index.html
ÕâʱÄã°´¸ölibaioµÄ¿â¾Í¿ÉÒÔÁË¡£
2. [root@localhost sdk]# ./occidml
./occidml: error while loading shared libraries: /usr/lib/oracle/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied
Õâ¸öÎÊÌâ¿É¾ÍÂé·³ÁË£¬Ò»¿ªÊ¼²»¶®£¬³¢ÊÔÏÈÉú³É.oÎļþ£¬ÔÙÁ¬½Ó³É¿ÉÖ´ÐÐÎļþ£¬¿É»¹ÊDz»ÐС£
ÔÀ´ÊÇSElinuxµÄÊ£º
[root@localhost sdk]# chcon -t texerl_shlib_t/usr/lib/oracle/lib/libnnz11.so
chcon: too few arguments
Çë³¢ÊÔÖ´ÐГchcon --help”À´»ñÈ¡¸ü¶àÐÅÏ¢¡£
»¹ÊDz»ÐУ¬²»¶®chconÊǸÉÂïµÄ£¬ÉÏÍø¿´×îºóÖªµÀ
½â¾ö°ì·¨£º
chcon /usr/lib/oracle/lib/libnnz11.so -t shlib_t
ÔÒòÊÇLinuxÓÐÒ»¸öSELinux±£»¤Ä£Ê½ÒýÆðµÄ¡£
¹Ø±ÕSELINUXµÄ·½·¨:
vi /etc/selinux/config ½«SELINUX=enforcing ¸Ä³ÉSELINUX=disabled
±£´æ,ÖØÆðµçÄÔ¼´¿É.
FC5 ÖеÄSELinux ´ú±íÁËÓû§£¬³ÌÐòÒÔ¼°½ø³Ì¼äÏ໥½»Á÷µÄÖ÷Òª±ä»¯¡£
×îºóÔËÐл¹ ......
Õâ½éÉܵÄLinuxË«Íø¿¨°ó¶¨ÊµÏÖ¾ÍÊÇʹÓÃÁ½¿éÍø¿¨ÐéÄâ³ÉΪһ¿éÍø¿¨£¬Õâ¸ö¾ÛºÏÆðÀ´µÄÉ豸¿´ÆðÀ´ÊÇÒ»¸öµ¥¶ÀµÄÒÔÌ«Íø½Ó¿ÚÉ豸£¬Í¨Ë׵㽲¾ÍÊÇÁ½¿éÍø¿¨¾ßÓÐÏàͬµÄIPµØÖ·¶ø²¢ÐÐÁ´½Ó¾ÛºÏ³ÉÒ»¸öÂß¼Á´Â·¹¤×÷¡£ÆäʵÕâÏî¼¼ÊõÔÚSunºÍCiscoÖÐÔçÒÑ´æÔÚ£¬±»³ÆÎªTrunkingºÍEtherchannel ¼¼Êõ£¬ÔÚLinuxµÄ2.4.xµÄÄÚºËÖоͲÉÓÃÁËÕâÖÖ¼¼Êõ£¬±»³ÆÎªbonding¡£bonding¼¼ÊõµÄ×îÔçÓ¦ÓÃÊÇÔÚ¼¯Èº——beowulfÉÏ£¬ÎªÁËÌá¸ß ¼¯Èº½Úµã¼äµÄÊý¾Ý´«Êä¶øÉè¼ÆµÄ¡£ÏÂÃæÎÒÃÇÌÖÂÛÒ»ÏÂbonding µÄÔÀí,ʲôÊÇbondingÐèÒª´ÓÍø¿¨µÄ»ìÔÓ(promisc)ģʽ˵Æð¡£ÎÒÃÇÖªµÀ£¬ÔÚÕý³£Çé¿öÏ£¬Íø¿¨Ö»½ÓÊÕÄ¿µÄÓ²¼þµØÖ·(MAC Address)ÊÇ×ÔÉíMacµÄÒÔÌ«ÍøÖ¡£¬¶ÔÓÚ±ðµÄÊý¾ÝÖ¡¶¼Â˵ô£¬ÒÔ¼õÇáÇý¶¯³ÌÐòµÄ¸ºµ£¡£µ«ÊÇÍø¿¨Ò²Ö§³ÖÁíÍâÒ»ÖÖ±»³ÆÎª»ìÔÓpromiscµÄģʽ£¬¿ÉÒÔ½Ó ÊÕÍøÂçÉÏËùÓеÄÖ¡£¬±ÈÈç˵tcpdump£¬¾ÍÊÇÔËÐÐÔÚÕâ¸öģʽÏ¡£bondingÒ²ÔËÐÐÔÚÕâ¸öģʽÏ£¬¶øÇÒÐÞ¸ÄÁËÇý¶¯³ÌÐòÖеÄmacµØÖ·£¬½«Á½¿éÍø¿¨µÄ MacµØÖ·¸Ä³ÉÏàͬ£¬¿ÉÒÔ½ÓÊÕÌØ¶¨macµÄÊý¾ÝÖ¡¡£È»ºó°ÑÏàÓ¦µÄÊý¾ÝÖ¡´«Ë͸øbondÇý¶¯³ÌÐò´¦Àí¡£ ÆäʵÔÚ linux ½«Ë«Íø¿¨°ó¶¨³ÉÒ»¿éÍø¿¨£¬ÅäÖÃÆðÀ´·Ç³£¼òµ¥£¬Ö»ÐèÒª¼òµ¥¼¸¸ö²½Öè¼´¿ÉʵÏÖ£¬ÏÂÃæÎÒÃǾÍÒ»ÆðÀ´ÌåÑéһϰɡ£Ê×ÏÈ£¬»¹Êǽ«±¾´Îʵ ......
fg¡¢bg¡¢jobs¡¢&¡¢ctrl + z¶¼ÊǸúϵͳÈÎÎñÓйصģ¬ËäÈ»ÏÖÔÚ»ù±¾Éϲ»ÔõôÐèÒªÓõ½ÕâЩÃüÁµ«Ñ§»áÁËÒ²ÊǺÜʵÓõÄ
Ò»¡£& ×î¾³£±»Óõ½
Õâ¸öÓÃÔÚÒ»¸öÃüÁîµÄ×îºó£¬¿ÉÒÔ°ÑÕâ¸öÃüÁî·Åµ½ºǫִ́ÐÐ
¶þ¡£ctrl + z
¿ÉÒÔ½«Ò»¸öÕýÔÚǰִ̨ÐеÄÃüÁî·Åµ½ºǫ́£¬²¢ÇÒÔÝÍ£
Èý¡£jobs
²é¿´µ±Ç°ÓжàÉÙÔÚºǫ́ÔËÐеÄÃüÁî
ËÄ¡£fg
½«ºǫ́ÖеÄÃüÁîµ÷ÖÁǰ̨¼ÌÐøÔËÐÐ
Èç¹ûºǫ́ÖÐÓжà¸öÃüÁ¿ÉÒÔÓà fg %jobnumber½«Ñ¡ÖеÄÃüÁîµ÷³ö£¬%jobnumberÊÇͨ¹ýjobsÃüÁî²éµ½µÄºǫ́ÕýÔÚÖ´ÐеÄÃüÁîµÄÐòºÅ(²»ÊÇpid)
Îå¡£bg
½«Ò»¸öÔÚºǫ́ÔÝÍ£µÄÃüÁ±ä³É¼ÌÐøÖ´ÐÐ
Èç¹ûºǫ́ÖÐÓжà¸öÃüÁ¿ÉÒÔÓÃbg %jobnumber½«Ñ¡ÖеÄÃüÁîµ÷³ö£¬%jobnumberÊÇͨ¹ýjobsÃüÁî²éµ½µÄºǫ́ÕýÔÚÖ´ÐеÄÃüÁîµÄÐòºÅ(²»ÊÇpid) LinuxÏÂʹÓÃShellÃüÁî¿ØÖÆÈÎÎñJobsÖ´ÐÐ ÏÂÁÐÃüÁî¿ÉÒÔÓÃÀ´²Ù×ݽø³ÌÈÎÎñ£º
ps ÁгöϵͳÖÐÕýÔÚÔËÐеĽø³Ì£»
kill ·¢ËÍÐźŸøÒ»¸ö»ò¶à¸ö½ø³Ì£¨¾³£ÓÃÀ´É±ËÀÒ»¸ö½ø³Ì£©£»
jobs Áгöµ±Ç°shell»·¾³ÖÐÒÑÆô¶¯µÄÈÎÎñ״̬£¬Èôδָ¶¨jobsid£¬ÔòÏÔʾËùÓлµÄÈÎÎñ״̬ÐÅÏ¢£»Èç¹û±¨¸æÁËÒ»¸öÈÎÎñµÄÖÕÖ¹(¼´ÈÎÎñµÄ״̬±»±ê¼ÇΪTerminated)£¬shell ´Óµ±Ç°µÄshell ......
Êý¾Ý¿â¿ª·¢¹ý³ÌÖУ¬µ±Äã¼ìË÷µÄÊý¾ÝÖ»ÊÇÒ»Ìõ¼Ç¼ʱ£¬ÄãËù±àдµÄÊÂÎñÓï¾ä´úÂëÍùÍùʹÓÃSELECT INSERT Óï¾ä¡£µ«ÊÇÎÒÃdz£³£»áÓöµ½ÕâÑùÇé¿ö£¬¼´´Óijһ½á¹û¼¯ÖÐÖðÒ»µØ¶ÁȡһÌõ¼Ç¼¡£ÄÇôÈçºÎ½â¾öÕâÖÖÎÊÌâÄØ£¿ÓαêΪÎÒÃÇÌṩÁËÒ»ÖÖ¼«ÎªÓÅÐãµÄ½â¾ö·½°¸¡£
1.1 ÓαêºÍÓαêµÄÓŵã
ÔÚÊý¾Ý¿âÖУ¬ÓαêÊÇÒ»¸öÊ®·ÖÖØÒªµÄ¸ÅÄî¡£ÓαêÌṩÁËÒ»ÖÖ¶Ô´Ó±íÖмìË÷³öµÄÊý¾Ý½øÐвÙ×÷µÄÁé»îÊֶΣ¬¾Í±¾ÖʶøÑÔ£¬Óαêʵ¼ÊÉÏÊÇÒ»ÖÖÄÜ´Ó°üÀ¨¶àÌõÊý¾Ý¼Ç¼µÄ½á¹û¼¯ÖÐÿ´ÎÌáȡһÌõ¼Ç¼µÄ»úÖÆ¡£Óαê×ÜÊÇÓëÒ»ÌõT_SQL Ñ¡ÔñÓï¾äÏà¹ØÁªÒòΪÓαêÓɽá¹û¼¯£¨¿ÉÒÔÊÇÁãÌõ¡¢Ò»Ìõ»òÓÉÏà¹ØµÄÑ¡ÔñÓï¾ä¼ìË÷³öµÄ¶àÌõ¼Ç¼£©ºÍ½á¹û¼¯ÖÐÖ¸ÏòÌØ¶¨¼Ç¼µÄÓαêλÖÃ×é³É¡£µ±¾ö¶¨¶Ô½á¹û¼¯½øÐд¦Àíʱ£¬±ØÐëÉùÃ÷Ò»¸öÖ¸Ïò¸Ã½á¹û¼¯µÄÓαꡣ
ÎÒÃÇÖªµÀ¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳʵÖÊÊÇÃæÏò¼¯ºÏµÄ£¬ÔÚMS SQL SERVER Öв¢Ã»ÓÐÒ»ÖÖÃèÊö±íÖе¥Ò»¼Ç¼µÄ±í´ïÐÎʽ£¬³ý·ÇʹÓÃwhere ×Ó¾äÀ´ÏÞÖÆÖ»ÓÐÒ»Ìõ¼Ç¼±»Ñ¡ÖС£Òò´ËÎÒÃDZØÐë½èÖúÓÚÓαêÀ´½øÐÐÃæÏòµ¥Ìõ¼Ç¼µÄÊý¾Ý´¦Àí¡£
Óɴ˿ɼû£¬ÓαêÔÊÐíÓ¦ÓóÌÐò¶Ô²éѯÓï¾äselect ·µ»ØµÄÐн ......