Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Tuesday, July 21, 2009

Where is listener information stored in Database

In E-Business Suite, the information about listeners is stored in the tables

APPS.FND_TNS_LISTENERS
APPS.FND_TNS_LISTENER_PORTS

SQL> SELECT A.LISTENER_NAME,B.PORT
2 FROM APPS.FND_TNS_LISTENERS A, APPS.FND_TNS_LISTENER_PORTS B
3 WHERE A.LISTENER_GUID = B.LISTENER_GUID
4 /

LISTENER_NAME
--------------------------------------------------------------------------------
PORT
----------
VISIONDBSERVER_VISION_DB
1521

APPS_VISIONDBSERVER_VISION_APPS
1621

APPS_VISIONAPPSERVER_VISION_APPS
1622

1 comment:

Binuraj said...

Useful information !!!