MoidIITDocID-600: How to install Oracle SQL Developer? --Moid

Click here for the document.

Moid

MoidIITDocID-599: Query to get count of in-memory active session history --Moid

 Click here for the document.

Moid

MoidIITDocID-596: How to send email from Linux server? --Moid

Example:

echo "My message" | mail -s subject contactmoid@gmail.com

Click here for the document.

Moid

MoidIITDocID-595: How to redirect nohup to a filename? --Moid

Example:

nohup rman @duplicate_db.rman > duplicate_db_`date +%m-%d-%y_%H%M%S`.log &

tail -f `ls -ltrh | awk '{print $9}' |tail -1`

Click here for the document.

Moid

MoidIITDocID-591: How to trim Oracle Datafile's name in Linux? --Moid

Click here for the document. 

Moid 

keywords:

datafile, substr, trim, separate, file name only

MoidIITDocID-590: How to UPGRADE 11.2.0.4 database to 12.2.0.1 using Data Pump? --Moid Muhammad

How to UPGRADE 11.2.0.4 database to 12.2.0.1 using Data Pump?

Moid Muhammad

Keywords: upgrade, 11g to 12c, 11.2, 12.2, data pump, migration.

MoidIITDocID-588: How to build Oracle 19c R2 standby database using Data Guard on AWS Server? --Nasreen Fatima

Click here for the document.

Nasreen Fatima

MoidIITDocID-587: How to clone oracle 19c database using RMAN to AWS server ? --Nasreen Fatima

Click here for the document

by:
Nasreen Fatima
Oracle DBA
Ajman, UEA

MoidIITDocID-586: How to Build 2-node RAC Cluster using Oracle VM Virtual Box? -Safi Naaz

 Click here for the document.

Safi Naaz

MoidIITDocID-585: How to cleanly terminate AWS instance? --Arshia Jabeen

Click here for the document.

Arshia Jabeen

MoidIITDocID-583: How to Configure Snapshot Standby Database in Oracle 19c? --Arshia Jabeen

Click here for the document.

Arshia Jabeen 
Oracle DBA
Saudi Arabia

MoidIITDocID-582: How to build Oracle 19c R3 standby database using Data Guard? --Safi Naaz

Click here for the document.

Safi Naaz

MoidIITDocID-581: How to exclude Oracle Maintained users in 11g?

To exclude oracle_maintained users in 11g:

select username from dba_users

where username NOT IN (select name from system.logstdby$skip_support)

order by 1;

To list oracle_maintained users in 11g:

select username from dba_users

where username IN (select name from system.logstdby$skip_support)

order by 1;

Hope this helps.

Moid Muhammad

Click here for the document. 

MoidIITDocID-573: How to create 19c R3 database using scripts on Linux? --Moid

Click here for the document

Moid Muhammad 

MoidIITDocID-572: ORA-0 error in alertlog "KILL SESSION for sid"

Click here for the document.

Moid

MoidIITDocID-567: How to install Statspack on Oracle database? --Moid

Click here for the document.

Moid

MoidIITDocID-569: How to upgrade 12c standalone database to 18c using DBUA? -- Sama Muhammad

Click here for the document.

Moid

MoidIITDocID-566: How to create a 19c database using DBCA? --Moid

Click here for the document.


Moid

MoidIITDocID-564: When was the orapassword file user's password changed?

Click here for the document.

Moid

MoidIITDocID-563: How to install 19c client on Windows 10? --Moid Muhammad

Click here to steps on how to install 19c Oracle client on Windows 10.

--Moid


Other links:
Click here for 10g client installation
Click here for 11g client installation
Click here for 12c client installation.
Click here for 18c client installation
Click here for 19c client installation