Oracle notes

How to restart database

connect as oracle user

$ sudo su - oracle

Restart DB Instance

$ sqlplus sys/password as sysdba
$ shutdown
$ startup
$ exit

Ref: Starting Up and Shutting Down

Restart Listener

$ lsnrctl stop
$ lsnrctl start
$ lsnctl status

Listener setting

ORACLE_INSTALLATION_DIR\product\12.1.0\dbhome_1\NETWORK\ADMIN\listener.ora