Solved

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

Posted on 2009-07-07
4
3,718 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

831 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