3.5.5 Configuring Wallet Information

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

• 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.
• Configuring a Wallet in a Full Development Environment
  Configure wallet settings a full development environment on the Instance Settings page.
• Configuring a Wallet in a Runtime Environment
  Configure wallet settings a runtime environment by starting SQL*Plus and running the following SQL statements.
• Determining Wallet Settings in a Runtime Environment
  Configure wallet settings in a runtime environment by starting SQL*Plus and running the following SQL statements.

3.5.5.1 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:

1. The database administrator must create a wallet on the APEX database instance.

2. 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 Database Enterprise User Security Administrator's Guide
• About Working with SSL Enabled Web Services in Oracle APEX App Builder User’s Guide

3.5.5.2 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:

1. Sign in to Administration Services.
2. Click Manage Instance.
3. Under Instance Settings, click Instance Settings.
4. Click Wallet.
5. Under Wallet:
   1. Wallet Path - Enter the path on the file system where the wallet is located using the following format:
      file:directory-path

      See field-level Help for examples.

   2. Password - Enter the password needed to open the wallet. Select Check to confirm that you wish to change the wallet password to indicate that you have changed the password.
6. Click Apply Changes.

3.5.5.3 Configuring a Wallet in a Runtime Environment

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

To specify wallet settings in a runtime environment:

1. Start SQL*Plus and connect to the database where APEX is installed as SYS. For example:

   • On Windows:

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

   • On UNIX and Linux:

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

2. 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 3-3 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.

See Also:

SET_PARAMETER Procedure in Oracle APEX API Reference

3.5.5.4 Determining Wallet Settings in a Runtime Environment

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

To determine wallet settings in a runtime environment:

1. Start SQL*Plus and connect to the database where APEX is installed as SYS. For example:

   • On Windows:

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

   • On UNIX and Linux:

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

2. Run the following statement:

   SELECT 
   APEX_INSTANCE_ADMIN.GET_PARAMETER(PARAMETER_NAME) 
   FROM DUAL;
   

   For a description of wallet parameters, see Table 3-3.

See Also:

SET_PARAMETER Procedure in Oracle APEX API Reference