1. ------切换至oracle用户
su - oracle
2.-------以sysdba身份连接数据库
sqlplus "/ as sysdba"
sqlplus "/ as sysdba"
3. -------查看数据库状态
select status from v$instance;
STATUS
------------
OPEN -----开启的
4.-----------关闭数据库
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
5.-------------启动数据库
SQL> startup;
ORACLE instance started.
6.----------------退出SQL
SQL> exit