|
-
--Change the listener to
# LISTENER.ORA Network Configuration File: D:\ora92\network\admin\listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.50.37)(PORT = 1521)
)
)
)
)
---- no need to enter the entry for 803 if you are using the same listener name and port.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = TEST92)
(ORACLE_HOME = D:\ora92)
)
(SID_DESC =
(SID_NAME = DCC1)
(ORACLE_HOME = C:\ORANT)
)
)
-- and change tns to
# TNSNAMES.ORA Network Configuration File: D:\ora92\network\admin\tnsnames.ora
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 = (SERVICE_NAME = TEST92)
)
)
I did put TNS_ADMIN to ora92 tnsnames.ora
--- point this to D:\ora92\network\admin (directory) not the tnsnames.ora file
Last edited by adewri; 01-31-2003 at 04:04 AM.
Amar
"There is a difference between knowing the path and walking the path."

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
|