TNS Lookup-failure

Hi all

First of all : I'm not an Oracle-expert

But : I have a problem : I get the following message when I try to log into a Oracle-database :

"ORA-12545: TNS: name lookup failure"

I have typed in correct username, password and database.

This message occure on some of the PC's where I am, and some not.

Any tip?

Regards
Batalf
LVL 32
BatalfAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mkooloosCommented:
Try to check the TNSNAMES.ORA that is used by Oracle to check the DB-Names. Probably on some PC's TNSNAMES.ORA does not exist.

Regards,

Michael.
0
meowshCommented:
Check the tnsnames.ora file held on each PC.

If you are using Oracle 7 then the tnsnames.ora file will usually be found in c:\orant\network\admin.

If you are using Oracle 8 then the tnsnames.ora file will usually be found in c:\orant\net80\admin.

The files may not exist in which case you could either copy them in from another machine or re-install the Oracle client from the Oracle CD.

Alternatively the files may contain an invalid entry or similar.  If in doubt copy the file in from a PC where it works.

Meowsh
0
BatalfAuthor Commented:
Thanks for fast reply.

Here's some aditional information :
The Pc's are connected to a network. The file TNSNames.ora are not located on each PC, but on th server(\\...\orant\admin\)

I can't find any TNSNAMES.ORA on the PC's.

Regards
Batalf
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

BatalfAuthor Commented:
There ain't any directory "ORANT" on the PC's.
0
meowshCommented:
I am fairly certain that you must have tnsnames.ora on the client machine ie the PC!!!  The copy on the server is what server side tools and operations will use to link to databases.

The clients need this file.  If you havent got an orant directory it sounds like you havent installed the oracle client on the PC's.  You need to do this.

The setup.exe found on the Oracle cd will guide you through how to do this...but you do need to do this!

Meowsh
0
mkooloosCommented:
Try to run 'regedit' on your PC's and find out to what path the 'TNS_ADMIN' points.

Michael.
0
BatalfAuthor Commented:
First of all : The PC's are connected in a Novell-network, with a 'applicationdealer' called 'snow distribution'.

In my office, I have 2 pc's. None of these have a 'orant' directory. The file 'tnsnames.ora' couldn't be located on the pc either.

The funny thing is : on one of these PC's the database is working. I'm able to log in.

I have also tried to copy the registrysettings(Local_machine Software Oracle) from the PC which is working to the other one.
0
BatalfAuthor Commented:
Comment to mkooloos:
I can't find any registresetting for TNS_ADMIN

0
mkooloosCommented:
Batalf,

In your registrysettings(Local_machine Software Oracle) there must be (In my opinion) a TNS_ADMIN. That's the one that points to the path where the TNSNAMES.ORA is or has to be located.

Regards,

Michael.
0
BatalfAuthor Commented:
mkooloos

Thank's for fast reply.

There ain't any TNS_ADMIN key under Local_Machine Software Oracle), neither on the PC which is working or on the one which don't.

Maybe I should try to put in a key(The Oracle-software is here located on S:\orant). What should the key be?

Regards,

Batalf
0
BatalfAuthor Commented:
Adjusted points to 100
0
mkooloosCommented:
Batalf,

Sorry to say, but this is out of my range. You can try to add a key TNS_ADMIN that points to 'S:\orant\admin' (or something like that), where your TNSNAMES.ora is located.

Hope this will work, otherwise I don't know.

Michael.
0
sivasundaramCommented:
this is a quick checklist. do it and see

1. check whether u'r able to connect to the server manually using tools such as ping tools
2. check whether the oracle service is running in the machine
3.check locally on the server, whether it's possible to connect to oracle.

do this and if u have any problems, reply
0
BatalfAuthor Commented:
To meowsh
It seems that I have managed to solve this problem. There are differents versjons of Oracle-software on our server. So we have both an Orawin-directory and an Orant-directory.

After som adjustments in the registry we manage to get it working on our PC's.

But : thanks for your replies.
If you propose an answer here, I would like to give you these 100 points.

Regards
Batalf.
0
meowshCommented:
Please refer to my previous suggestions.

Many Thanks

Meowsh
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.