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

The wallet can also be recreated with :

SQL>conn / as sysdba;

SQL> exec
DBMS_XDB_ADMIN.INSTALLDEFAULTWALLET;
這個(gè)問題在12c以上版本存在。19C上存在該問題。