troubleshooting Question

How do I resolve ORA-12514: TNS:listener does not currently know of service requested in

Avatar of sikyala
sikyalaFlag for United States of America asked on
Unix OSOracle Database
15 Comments3 Solutions5366 ViewsLast Modified:
When I type emca -repos create
I get prompted with the question:

Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 22, 2011 3:16:49 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /raquel/u01/app/oracle/product/10.2.0.1/cfgtoollogs/emca/tems/emca_2011-07-22_03-16-08-PM.log.
Jul 22, 2011 3:16:50 PM oracle.sysman.emcp.DatabaseChecks performReposChecks
SEVERE: Dbcontrol Repository already exists.  Fix the error(s) and run EM Configuration Assistant again in standalone mode.

Now when I type emca -repos recreate

I get the following error in the log file:
WARNING: ORA-12514: TNS:listener does not currently know of service requested in
 connect descriptor
 
The database is online and the listener as well. I don't know how to fix this. Can someone help me?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 15 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros