1、oracle 12c 默认安装后,启动监听及数据库实例orcl后,打开浏览器访问em控制台后,输入用户SYS及密码,以SYSDBA登录后,资源及sql监视模块加载失败,其他模板均可以正常加载
2、出现上述现象的原因是只启动了cdb级别的监视而没有启动pdb级别的监视
3、下面步骤介绍启动pdb级别的监视
a)执行lsnrctl status,查看已启动的监视
b)执行
#sqlplus /nolog
SQL> conn / as sysdba
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBORCL MOUNTED
SQL> alter session set container=pdborcl;
Session altered.
SQL> alter pluggable database pdborcl open;
Pluggable database altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDBORCL READ WRITE NO
SQL> exec DBMS_XDB_CONFIG.SETHTTPPORT(5501);
PL/SQL procedure successfully completed.
SQL>
c)再次执行lsnrctl status可以看到启动了一个5501的监视
d)打开浏览器输入localhost:5501/em登录后,可以看到资源及sql监视模块可以正常加载
阅读(1672) | 评论(0) | 转发(0) |