OracleÅäÖñ¾µØNet·þÎñÃû
Ò».ÅäÖñ¾µØNet·þÎñÃûÊǸÉʲôÓõģ¿
Èç¹ûҪͨ¹ýÍøÂç·ÃÎÊOracleÊý¾Ý¿â»òÆäËû·þÎñ£¬¾Í»áÓõ½Net·þÎñÃû¡£Oracle Net
Configuration AssistantÔÊÐíʹÓÃÓɱ¾µØÃüÃû½âÎöµÄÍøÂç·þÎñÃû¡£
¶þ.ÔõÑùÅäÖñ¾µØNet·þÎñÃû£¿
1.´ò¿ª->³ÌÐò/Oracle - OraClient10g_home1/ÅäÖúÍÒÆÖ²¹¤¾ß/Net
Configuration Assistant´ò¿ªNet Configuration Assistant¡£
2.Ñ¡Ôñ->±¾µØNet·þÎñÃûÅäÖã¬È»ºóÎҾͿÉÒÔ±à¼Net·þÎñÃû£¬ÕâÀïÎÒÃÇÊÇ´´½¨£¬
Ñ¡Ôñ“Ìí¼Ó”£¬
È»ºóÏÂÒ»²½¡£
3.ÊäÈëOracle·þÎñÃû£¬Êý¾ÝµÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃû£¬¼ÓÈëÓøöÊý¾Ý¿âÃû½ÐSJZX
£¨Ã¿¸öOracleÊý¾Ý¿â»ò·þÎñ¶¼ÓÐÒ»¸ö·þÎñÃû£¬OracleÊý¾Ý¿âµÄ·þÎñÃûͨ³£ÊÇÈ«¾Ö
Êý¾Ý¿âÃû£©¡£
4.ͨ¹ýÍøÂçÓëÊý¾Ý¿âͨÐÅÐèҪʹÓÃÍøÂçÐÒ顣ѡÔñÓÃÓÚ·ÃÎʵÄÊý¾Ý¿âÍøÂçÐÒ飬
ÓÐTCP,TCPS,IPC,NMP,ÕâÀïÎÒÃÇÓõÄÊÇTCP¡£
5.ҪʹÓÃTCP/IPÐÒéÓëÊý¾Ý¿âͨÐÅ£¬±ØÐëʹÓÃÊý¾Ý¿â¼ÆËã»ú£¨OracleÊý¾Ý¿âµÄ·þ
ÎñÆ÷¶Ë°²×°µÄ»úÆ÷£©µÄÖ÷»úÃû£¬ÊäÈëÀýÈ磺10.148.36.51£¬»¹ÐèÒªÒ»¸öTCP/IPµÄ
¶Ë¿ÚºÅ£¬ÓÐOracleµÄ±ê×¼¶Ë¿ÚºÍ×Ô¼ºÑ¡ÔñµÄ¶Ë¿Ú£¬´ó¶àÊýÇé¿öÏÂӦʹÓñê×¼¶Ë¿Ú
ºÅ¡£
6.ͨ¹ýÖ´ÐÐÁ¬½Ó²âÊÔ²¢Ê¹ÓÃÌṩµÄÊý¾Ý£¬¼à²âÊÇ·ñÁ¬½Óµ½OracleÊý¾Ý¿â¡£Ò»°ãÑ¡
Ôñ->ÊÇ£¬½øÐвâÊÔ¡£
7.¿ÉÄÜ»áʧ°Ü£¬ÔÒò×îÓпÉÄÜÊǵǼµÄÓû§Ãû£¬ºÍÃÜÂë²»¶à£¬Ä¬ÈϵÄÓû§ÃûÊÇ
SYSTEM£¬ÃÜÂëÊÇÄãÔÚ°²×°Êý¾Ý¿âµÄʱºòµÄÃÜÂ룬¶øÄãÔÚÓÃSJZXµÄÊý¾Ý¿âʱºò¿ÉÄÜ
ÃÜÂ룬ÒѾ¸Ä¹ýÁË£¬Õâ¾ÍÐèÒªÊÇÄã¸Ä¹ýµÄÃÜÂë¡£
8.ÒÔÉϲÙ×÷³É¹¦µÄ½¨Á¢ÁËÒ»¸öNet·þÎñÃû£¬´Ëʱ£¬Òª×öµÄÊÇΪÕâ¸ö·þÎñÃûÔÙÈ¡¸öÃû
×Ö£¬Ò»°ãÓÃĬÈÏÊÇÇ°ÃæµÄ·þÎñÆ÷Ãû¡£Ò²¿ÉÒԸijÉ×Ô¼ºÏëÒª¸ÄµÄÃû×Ö¡£Õâ¸öÃû×ÖËæ
±ãÈ¡¡£
9.È»ºó»áÎÊÄãÊDz»ÊÇÒªÔÙÅäÖÃÒ»¸ö£¬Ñ¡Ôñ·ñ¡£È»ºó»áÌáʾÄãÅäÖÃÍê±Ï¡£È»ºóÍê³É
¾Í¿ÉÒÔÁË¡£
Ïà¹ØÎĵµ£º
CREATE PUBLIC DATABASE LINK ASXT_LINK ;
CONNECT TO ASXT IDENTIFIED BY PASSWORD ;
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = AAA)))'; ......
¾ÍÊÇÔÚÒÑÓеÄÊý¾Ý¿âʵÀýÉÏ´´½¨Ò»¸öеÄÕʺţ¬·ÃÎÊһЩеıí
²Ù×÷²½ÖèÈçÏ£º
1¡¢µÇ¼linux£¬ÒÔoracleÓû§µÇ¼£¨Èç¹ûÊÇrootÓû§µÇ¼µÄ£¬µÇ¼ºóÓà su - oracleÃüÁîÇл»³ÉoracleÓû§£©
2¡¢ÒÔsysdba·½Ê½À´´ò¿ªsqlplus£¬ÃüÁîÈçÏ£º sqlplus "/as sysdba"
3¡¢²é¿´ÎÒÃdz£¹æ½«Óû§±í¿Õ¼ä·ÅÖÃλÖà ......
Oracle RAC ͬʱ¾ß±¸HA(High Availiablity) ºÍLB(LoadBalance). ¶øÆä¸ß¿ÉÓÃÐԵĻù´¡¾ÍÊÇFailover(¹ÊÕÏ×ªÒÆ). ËüÖ¸¼¯ÈºÖÐÈκÎÒ»¸ö½ÚµãµÄ¹ÊÕ϶¼²»»áÓ°ÏìÓû§µÄʹÓã¬Á¬½Óµ½¹ÊÕϽڵãµÄÓû§»á±»×Ô¶¯×ªÒƵ½½¡¿µ½Úµã£¬´ÓÓû§¸ÐÊܶøÑÔ£¬ ÊǸоõ²»µ½ÕâÖÖÇл»¡£
Oracle&nbs ......
Èí¼þ»·¾³£º
1¡¢Windows 2000+ORACLE 8.1.7
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORACLE
ʵÏÖ·½·¨£º
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle Installation Products££¾ Universal Installer жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí ......
[×ÊÁÏÀ´×ÔÓÚORACLEƵµÀ http://oracle.chinaitlab.com/induction/398193.html]
¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
¡¡¡¡ÀýÈç:
¡¡¡¡SELECT /*+ALL_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='SCOTT';
¡¡¡ ......