装完Oracle 12c,想体验下EM Express,缺发现不能用,应该怎么办?12c的EM 不再像以前版本配置那么麻烦,当然提供的功能也没有那么多了,只需要启用对应端口即可,请看:

To manually configure the HTTPS port for EM Express:

1. Configure and start the Oracle Net Listener (the listener). You can use lsnrctl to start, stop, and view the status of the listener.

2. If the listener is running on a nonstandard port (for example, not 1521), then the init.ora file for the database you want to manage using EM Express must contain a local_listener entry so that the HTTPS port can register with the correc

listener. The local_listener entry references a TNSNAMES entry that points to the correct listener. For example:

local_listener=inst1

where inst1 is a TNSNAMES entry defined in tnsnames.ora that points to the listener. For example:

inst1= (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1234)) (CONNECT_DATA=(SERVICE_NAME=service_name)(SERVER=DEDICATED)))

In this example, 1234 is the nonstandard port on which the listener has been configured to listen.

3. Enable the TCP dispatcher by adding the following entry to the init.ora file for the database you want to manage using EM Express:

dispatchers=”(PROTOCOL=TCP)(SERVICE=XDB)”

For example, if the database SID is ORCL, then the entry would be:

dispatchers=”(PROTOCOL=TCP)(SERVICE=ORCLXDB)”

4. Restart the database so that the changes made in the init.ora file take effect.

5. Use the PL/SQL procedure DBMS_XDB_CONFIG.SETHTTPSPORT to set the HTTPS port for EM Express. This will update the HTTPS port in the xdbconfig.xml file in the Oracle XML DB Repository. You must connect as SYS / AS SYSDBA to run the procedure. For example:

SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);

6. To access EM Express, enter a URL in the following format in a Web browser:

https://database-hostname:portnumber/em/

For example:

https://mydbhost.example.com:5500/em/

When prompted for your username and password, log in as a user with DBA privilege (such as SYSTEM).

http://blog.sina.com.cn/s/blog_6058d7c101014qx2.html

原文:http://www.cnblogs.com/zangdalei/p/5487911.html

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐