配置和启动Oracle Enterprise Manager

关闭顺序：EM、isql*plus---->监听---->数据库
启动顺序：监听---->数据库----->EM、isql*plus

启动详解：（注意网络的配置）

配置、启动监听

① 先配置监听程序：

[[email protected]_2~]$ netca

OracleNet Services Configuration:

Warning:Cannot convert string "-b&h-lucida-medium-r-normal-sans-*-140-*-*-p-*-iso8859-1"to type FontStruct

ConfiguringListener:LISTENER

Next

Next

…..

Next

Finish

② 启动监听程序：

[[email protected]_2~]$ lsnrctl start

LSNRCTLfor Linux: Version 10.2.0.1.0 - Production on 10-NOV-2013 19:27:49

Copyright(c) 1991, 2005, Oracle. All rightsreserved.

Starting/u01/app/oracle/product/10.2.0/bin/tnslsnr: please wait...

TNSLSNRfor Linux: Version 10.2.0.1.0 - Production

Systemparameter file is /u01/app/oracle/product/10.2.0/network/admin/listener.ora

Logmessages written to /u01/app/oracle/product/10.2.0/network/log/listener.log

Listeningon: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle_2)(PORT=1521)))

Listeningon: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle_2)(PORT=1521)))

STATUSof the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version10.2.0.1.0 - Production

StartDate 10-NOV-2013 19:27:49

Uptime 0 days 0 hr. 0 min. 0 sec

TraceLevel off

Security ON: Local OS Authentication

SNMP OFF

ListenerParameter File/u01/app/oracle/product/10.2.0/network/admin/listener.ora

ListenerLog File /u01/app/oracle/product/10.2.0/network/log/listener.log

ListeningEndpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle_2)(PORT=1521)))

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

ServicesSummary...

Service"PLSExtProc" has 1 instance(s).

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

Thecommand completed successfully

③ 启动数据库

[[email protected]_2~]$ sqlplus / as sysdba

SQL*Plus:Release 10.2.0.1.0 - Production on Sun Nov 10 19:30:40 2013

Copyright(c) 1982, 2005, Oracle. All rightsreserved.

Connectedto an idle instance.

[email protected]>startup

ORACLEinstance started.

TotalSystem Global Area 285212672 bytes

FixedSize 1218992 bytes

VariableSize 92276304 bytes

DatabaseBuffers 188743680 bytes

RedoBuffers 2973696 bytes

Databasemounted.

Databaseopened.

[email protected]>

④ 启动isql*plus

[[email protected]_2~]$ isqlplusctl start

iSQL*Plus10.2.0.1.0

Copyright(c) 2003, 2005, Oracle. All rightsreserved.

StartingiSQL*Plus ...

iSQL*Plusstarted.

[[email protected]_2~]$

[[email protected]_2~]$ netstat -tulnp|grep 5560

(Notall processes could be identified, non-owned process info

will not be shown, you would have to be rootto see it all.)

tcp 00 0.0.0.0:55600.0.0.0:* LISTEN 11889/java

可以通过物理机的IE浏览器看一下是否启动：

http://192.168.12.70:5560/isqlplus/ （192.168.12.70是你的IP地址）

注：EM一旦建立以后，Linux服务器的主机名字就不要改变

⑤ 启动Enterprise Manager (EM)

[[email protected]_2~]$ emctl start dbconsole

TZset to PRC

OracleEnterprise Manager 10g Database Control Release 10.2.0.1.0

Copyright(c) 1996, 2005 Oracle Corporation. Allrights reserved.

http://oracle_2:1158/em/console/aboutApplication

StartingOracle Enterprise Manager 10g Database Control ............................started.

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

Logsare generated in directory/u01/app/oracle/product/10.2.0/oracle_2_orcl/sysman/log

[[email protected]_2~]$

[[email protected]_2~]$ netstat -tulnp|grep 1158

(Notall processes could be identified, non-owned process info

will not be shown, you would have to be rootto see it all.)

tcp 00 0.0.0.0:11580.0.0.0:* LISTEN 17917/java

[[email protected]_2~]$

此时可以登录到EM看一下是否可以登录：

http://192.168.12.70:1158/em/