Wednesday , July 26 2017
Home / Oracle DBA / Creating new Listener manually

Creating new Listener manually

Creating new Listener manually

  1. Copy the existing entry to end of the listener.ora file
SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = PLSExtProc)(ORACLE_HOME = /u02)(PROGRAM = extproc)))
LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = server1.kanna.com)(PORT = 1521))(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))))
  1. Remove the line mentioned “protocol=IPC” in listener description in listener.ora
  2. Change listener name, host and port no to appropriate values
  3. Change the listener name in the first line of SID_LIST
  4. Change SID_NAME and ORACLE_HOME and remove EXTPROC line, when finished it should look like below
SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = prod)(ORACLE_HOME = /u02)))LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = server1.kanna.com)(PORT = 1521))))
Read More:
ORACLE AUDITING
PROFILE MANAGEMENT
USER MANAGEMENT

Comments

comments

Check Also

DATA BASE LINKS

DATABASE LINKS: What are the db links? create a link from one database to another …

Leave a Reply

Your email address will not be published. Required fields are marked *