#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!