首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > 其他数据库 >

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

2012-07-20 
linux下oracle数据库服务和监听的启动停止1、启动数据库:oracle@suse92:~ sqlplus /nologSQL*Plus: Releas

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> shutdown abort;


3、启动监听器
oracle@suse92:~> lsnrctl start


4、停止监听器
oracle@suse92:~> lsnrctl stop


5、查看监听器状态
  lsnrctl">oracle@suse92:~>lsnrctl
  LSNRCTL> status
  LSNRCTL> exit

热点排行