We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

luyan
luyan asked
on
Medium Priority
3,763 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!
Comment
Watch Question

Author

Commented:
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?
CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
thanks!
CERTIFIED EXPERT
Top Expert 2008

Commented:
Thank you!
Good luck!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.