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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

mohammadzahidCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.