当前所在位置:珠峰网资料 >> 计算机 >> Oracle认证 >> 正文
Oracle认证综合辅导:Oracle启动停止命令
发布时间:2012/9/5 22:36:56 来源:城市网学院 编辑:admin
   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> startupORACLE instance started.
    Total System Global Area 135352820 bytesFixed Size
    455156 bytesVariable Size
    109051904 bytesDatabase Buffers
    25165824 bytesRedo Buffers
    679936 bytesDatabase 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 sysdbaConnected 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
广告合作:400-664-0084 全国热线:400-664-0084
Copyright 2010 - 2017 www.my8848.com 珠峰网 粤ICP备15066211号
珠峰网 版权所有 All Rights Reserved