# Listener.ora Network Configuration file:d:\oracle\product\10.1.0\db_1\network\admin\listener.ora# Generated by Oracle configuration Tools. Sid_list_listener = (sid_list = ( Sid_desc = (sid_name = Plsextproc) (oracle_home = D:\oracle\product\ 10.1.0\db_1) (program = Extproc))) LISTENER = (description_list = ( DESCRIPTION = ( Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = cust-e44050fe71) (PORT = 1521)) ) (address_list = ( ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC))))
If you listener.ora configuration file is such that the instructions are missing some configuration information should indicate that listening to that database should be added
(Sid_desc = (Global_dbname = GKBM2015)//For database service name (oracle_home = D:\oracle\product\10.1.0\Db_1) (sid_name = GKBM2015)// For database service name ) (Sid_desc = (Global_dbname = ZYXX2015)//For database service name (Oracle_home = D:\oracle\product\10.1.0\ db_1) (sid_name = ZYXX2015)//For database service name )
And then the files are like this
# Listener.ora Network Configuration file:d:\oracle\product\10.1.0\db_1\network\admin\listener.ora# Generated by Oracle configuration Tools. Sid_list_listener = (sid_list = ( Sid_desc = (sid_name = Plsextproc) (oracle_home = D:\oracle\product\ 10.1.0\db_1) (Program = extproc) ) (Sid_desc = (global_dbname = GKBM2015) (oracle_home = d:\ oracle\product\10.1.0\db_1) ( sid_name = GKBM2015) ) (Sid_desc = (global_dbname = ZYXX2015) (Oracle_home = D:\oracle\product\10.1.0\Db_1) (Sid_name = ZYXX2015)))) LISTENER = (description_list = ( DESCRIPTION = ( address_list = ( ADDRESS = (PROTOCOL = TCP) (HOST = CUST-E44050FE71) (PORT = 1521)) (address_list = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC) )) ) )
Then restart the listener.
cmd command, enter LSNRCTL
Stop
Start
Oracle Ora-12514:tns:listener does not currently know of service requested in Conn solution