Configuring Wallet Information

Configure wallet information (which store authentication and signing credentials) for an APEX instance.

Note: If you are using Oracle AI Database 26ai or later, wallet configuration can remain empty. To learn more, see SET_WALLET Procedure in Oracle AI Database PL/SQL Packages and Types Reference

About SSL and Wallet Creation

A wallet is a password-protected container that stores authentication and signing credentials (including private keys, certificates, and trusted certificates) needed by SSL.

Secure Sockets Layer (SSL) is an industry standard protocol that uses RSA public key cryptography with symmetric key cryptography to provide authentication, encryption, and data integrity. When SSL is enabled, https displays in the URL.

You must create a wallet if you:

Call a SSL-enabled URL (for example, by invoking a Web service).
Create a region of type URL that is SSL-enabled.
Configure secure SMTP, by setting the Use SSL/TLS attribute to Yes.
Have applications with LDAP authentication schemes that are configured to use SSL with Authentication.

Overview of Creating a Wallet

To create a wallet:

The database administrator must create a wallet on the APEX database instance.
The instance administrator configures the Wallet attributes on the Instance Settings page to specify the file system path to the wallet and the wallet password (if required).

See Also:

Using Oracle Wallet Manager in Oracle AI Database Enterprise User Security Administrator's Guide
About Working with SSL Enabled Web Services in Oracle APEX App Builder User’s Guide

Configuring a Wallet in a Full Development Environment

Configure wallet settings a full development environment on the Instance Settings page.

To specify wallet settings in a full development environment:

Sign in to Administration Services.
Click Manage Instance.
Under Instance Settings, click Instance Settings.
Click Wallet.
Under Wallet:
1. Wallet Path - Enter the path on the file system where the wallet is located using the following format:
  
  file:directory-path
  
  Examples:
  - Windows-based system:
    
    file:c:\WINNT\Profiles\<username>\WALLETS
  - UNIX-based system:
    
    file:/home/<username>/wallets
2. Auto-login Wallet - Select this option if your Oracle wallet is an auto-login wallet. Auto-login wallets do not require a password to open. If you enable this option, Wallet Password and Confirm Wallet Password are disabled.
3. Wallet Password - Enter the password needed to open the wallet.
4. Confirm Wallet Password - Enter the wallet password again to confirm.
Click Apply Changes.

Configuring a Wallet in a Runtime Environment

Configure wallet settings a runtime environment by starting SQLcl and running the following SQL statements.

To specify wallet settings in a runtime environment:

Start SQLcl and connect to the database where APEX is installed as SYS. For example:

On Windows:

SYSTEM_DRIVE:\ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

On UNIX and Linux:

$ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

Run the following statement:

BEGIN
    APEX_INSTANCE_ADMIN.SET_PARAMETER(PARAMETER_NAME, PARAMETER_VALUE);
    COMMIT;
END;

See the table that follows for a description of wallet parameters.

Table 2 Wallet Parameters

Parameter Name Description

Parameter Name	Description
`WALLET_PATH`	The path to the wallet on the file system, for example: file:/home/`username`/wallets
`WALLET_PWD`	The password associated with the wallet. Use an empty/null value for auto-login wallets.

WALLET_PATH

The path to the wallet on the file system, for example:

file:/home/username/wallets

WALLET_PWD The password associated with the wallet. Use an empty/null value for auto-login wallets.

See Also: SET_PARAMETER Procedure in Oracle APEX API Reference

Determining Wallet Settings in a Runtime Environment

Configure wallet settings in a runtime environment by starting SQLcl and running the following SQL statements.

To determine wallet settings in a runtime environment:

Start SQLcl and connect to the database where Oracle APEX is installed as SYS, for example:

On Windows:

SYSTEM_DRIVE:\ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

On UNIX and Linux:

$ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

Run the following statement:
```
SELECT
APEX_INSTANCE_ADMIN.GET_PARAMETER(PARAMETER_NAME)
FROM DUAL;
```
For a description of wallet parameters, see Table 3-2.

See Also: SET_PARAMETER Procedure in Oracle APEX API Reference