EXACC:Database preupgrade checks fails with error-[DBAAS-13019] - The TDE wallet of the following database(s) is not properly set to autologin: <DB NAME>.
(Doc ID 2897651.1)
Last updated on NOVEMBER 16, 2022
Applies to:
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and laterInformation in this document applies to any platform.
Symptoms
DB prechecks is failing with TDE validation errors as preupgrade steps is looking for nodes 3 and 4, which are already deleted successfully from the cluster through UI.
Currently this is 2 node cluster.
[root@<NODE4> ContentsXML]# olsnodes -s -t
<NODE1> Active Pinned
<NODE2> Active Pinned
//precheck failures
INFO : Collection of Pre-Upgrade diagnostics PASSED
INFO : Running Pre-Upgrade check for TDE wallet in autologin mode...
INFO : Validating TDE wallet configuration in node <NODE1>...
INFO : Validating TDE wallet configuration in node <NODE2>...
INFO : Validating TDE wallet configuration in node <NODE3>...
INFO : Validating TDE wallet configuration in node <NODE4>...
[FATAL] [DBAAS-13019] - The TDE wallet of the following database(s) is not properly set to autologin: <DBNAME>.
CAUSE: The TDE wallet is not properly configured or errors were detected on its configuration.
ACTION: Verify the logs at /var/opt/oracle/log/<DBNAME>/dbupgrade/dbupgrade_2022-09-<Timestamp>.log and try again.
//From dbupgrade_2022-09-19_11_3A22_3A41.96248913640.log
EOF run on <NODE2> is:
2022-09-19 11:25:10.987979 - DBAAS CLI version 22.2.1.1.0
Executing command tde status
TDE is configured on this instance with:
keystore login: auto
keystore status: <open>
keystore type: autologin
Checking wallet consistency.
Master keys compared successfully.
2022-09-19 11:25:10.996423 - cmd took 24.1607871055603 seconds
2022-09-19 11:25:11.014064 - INFO : Validating TDE wallet configuration in node <NODE3>...>>>>>>>>>>>
2022-09-19 11:25:11.023309 - Output from cmd sudo su <
EOF run on <NODE3> is:
2022-09-19 11:25:14.221872 - cmd took 3.18738389015198 seconds
2022-09-19 11:25:14.230278 - WARN : non-zero status returned
Command: sudo su <
EOF
Exit: 255
Command has no output
2022-09-19 11:25:14.246630 - ERROR : An error occurred during the validation of the TDE configuration in node <NODE4>:
2022-09-19 11:25:14.254288 - INFO : Validating TDE wallet configuration in node <NODE4>...>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2022-09-19 11:25:14.261614 - Output from cmd sudo su <
EOF run on <NODE4> is:
2022-09-19 11:25:17.486023 - cmd took 3.21687006950378 seconds
2022-09-19 11:25:17.494370 - WARN : non-zero status returned
Command: sudo su <
EOF
Exit: 255
Command has no output
2022-09-19 11:25:17.511860 - ERROR : An error occurred during the validation of the TDE configuration in node <NODE1>:
2022-09-19 11:25:17.519530 - [FATAL] [DBAAS-13019] - The TDE wallet of the following database(s) is not properly set to autologin: <DBNAME>.>>>>>>
CAUSE: The TDE wallet is not properly configured or errors were detected on its configuration.
ACTION: Verify the logs at /var/opt/oracle/log/<DBNAME>/dbupgrade/dbupgrade_2022-09-19_11:22:41.96248913640.log and try again.
2022-09-19 11:25:17.527852 - INFO : Running Pre-Upgrade check for EM Database Control repository...
2022-09-19 11:25:17.535653 - INFO : Pre-Upgrade check for EM Database Control repository PASSED
2022-09-19 11:25:17.547756 - DEBUG: SQL Executing set hea off set pagesize 5000 set linesize 400 set newpage none set feedback on prompt =START= select DEST_NAME from v$archive_dest where status = 'VALID' and target = 'STANDBY'; quit
2022-09-19 11:25:17.968167 - INFO : Running Pre-Upgrade check for the SPFILE pointer integrity...
//From /var/opt/oracle/log/<DBNAME>/update/update_2022-09-20_08\:49\:35.339599242085.log
2022-09-20 08:49:37.596511 - Calling srvctl config database <DBNAME>
2022-09-20 08:49:37.599453 - Output from cmd export ORACLE_HOME=/u02/app/oracle/product/12.2.0/dbhome_1; /u02/app/oracle/product/12.2.0/dbhome_1/bin/srvctl config database -d fra16r_<DBNAME> | grep "Configured nodes:" run on localhost is:
2022-09-20 08:49:39.090374 - Configured nodes: <NODE1>,<NODE2>
2022-09-20 08:49:39.092986 - cmd took 1.48229694366455 seconds
2022-09-20 08:49:39.096992 - Done srvctl config database f<DBNAME>
2022-09-20 08:49:40.446259 - Output from cmd /var/opt/oracle/ocde/rops get_creg_key <DBNAME> nodelist run on <NODE1> is:
2022-09-20 08:49:41.242639 - <NODE1> <NODE2> <NODE3> <NODE4>
2022-09-20 08:49:41.245621 - cmd took 0.793187856674194 seconds
2022-09-20 08:49:41.249854 - ERROR: <DBNAME> configured nodes in srvctl and creg nodelist in <NODE1> does not match and correcting
2022-09-20 08:49:41.905458 - Output from cmd /u01/app/19.0.0.0/grid/bin/olsnodes -n run on localhost is:
2022-09-20 08:49:43.011196 - <NODE1> 1
//From creg.ini file is updated correctly.
"nodelist=<NODE1> <NODE1>"
//Environment details
]# rpm -qa --last | egrep -i 'dbaastools_exa|dbcs'
dbaastools_exa-1.0-1+22.2.1.1.0_220713.1149.x86_64 Sat 30 Jul 2022 12:12:55 PM CEST
dbcs-agent-update-exacc-22.2.1.1.0-220713.1149.x86_64 Sat 30 Jul 2022 12:11:41 PM CEST
dbcs-agent-exacc-2.8OL7-21.1.1.3.0_210630.1055.x86_64 Sun 15 Aug 2021 06:15:05 PM CEST
Changes
Deleted 2 nodes in cluster out of 4 nodes through UI and Deletion workflow is completed successfully with out any issues.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |