Click here to Skip to main content
12,303,190 members (74,417 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: ASP.NET Oracle
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?
Posted 11-Nov-13 0:36am
Edited 11-Nov-13 0:37am
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

In order to solve the problem follow the following steps;

>close the sql developer or sql plus window.
>Open Run by pressing (WIndowsButton + R ).
>type in the text field 'services.msc' and run it.
>A new window appears
>In that Services window scroll down and find 'OracleOraDb11g_homeTNSListner',start it if it is not.
>and also start 'OracleServiesORCL',
>Open sql developer and try to establish the connection,If this does not connect Try to create one more connection in sql developer.
>If even this dosent help, try to establish a connection after sometime you will be able to establish a connection.
  Permalink  
Comments
safi rehman 7-Dec-15 1:28am
   
I am having the same problem while connecting my visual basic application with oracle database. "OracleMTSRecoveryService" is the only oracle service running in my OS(windows 7) please help
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Hello Member,

The error ORA-12514 means that a listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.

The possible resolutions for this error are
  • Check which services are currently known by the listener by executing:
    lsnrctl services <listener name>
  • Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.
  • If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener
  • Check for an event in the listener.log file

This answer[^] on oracle forums should help you understand the difference between the SID and the SERVICE_NAME.

Regards,
  Permalink  
Comments
Yvan Ecarri 12-Oct-15 8:56am
   
And then what?
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Hi,
I think the solution from burleson was much enough than oracle forum. Hope this below link will help you a lot,

http://dba-oracle.com/t_ora_12514_tns_listener_does_not_currently_know_service_requested.htm[^]

Regards,
BlueSathish
  Permalink  
v2

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160530.1 | Last Updated 23 Nov 2014
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100