ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle启动停止命令

Oracle启动停止命令

原创 Linux操作系统 作者:gengzhizhen 时间:2009-04-26 11:40:05 0 删除 编辑

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15142212/viewspace-591837/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-02-09

  • 博文量
    119
  • 访问量
    206240