Check whether oracle is started in linux

藏色散人
Release: 2020-03-14 13:33:37
Original
13528 people have browsed it

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 ://m.sbmmt.com/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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!