在GI+DB情况下，19c EM EXPRESS不显示的问题

郑全

Wallet file permissions when RDBMS sits on top of GI with role separation -- This case is only applicable to UNIX platform.

The wallet files should have permission 0600, and that doesn't allow successful display of the EM Express page when RDBMS sits on top of GI with role separation.

The XDB wallet is stored in the $ORACLE_BASE/admin/<db_name>/xdb_wallet directory . If ORACLE_BASE is not defined, the XDB wallet is stored in $ORACLE_HOME/admin/<db_name>/xdb_wallet, where <db_name> is the unique database name.

ls -l would show
-rw------- 1 oracle asmadmin 3926 Jun 28 13:45 cwallet.sso
-rw------- 1 oracle asmadmin 3881 Jun 28 13:45 ewallet.p12

  

changing mode to 640 to allow for group asmadmin to read the wallet files makes the EM Express page available via browser.

chmod 640 $ORACLE_BASE/admin/<db_name>/xdb_wallet

或者

chmod 640 $ORACLE_HOME/admin/<db_name>/xdb_wallet

解决办法：

   chmod 640 $ORACLE_BASE/admin/<db_name>/xdb_wallet/*

The wallet can also be recreated with :

SQL>conn / as sysdba;

SQL> exec DBMS_XDB_ADMIN.INSTALLDEFAULTWALLET;
这个问题在12c以上版本存在。19C上存在该问题。