Configuring Wallet Information

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

If you call a SSL-enabled URL (for example, by invoking a Web service), or create a region of type URL that is SSL-enabled, you must create a wallet. A wallet is a password-protected container that stores authentication and signing credentials (including private keys, certificates, and trusted certificates) needed by SSL.

Topics:

Creating a Wallet
Configuring a Wallet in a Full Development Environment
Configuring a Wallet in a Runtime Environment
Determining Wallet Settings in a Runtime Environment

Creating a Wallet

To create a wallet:

The database administrator must create a wallet on the Oracle Application Express database instance. See "Using Oracle Wallet Manager" in Oracle Database Advanced Security Administrator's Guide.
The Oracle Application Express administrator configures the Wallet section of the Instance Settings page to specify the file system path to the wallet and the wallet password (if required).

Configuring a Wallet in a Full Development Environment

To specify wallet settings in a full development environment:

Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".
Click Manage Service.
Under Manage Environment Settings, click Instance Settings.
Scroll down to Wallet.
In Wallet, enter the path on the file system where the wallet is located using the following format:
```
file:directory-path
```
If a password is required to open the wallet:
1. Enter a password in the Wallet Password field.
2. Select Check to confirm that you wish to change the wallet password.
Click Apply Changes.

Configuring a Wallet in a Runtime Environment

To specify wallet settings in a runtime environment:

Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:
- On Windows:
```
SYSTEM_DRIVE:\ sqlplus /nolog
connect sys as sysdba
```
- On UNIX and Linux:
```
$ sqlplus /nolog
connect sys as sysdba
```
When prompted enter the appropriate password.

Run the following statement:

ALTER SESSION SET CURRENT_SCHEMA = APEX_030200

Run the following statement:
```
BEGIN 
    APEX_INSTANCE_ADMIN.SET_PARAMETER(PARAMETER_NAME, PARAMETER_VALUE);
END;
```
For a description of wallet parameters, see Table: Wallet Parameters.
Wallet Parameters
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.

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.

Determining Wallet Settings in a Runtime Environment

To determine wallet settings in a runtime environment:

Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:
- On Windows:
```
SYSTEM_DRIVE:\ sqlplus /nolog
connect sys as sysdba
```
- On UNIX and Linux:
```
$ sqlplus /nolog
connect sys as sysdba
```
When prompted enter the appropriate password.

Run the following statement:

ALTER SESSION SET CURRENT_SCHEMA = APEX_030200

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