Oracle TNS/Listener Interview questions and Answer
Registering listener in oracle 11G Error : [oracle@oraclehost admin]$ sqlplus system/manager@test SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 21 11:16:06 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Make sure the below entry exists ... [oracle@oraclehost admin]$ cat listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. ADR_BASE_LISTENER_TEST = /u01/app/oracle LISTENER_TEST = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraclehost)(PORT = 1521)) ) ) [oracle@oraclehost admin]$ cat tnsnames.ora test = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oraclehost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = test) ) ) You may get the below error when registering SQL> alter system set local_listener='LISTENE...