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Êý¾Ý¿âµÄЧÀÍÃûÔõô¿´µÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡