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

From: Isabel <istalcup_at_hotmail.com>
Date: 19 Apr 2006 04:36:45 -0700
Message-ID: <1145446605.737635.89110@j33g2000cwa.googlegroups.com>

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! Received on Wed Apr 19 2006 - 06:36:45 CDT