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
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

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

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe