Author: Joe Li

Troubleshooting SSH slow login

In another post I wrote before, slow SSH login issue -- after you enter the username, it takes some time (a minute or a few) to show the password prompt, could be due to the wrong DNS configuration. And there is a configuration option UseDNS for sshd and by default it's enabled (value yes) which … Continue reading Troubleshooting SSH slow login

Another reason for verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

In another post I wrote some time ago, I ran into the error ORA-20001 during the datapatch of a 19c upgrade. I got the same error but with a different reason this time: temp data files missing due to OS changes. So we moved a 12c datatabase from Oracle Linux 6 to Oracle Linux 8 … Continue reading Another reason for verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

BASH auto complete doesn’t work? Watch out the mount option “noexec”

BASH is one of popular shell environment on Linux OS. And when using it, everyone loves the auto complete feature, you just tab after you enter first few letters and BASH will match commands/files for you. However, a few weeks ago when I went into a newly staged Oracle Linux 8 system with some kind … Continue reading BASH auto complete doesn’t work? Watch out the mount option “noexec”

Could not open file /var/log/sssd/sssd.log –Permission denied

This was the exactly the same problem I ran into before on auditd. The log directory for sssd was recreated somehow but the context of SELinux was not restored. That caused even root could not create the sssd logs under the directory and the service could not start. sssd[sssd][17594]: Could not open file [/var/log/sssd/sssd.log]. Error: … Continue reading Could not open file /var/log/sssd/sssd.log –Permission denied

RollbackSession failed in system modification phase — Archive not rolled back

When patching a 19c database, I ran into an issue when it's trying to roll back the old OJVM patch and applying the newer one. UtilSession failed: RollbackSession failed in system modification phase... 'Archive not rolled back /opt/oracle/190000/.patch_storage/33561310_Jan_5_2022_08_13_10/files/lib/libserver19.a/joxwtp.o to /opt/oracle/190000/lib/libserver19.a... ' OPatch failed with error code 73 It's strange because I could see the backup … Continue reading RollbackSession failed in system modification phase — Archive not rolled back

verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

Ran into a different issue with Oracle 19c datapatch again. The error was: [oracle@joedb OPatch]$ ./datapatch -verbose SQL Patching tool version 19.14.0.0.0 Production on Thu Jun 2 19:35:49 2022 Copyright (c) 2012, 2021, Oracle. All rights reserved. Log file for this invocation: /opt/oracle/cfgtoollogs/sqlpatch/sqlpatch_74090_2022_06_02_19_35_49/sqlpatch_invocation.log Connecting to database...OK Gathering database info...done Bootstrapping registry and package to current … Continue reading verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table