Home » RDBMS Server » Enterprise Manager » Connect to database through Enterprise Manager 9i (Enterprise Manager 9i + win7)
Connect to database through Enterprise Manager 9i [message #570907] Sat, 17 November 2012 22:02 Go to next message
hnp2500
Messages: 2
Registered: November 2012
Junior Member
Hi all
I have intsalled oracle client 9i.
I add my services into tnsnames.ora
I could connect in sqlplus but in Enterprise manager i receive error ora12154 tns could not resolve service name!!
Anyone can help me?
Re: Connect to database through Enterprise Manager 9i [message #570908 is a reply to message #570907] Sat, 17 November 2012 22:09 Go to previous messageGo to next message
BlackSwan
Messages: 23149
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
ORA-12154 NEVER involves the listener, the database itself or anything on the DB Server.
ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
TNS-03505 is thrown by tnsping & is same error as ORA-12154 thrown by sqlplus or others.
The lookup operation fails because the name provided can NOT be resolved to any remote DB.
The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
Re: Connect to database through Enterprise Manager 9i [message #570909 is a reply to message #570908] Sat, 17 November 2012 22:17 Go to previous messageGo to next message
hnp2500
Messages: 2
Registered: November 2012
Junior Member
thank for your reply
But I can connect with sqlplus so tnsnames.ora is ok
but I cant connect to same service through enterprise manager!
what is wrong?!
I think both of above utilities must use same config!
Re: Connect to database through Enterprise Manager 9i [message #570910 is a reply to message #570909] Sat, 17 November 2012 22:29 Go to previous messageGo to next message
BlackSwan
Messages: 23149
Registered: January 2009
Senior Member
(Enterprise Manager 9i + win7)
above is an unsupported combination.
Which Windows 7 Edition?

Oracle V9 has not been supported this Decade.
Consider joining the 21 ^st^ Century at your earliest convenience.

>I think both of above utilities must use same config!
you are free to think anything you deem appropriate.
you do not have to convince me of anything.
you need to convince Oracle that it is configured correctly so that no error is thrown.
I won't waste more time trying to inform about any Oracle error code.

[Updated on: Sat, 17 November 2012 22:34]

Report message to a moderator

Re: Connect to database through Enterprise Manager 9i [message #570914 is a reply to message #570909] Sun, 18 November 2012 02:58 Go to previous message
John Watson
Messages: 4859
Registered: January 2010
Location: Global Village
Senior Member
I can barely remember 9i OEM. I never used it much. Biut I do recall that the stand-alone console prompts you do read a local tnsnames.ora file and uses it to populate a list of databases. You probably read the wrong file, one that is in a directory local to the OEM installation. Alternatively, you may have added the daabase manullay, and got the details wrong. Either way, just crete another entry forthe database, and be sure to get the details correct.
Previous Topic: cannot access dbconsole 11gR2 on Windows Server2008 64 bit
Next Topic: User Defined Metric using SQL code
Goto Forum:
  


Current Time: Fri Dec 19 14:20:09 CST 2014

Total time taken to generate the page: 0.14242 seconds