Cloud Computing
- Enable Auto-completion for kubectl for Redhat 8
- PowerShell getting AWS instances from all regions
- Connecting (SSH) to Linux instance in Cloud
- PowerShell with GCP — Google Cloud Platform
Linux
- Install sshfs on Oracle Linux 8
- fapolicyd: Error – both old and new rules exist. Delete one or the other
- Oracle Linux 8: Packages OR Modules?
- Permission denied (13) when running an OS script with an Oracle scheduler job
- Installing HAProxy from source on Oracle Linux 8
- HAProxy service Failed with result ‘protocol’
- “clnt_create: RPC: Program not registered” — NFS share a directory on Redhat Linux 8
- sudo not working with wildcard matching?
- Troubleshooting SSH slow login
- reboot, shutdown, halt & systemctl
- BASH auto complete doesn’t work? Watch out the mount option “noexec”
- Ubuntu — Stop constantly blinking WiFi LED
- bash (sh): Operation not permitted
- Can’t login to Ubuntu GUI with correct password
- Linux grep a string within a ZIP file containing multiple files — zgrep or zipgrep?
- XFS filesystem full without an obvious reason?
- RedHat Linux audit log rotation
- Could not open dir /var/log/audit (Permission denied)
- mount CIFS from Linux Tips
- Ext4 file system reserved blocks
- YUM — GPG check FAILED or package no digest
- openssl — create certificate request containing SAN with multiple names
- ssh break out while loop?
- “no hostkey alg” when SSH from Oracle Linux 6 to 8
- Unblocking ICMP Requests on RHEL 7 & 8?
- PowerPath on RHEL7 — disabling native DM-Multipath
- Strange problem with http_proxy environment variable
- Two possible issues when ssh from a secured (FIPS enabled) RH Linux 8 to RHL 6
- Network Initscript and NetworkManager on RHEL 7/OL 7
- SMB(CIFS) does not show all files when mounting a Windows share
- slow login with SSH, SQLPLus, lsnrctl?
- Shrinking an XFS partition
- Firewall on Redhat Linux 7 onwards — firewalld, firewall-cmd
- CIFS share disconnected after NetApp upgraded
- Driver has suspect GRO implementation, TCP performance may be compromised
- Time to move to Oracle Linux for CentOS user?
- Create symbolic link on CIFS share under Linux
- How I fixed a Linux user login issue
- Allow root to login via SSH
- How does systemd maintain the compatibility with SystemV init scripts?
- runlevel returns “unknown” on Oracle Linux 7
- dmesg timestamp
- SSH “timed out waiting for input: auto-logout”
- Wonder where SSH sessions come from?
- A small trick to handle files prefixed with a specify character in BASH
- You are not allowed to access to (crontab) because of pam configuration.
- Show difference of two files side by side?
- SSH session disconectted with “Write Failed: broken pipe”
- Input/output error — Rebooting Linux remotely
- Linux cannot start due to a mistake in fstab?
- CIFS mount : special device does not exist
Oracle
- Switching to SQLcl if you are still using SQLPlus in 2024
- ALL_INDEXES vs DBA_INDEXES what are differences?
- Moving and resizing data files in an Oracle DataGuard environment
- Will DBMS_UTILITY.EXPAND_SQL_TEXT make your life easier?
- Permission denied (13) when running an OS script with an Oracle scheduler job
- Watch out — 19c RMAN retention policy behaviour change
- ‘.patch_storage’ consumes quite some space?
- Another reason for verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table
- RollbackSession failed in system modification phase — Archive not rolled back
- verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table
- SQL Patch fails — Archived Patch Directory Is Empty — sqlpatch_invocation.log
- ORA-16700: The standby database has diverged from the primary database
- AUTO_STATS_ADVISOR_TASK missing after the upgrade causing ORA-20001
- Tracing listener dynamic service registration
- ORA-16766: Redo Apply is stopped
- Listener — Linux Error: 2: No such file or directory
- Unhandled datatype (-25) found in kxsbndinf — capturing bind variables
- Message xxxx not found; No message file for product=RDBMS, facility=ORA
- ORA-20001: Statistics Advisor: Invalid task name for the current user
- ORA-12516 TNS:listener could not find available handler with matching protocol stack
- IMP-00403: Warning: This import generated a separate SQL file “logfilename_sys” which contains DDL that failed due to a privilege issue.
- RMAN-05158: WARNING: Auxiliary (datafile / tempfile) file name conflicts with a file used by the target database
- ORA-00600: internal error code, arguments: [ksvworkmsgalloc: bad reaper] open resetlog fail
- ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks
- ORA-26040: Data block was loaded using the NOLOGGING option
- ORA-12801: error signaled in parallel query server
- ORA-00093: pga_aggregate_limit must be between
- ORA-01033: ORACLE initialization or shutdown in progress with Dataguard
- The home is not clean and cannot be used due to a failed OPatch execution
- Size of a table containing large object columns — clob & blob
- Resize Operation Completed For File# (Doc ID 1982901.1)
- ORA-16038 — when network is slow
- ORA-63999: data file suffered media failure — Oracle shut down by itself
- File ID for temp data files
- DBMS_STATS GATHER_FIXED_OBJECTS_STATS hangs
- SQLPlus spool to multiple files
- ORA-01489 or ORA-22835 when using LISTAGG
- ORA-08102: index key not found, obj# 35775, file 34, block 5830 (2) on a function-based index
- ORA-01878: specified field not found in datetime or interval
- DBMS_LDAP example
- ORA-02085: database link MYDB_LINK connects to MYDB
- Invalid Java Class objects and ORA-29534
- ORA-24247: network access denied by access control list (ACL)
- SQL Patch another example
- oratop – a handy tool to monitor database in real-time
- ORA-16649: possible failover to another database prevents this database from being opened
- ORA-01795 — PARSE ERROR: ospid=17974, error=1795 for statement
- ORA-16033: parameter LOG_ARCHIVE_DEST_2 destination cannot be the same as parameter LOG_ARCHIVE_DEST_1 destination
- ORA-16714: the value of property is inconsistent with the database setting
- Oracle patch apply order matters
- Adding a column with default taking a long time?
- Strange issue PL/SQL: SQL Statement ignored & ORA-00942
- Interesting fact — having space within data file name
- Monitor Temporary Tablespace Usage
- Converting column data type from clob to varchar?
- ORA-19510 & ORA-27044 RMAN duplicate failed on CIFS
- ORA-01244: unnamed datafile(s) added to control file by media recovery
- ORA-01623: log xx is current log for instance xxxx (thread 1) – cannot drop
- ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM]
- PGA_AGGREGATE_LIMIT
- SGA_MAX_SIZE specified is high ORA-00700: soft internal error, arguments: [sms physmem limit]
- Process running with Bequeath (beq) Protocol?
- Delete a snapshot control file?
- Create symbolic link on CIFS share under Linux
- ORA-16624: broker protocol version mismatch detected
- Dynamic Service Registration with IPC protocol?
- Oracle 19c — ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
- little things to pay attention
- Fatal NI connect error 12514 and TNS-12564
- OPatch needs exec option on /tmp
- Rebuilding database from scratch due to an interruption
- ORA-19527: physical standby redo log must be renamed
- ORA-27106: system pages not available to allocate memory
- JDBC Numeric Overflow with SQL error code: 17026
- Which Oracle session is generating redo logs most?
- Monitoring process/session usage in Oracle SE
- Oracle Instant Client installation on Linux
- DB_BLOCK_CHECKSUM vs DB_BLOCK_CHECKING
- Interesting case with ORA-00245
- RMAN doesn’t mark control file/spfile backup obsolete with retention policy set to redundancy
- ODG — ORA-38760 This database instance failed to turn on flashback
- ODG — ORA-16854: apply lag could not be determined
- Things to note in Oracle Initialization Parameter Files
- Oracle startup failure with ORA-00704 ORA-00604
- Large size of trace files from MMON
- Which user to run ADRCI?
- Purging flat (non-XML) text listener log file for ASM, SCAN etc.
- Purging Audit Trail in RAC & ODG with ASM environment
- A subtle detail of outer join
- SchemaSpy — Graphical Database Schema Metadata Browser
- Redo & Standby Redo files created as OMF when duplicating a standby database
- Getting AWR report every hour automatically
- RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
- Disable or add hint for queries you cannot touch the query text
- Buffer Cache Usage for a lob segment if cached
- select sequence NEXTVAL slow?
- Oracle ADR partition full due to large trace files
- ODG broker error: ORA-1005: null password given; logon denied
- ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations
Python
- Managing Windows servers with Rundeck?
- pyenv installation on Oracle Linux 6.10
- Python Virtual Environment
Solaris
VMware
- VM (vmware) hanging after delete snapshots
- Getting SCSI controller information with ESXCLI for VMware disks
Windows
- PowerShell checking file hash
- PowerShell — Get-Content slow?
- PowerShell on Linux
- Retrieve password configured within mRemoteNG
- Return IP from a specific NIC (Network Binding Order) for Windows Server 2016 and above
- Windows turning off network discovery or file and printer sharing activate Public profile for the firewall
- Configure a Windows server as a NTP client
- Get ObjectGUID of Microsoft Active Directory using ldapsearch
- Getting version information from Windows MSI installer
- A side feature from 7zip — deleting file with long file path
- Always looking for an easy life.
- Timing a command on Windows?
JoeLi's TechLife 