connection issue

I am getting following erorr  during export, i tried connecting through toad and getting same eror. but i can conneect through sqlplus and from oem.  
EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve service name
Who is Participating?
annamalai77Connect With a Mentor Commented:
hi my friend

do this and ur problem will be solved.

just copy the tnsnames.ora from ur database oracle home and put it in the client oracle home path.

sqlplus uses the DB oracle home path and toad uses the last installed oracle home path which is ur client.

so copy the tnsnames.ora file from DB path DB_oracle_home/network/admin/tnsnames.ora

and paste in the client path


that will solve ur problem.

The connect string u are using trying connect during export/toad is not find in ur tnsnames.ora. Hopefully you are using different (or probably not using any of) connect string while connecting from sqlplus/oem,so u r getting connected. Please do check ur tnsnames.ora file.

gupta_nagConnect With a Mentor Commented:
This problem generally happenes when toad uses different oracle home what sqlplus uses.

You can set oracle home for TOAD as below:

1) Open Toad
2) You will see In Toad Server login window
3) Check Use Toad Home
4) press SQL* NET help
5) Select Home from Tree View in which your Service entry is there. (Generally if you install new oracle product toad default uses latest version of oracle home but in that the service name will not be there)
6)and now try to login.

nagendra gupta
7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Mark GeerlingsDatabase AdministratorCommented:
Do you use a connect string for SQL*Plus or OEM?  If so, what is it?  Do you run all of these programs on the same machine, or do you run some of them on the server and some on a client?  Do you have multiple Oracle_homes?  If so, SQL*Net may be configured differntly in one of them than in the other(s).
ImanmalikAuthor Commented:
i installed oracle personal database on my machine . i do have client as well, when i try to connect to client through toad i m getting this erorr . however i m ok with connction with database i recently installed and aslo can connect to client using sql and oem. how do configure the sql*Net?
to configure sql* Net for toad follow the steps what i mentioned before.

else copy the tnsnames.ora file from old oracle home to new oracle personal database home

generally u will fine tnsnames.ora file in $ORACLE_HOME\network\admin or $ORACLE_HOME\net80\admin

nagendra gupta
Mark GeerlingsDatabase AdministratorCommented:
Is your Oracle client in a different Oracle_home than your Personal Oracle database?

You said that you are "ok with connection with database", but which database: Personal Oracle, or another Oracle database on a server?

You said that you can also "connect to client using sql and oem".  This puzzles me.  SQL*Plus and OEM are clients that connect to a database.  They don't connect to a client, they are the client.  Which database do they connect to: Personal Oracle, or another Oracle database on a server?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.