• Oracle12C的EM无法访问怎么办?


    装完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

  • 相关阅读:
    Silverlight的OOB特性 (转)
    B/S安全退出
    判断滚动条是否到达页面的尾部
    通过XmlSerializer序列化(对象)和反序列化(xml文件)
    SQL Server与ADO.Net数据类型对照
    在C#里使用属性,如Obsolete,Serializable,XmlRoot
    SQL求往年的工资和
    通过使用partition by 过滤重复项
    委托的协变与逆变代码
    Routing
  • 原文地址:https://www.cnblogs.com/zangdalei/p/5487911.html
Copyright © 2020-2023  润新知