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
ImanmalikAsked:
Who is Participating?
 
annamalai77Commented:
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

client_oracle_home/network/admin/tnsnames.ora

that will solve ur problem.

regards
annamalai
0
 
riazpkCommented:
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.

0
 
gupta_nagCommented:
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
0
Ultimate Tool Kit for Technology Solution Provider

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 now.

 
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).
0
 
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?
0
 
gupta_nagCommented:
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
0
 
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?
0
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.