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

Question

0.00/5 (No votes)

See more:

VB

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

Member 9410081

Updated 10-Apr-18 20:04pm

v2

Add a Solution

5 solutions

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.

Posted 22-Nov-14 22:36pm

Member 11092826

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

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

Posted 11-Nov-13 2:27am

bluesathish

v2

Solution 10

try to restart the listener with command prompt in your file bin in product in oracle:

lsnrctl stop listener
lsnrctl start listener

Posted 10-Nov-21 2:15am

Member 15425503

Updated 10-Nov-21 2:47am

v2

Solution 4

use below if you have SID instead service

berlin =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP)
(PROTOCOL = TCP)
(HOST = hun)
(PORT = 1521)
)
)
(CONNECT_DATA = (SID = kraus))
)

Posted 10-Jun-16 6:19am

ni_pa

Add a Solution

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

Prasad Khandekar · Accepted Answer · 2013-11-11T02:11:00

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,

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

5 solutions

Solution 1

Solution 3

Solution 2

Solution 10

Solution 4

Add your solution here

Preview 0

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

5 solutions

Solution 1

Solution 3

Solution 2

Solution 10

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us