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 |