当前位置:   article > 正文

oracle19c启用em控制台管理_oracle 19c em

oracle 19c em

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

[oracle@rac1 ~]$ 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
[oracle@rac1 ~]$  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))
[oracle@rac1 ~]$ cd /oracle/app/oracle/product/19c/dbhome_1/admin/cisdb
[oracle@rac1 cisdb]$ ls -l
total 0
drwxr-xr-x 2 oracle asmadmin 44 Nov 14 14:24 xdb_wallet
[oracle@rac1 cisdb]$ cd xdb_wallet/
[oracle@rac1 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

如果不修改权限,控制台无法显示登录界面。在两个节点执行下面权限后,再刷新浏览器地址可正常显示:
[oracle@rac1 xdb_wallet]$ chmod 777 *
[oracle@rac1 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.p12


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

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/笔触狂放9/article/detail/74587
推荐阅读
相关标签
  

闽ICP备14008679号