Click here to Skip to main content
11,709,529 members (50,963 online)
Click here to Skip to main content

Tagged as

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

, 11 Nov 2013 CPOL 20.8K
Rate this:
Please Sign up or sign in to vote.
DPB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.100)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dps) ) )I have used above in tnsnames but still gives me the above error.How to resolve this error?IS SERVICE_NAME &...
DPB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.100)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = dps)
    )
  )

I have used above in tnsnames but still gives me the above error.

How to resolve this error?
IS SERVICE_NAME & SID Similar in tnsnames?

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

No Biography provided

You may also be interested in...

Comments and Discussions

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.150819.1 | Last Updated 11 Nov 2013
Article Copyright 2013 by Member 9410081
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid