SERVICE_NAME / SID

Difference Between SERVICE_NAME / SID

SERVICE_NAME

Purpose

Use the parameter SERVICE_NAME to identify the Oracle9i or Oracle8i database service to access. Set the value to a value specified by the SERVICE_NAMES parameter in the initialization parameter file.


SID
Purpose

Use the parameter SID to identify the Oracle8 database instance by its Oracle System Identifier (SID). If the database is Oracle9i or Oracle8i, use the SERVICE_NAME parameter rather than the SID parameter.


Note:

1.SERVICE_NAME is equal to SID (SERVICE_NAME = SID)
2.DB_NAME is NOT equal to SID/SERVICE_NAME (SID/SERVICE_NAME <> DB_NAME)

If the database is Oracle9i or Oracle8i, use the SERVICE_NAME parameter rather than the SID parameter.

DATABASE NAME

SQL> select NAME from v$database;

NAME
---------
DBORCL



INSTANCE_NAME

SQL> select INSTANCE_NAME from v$instance;

INSTANCE_NAME
----------------
sidorcl


TNS_ENTRY


TNSORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.64)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sidorcl)
)
)