How To add Oracle Listener

How to Add oracle Listener | Adding Listener for Oracle Database

STEPS TO FOLLOW :

Basically Listener is used to receive incoming connection requests and to manage the traffic of these requests to the DB server accordingly.  I am going tell you how to create an Oracle Listener.

Go to Start

Click Oracle database Home 11g

Click configuration and Mitigation tools and  keep the cursor on "Net Configuration Assistant" and Right click it and run it as an administrator

Click Listener configuration and click Next

Give your listener name and click Next

Choose Your Protocol (Basically TCP is chosen mostly by default) and click Next

You will be prompted for other Listener, Just click the "No" radio button and give next.

After clicking next then click Finish

Then after adding Listener you have to check whether the listener is started or not right ???

Give The Command LSNRCTL STATUS  in your command prompt to check that you have added listener properly or not.


Hope this will help you, If you have further queries please feel free to ask me.