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: The Chronicles of Oracle: the Client, the TNSnames.ora, and a DB cluster

Re: The Chronicles of Oracle: the Client, the TNSnames.ora, and a DB cluster

From: Isabel <istalcup_at_hotmail.com>
Date: 19 Apr 2006 18:21:45 -0700
Message-ID: <1145496105.366357.136460@v46g2000cwv.googlegroups.com>


Thanks! this information is working well for me!

Rauf Sarwar wrote:
> Isabel wrote:
> > Hi,
> >
> > I have just recentely become an Oracle 10g database administrator and I
> > have been having problems connecting a clients to our DB.
> > I have installed the instant client but I am getting the ora-12514
> > errors (unable to resolve the TNSnames, etc...)
> >
> > After searching the internet, I realize that I need to get an
> > tnsnames.ora, listener.ora and a sqlnet.ora file and get them
> > configured correctly.
> >
> > Where do I get these files? and how do they get configured? and where
> > do I put them?
> >
> > On one client, I was able to connect to one of our instances without
> > using a tnsnames.ora file (I think i did the easy connect method)
> > ...but we have a cluster of 8 instances and I need to connect to all of
> > them for load balancing!
> >
> > I have read that there is an wizard in the OEM that will create these
> > but I have unable to find it....
> > (I need an "Intro to client configuration" guide)
> >
> > Thank you if anyone can point me in the right direction!
>
> This should get you going,
> http://download-uk.oracle.com/docs/cd/B19306_01/network.102/b14212/toc.htm
>
> Regards
> /Rauf
Received on Wed Apr 19 2006 - 20:21:45 CDT

Original text of this message

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