|
Look at these cases and see how an
Oracle service is named function of the pfile/ spfile parameters.
Case nr. 1
DB_NAME
= 'myDB'
DB_DOMAIN
- not set in the pfile
DB_UNIQUE_NAME - not set in the
pfile
INSTANCE_NAME - not set
in the pfile
SERVICE_NAMES
- not set in the pfile
C:\>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 -
Production on 21-AUG-2010 11:43:17
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cata1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 21-AUG-2010 11:27:43
Uptime 0 days 0 hr. 15 min. 34 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle10g\OH\network\admin\listener.ora
Listener Log File D:\Oracle10g\OH\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cata1)(PORT=1521)))
Services Summary...
Service "myDB_XPT" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
Service "mydb" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
The command completed successfully
Case nr. 2
DB_NAME
= 'myDB'
DB_DOMAIN
- not set in the pfile
DB_UNIQUE_NAME - not set in the
pfile
INSTANCE_NAME - not set
in the pfile
SERVICE_NAMES
= 'myDB'
The result is the same as in the case nr. 1
Case nr. 3
DB_NAME
= 'myDB'
DB_DOMAIN
- not set in the pfile
DB_UNIQUE_NAME - not set in the
pfile
INSTANCE_NAME - not set
in the pfile
SERVICE_NAMES
= 'myDB2'
C:\>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 -
Production on 21-AUG-2010 12:03:38
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cata1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 21-AUG-2010 12:03:19
Uptime 0 days 0 hr. 0 min. 19 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle10g\OH\network\admin\listener.ora
Listener Log File D:\Oracle10g\OH\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cata1)(PORT=1521)))
Services Summary...
Service "myDB2" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
Service "myDB_XPT" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
Service "mydb" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
The command completed successfully
More information
about this subject (
Oracle service name ) you can get from
www.in-oracle.com
|