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

Related Posts