Avatar of sikyala
sikyala
Flag for United States of America asked on

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

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?
Oracle DatabaseUnix OS

Avatar of undefined
Last Comment
sikyala

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Darius Ghassem

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Chakravarthi Ayyala

What is the output for the command "lsnrctl services"?
I doubt the listener is listening to any DB services.
sikyala

ASKER
LSNRCTL for Solaris: Version 10.2.0.5.0 - Production on 04-AUG-2011 15:25:18

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

lsnrctl services LISTENER

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
Services Summary...
Service "tems.usae.bah.com" has 1 instance(s).
  Instance "tems", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:113571 refused:80
         LOCAL SERVER
The command completed successfully


The oracle sid is tems
SOLUTION
mrjoltcola

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
mrjoltcola

So can you login to tems via TNS?

sqlplus system/<pass>@tems


Does tnsnames.ora have the correct alias for tems?
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
sikyala

ASKER
yes

tnsnames.ora

tems.USAE.BAH.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = backupdb)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = tems.usae.bah.com)
    )
  )
Darius Ghassem

Run alter system register
Chakravarthi Ayyala

This "Instance "tems", status UNKNOWN, has 1 handler(s) for this service...
should go to a READY state and then you are good.

You can check the status of the service through "lsnrctl status" command too.

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
sikyala

ASKER
I executed alter system register

$ lsnrctl status

LSNRCTL for Solaris: Version 10.2.0.5.0 - Production on 04-AUG-2011 15:39:07

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 10.2.0.5.0 - Production
Start Date                04-AUG-2011 15:38:57
Uptime                    0 days 0 hr. 0 min. 10 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /raquel/u01/app/oracle/product/10.2.0.1/network/admin/listener.ora
Listener Log File         /raquel/u01/app/oracle/product/10.2.0.1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=backupdb)(PORT=1522)))
Services Summary...
Service "tems.usae.bah.com" has 1 instance(s).
  Instance "tems", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
slightwv (䄆 Netminder)

Looks like you have domains set in the database.  What does your sqlnet.ora file look like?  You might need to set the default domain or specify the full name in your connects: tems.usae.bah.com

Fyi: is that not a 'sensitive' domain name?  In other words, should you be posting it in a public site?
sikyala

ASKER
I didn't think it was sensitive because it isn't an IP address. in the sqlnet file the names.default_domain is set to usae.bah.com

NAMES.DEFAULT_DOMAIN = usae.bah.com

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)
 
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
slightwv (䄆 Netminder)

>>I didn't think it was sensitive because it isn't an IP address

C:\>nslookup usae.bah.com
Address:  10.128.0.5
Name:    usae.bah.com

>>NAMES.DEFAULT_DOMAIN = usae.bah.com

from a command prompt try: tnsping tems.usae.bah.com
sikyala

ASKER
that is not the IP

tnsping comes back ok
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
sikyala

ASKER
thanks
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.