Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*net problem, no tnsnames.ora ???

Re: SQL*net problem, no tnsnames.ora ???

From: Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca>
Date: 1998/04/06
Message-ID: <01bd619b$327b2bc0$3301020a@tdykstra>#1/1

Now I think of it, you are probably running the Names Server. Run 'namesctl' to verify that.

-- 
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Jeremy Cope <thecopes_at_ihug.co.nz> wrote in article
<6g3ud6$sss$1_at_newsource.ihug.co.nz>...

> I have a problem trying to configure sql*net for a new instance and
> database.
>
> We're running Oracle 7.3 on SGI Irix.
>
> I've created a new database and instance (tins). I can connect using
server
> manager, but not sqlplus. I understand sqlplus uses sql*net to
communicate
> to the instance, but I can't see how to configure it.
>
> I've amended listener.ora and /etc/oratab. I've searched this newsgroup
for
> an answer but everybody sayes update the tnsnames.ora file, however this
> file does not exist, (I believe it should be in
$ORACLE_HOME/network/admin,
> I searched the entire $ORACLE_HOME), neither does Netman, a tool some say
to
> use.
>
> Can I just create the tnsnames.ora file manually??
>
> What's more baffling is that we have an existing database up and running
> with client apps talking to it, they use sql*net. So how does that work??
I
> can use sqlplus on the server to the existing database, without a host
> connection string??
>
> I've tried reading the Oracle Irix documentation which comes on the
install
> cd , however trying to use Oracle book through a telnet session is
> impossible.
>
> Any help appreciated as I'm stuck!
>
> Jeremy Cope
> intrahealth systems limited
> New Zealand
>
>
>
>
Received on Mon Apr 06 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US