Oracle启动停止命令

2011年3月21日

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

 


如果给你带来帮助，欢迎微信或支付宝扫一扫，赞一下。