oracle数据库的启动、关闭、连接

登陆数据库

方法一：

$ sqlplus / as sysdba

[[email?protected] /]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri May 31 09:34:26 2019

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


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

SQL>

方法二：

$ sqlplus /nolog

SQL> conn /as sysdba

[[email?protected] ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Fri May 31 17:05:28 2019

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

SQL>
SQL> conn /as sysdba
Connected.
SQL>
SQL>

关闭数据库

SQL> shutdown immediate;

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

装载启动数据库到mount状态

SQL> startup mount

SQL> startup mount
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2213776 bytes
Variable Size             402655344 bytes
Database Buffers         1191182336 bytes
Redo Buffers                7360512 bytes
Database mounted.

启动数据库

SQL> startup

SQL> startup
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2213776 bytes
Variable Size             402655344 bytes
Database Buffers         1191182336 bytes
Redo Buffers                7360512 bytes
Database mounted.
Database opened.

end

【免责声明】本站内容转载自互联网，其相关言论仅代表作者个人观点绝非权威，不代表本站立场。如您发现内容存在版权问题，请提交相关链接至邮箱：bqsm@foxmail.com，我们将及时予以处理。