博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
Oracle12C的EM无法访问怎么办?
阅读量:6368 次
发布时间:2019-06-23

本文共 1986 字,大约阅读时间需要 6 分钟。

装完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://seema.baihongyu.com/

你可能感兴趣的文章
消除GitHub上的历史记录
查看>>
自学 JAVA 的几点建议
查看>>
第十三天-企业应用架构模式-对象-关系元数据映射模式
查看>>
k8s与HPA--通过 Prometheus adaptor 来自定义监控指标
查看>>
Python 比特币教程之二: 机器人收发比特币
查看>>
虎牙直播在微服务改造方面的实践和总结
查看>>
怎样将优酷网站下载的视频KUX转MP4格式
查看>>
MongoDB 分组统计
查看>>
二进制状态码
查看>>
Vue 中 CSS 动画原理
查看>>
关于 Promise 的 9 个提示
查看>>
算法复习
查看>>
安卓中高级开发面试知识点之——缓存
查看>>
Java的初始化顺序
查看>>
js 判断回文字符串
查看>>
shields小徽章是如何生成的?以及搭建自己的shield服务器
查看>>
猫头鹰的深夜翻译:spring事务管理
查看>>
记一次使用Spring REST Docs + travis + github自动生成API接口文档的操作步骤(下)...
查看>>
1、集合 2、Iterator迭代器 3、增强for循环 4、泛型
查看>>
关于/var/run/docker.sock
查看>>