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»ÊÇÒªÔÙÅäÖÃÒ»¸ö£¬Ñ¡Ôñ·ñ¡£È»ºó»áÌáʾÄãÅäÖÃÍê±Ï¡£È»ºóÍê³É
¾Í¿ÉÒÔÁË¡£
Ïà¹ØÎĵµ£º
oracleÊý¾Ý¿âÖÐÐÞ¸ÄÊý¾ÝʱÌáʾ“¼Ç¼±»ÁíÒ»¸öÓû§Ëøס” ½â¾ö·½·¨£º
1>²é¿´Êý¾Ý¿âËø,Õï¶ÏËøµÄÀ´Ô´¼°ÀàÐÍ£º
¡¡¡¡select object_id,session_id,locked_mode from v$locked_object;
»òÕßÓÃÒÔÏÂÃüÁ
select b.owner,b.object_name,l.ses ......
Linux ƽ̨ÏÂOracle Silent Installations(¾²Ä¬°²×°)£¬Ò»Ö±¶¼Ã»Óг¢ÊÔ¹ýÓÃÕâÖÖ·½·¨À´×°Êý¾Ý¿â¡£ ÒòΪÓи߼¶µÄ¹¤¾ß£¬¾ÍûÓбØÒªÔÚÀ´ÓÃÕâÖÖ·½·¨ÁË£¬Oracle µÄ½çÃ滹ÊDZȽϷ½±ã£¬¶øÇÒÎÒÃÇ»¹ÓÐXmanager ¹¤¾ß£¬ËùÒÔÔÚlinux ÏÂ×°Èí¼þ£¬»¹ÊǺܷ½±ãµÄ¡£
Òò´ËÒ²¾ÍûÓÐÌ«ÔÚÒâÕ ......
·½°¸Ò»£º
ÐÂ×°ÁËϵͳºó£¬·¢ÏÖÔÚµ÷ÊÔ³ÌÐòʱTOMCATÌáʾ8080¶Ë¿ÚÒѱ»Õ¼Óã¬ÓÚÊÇÔËÐÐNETSTAT -ANO²é¿´¶Ë¿ÚʹÓÃÇé¿ö£¬·¢ÏÖ8080¶Ë¿Ú±»ORACLEµÄ¼àÌýÆ÷¸øÕ¼ÓÃÁË£¬ÓÚÊǽáºÏÉÏÍø²éµ½·½·¨£¬½«ORACLE XDBµÄHTTP·þÎñ¶Ë¿Ú¸Ä³É8081£¬ÎÊÌâ½â¾ö¡£
×ܽáһϿɽâ¾öµÄ·½·¨£º
Ò»¡¢¸ü¸ÄTOMCATµÄĬÈ϶˿Ú
Ïà¹ØÎļþ£º"TOMCAT ROOT"\conf\server ......
create or replace procedure inserttestdata
(
v_count in number,
v_startuserid in varchar2,
v_returnval out number )
as
v_opertime   ......
Èí¼þ»·¾³£º
1¡¢Windows 2000+ORACLE 8.1.7
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORACLE
ʵÏÖ·½·¨£º
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle Installation Products££¾ Universal Installer жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí ......