TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

I issues lsnrctl services and I did not find that service name that is listener log.How can I resovle this
BABU123Asked:
Who is Participating?
 
mohammadzahidConnect With a Mentor Commented:
Hi Babu,
You need to check for an entry that looks like this in listener.ora file

SID_LIST section contains a list of SID (Databases) that are serviced by listener.

(SID_LIST=
 (SID_DESC=
  (GLOBAL_DBNAME=sales.us.acme.com)
  (SID_NAME=sales)
  (ORACLE_HOME=/u01/app/oracle/10g)))

You can add this entry by using Oracle Net Manager or simply manually editing listener.ora file
(Note: Backup listener.ora file prior to making changes)

0
 
slightwv (䄆 Netminder) Commented:
What database version?  There is a bug in 10g where the instance doesn't properly register with the linstener.

You need to add an entry for the database in the listener.ora file.
0
 
BABU123Author Commented:
It's 10.2.0.3 in Linux..I recentley drop the database and re-built using export from a different schema.
It has init.ora and tnsnames.ora has not been changed.. I have verified that tnsnames.ora has all the entries.

What I noticed is that tnsnames.ora is listing a name of the service that I couldn't identify. That same service name is not listed when I issue lsnrctl servcies.

Hope this helps  
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
slightwv (䄆 Netminder) Commented:
Again:

There is a bug in 10g where the instance doesn't properly register with the linstener.

You need to add an entry for the database in the listener.ora file.
0
 
BABU123Author Commented:
Hi I did that but I am seeing the same error message in the listener.log file. I even bounced the listener but I am seeing the same error.

(SID_LIST=
 (SID_DESC=
  (SID_NAME=sales)
  (ORACLE_HOME=/u01/app/oracle/10g)))

I put the instance name for SID_NAME.
0
 
mohammadzahidCommented:
verify case sensitivty between tnsnames.ora (SID or SERVICE NAME) is the same as listener.ora
0
 
slightwv (䄆 Netminder) Commented:
Just to confirm:  You did change SID_NAME and ORACLE_HOME to your specific install?

Can I also assume you added that entry under the SID_LIST_LISTENER entry?

Can you post your listener.ora file?
0
 
schwertnerCommented:
You made significant changes in the installation.
I am not sure you use the correct listener.ora
Some parameters are very important.

You have to start the listener.
run
% lsnrctl services
and see if the instance arise in the report.
If yes - see how many network cards your computer has and does the
listener use the correct IP address
If not - correct the listener.ora file to ensure "static registration of the instance' - see the tons of postings here.
Also see if you address the correct IP in the client machine.
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.