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

3、启动监听器

oracle@suse92:~> lsnrctl start

4、停止监听器

oracle@suse92:~> lsnrctl stop

5、查看监听器状态

　　oracle@suse92:~> lsnrctl

　　LSNRCTL> status

　　LSNRCTL> exit