oracle19c启用em控制台管理

从oracle12c开始em控制台只需简单启用即可。不过19c em只能查看性能页,而12c的em包括配置,用户所有功能都可以操作。精简掉太多功能了。

[[email protected] ~]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 2 12:15:12 2019
Version 19.5.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> select dbms_xdb_config.gethttpsport FROM DUAL;

GETHTTPSPORT
------------
           0

SQL> show parameter dispatchers;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dispatchers                          string      (PROTOCOL=TCP) (SERVICE=cisdbX
                                                 DB)
max_dispatchers                      integer
SQL> show parameter listen;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
forward_listener                     string
listener_networks                    string
local_listener                       string       (ADDRESS=(PROTOCOL=TCP)(HOST=
                                                 192.168.52.152)(PORT=1521))
remote_listener                      string       rac-scan:1521
SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);

PL/SQL procedure successfully completed.

SQL> select dbms_xdb_config.gethttpsport FROM DUAL;

GETHTTPSPORT
------------
        5500

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.5.0.0.0
[[email protected] ~]$  lsnrctl status | grep -i 5500
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=rac1)(PORT=5500))(Security=(my_wallet_directory=/oracle/app/oracle/product/19c/dbhome_1/admin/cisdb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
[[email protected] ~]$ cd /oracle/app/oracle/product/19c/dbhome_1/admin/cisdb
[[email protected] cisdb]$ ls -l
total 0
drwxr-xr-x 2 oracle asmadmin 44 Nov 14 14:24 xdb_wallet
[[email protected] cisdb]$ cd xdb_wallet/
[[email protected] xdb_wallet]$ ls -l
total 8
-rw------- 1 oracle asmadmin 3880 Nov 14 14:24 cwallet.sso
-rw------- 1 oracle asmadmin 3835 Nov 14 14:24 ewallet.p12

如果不修改权限,控制台无法显示登录界面。在两个节点执行下面权限后,再刷新浏览器地址可正常显示:
[[email protected] xdb_wallet]$ chmod 777 *
[[email protected] xdb_wallet]$ ls -l
total 8
-rwxrwxrwx 1 oracle asmadmin 3880 Nov 14 14:24 cwallet.sso
-rwxrwxrwx 1 oracle asmadmin 3835 Nov 14 14:24 ewallet.p12oracle19c启用em控制台管理


oracle19c启用em控制台管理

https://blog.csdn.net/xxzhaobb/article/details/102495959