My Oracle Support Banner

ORA-12514 Starting up the Database via Oracle Net (Doc ID 1346955.1)

Last updated on NOVEMBER 21, 2019

Applies to:

Oracle Net Services - Version 10.2.0.4 and later
Information in this document applies to any platform.
When connecting through TNS-Names, Trying to startup the database after shutting it down triggers:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor


Goal

When using OracleNet to connect to a database, shutting down the database and then restarting will produce an ORA-12514 error.

SQL> connect /@<TNS_alias> as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
 
SQL> startup
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Solution

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
Goal
Solution


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