1.³õ¼¶ÈëÃÅ xp sqlplus Á¬½Ó linuxÐéÄâ»ú oracle
1.Ê×ÏÈ¿´¿´ÔÚxpÏÂÊÇ·ñÄܹ»pingͨÐéÄâ»úµÄip£¨ÐéÄâ»ú²é¿´ipÃüÁifconfig£¬´ËÃüÁîÒªÇóÓÐrootȨÏÞ£¬»òÕßÓà /sbin/ifconfig).
2.ÔÚµÚÒ»²½³É¹¦µÄ»ù´¡ÉÏ£¬ÒªÅäÖÃxpÏÂoracle°²×°Ä¿Â¼ÏµÄtnsnames.oraÕâ¸öÎļþ£¨Îҵķ¾¶ÊÇ£ºD:\oracle\product\10.2.0\db_1\NETWORK\ADMIN£¬Õâ¸ö·¾¶Òò»úÆ÷¶øÒì)
Ê×ÏÈÔÚtnsnames.oraÕâ¸öÎļþÖÐÕÒµ½ÕâЩ£º
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HS-CHENGHY)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ÉϱßÊÇxpÏÂoracle×Ô¼ºµÄ¼àÌý£¬Ö»ÓÐÓÐÁËÉϱßÕ⼸ÐУ¬ÎÒÃÇÔÚxpϲſÉÒÔ˳ÀûµÄÁ¬½Óxpϰ²×°µÄoracle£¬ÆäÖÐorclÊÇ·þÎñÃû£¬ÎÒÓõÄÊÇĬÈϵġ£
ÏÂÃæ½«Ëü¸´ÖƳöÀ´£¬²¢ÇÒÔÚÉϱßÕ⼸ÐÐÎÄ×Ö°´ÀíÌí¼ÓÏÂÃæÕ⼸ÐУ¬ÆäÖÐÎÒµÄÐéÄâ»úÖÐoracleµÄ·þÎñÃû³ÆÎªora92£¬ipµØÖ·£º192.168.90.126
ora92 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.90.126)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora92)
)
)
½âÊÍһϣ¬Ö»ÓÐÉϱߵÄipµØÖ·Ð´¶ÔÁË£¬ÔÚxpÏÂsqlplus²Å¿ÉÒÔ˳ÀûµÄ°´ÕÕÕâ¸öipµØÖ·²¢ÇÒÓÃÕâ¸ö·þÎñÃûÇø±ðÄãÒªÁ¬½ÓµÄoracle·þÎñ£¬ºÇºÇ
3.ÕâÑùÃ²ËÆ¾Í¿ÉÒÔÁ¬½ÓÁË£¬Èç¹û²»ÐУ¬¾Í¼ì²éÒ»ÏÂlinux·À»ðǽÊDz»ÊǹصôÁË£¬Ë³±ã·¢´ÓÍøÉÏÌÔÁËLinuxϹرշÀ»ðǽµÄÃüÁºÇºÇ£¬·ÅÔÚϱßÁË
1) ÓÀ¾ÃÐÔÉúЧ£¬ÖØÆôºó²»»á¸´Ô
¿ªÆô£º chkconfig iptables on
¹Ø±Õ£º chkconfig iptables off
2) ¼´Ê±ÉúЧ£¬ÖØÆôºó¸´Ô
¿ªÆô£º service iptables start
¹Ø±Õ£º service iptables stop
ÐèҪ˵Ã÷µÄÊǶÔÓÚLinuxÏÂµÄÆäËü·þÎñ¶¼¿ÉÒÔÓÃÒÔÉÏÃüÁîÖ´ÐпªÆôºÍ¹Ø±Õ²Ù×÷¡£
ÔÚ¿ªÆôÁË·À»ðǽʱ£¬×öÈçÏÂÉèÖ㬿ªÆôÏà¹Ø¶Ë¿Ú£¬
ÐÞ¸Ä/etc/sysconfig/iptables Îļþ£¬Ìí¼ÓÒÔÏÂÄÚÈÝ£º
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
ÐéÄâ»úÏÂoracle µÄsqlplu
Ïà¹ØÎĵµ£º
°²×°MySQL
ºÃ£¬ÎÒÃÇ¿ÉÒÔ¿ªÊ¼ÕýʽµÄ°²×°ÁË¡£¼ÙÉèÄã°ÑËùÓбØÐëµÄÔ´Âë»òÕß°ü¶¼·ÅÔÚÁË/tmpÏ¡£Èç¹ûÄãÏÂÔØµÄÊÇRPM°üµÄ»°£¬ÄDZȽϼòµ¥£»Èç¹ûÄãÏÂÔØµÄÊǶþ½øÖưü£¨ÄãûÓÐrpm³ÌÐò»òÕßÄãÏë×Ô¶¨ÒåµÄ»°£©£¬ÄÇô»áÉÔ΢Âé·³Ò»µã¡£
RPM°ü°²×°
Äã±ØÐë³ÉΪrootÓû§²ÅÄÜʹÓÃrpm°²×°³ÌÐò£¬ÒÔÏÂÊǰ²×°¹ý³Ì£º
$ cd /tmp
$ su
# rpm -Uvh ......
¹Ø¼üÒµÎñÉ÷ÓÃlinux!
ÔÚÕâÀïÎÒÖ¸µÄ“¹Ø¼üÒµÎñ”ÊÇÖ¸ÔÚÆóÒµÖÐÌṩÖîÈçÊÕ·Ñ¡¢ÏúÊÛµÈÒµÎñ£¬ÐèÒªÌṩҪÇó¿Á¿ÌµÄ“°²È«ÐÔ”¡¢“¿É¿¿ÐÔ£¨7X24£©µÈÒªÇóµÄÒµÎñ¡£²»ÊÇå´»ú¼¸¸öСʱ¶¼ÎÞËùνµÄÒµÎñ¡£´ÓÎÒµÄÒÔÍùµÄÓ¦Óð¸ÀýÀ´¿´£¬Ê¹ÓÃlinuxÊǸö·Ç³£Ôã¸âµÄÑ¡Ôñ¡£°²È«ÐÔ£¬ÓÉÓÚ²»Äܵõ½¼°Ê±ÐÞ²¹ºÜÈÝÒ×±»ÀûÓá£Îȶ¨ ......
²ÉÓúìñµÄÆóÒµ°æ5£¬°²×°µÄʱºòÒª°Ñ±ØÒªµÄ¿ª·¢×齨ѡÔñÉÏ£¡Èçtftp£¬samba£¬ºÍnfsµÈ¡£¡£¡£¡£
°²×°VMware¶øºóÉèÖð²×°ºìñÆóÒµ°æ5£¬×îºó°²×°VMware tools£¬ÔËÓÃVMware tools¾Í¿ÉÒÔÔÚLinuxºÍwindowsÖ®¼ä¸´ÖÆÕ³ÌùÎļþ£¬ÕâÑù¿ÉÒÔÈ¡´úsamba·þÎñÆ÷µÄ¹¦ÄÜ¡£
samba·þÎñÆ÷ʹÓÃʱºò£¬ÒªÏȶ¨ÒåwmÁ¬½Ó0°ÑËü¶¨Òå³ÉÒ»¸öÖ¸¶¨µÄÍøÂçÁ¬½Ó£¬È ......
Memcache»º´æÊǸöºÃÈí¼þ£¬ÕâÀï½²ÏÂÔÚLinuxϰ²×°µÄ·½·¨£º
·þÎñÆ÷¶ËÖ÷ÒªÊǰ²×°memcache·þÎñÆ÷¶Ë£¬Ä¿Ç°µÄ×îа汾ÊÇ memcached-1.3.0 ¡£
ÏÂÔØ£ºhttp://www.danga.com/memcached/dist/memcached-1.2.2.tar.gz
ÁíÍ⣬MemcacheÓõ½ÁËlibeventÕâ¸ö¿âÓÃÓÚSocketµÄ´¦Àí£¬ËùÒÔ»¹ÐèÒª°²×°libevent£¬libeventµÄ×îа汾ÊÇlibevent ......
×òÌì·Ö±ðÊÔÓÃÁËÒ»ÏÂLinuxϺÍWindowsϵÄIPv6 Ping£¬·¢ÏÖÎÞ·¨ping Link-localµØÖ·£¬°Ù˼²»µÃÆä½â£¬ËìÉÏÍøgoogleһϣ¬ÖÕÓÚÕÒµ½ÁËÔÒò¡£
Windows XPϵÄIPv6µØÖ·£º
Ethernet adapter Test:
Connection-specific DNS Suffix . :
& ......