linux 下手动启动、关闭Oracle

linux 下手动启动、关闭Oracle

启动Oracle

1.切换Oracle用户登陆

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

2.以SYS用户身份登录Oracle

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

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

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

4.通过startup命令启动实例

1 SQL> startup
2 ORACLE instance started.
3 
4 Total System 
5 ... ...
6 Database mounted.
7 Database opened.
8 SQL>

5.退出

1 SQL> quit

6.启动监听

1 [oracle@localhost ~]$ lsnrctl start

关闭Oracle

1.关闭数据库实例

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

2.关闭监听器

1 [oracle@localhost ~]$ lsnrctl stop

 



posted @ 2020-07-27 09:16  子寒子寒  阅读(303)  评论(0)    收藏  举报