| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Strange SQL*Net problem - 12545
Hi all:
I've been called in to help with a problem connecting to an 8i database that I had nothing to do with creating. And I'm stumped. I apologise in advance for the length of this post, but a little background may help.
First, the problem: The users can connect to one instance of Oracle on the server via sql*net, either locally or remotely. But they can only connect to a 2nd instance (and a 3rd!!) via sql*net directly from the server. Trying to connect remotely generates a 12545 error. I've examined, and played with, both the tnsnames file on the client and the listener.ora on the server. I can't see anything wrong. I also changed the Oracle_SID entry in the registry from xxxxtest to xxxxdev1, and xxxxdvlp, without any luck.
8i is running on a Win2K server, configured as a DNS server. In addition to 8i, they've also got iAS running on the machine. There are two Oracle Homes, I'm assuming the 2nd is for iAS, but I'm not really sure, having never worked with iAS before. They also have 3 (!!) instances of Oracle running at the moment. The only other thing I can think that might be relevent is that it looks like they've installed both the Oracle 8 and 8i client software on the client PC.
The first instance (xxxxtest) is apparently the one created by Oracle during the install. Everything works fine with this one. The 2nd (xxxxdev1) was supposed to be the development database. The server name is also xxxxdev1. Thinking that might be the problem, the dba created a 3rd instance called xxxxdvlp.
Tnsping from the client works fine, for what little that's worth.
Here are exceprts from the tnsnames file on the client:
OFNSTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxdev1.zzzz_yyyy)(PORT =
1521))
)
(CONNECT_DATA =
(SID = xxxxTEST)
)
)
OFNSDEV1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxdev1.zzzz_yyyy)(PORT =
1521))
)
(CONNECT_DATA =
(SID = xxxxdev1)
)
)
I also tried:
XXXXTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 000.000.000.00)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xxxxtest.zzzz_yyyy)
)
)
XXXXDev1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 000.000.000.00)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xxxxdev1.zzzz_yyyy)
)
)
No matter what variation I use, the client can connect to xxxxtest, but not to xxxxdev1 (or xxxxdvlp).
Here's the server tnsname.ora:
XXXXTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
xxxxdev1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = xxxxtest)
)
XXXXDEV1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
xxxxdev1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xxxxdev1.zzzz_yyyy)
)
I **think** I've tried using SID instead of service name here, too.
Finally, here's the listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = xxxxtest.ZZZZ_YYYY)
(ORACLE_HOME = d:\Oracle\Ora81)
(SID_NAME = xxxxtest)
)
(SID_DESC =
(GLOBAL_DBNAME = xxxxdev1.ZZZZ_YYYY)
(ORACLE_HOME = d:\Oracle\Ora81)
(SID_NAME = xxxxdev1)
)
(SID_DESC =
(GLOBAL_DBNAME = xxxxdvlp.ZZZZ_YYYY)
(ORACLE_HOME = d:\Oracle\Ora81)
(SID_NAME = xxxxdvlp)
)
(SID_DESC =
(GLOBAL_DBNAME = Dev1.ZZZZ_YYYY)
(ORACLE_HOME = d:\Oracle\Ora81)
(SID_NAME = Dev1)
)
I anyone has ANY idea of what I might try next, I'd sure appreciate it.
Bob Received on Sun Mar 18 2001 - 22:24:16 CST
 |
 |