OracleDB‎ > ‎Error‎ > ‎


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

This normally happens when you want to duplicate a database to nomount instance or just want to separate an instance's listener. After creating the listener entry in listener.ora (don't forget to add your SID to SID_LIST_LISTENER section).
Log in to the new database and run:

create pfile='/tmp/init.ora' from spfile;

add the following to /tmp/init.ora and shutdown the database and run:

create spfile from pfile='/tmp/init.ora'

Add an entry for the new database to your tnsnames.ora:

    (ADDRESS = (PROTOCOL = TCP)(HOST = = 1523))
      (SERVICE_NAME = mynewdb)

OK now start the database back up and you should be able to connect to the new database using

sqlplus user/pass@MYNEWDB