By default, AWS CLI or PowerShell AWS cmdlets only list EC2 resources from your default region. You need to specify a region to see what services are there or a profile created with AWS CLI's configuration which contains a different region. Within the AWS Management Console, you can use "EC2 Global View" to list all … Continue reading PowerShell getting AWS instances from all regions
Connecting (SSH) to Linux instance in Cloud
After a Linux compute instance is created in Cloud (for example in GCP or OCI), you can connect it either using a web browser (SSH-in-browser) provided by the cloud console or using the cloud shell. No matter which way you use, the GCP or OCI will generate key pairs and transfer the public key to … Continue reading Connecting (SSH) to Linux instance in Cloud
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
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
SQL Patch fails — Archived Patch Directory Is Empty — sqlpatch_invocation.log
When patching Oracle database, some patches need to update database objects. A SQL patch is a patch that contains SQL scripts which need to be run after OPatch completes. In Oracle 12c, Oracle has introduced a new tool named "datapatch" which enables automation of post-patch SQL actions for RDBMS patches. It's called by OPatchAuto usually. … Continue reading SQL Patch fails — Archived Patch Directory Is Empty — sqlpatch_invocation.log
Retrieve password configured within mRemoteNG
mRemoteNG is a popular and handy tool for people managing connections to multiple servers with tabs no matter the connection types are ssh, or rdp, or http/https etc. Usually for a connection, you will configure username & password along with the host/IP information so that you don't need to enter a user name and its … Continue reading Retrieve password configured within mRemoteNG
bash (sh): Operation not permitted
Ran into an issue on another day when login as a normal user on an Oralce Linux 8 system. Once login, there were messages on the screen like /bin/sh: /usr/libexec/grepconf.sh: Operation not permitted It looks like loading the user's shell profile which failed to exeute this script. It didn't really affect what I was doing, … Continue reading bash (sh): Operation not permitted
JoeLi's TechLife 