Skip to Main Content
Oracle Net8 Configuration and Troubleshooting
book

Oracle Net8 Configuration and Troubleshooting

by Hugo Toledo, Jonathan Gennick
December 2000
Intermediate to advanced content levelIntermediate to advanced
408 pages
12h 26m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Pro Oracle Database 11g RAC on Linux

Pro Oracle Database 11g RAC on Linux

Steve Shaw, Martin Bach
Oracle 11g

Oracle 11g

Lewis Cunningham

Publisher Resources

ISBN: 1565927532Catalog PageErrata