How to Find Oracle DB Connect Descriptor Parameters

No Comments

Setting up Oracle DB discovery in vScope require an Instance or Service Name in the Oracle database. If you don’t not know the instance same, but have access to the database and the credentials, here is a way to determine the instance names.

Solution 1 – Try one of the standard instance names

Try to enter one of the following

  • XE (Oracle Express Edition)
  • ORCL (Oracle default SID)
  • IASDB (Oracle Application Server 9i Rel. 2 – 10g)
  • SA (SAP)

Solution 2 – Find out the real instance names from your Oracle DB server

Use the command: lsnrctl status from the terminal. This works on both Unix, Linux, and Windows machines. The status command will show you all the listeners (and their associated SIDs).

Example:

C:>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 15-JUN-2009 16:16:34
Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 13-JUN-2009 12:04:14
Uptime 2 days 4 hr. 12 min. 19 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:oracleXEapporacleproduct10.2.0servernetworkadminlistener.ora
Listener Log File C:oracleXEapporacleproduct10.2.0servernetworkloglistener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ThinkpadT61)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully

In this example, the instance names are XEXDB, XE_XPT or XE.

Solution 3 – Find the instance from querying the DB

  • The query SELECT SYS_CONTEXT('USERENV', 'SID') FROM DUAL; will return the instance names

Leave a Reply