Config Enterprise Manager Express

 

oracle在12c中彻底弃用OEM，改用轻量级的EM Exprexs来替代EM。优点是管理和操作要简便了许多，缺点是没有OEM那么强大的功能的。但是OEM毕竟是ORACLE亲生的，他们还有grid control，cloud control，ORACLE SQL development等工具。

EM Express是基于底层XDB实现的，在12c中XDB默认安装。所以安装的时候只需要执行

DBMS_XDB_CONFIG.setHTTPPort(port)即可。

 

1. Starting Listener

启动监听，官方建议这个监听的端口号是一个非标准端口号（即非1521端口），并且确认Local_listener参数=TNS_NAME。 oracle@DB12c:/u01/app/oracle/products/12.1.0/network/admin>ps -ef | grep tns root        15     2  0 Sep14 ?        00:00:00 [netns] oracle    9434     1  0 01:46 ?        00:00:00 /u01/app/oracle/products/12.1.0/bin/tnslsnr LISTENER -inherit oracle   12498 12239  0 03:59 pts/1    00:00:00 grep tns   SQL> show parameter local_listener   NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ local_listener                       string      LISTENER_XXLCDB   oracle@DB12c:/u01/app/oracle/products/12.1.0/network/admin>pwd /u01/app/oracle/products/12.1.0/network/admin   oracle@DB12c:/u01/app/oracle/products/12.1.0/network/admin>cat tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/products/12.1.0/network/admin/tnsnames.ora # Generated by Oracle configuration tools.   LISTENER_CLOUD =   (ADDRESS = (PROTOCOL = TCP)(HOST = DB12c)(PORT = 1521))     XXLCDB =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = DB12c)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = xxlcdb)     )   )   NONCDB =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = DB12c)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = noncdb)     )   )   LISTENER_XXLCDB =   (ADDRESS = (PROTOCOL = TCP)(HOST = DB12c)(PORT = 1521))     LISTENER_NONCDB =   (ADDRESS = (PROTOCOL = TCP)(HOST = DB12c)(PORT = 1521))

 

2.Enable TCP Dispatchers

SQL> show parameter dispatcher   NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ dispatchers                          string      (PROTOCOL=TCP) (SERVICE=xxlcdb                                                  XDB) max_dispatchers                      integer

 

3.Restart DATABASE

这一步在测试过程中发现没有必要

 

4.Enable XDB Port

SQL> exec DBMS_XDB.setHTTPPort(8080);   PL/SQL procedure successfully completed.   oracle@DB12c:/u01/app/oracle/products/12.1.0/network/admin>lsnrctl status   LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 15-SEP-2013 04:05:28   Copyright (c) 1991, 2013, Oracle.  All rights reserved.   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DB12c)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias                     LISTENER Version                   TNSLSNR for Linux: Version 12.1.0.1.0 - Production Start Date                15-SEP-2013 01:46:36 Uptime                    0 days 2 hr. 18 min. 51 sec Trace Level               off Security                  ON: Local OS Authentication SNMP                      OFF Listener Parameter File   /u01/app/oracle/products/12.1.0/network/admin/listener.ora Listener Log File         /u01/app/oracle/diag/tnslsnr/DB12c/listener/alert/log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DB12C)(PORT=1521)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DB12C)(PORT=8080))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "noncdb" has 1 instance(s).   Instance "noncdb", status READY, has 1 handler(s) for this service... Service "noncdbXDB" has 1 instance(s).   Instance "noncdb", status READY, has 1 handler(s) for this service... Service "xxlcdb" has 1 instance(s).   Instance "xxlcdb", status READY, has 1 handler(s) for this service... Service "xxlcdbXDB" has 1 instance(s).   Instance "xxlcdb", status READY, has 1 handler(s) for this service... Service "xxlpdb" has 1 instance(s).   Instance "xxlcdb", status READY, has 1 handler(s) for this service... The command completed successfully

5.访问EM exprexss

http://192.168.56.60:8080/em/

QQ交流群：300392987

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26169542/viewspace-772728/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26169542/viewspace-772728/