This should be used only for local installations, if you have OCI ATP, wallet should work out of the box.
- Access to the database server
- download the full root certs from the website for Https calls
- upload certs to your database server with SCP or other way
I do know that there is a gitRepo that does a download of all certs there are, however It only worked for my Docker DB instance , not a DB in a VM. Therefore, I have sticked to this manual way.
*** update *** Upbove mentioned gitRepo, does work. However. after create the wallet, the setting should be like this. begin apex_instance_admin.set_parameter('WALLET_PATH' ,'file:/opt/oracle/my_wallets'); apex_instance_admin.set_parameter('WALLET_PWD' ,NULL); commit; end; /
Read here for more. https://docs.oracle.com/en/database/oracle/apex/23.1/aeapi/Available-Parameter-Values.html#GUID-75DCF658-5A76-4E81-B12D-04E254A3D80A search "The password associated with the wallet. Use an empty/null value for auto-login wallets"
!! use user Oracle at all times
$ sudo su - oracle $ cd /opt/oracle $ mkdir my_wallets $ orapki wallet create -wallet /opt/oracle/my_wallets -pwd WalletPasswd123 -auto_login
If error orapki command not found
if you run a different version, the third command can be different. For exmple ../18c/..
$ export ORACLE_SID=XE $ export ORAENV_ASK=NO $ . /opt/oracle/product/21c/dbhomeXE/bin/oraenv
Assume you have SCP the .pem file into /tmp folder
$ orapki wallet add -wallet /opt/oracle/my_wallets -trusted_cert -cert "/tmp/mycer.pem" -pwd WalletPasswd123
Settings in Database
Run this code in SYS
begin apex_instance_admin.set_parameter('WALLET_PATH' ,'file:/opt/oracle/my_wallets'); apex_instance_admin.set_parameter('WALLET_PWD' ,'WalletPasswd123'); commit; end; /
Or setting the wallet in APEX Internal workspace -> manage instance -> instance settings -> wallet
To Download Wallet
I recommand using firefox