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