|
-
Thanks for your help adewri
Everything worked till I changed it to one listener. I configured my ora92 listerer like this so that I could eliminate 803 listener. Now I am getting ora-12500 again if I connect to 803 from 92sqlplus.
# 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)
)
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = 172.18.50.37)(Port = 1526)
)
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = TEST92)
(ORACLE_HOME = D:\ora92)
)
(SID_DESC =
(SID_NAME = DCC1)
(ORACLE_HOME = C:\ORANT)
)
)
# TNSNAMES.ORA Network Configuration File: D:\ora92\network\admin\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 = 1521)
)
)
(CONNECT_DATA = (SERVICE_NAME = TEST92)
)
)
I did put TNS_ADMIN to ora92 tnsnames.ora
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
|