oracle 停止em,Linux下启 停 oracle 以及em控制台

一、启动数据库

1.进入到sqlplus启动监听

[oracle@redhat ~]$ su - oracle                                 --“切换到oracle用户”

Password:

[oracle@redhat ~]$ lsnrctl start                               --“打开监听”LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-OCT-2009 19:06:40

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /home/oracle/product/10g/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production

System parameter file is /home/oracle/product/10g/network/admin/listener.ora

Log messages written to /home/oracle/product/10g/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redhat)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date                14-OCT-2009 19:06:40

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /home/oracle/product/10g/network/admin/listener.ora

Listener Log File         /home/oracle/product/10g/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redhat)(PORT=1522)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

2.启动数据库实例

[oracle@redhat ~]$ sqlplus /nolog                                --“进入到sqlplus”

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Oct 14 19:06:45 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn /as sysdba                                              --“连接到sysdba”

Connected to an idle instance.

SQL> startup                                                     --“启动数据库实例”ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size      1218968 bytes

Variable Size     88082024 bytes

Database Buffers   188743680 bytes

Redo Buffers      7168000 bytes

Database mounted.

Database opened.

二、关闭数据库

1.关闭实例

SQL> shutdown immediate                                          --“关闭数据库实例”

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

2.关闭监听

[oracle@redhat ~]$ lsnrctl stop                                 --“关闭监听”

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-OCT-2009 19:08:06

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2)))

The command completed successfully

##########################################################

启动EM控制台

1.[oracle@redhat ~]$emctl start

// 用来检查EM工具是否已经安装配置，若没有配置可以使以下命令配置

2.[oracle@redhat ~]$emca -config dbcontrol db -repos recreate

3.[oracle@redhat ~]$emctl start  dbconsole           //启动EM控制台