ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Config Enterprise Manager Express

Config Enterprise Manager Express

原创 Linux操作系统 作者:DBA_oracle_java 时间:2013-09-15 14:31:07 0 删除 编辑

 

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

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

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-07-02

  • 博文量
    31
  • 访问量
    117025