Concept :
Listener will simple listen on port specified by you and will accept connections on that port , and finally will connect that connection to started instance of database
client --> LISTENER --> DATABASE INSTANCE (Your started database)
Important Things which you will require while configuring listener
- ORACLE_HOME
- ORACLE_SID
- PORT NUMBER ON WHICH LISTENER WILL LISTEN FOR CLIENT CONNECTIONS
To check your SID on Linux Box : echo $ORACLE_SID
This SID you will configure in your listener which is currently running instance
Navigate to :
- cd $ORACLE_HOME
- cd network/admin
- vim listener.ora
Configure listener.ora as follows :
HOST : your ip on which your going to listen
PORT : (Your choice)
ORACLE_HOME , ORACLE_SID check with previous command and enter same here in file.
Thats it!
You simply configured listener names LISTENER (by default name)
How to Start Listener :
$ lsnrctl start LISTENER
How to Check :
$ sqlplus girish/girish@//HOSTNAME:PORT/SID
If everything is proper you should get connected to oracle instance!
Thank You!
