DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_TNS_LISTENERS

Object Details
Object Name: FND_TNS_LISTENERS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_TNS_LISTENERS
Subobject Name:
Status: VALID


The FND_TNS_LISTENERS table tracks the TNS Listeners used on a system to contact a databases and RPC services.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_TNS_LISTENERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnLISTENER_GUID
FND_TNS_LISTENERS_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSERVER_GUID
ColumnLISTENER_NAME
Columns
Name Datatype Length Mandatory Comments
LISTENER_GUID RAW (16) Yes Unique ID for this row, since the unique key Host+Port may change. (In particular, the port may change.)
LISTENER_NAME VARCHAR2 (255) Yes Each listener has a name, however, this is not forced to be unique outside of an ORACLE_HOME. In fact, AutoConfig will name all Apps RPC listeners in a given system the same: "APPS_%s_dbsid%". So, listener_name should not be used as a key
CREATED_BY NUMBER
Yes Standard "who" column
CREATION_DATE DATE
Yes Standard "who" column
LAST_UPDATED_BY NUMBER
Yes Standard "who" column
LAST_UPDATE_DATE DATE
Yes Standard "who" column
LAST_UPDATE_LOGIN NUMBER
Yes Standard "who" column
SERVER_GUID RAW (16) Yes SERVER_GUID
TNS_ALIAS_GUID RAW (16)
TNS_ALIAS_GUID
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LISTENER_GUID
,      LISTENER_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SERVER_GUID
,      TNS_ALIAS_GUID
FROM APPLSYS.FND_TNS_LISTENERS;

Dependencies

[top of page]

APPLSYS.FND_TNS_LISTENERS does not reference any database object

APPLSYS.FND_TNS_LISTENERS is referenced by following:

SchemaAPPS
SynonymFND_TNS_LISTENERS