Linux下Oracle数据库启动及关闭

来源:互联网 发布:js解析json数组对象 编辑:程序博客网 时间:2024/04/29 05:34

1,启动数据库

 伦理片 http://www.dotdy.com/

[oracle@DB-SERVER ~]$ sqlplus /nolog

[省略N多log  ... ]

 

SQL> connect /as sysdba

Connected to an idle instance.

 

SQL> startup

ORACLE instance started.

[省略N多log  ... ]

 

SQL> exit

 

2,启动监听

 

[oracle@DB-SERVER ~]$ lsnrctl start

 

[省略N多log  ... ]

The command completed successfully

 

3,关闭数据库

SQL> connect /as sysdba

Connected to an idle instance.

SQL> shutdwon abort;

 

4,停止监听器

[oracle@DB-SERVER ~]$ lsnrctl stop

 

5,查看监听器状态

[oracle@DB-SERVER ~]$ lsnrctl

 

[省略N多log  ... ]

 

LSNRCTL> status

[省略N多log  ... ]

 

LSNRCTL> exit


0 0
原创粉丝点击