19c em 无法登陆
检查端口配置
[oracle@cat1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jun 9 16:58:11 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> select dbms_xdb_config.gethttpsport FROM DUAL;
GETHTTPSPORT
5500
SQL> show parameter dispatchers;
NAME TYPE VALUE
dispatchers string (PROTOCOL=TCP) (SERVICE=whs1XDB)
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.0.41)(PORT=1521))
remote_listener string catscanip: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
修改权限
[grid@cat1 ~]$ lsnrctl status | grep -i 5500
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=cat1)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/19.3.0/db_1/admin/whs1/xdb_wallet))(Presentation=HTTP)(Session=RAW))
[root@cat1 ~]$ cd /u01/app/oracle/product/19.3.0/db_1/admin/whs1/xdb_wallet
[root@cat1 xdb_wallet]$ ls -l
total 8
-rw------- 1 oracle asmadmin 3880 Nov 24 2020 cwallet.sso
-rw------- 1 oracle asmadmin 3835 Nov 24 2020 ewallet.p12
如果不修改权限,控制台无法显示登录界面。在两个节点执行下面权限后,再刷新浏览器地址可正常显示:
[root@cat1 xdb_wallet]$ chmod 777 *
[root@cat1 xdb_wallet]$ ls -l
total 8
-rwxrwxrwx 1 oracle asmadmin 3880 Nov 24 2020 cwallet.sso
-rwxrwxrwx 1 oracle asmadmin 3835 Nov 24 2020 ewallet.p12