My Oracle Support Banner

ORA-12514 :Connecting Via Oracle Net While Database is Down (Doc ID 834766.1)

Last updated on JANUARY 17, 2020

Applies to:

Oracle Net Services - Version 9.2.0.1 to 12.1.0.2 [Release 9.2 to 12.1]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Attempting to connect remotely to an instance that is not started using a privileged account.  This might be necessary to start up the database remotely or via the listener.  The following error is returned:

SQL> connect sys/password@ORCL as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor



The TNS connect string used is in the following form:

ORCL =
   (DESCRIPTION =
       (ADDRESS_LIST =
          (ADDRESS = (PROTO = TCP)(HOST = myhost)(PORT = 1521))
      )
  (CONNECT_DATA =
      (SERVICE_NAME = ORCL.ORACLE.COM)
   )
  )

Changes

It is likely the database has been shutdown since the last successful connection via the listener.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.