|
-
Here we go: I am posting these to someone who WISHES to be a DBA: God help us all>>
ORA8.0.3:LISTENER
################
# Filename......: listener.ora
# Node..........: local.world
# Date..........: 24-MAY-94 13:23:20
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= TCP)
(Host= 172.18.50.37)
(Port= 1526)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = DCC1)
(ORACLE_HOME = C:\ORANT)
)
(SID_DESC =
(SID_NAME = TEST92)
(ORACLE_HOME = D:\ORA92)
)
)
ORA8.0.3 TNSNAMES.ORA
DCC1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.50.37)(PORT = 1526))
)
(CONNECT_DATA = (SID = DCC1)
)
)
TEST92 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.50.37)(PORT = 1526))
)
(CONNECT_DATA = (SID = TEST92)
)
)
ORA92 LISTENER
# LISTENER.ORA Network Configuration File: D:\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.50.37)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = TEST92)
(ORACLE_HOME = D:\ora92)
)
(SID_DESC =
(SID_NAME = DCC1)
(ORACLE_HOME = C:\ORANT)
)
)
ORA92 TNSNAMES.ORA
# TNSNAMES.ORA Network Configuration File: D:\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
DCC1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.50.37)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DCC1)
)
)
TEST92 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.50.37)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TEST92)
(SERVICE_NAME = TEST92)
)
)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|