Скачать или смотреть How to Create a Wallet in Oracle 19c

Learn how to securely create a wallet in Oracle 19c to store sensitive information such as SSL certificates and keys. Follow this step-by-step guide to ensure your database connections are encrypted and secure.
---
Disclaimer/Disclosure: Some of the content was synthetically produced using various Generative AI (artificial intelligence) tools; so, there may be inaccuracies or misleading information present in the video. Please consider this before relying on the content to make any decisions or take any actions etc. If you still have any concerns, please feel free to write them in a comment. Thank you.
---
In Oracle Database 19c, creating a wallet is a crucial step in ensuring secure communication between clients and the database server, especially when dealing with sensitive data transmissions over the network. A wallet serves as a container for storing authentication and encryption keys, including SSL certificates and private keys. Here's a step-by-step guide on how to create a wallet in Oracle 19c:

Access the Oracle Wallet Manager: The Oracle Wallet Manager is a graphical tool used for managing security credentials on Oracle databases. You can launch it by navigating to the Oracle home directory and locating the owm executable file.

Create a New Wallet: Once the Wallet Manager opens, go to the "Wallet" menu and select "New Wallet." You will be prompted to specify a location and name for the wallet file. Choose a secure location and provide a name for the wallet file, then click "Save."

Set Wallet Password: After saving the wallet, you will be prompted to set a password to protect it. Choose a strong password that meets Oracle's complexity requirements and confirm it.

Generate a Certificate Request (Optional): If you intend to use the wallet for SSL/TLS communication, you may need to generate a certificate request within the Wallet Manager. This step is optional and depends on your specific requirements.

Import Certificates and Keys: If you have existing SSL certificates or keys that you want to use with the wallet, you can import them into the wallet using the Wallet Manager. Navigate to the "Operations" menu and select "Import Trusted Certificate" or "Import User Certificate" as needed.

Save and Exit: Once you have imported any necessary certificates and keys, save the wallet by selecting "Save" from the "Wallet" menu. Then, exit the Oracle Wallet Manager.

Set Wallet Location in Database Configuration: After creating the wallet, you need to specify its location in the database configuration. This typically involves setting the WALLET_LOCATION parameter in the database initialization file (sqlnet.ora) to point to the directory where the wallet file is stored.

Restart the Database: To apply the changes, restart the Oracle database instance to ensure that it recognizes the newly created wallet and its configuration.

By following these steps, you can securely create a wallet in Oracle 19c to store sensitive information such as SSL certificates and keys. This helps ensure that your database connections are encrypted and protected from unauthorized access.