【Oracle】sql plus重启数据库命令

sql plus重启数据库：
关闭
shutdown immediate;
启动
startup force;

 

Linux下：

1、登录oracle用户

oracle@ypdbuat:/home/oracle>sqlplus

SQL*Plus: Release 11.2.0.4.0 Production on Wed Aug 30 14:37:04 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> startup

2、启动监听

oracle@ypdbdev:/home/oracle>cd $ORACLE_HOME/bin
oracle@ypdbdev:/u01/app/oracle/product/11.2.0/db_1/bin>lsnrctl start