Re: A stupid SQL*Plus question

Thank you for all the replies.

[Quoted] When I looked for any existing tnsname.ora file, I could not find it. In [Quoted] what directory should this file reside.

Thanks again for all the help.

"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message news:MPG.19007fd5e6f0e003989730_at_news.la.sbcglobal.net...
> Xalison.holloway_at_oracle.comX said...
> > You'll need to create an entry in the tnsnames.ora file for the remote
server. You can do
> > this using the Net Configuration Assistant.
> >
> > Alison
> >
> > wl wrote:
> > > Hi all,
> > > I apologize for this simple question.
> > >
> > > I have a need to access an Oracle database on another server using my
PC. I
> > > installed SQL*Plus for Windows, but was unable to logon to the
database. I
> > > have no idea what to enter in the "hostname string".
> > >
> > > With the following example information, can someone tell me what the
> > > "hostname string" should be:
> > >
> > > server address: dbserver.company.com
> > > port: 1521
> > > database: mydb
> > > user: userid1
> > > password: password1
> > >
> > > Thanks
> > >
> > >
> >
> Or ... if you're the "edit" kind of person, edit your tnsnames.ora file
> and include the following entry (modified for your environment):
>
> mydb =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)(HOST = dbserver.company.com)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = mydb)
> )
> )
>
> Then in the dialog box when you start sqlplus, put the userid, password,
> and mydb (or whatever you call it in your tnsnames.ora).
>
> One thing, though - make sure your host name is dbserver.company.com. Go
> to the server, and if it's Unix, type the command, hostname. Whatever
> appears in the reply is what you put as the HOST parameter in your
> tnsnames.ora. And even if you use the Net Config Assist as suggested, be
> sure to check your sqlnet.ora file, which often by default has a
> DEFAULT_DOMAIN entry that is wrong (in my environment, at least).
> --
> /Karsten
> DBA > retired > DBA
>
Received on Sat Apr 12 2003 - 03:28:39 CEST