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