Today we upgraded a 4 node RAC from 11.2.0.3 to 11.2.0.4. Unfortunately, we did not know the database was using encryption and the Oracle Wallet Manager. The users began to notice issues accessing the encrypted table. I ran the below SQL and the status indicated there was an issue:
SQL> select wrl_type wallet,status,wrl_parameter wallet_location from v$encryption_wallet; WALLET STATUS WALLET_LOCATION ------ ------------------ ------------------------ file OPEN_NO_MASTER_KEY /opt/oracle/product/cost
The solution for this was to
back up the sqlnet.ora file in the ora_home_11.2.0.4/network/admin directory On each node of the RAC, copy the sqlnet.ora file from the ora_home_11.2.0.3/network/admin directory to the ora_home_11.2.0.4/network/admin directory bounce the RAC with srvctl commands
I am not sure if a rolling bounce would have resolved the issue or not. We were in a hurry to get the application back into service and hence bounced the database.
