您好,登錄后才能下訂單哦!
https://database-hostname:portnumber/em/
查non-CDB的端口號(hào)
select dbms_xdb_config.gethttpsport() from dual;
查看CDB的https端口號(hào)
alter session set container=CDB$ROOT; select dbms_xdb_config.gethttpsport() from dual;
查看PDB的https端口號(hào)
alter session set container=PDB1; select dbms_xdb_config.gethttpsport() from dual;
監(jiān)聽必須啟動(dòng)
非默認(rèn)監(jiān)聽端口
local_listener=inst1
inst1必須在tnsnames.ora里面有,例如
inst1= (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1234)) (CONNECT_DATA=(SERVICE_NAME=service_name)(SERVER=DEDICATED)))
3.允許tcp調(diào)度員通過下面的配置進(jìn)入到init.ora去管理EM
dispatchers="(PROTOCOL=TCP) (SERVICE=<sid>XDB)"
4.重啟數(shù)據(jù)庫,讓改變在init.ora文件生效
5.使用DBMS_XDB_CONFIG.SETHTTPSPORT設(shè)置em的https端口,
將會(huì)更新xdbconfig.xml里的https端口
(不管設(shè)置成什么端口號(hào),都不能與本服務(wù)器其他服務(wù)端口沖突)
設(shè)置non-CDB https端口
conn sys / as sysdba; sql>exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);
設(shè)置CDB https端口
conn sys / as sysdba; sql>alter session set container=CDB$ROOT; sql>exec DBMS_XDB_CONFIG.SETHTTPSPORT(5501);
設(shè)置PDB https端口
conn sys / as sysdba; sql>alter session set container=PDB1; sql>exec DBMS_XDB_CONFIG.SETHTTPSPORT(5502);
使用下面的命令確認(rèn)注冊在監(jiān)聽上的端口
$lsnrctl status| grep -i 5502
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=hostname.example.com)(PORT=5502)
)(Security=(my_wallet_directory=/$ORACLE_BASE/admin/sid/xdb_wallet))
(Presentation=HTTP)(Session=RAW))
訪問em,根據(jù)端口號(hào)區(qū)別要連接到的是non-CDB,CDB,PDB
https://database-hostname:portnumber/em/
登錄進(jìn)去的用戶是做為dba權(quán)限的
文檔鏈接:
http://docs.oracle.com/database/121/ADMQS/GUID-EB851101-07BE-4038-BB9D-06E01CC7F5D5.htm#ADMQS032
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。