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

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Net Services - Version: 10.2.0.4 and later   [Release: 10.2 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 /@jde 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms