Stack Overflow
Stack Overflow

Questions tagged [ora-12514]

TNS:listener does not currently know of service requested in connect descriptor Cause: The listener received a request to establish a connection to a database or other service.

The 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.

Reference:

28 questions
326
votes
31 answers

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

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly…
Jacques
  • 6,936
  • 8
  • 43
  • 102
14
votes
4 answers

TNSPING OK but sqlplus gives ORA-12154?

I have Oracle 11 running on a Windows server and I'm logged onto the same server trying to use SQL Plus. When I try to connect I get a ORA-12154 even though TNSPING and various other diagnostics look OK. Can anyone suggest why ? Loads of detail…
glaucon
  • 8,112
  • 9
  • 41
  • 63
8
votes
8 answers

ORA-12154: TNS:could not resolve the connect identifier specified

I am trying to connect to oracle 11g installed on Linux EL 5 and and getting the following error SQL> connect sys/password@ud06 as sysdba ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor my…
user275705
  • 115
  • 1
  • 2
  • 9
7
votes
1 answer

Oracle EasyConnect connection string using a SID?

I'm trying to connect to an Oracle database through code (Ruby/DBI, but that's irrelevant) using an EasyConnect connection string. All of the Oracle documentation says to specify the connection string as //hostname:port/service_name. I don't have…
Jon Kruger
  • 4,009
  • 4
  • 33
  • 46
4
votes
3 answers

Connect to an Oracle 10g database with Microsoft ODBC for Oracle

I'm trying to connect to an Oracle 10g database using the built in Microsoft ODBC for Oracle driver. I want to use an dnsless connection, so I grab my connection string from www.connectionstrings.com. Ideally I won't have to setup a DNS entry or an…
Gaidin
  • 1,381
  • 3
  • 13
  • 19
3
votes
2 answers

TNS Listener -ORA-12514 error following database shutdown - Oracle 11g

I have hit a problem with my oracle development database. When in sqlplus I executed the shutdown command, but nothing happened for several minutes and it was just hanging. No messages were displayed to the screen. The only thing was to close the…
Andy5
  • 2,319
  • 11
  • 45
  • 91
3
votes
4 answers

ORA-12514 after rebooting server

I am using Oracle 10g R2. Recently, after rebooting the server, I started having a problem where I couldn't connect to the instance. I am only connecting locally on the server itself. Oddly enough, the issue corrects itself if I start the Database…
Ovesh
  • 5,209
  • 11
  • 53
  • 73
3
votes
4 answers

OracleClient + TNSless connection with .NET

We are using System.Data.OracleClient and the abstract base classes DbConnection, DbCommand (etc) to connect to Oracle. The connection works fine in our development stages. During staging we encounter the error ORA-12514: TNS:listener does not…
user112799
  • 1,605
  • 2
  • 13
  • 15
2
votes
1 answer

Oracle error ORA-00600

I use Oracle 11g. A few days ago I encountered an ORA-12514 error. I tried to solve it by following this website suggestions: C:\>set oracle_sid=SID Create a new environment variable called TNS_ADMIN: in the ‘value’ field, add the new folder:…
Amir
  • 1,919
  • 8
  • 53
  • 105
2
votes
2 answers

Connecting to Oracle with PHP on IIS

I'm having all sorts of trouble... Here is the code I'm using: $c = OCILogon('user', 'pass', 'host'); I get the following error: PHP Warning: ocilogon(): ociopen_server: Error while trying to retrieve text for error ORA-12514 in…
tgrk35
  • 21
  • 1
  • 2
1
vote
1 answer

Oracle connection with port, service name, and database from C# (ORA-12514

I'm new to Oracle. Trying to connect C# windows app to an Oracle database but can't seem to establish a proper connection. Keep getting exception: "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor". I…
James
  • 53
  • 1
  • 1
  • 7
1
vote
0 answers

get ora 12514 when connecting 12c to sql developer

My procedure: 1. checking container , 2. altering container n unlocking I made the following addition to tnsnames.ora PDBORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER =…
Surbhi Kohli
  • 11
  • 1
  • 4
1
vote
1 answer

Unable to Connect to Database 12c

I have installed Oracle Database 12.1.0.2 on my linux machine. For the very first time everything works perfectly fine but when i restarted my machine then i was unable to connect to the database and it throws this error ORA-12514: TNS:listener…
daniyal.bashir
  • 88
  • 4
  • 14
1
vote
2 answers

Suddenly getting ORA-12514 error Oracle 11gr2

I installed Oracle 11g r2 fine, had 2 databases (se3 and mydb, both have db_domain .orcl i.e. mydb.orcl and se3.orcl) running on it fine till yesterday. but suddenly im getting ORA-12514 error (TNS:listener doesn't know of service requested in…
Solat Ali
  • 39
  • 1
  • 6
0
votes
4 answers

How to connect to Oracle 10g from remote client?

Using the standard Delphi dbexpress dbexpora.dll + oci.dll (10g) (the oracle instantclient is installed). When directly on the Oracle Database box we can run dbexpress apps just fine. The local dbxconnections.ini alias used in that case simply…
None
1
2