OracleDB‎ > ‎Error‎ > ‎

ORA-12514

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:

MYNEWDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.10)(PORT = 1523))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (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





Comments