How to start and stop the Listener

A quick video and a little tutorial about the Listener in Oracle 11g

 

Status of the listener

# lsnrctl status

Starting the listener

# lsnrctl start

Stopping the listener

  # lsnrctl stop

Oracle 11g user connection

A quick video about user connection via Sqlplus. Login to oracle system user first.

 

As you can see, you can connect by different way.

Connect as sysdba :

  # sqlplus "/as sysdba"

Connect as normal user : sqlplus user/password

  # sqlplus scott/tiger

View current user

#sql> SHOW USER