`
zhangbo_on
  • 浏览: 2393 次
  • 性别: Icon_minigender_1
  • 来自: 北京
最近访客 更多访客>>
文章分类
社区版块
存档分类
最新评论

linux下oracle数据库服务和监听的启动停止

阅读更多

 

<!--[if !supportLists]-->1.                <!--[endif]-->启动数据库:

[oracle@oracle11g ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 8 13:56:48 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

 

SQL> conn /as sysdba

Connected to an idle instance.

 

SQL> startup

ORACLE instance started.

Total System Global Area 3340451840 bytes

Fixed Size                  2217952 bytes

Variable Size            1879050272 bytes

Database Buffers         1442840576 bytes

Redo Buffers               16343040 bytes

Database mounted.

Database opened.

 

SQL> quit

 

<!--[if !supportLists]-->2.                <!--[endif]-->关闭数据库:

oracle@suse92:~> sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 20 02:29:37 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

 

SQL> connect /as sysdba

Connected to an idle instance.

 

SQL> shutdwon Immediate

 

<!--[if !supportLists]-->3.                <!--[endif]-->启动监听器

oracle@suse92:~> lsnrctl start

 

<!--[if !supportLists]-->4.                <!--[endif]-->停止监听器

oracle@suse92:~> lsnrctl stop

 

<!--[if !supportLists]-->5.                <!--[endif]-->查看监听器状态

oracle@suse92:~> lsnrctl status

 

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics