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