Starting and Stopping Oracle Service in Linux

Starting Oracle

login as: root on your oracle installed system

To verify service and ports are listening up check with these commands

[root@CENTOS ~]# netstat -ntpul | grep :1521



[root@CENTOS ~]# netstat -ntpul | grep :1522



Then switch to oracle user for starting services

[root@CENTOS ~]# su - oracle



Then start services with these command

[oracle@CENTOS ~]$ lsnrctl start

The command completed successfully

Then run this command

[oracle@CENTOS ~]$ sqlplus



Then run this command

Enter user-name: sys as sysdba

Enter password: mind123

Connected to an idle instance.

SQL> startup

quit command from exit from sql console

SQL> quit

Run this command to start web interface console to manage Oracle database

[oracle@CENTOS ~]$ emctl start dbconsole

Starting Oracle Enterprise Manager 11g Database Control............. started.

---

Shutdown Oracle Database

To shutdown Oracle server use this command.

[oracle@CENTOS ~]$ sqlplus

Then run this command

Enter user-name: sys as sysdba

Enter password: mind123

Connected to an idle instance.

SQL> shutdown immediate

select TABLE_NAME,TABLESPACE_NAME,STATUS,NUM_ROWS,AVG_ROW_LEN,BLOCKS,EMPTY_BLOCKS from SYS.USER_TABLES WHERE TABLE_NAME LIKE '%RULE_SET*%';