Re: ARG: Cannot resolve servie name, please help

On Thu, 14 Feb 2002 12:49:43 -0800, "Rhugga" <ccarson_at_rhugga.net> wrote:

>
>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
>
>
>______________________________________________________________________________
>Posted Via Binaries.net = SPEED+RETENTION+COMPLETION = http://www.binaries.net

1 localhost in listener.ora, hardcoded ip address in tnsnames.ora 2 sid_name in listener.ora, service_name in tnsnames.ora (where it is uncertain the init.ora service_name parameter actually is ops1.rhugga.net
3 probably manually edited the files, use the net 8 configuration assistant and it'll work.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Feb 14 2002 - 15:55:32 CST