Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ARG: Cannot resolve servie name, please help
Arg. I do not know why but ever since 8i came out connecting has been a royal pain in the ass.
I have the following 8.17 database on Solaris 8 with the following
listener.ora file (I removed some paranthesis to shorten it):
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(SID_DESC =
(GLOBAL_DBNAME = ops1.rhugga.net)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(SID_NAME = ops1)
On a Windows client, I have the following tnsnames.ora file:
OPS1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <server IP address>)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ops1.rhugga.net )
From SQLPlus, I am trying to connect. I have tried the following in the host
string field:
OPS1
OPS1.
ops1.rhugga.net
What am I doing wrong. I can connect fine using a jdbc driver within Weblogic.
Thanks very much in advance,
CC