Check whether oracle is started in linux

#linux check if oracle is started?

How to check whether the Oracle database has been started:

Check whether the database is started. You can use ipcs to check under Linux, you can check the service under Windows, or you can enter the database to check the database. Current status select status from v$instance; if status = open, it means the oracle service is normal.

To view the monitoring, execute lsnrctl status to see the instance corresponding to the monitoring.

If there is a scott user, you can check the user status of the dba_users table.

linux restart oracle service:

1.su - oracle ---switch to oracle user

2.lsnrctl stop ----stop listening

3.sqlplus / as sysdba

4 .SQL>shutdown immediate ---Stop oracle

5.SQL> startup; ----Start service

6SQL> exit;

7.lsnrctl start ----Start monitoring

8.emctl start dbconsole

9.isqlplusctl start

Recommended to learn Linux video tutorials ：https://www.php.cn/course/list/33.html

The above is the detailed content of Check whether oracle is started in linux. For more information, please follow other related articles on the PHP Chinese website!