11/12: Oracle > service / instance name & SID
Category: Oracle
Posted by: hajime osako
%u30C7%u30FC%u30BF%u30D9%u30FC%u30B9%u3092%u7279%u5B9A%u3059%u308B%u540D%u524D - %u30AA%u30E9%u30AF%u30EB%u30FBOracle%u3092%u30DE%u30B9%u30BF%u30FC%u3059%u308B%u305F%u3081%u306E%u57FA%u672C%u3068%u4ED5%u7D44%u307F
DBID (Database Identifer)
SELECT DBID,NAME,DB_UNIQUE_NAME,CURRENT_SCN,LOG_MODE FROM V$DATABASE;
SID (System Identifer)
Used in the host server to access shared memory.
Set in environment variables
INSTANCE_NAME
Used from outside of the host.
show parameter instance_name
DB_NAME
show parameter db_name
GLOBAL_NAME
Used to create DATABASE LINK
SERVICE_NAME
Used by LISTENER / TNSNAMES
show parameter service_name
DBID (Database Identifer)
SELECT DBID,NAME,DB_UNIQUE_NAME,CURRENT_SCN,LOG_MODE FROM V$DATABASE;
SID (System Identifer)
Used in the host server to access shared memory.
Set in environment variables
INSTANCE_NAME
Used from outside of the host.
show parameter instance_name
DB_NAME
show parameter db_name
GLOBAL_NAME
Used to create DATABASE LINK
SERVICE_NAME
Used by LISTENER / TNSNAMES
show parameter service_name