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
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps
Tuesday, July 21, 2009
Subscribe to:
Post Comments (Atom)
1 comment:
Useful information !!!
Post a Comment