linux 下手动启动、关闭Oracle

第一篇博客

linux 下手动启动、关闭Oracle

启动Oracle

1.切换Oracle用户登陆

[root@localhost ~]# su - oracle
password:

2.以SYS用户身份登录Oracle

[oracle@localhost ~]$ sqlplus / nolog
SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 1 23:29:19 2017
Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> 

3.使用操作系统身份认证

SQL> conn /as sysdba
Connected to an idle instance.

4.通过startup命令启动实例

SQL> startup
ORACLE instance started.

Total System 
... ...
Database mounted.
Database opened.
SQL>

5.退出

SQL> quit

6.启动监听

[oracle@localhost ~]$ lsnrctl start

关闭Oracle

1.关闭数据库实例

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

2.关闭监听器

[oracle@localhost ~]$ lsnrctl stop