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

前端之家收集整理的这篇文章主要介绍了oracle数据库的启动、关闭、连接前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
@H_404_1@

登陆数据库

方法一:

$ 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

猜你在找的Oracle相关文章