配置oracle 监听和oracle EM

配置和启动Oracle Enterprise Manager

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

 

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

 配置、启动监听

①  先配置监听程序：

[oracle@oracle_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

②  启动监听程序：

[oracle@oracle_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

③  启动数据库

[oracle@oracle_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.

SYS@orcl>startup

ORACLEinstance started.

 

TotalSystem Global Area  285212672 bytes

FixedSize                  1218992 bytes

VariableSize              92276304 bytes

DatabaseBuffers          188743680 bytes

RedoBuffers                2973696 bytes

Databasemounted.

Databaseopened.

SYS@orcl>

④  启动isql*plus

[oracle@oracle_2~]$ isqlplusctl start

iSQL*Plus10.2.0.1.0

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

StartingiSQL*Plus ...

iSQL*Plusstarted.

[oracle@oracle_2~]$

[oracle@oracle_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        0     0 0.0.0.0:5560               0.0.0.0:*                   LISTEN      11889/java

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

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

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

⑤  启动Enterprise Manager (EM)

[oracle@oracle_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

[oracle@oracle_2~]$

[oracle@oracle_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        0     0 0.0.0.0:1158               0.0.0.0:*                   LISTEN      17917/java   

[oracle@oracle_2~]$

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

http://192.168.12.70:1158/em/