Oracle Net8 Configuration and Troubleshooting

Name

SID_DESC

Synopsis

SID_DESC=
   [(GLOBAL_DBNAME = global_database_name)]
   [(SID_NAME = sid)]
   (ORACLE_HOME = oracle_home_directory)
   [(PRESPAWN_MAX...)]
   [(PRESPAWN_LIST...)]
   [(PROGRAM = executable_name)]

Registers one database instance with the listener, and must be enclosed within a SID_LIST parameter. The GLOBAL_DBNAME and SID_NAME parameters are both optional, but at least one of the two must be included. Oracle7 clients connect to an instance using the SID, so include SID_NAME if you want to support such clients. Beginning with Oracle8, clients can connect using either the SID or the global database name, so you may want to include both in your static service definitions. To see which method a client is using, look at the CONNECT_DATA parameter in the client’s tnsnames.ora file.

Parameters

global_database_name

The global name for the database. This is a combination of the DB_NAME and DB_DOMAIN initialization parameters, and it must also be one of the service names listed with the SERVICE_NAMES initialization parameter.

sid

The system identifier for the database instance. This usually is equivalent to the INSTANCE_NAME initialization parameter.

oracle_home_directory

The complete path to the Oracle Home directory for the instance in question. This should be the actual path. Do not use symbols such as $ORACLE_HOME here.

PRESPAWN_MAX...

Only has relevance if you are using prespawned dedicated server processes. See the PRESPAWN_MAX parameter.

PRESPAWN_LIST...

Only has relevance if you are using ...