×ðÁú¿­Ê±¹ÙÍøµÇ¼

oracleÊý¾Ý¿âµÄЧÀÍÃûÔõô¿´

ÔõÑùÉó²é oracle Êý¾Ý¿âµÄЧÀÍÃû £¿Ê¹Óà sql*plus ÅÌÎÊ v$instance ±í¡£ÔÚ oracle enterprise manager ÔÆ¿ØÖÆ̨µÄÊý¾Ý¿âÏêϸÐÅÏ¢Ò³ÃæÖÐÉó²é¡£ÔÚ tnsnames.ora ÎļþÖÐËÑË÷Êý¾Ý¿âÓÖÃûµÄ “service_name” ²ÎÊý¡£

ÔõÑùÉó²é Oracle Êý¾Ý¿âµÄЧÀÍÃû

ÒªÉó²é Oracle Êý¾Ý¿âµÄЧÀÍÃû£¬¿ÉÒÔͨ¹ýÒÔÏÂÒªÁ죺

ʹÓà SQL*Plus ÅÌÎÊ£º

·­¿ª SQL*Plus ²¢ÅþÁ¬µ½Êý¾Ý¿â£º

sqlplus scott/tiger

µÇ¼ºó¸´ÖÆ

ÔËÐÐÒÔÏÂÅÌÎÊ£º

select name from v$instance;

µÇ¼ºó¸´ÖÆ

ЧÀÍÃû½«ÏÔʾÔÚÅÌÎÊЧ¹ûÖС£

ʹÓà Oracle Enterprise Manager ÔÆ¿ØÖÆ̨£º

µÇ¼µ½ Oracle Enterprise Manager ÔÆ¿ØÖÆ̨¡£

Ñ¡Ôñ¡°Êý¾Ý¿â¡±¡£

Ñ¡ÕªÒªÉó²éÆäЧÀÍÃûµÄÊý¾Ý¿â¡£

ÔÚÊý¾Ý¿âÏêϸÐÅÏ¢Ò³ÃæÖУ¬Ð§ÀÍÃû½«ÏÔʾÔÚ¡°»ù±¾ÐÅÏ¢¡±²¿·Ö¡£

ʹÓà tnsnames.ora Îļþ£º

¹ØÓÚÔçÆÚ°æ±¾µÄ Oracle Êý¾Ý¿â£¬Äú¿ÉÒÔÔÚ tnsnames.ora ÎļþÖÐÕÒµ½Ð§ÀÍÃû¡£´ËÎļþͨ³£Î»ÓÚÒÔÏÂλÖãº

Windows£º%ORACLE_HOME%\network\admin\tnsnames.ora

Linux/Unix£º$ORACLE_HOME/network/admin/tnsnames.ora

·­¿ª tnsnames.ora Îļþ²¢ËÑË÷ÄúµÄÊý¾Ý¿âÓÖÃû¡£Ð§ÀÍÃû½«Ö¸¶¨ÔÚÓÖÃûµÄ “service_name” ²ÎÊýÖС£

ÒÔÉϾÍÊÇoracleÊý¾Ý¿âµÄЧÀÍÃûÔõô¿´µÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡

ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí£¬°æȨÕùÒéÓë±¾Õ¾Î޹أ¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í×ðÁú¿­Ê±¹ÙÍøµÇ¼ÂËÓÍ»úÍø¹Ù·½Ì¬¶È£¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ£¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢£¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢£¬ÇëÄúÁ¬Ã¦ÁªÏµ×ðÁú¿­Ê±¹ÙÍøµÇ¼ʵʱÐÞÕý»òɾ³ý¡£

Ïà¹ØÐÂÎÅ

ÁªÏµ×ðÁú¿­Ê±¹ÙÍøµÇ¼

18523999891

¿É΢ÐÅÔÚÏß×Éѯ

ÊÂÇéʱ¼ä£ºÖÜÒ»ÖÁÖÜÎ壬9:30-18:30£¬½ÚãåÈÕÐÝÏ¢

QR code
ÍøÕ¾µØͼ