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
Month: June 2022
PowerShell checking file hash
PowerShell has a function Get-FileHash to compute the hash value for a file by using a specified hash algorithm. For example, to calculate SHA1 hash code for a file: Get-FileHash -Path "D:\Software\test.ovf" -Algorithm SHA1 You can also check other algorithms like MD5, SHA256 etc. PS D:\Software> Get-Command Get-FileHash CommandType Name Version Source ----------- ---- ------- … Continue reading PowerShell checking file hash
PowerShell with GCP — Google Cloud Platform
Google Cloud SDK provides libraries and tools for interacting with Google Cloud products and services. It includes Google Cloud Command Line Interface (gcloud CLI) for various platforms like Linux, Windows, MacOS. On Windows, you can even use PowerShell to manage GCP because the SDK has dozens of cmdlets for this purpose. To install the SDK … Continue reading PowerShell with GCP — Google Cloud Platform
PowerShell — Get-Content slow?
In PowerShell, the cmdlet Get-Content is used to read a file. Usually you just give the path of a file name as below: Get-Content -Path "c:\temp\test.txt" When the file is small, you won't notice anything wrong. But when it's quite big with thousands of lines, you might notice it's extremely slow to display. This is … Continue reading PowerShell — Get-Content slow?
PowerShell on Linux
When working in a heterogeneous envrionment with different types of OS (Windows, Linux etc.), you probably want to manage systems from a central place. People usually have a RDP session of Windows, then using a multi connection manager like mRemoteNG to connect those systems. To automate your tasks with scripts, you want them fired from … Continue reading PowerShell on Linux