`
e-ant
  • 浏览: 72203 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

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

阅读更多

1、启动数据库:

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> startup
ORACLE instance started.

Total System Global Area 135352820 bytes
Fixed Size                   455156 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 679936 bytes
Database mounted.
2、关闭数据库:
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 abort;
3、启动监听器
oracle@suse92:~> lsnrctl start
4、停止监听器
oracle@suse92:~> lsnrctl stop
5、查看监听器状态
  oracle@suse92:~>lsnrctl
  LSNRCTL> status
  LSNRCTL> exit
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics