MoidIITDocID-610: How to apply 19c patches on GI and RDBMS home (April 2022)? --Arshia Jabeen

 Click here for the document.

Moid

MoidIITDocID-606: Script to check tablespace usage - tbs0.sql

Click here for tbs0.sql

Moid Muhammad

MoidIITDocID-605: Script to purge Archivelogs in Linux

Click here for the link

Moid Muhammad

MoidIITDocID-604: Script to monitor mount points on Linux --Moid

 

See monitor_mountpoints.sh

Moid Muhammad

MoidIITDocID-601: Database Migration using Transportable tablespace (AIX to Linux) - Database Migration Steps (rough notes) --Moid

Click here for the document. 

Note that this is the first draft of the notes. I will be making it clean as time permits. You can see Oracle Doc ID 2471245.1 for more details. 

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