You may also want to check sqlnet.ora on the client. sometimes its missing
or gets goofy configuration.
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:0eco6u43d67lsga32mok29n6s8b17v2p2j_at_4ax.com...
> 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 Mon Feb 18 2002 - 10:40:26 CST
