赞
踩
从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
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。