Solved

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

Posted on 2009-07-07
4
3,713 Views
Last Modified: 2013-12-19
The instance entry in tnsnames.ora is as below. I could connect through
sqlplus /@myprod1
SQL>

MYPROD1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myprodsrv)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = myprod1)
    )
  )
But user told me he couldn't connect myprod1, and got the following error message.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
The user told me they liked our setting myprod1 with .world in tnsnames.ora. But if I set up SERVICE_NAME=myprod1.world in tnsnames.ora file,  it would fail to connect myprod1.
How to fix it?
Thanks!
0
Comment
Question by:luyan
  • 2
  • 2
4 Comments
 

Author Comment

by:luyan
ID: 24795994
User said he could connect from his desktop and he could tnsping the instance. But he couldn't connect the instance from any other server. Anything wrong?
0
 
LVL 47

Accepted Solution

by:
schwertner earned 500 total points
ID: 24839003
Backup LISTENER.ORA file!!!!!!!

In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
  )

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start


Please change "Exchange Email Server" "with "Oracle database"
0
 

Author Closing Comment

by:luyan
ID: 31600592
thanks!
0
 
LVL 47

Expert Comment

by:schwertner
ID: 24915407
Thank you!
Good luck!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now