instance_name,ORACLE_SID和service_name之間的關係

db_name - 當你執行“create database”命令時被建立，可以從v$database視圖中查詢。

SQL> CREATE DATABASE mysid DATAFILE SIZE 400M<br />2> DEFAULT TEMPORARY TABLESPACE temp_ts<br />3> TEMPFILE SIZE 10M<br />4> UNDO TABLESPACE undo_ts DATAFILE SIZE 10M;</p><p>select<br /> name,<br /> value<br />from<br /> v$parameter<br />where<br /> name = 'db_name';</p><p>NAME VALUE<br />------- ----------------------------------------------<br />db_name mysid</p><p>

 

instance_name - 在init.ora檔案中

init.ora<br />INSTANCE_NAME=mysid</p><p>select<br /> instance_number,<br /> instance_name,<br /> host_name<br />from<br /> v$instance</p><p>INSTANCE_NUMBER INSTANCE_NAME HOST_NAME<br />--------------- ---------------- ----------------------1 mysid MYSERVER</p><p>

 

service_name - 在tnsnames.ora檔案中，允許你把一個執行個體註冊到監聽器。

mysid=<br /> (DESCRIPTION =<br /> (ADDRESS =<br /> (PROTOCOL = TCP)<br /> (HOST = myserver)<br /> (PORT = 1521))<br /> )<br /> (CONNECT_DATA =<br /> (SERVICE_NAME = mysid)<br /> )<br />)<br />

 

sid_name - 在listener.ora檔案中

SID_LIST_LISTENER =<br /> (SID_LIST =<br /> (SID_DESC =<br /> (SID_NAME = mysid)<br /> (ORACLE_HOME = /u01/app/oracle)<br /> )<br /> (SID_DESC =<br /> (GLOBAL_DBNAME = remote.dba.net)<br /> (ORACLE_HOME =/u01/app/oracle/product/10.1.2)<br /> (SID_NAME = mysid)<br /> )<br /> )<br />)<br />