Techgoeasy

How To Retrieve Instance Metadata from Server

We can retrieve Instance Metadata like OCID, Display Name, Region, Availability Domain, Fault domain, Compartment OCID, Instance shape, Subnet CIDR, etc in three ways. Using oci-metadata #oci-metadata Instance details: Display Name: tech Region: uk-london-1 Canonical Region Name: us-ashburn-1 Availability Domain: DSdu:US-ASHBURN-1-AD-3 Fault domain: FAULT-DOMAIN-1 OCID: ocid1.instance.oc1.us-ashburn-1.abwgiljrfu6w22gihsxj4h6m6ybabv3mb23edmqhj4kamvv2sdodk7voplfq Compartment OCID: ocid1.compartment.oc1..aaaaaaaamlbsubwajqyvzyrqas6e6sbl3iqp55u6yloyxmg4muaks5xvxbuq Instance shape: VM.Standard2.1 Image ID: ocid1.image.oc1.uk-london-1.aaaaaaaavrftjg3fa2uw5ndqin3tjme3jc4vpxnsysoxetlswsr6aqlfwurq …

How To Retrieve Instance Metadata from Server Read More »

How to generate tkprof in EBS in 19c

Oracle, Oracle Ebuisness Suite

EBS R12 is supported in Multitenant mode for Oracle Database 19c. If you try to generate a tkprof to report explain plan generation on the Database, you will receive errors for the Invalid username /password in the trace file generated tkprof test.trc test.txt sys=no explain=apps/apps sort=prsela,exeela,fchela The reason for this is that the apps is …

How to generate tkprof in EBS in 19c Read More »

RSYNC command – sync the data between two directories

Unix command and scripts

Here in this post, I would be giving the basics on the RSYNC command and how to use it effectively to sync the directories/code Introduction I have to sync up the two directories many times on Unix boxes. The simple steps would be to delete the directory from the destination and take a backup of …

RSYNC command – sync the data between two directories Read More »

Sed command

Unix command and scripts

sed command is a powerful Linux command and it is useful in many cases while dealing with data, and inputs in the Unix operating system. In this post, we will be looking at the sed command in the Unix example, the sed replace command, how to delete with sed command and other few cases. Introduction …

Sed command Read More »

How are the histograms generated in Oracle

Oracle, Oracle Database

Histograms are generated in Oracle by using the method_opt parameter in the dbms_stats procedure method_opt syntax FOR ALL [INDEXED | HIDDEN] COLUMNS [size_clause] FOR COLUMNS [column_clause] [size_clause] size_clause is defined as size_clause := SIZE {integer | REPEAT | AUTO | SKEWONLY} column_clause is defined as column_clause := column_name | extension name | extension – integer : …

How are the histograms generated in Oracle Read More »

How to Enable Telnet For Windows for MSCA

Oracle, Oracle Ebuisness Suite

The telnet client is used to connect to the MWA server in EBS. Windows has telnet installed by default but it is often disabled. If you use Start > Run > telnet and the program is not found, then telnet is disabled. In this post, we will check how we can enable it How to …

How to Enable Telnet For Windows for MSCA Read More »