MoidIITDocID-633: How to check the patch level of an oracle database? --Moid

Click here for the document. 

Moid Muhammad

MoidIITDocID-632: How to use tmux (instead of screen) in Linux? --Arshia Jabeen

tmux list-sessions

tmux new-session -s MMpatching

tmux attach-session -t  MMpatching

Click here for the full document

Thanks,

Arshia Jabeen

MoidIITDocID-629: How To Get Table Growth History Information? --Moid Muhammad

Click here for the document.

Moid

table size segment size 

MoidIITDocID-628: How to upgrade 12c database to 19c using Autoupgrade? --Arshia Jabeen

Click here for the link.

by Arshia Jabeen.

Keywords: Moid oracle 19c autoupgrade rac data guard ASM

MoidIITDocID-627: How to upgrade 12c standalone database to 19c using DBUA? --Arshia Jabeen

Click here for the document.

Arshia Jabeen

Keywords: Moid oracle 19c upgrade Arshia 
migration export import data pump tesla MyTravelsPro.com MoidIIT.com

MoidIITDocID-625: How to load Scott Schema in Oracle database? --Arshia Jabeen

Click here for the document,

Thanks,
Arshia Jabeen.

Keywords: create scott schema, run script

MoidIITDocID-624: How to start xclock (GUI tools) after switching user to oracle in Linux? --Moid Muhammad

Click here for the document.

Moid

MoidIITDocID-623: Shell script that loop through tnsnames.ora to execute SQL script in multiple databases --Moid Muhammad

Click here for the document. 

Moid Muhammad

Keywords: .sql run SQL Script multiple databases servers parameter change across 

MoidIITDocID-622: How to schedule sql script on Linux DB server? --Moid Muhammad

Click here for the link.

Moid Muhammad

Keywords:
crontab execute schedule oracle sqlplus 

MoidIITDocID-620: How to register database service to non-default LISTENER port? --Moid

Click here for the document

Moid

Keywords: Oracle Listener on 1733 non-default port Register multiple ports on different listeners.

MoidIITDocID-619: How to register multiple ports to oracle LISTENER? --Moid

Click here for the document.

Moid

Keywords: Oracle Listener 1733 non-default port multiple ports on different listeners.

MoidIITDocID-618: How to move oracle tables to a different tablespace? --Moid

 Click here for the document.

Moid

MoidIITDocID-617: Query to find the non-oracle user maintained tables in SYSTEM tablespace

 Click here for the document.

Moid

MoidIITDocID-616: How to check if TDE or TSE is enabled in Oracle database? --Moid

Click here for the document.

Moid

MoidIITDocID-615: Create trigger to capture failed database login attempts --Moid

Click here for the document.

Moid

MoidIITDocID-614: Why is Oracle DataPump export process slow? --Moid

 Click here for the document.

Moid

MoidIITDocID-613: How to check size of all non oracle_maintained tables and index in oracle database? --Moid

Click here for the document

Moid

MoidIITDocID-612: How to run SQL script in loop? (loop.sql) --Moid

Click here for the document.

Moid 

Keywords: 

loop.sql

Oracle Sqlplus calling sql script repeatedly in a loop

MoidIITDocID-611: How to build two node RAC cluster on Oracle Virtual Box? --Nasreen Fatima

Click here for the link

Nasreen Fatima

Keywords: Build RAC Cluster, 19c

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

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 11.

--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 on Windows 10

Click here for 19c client installation on Windows 11.

MoidIITDocID-562: How to connect to Oracle Database from command line? --Moid

Click here for the document.

Moid

MoidIITDocID-561: How to run SQL script in multiple oracle databases? --Moid

Click here for the document.

Moid

MoidIITDocID-560: How to get the column heading when "no rows selected" in SQL Plus? --Moid

Click here for the document.

Moid

MoidIITDocID-555: How to get SCN from timestamp? --Moid

Click here for the doc.

Moid

MoidIITDocID-555: MoidIIT Database Standards

MoidIIT Database Standards:

MoidIITDocID-552: How to install 18c client on Windows 10? --Moid Muhammad

Click here for the document.

Moid

MoidIITDocID-536: Example of Oracle 12c Patching (July 2018 patching on standlone) --by Wasim Chaudhry

Click here for the document.

Moid

MoidIITDocID-534: How to flush SQL statement from SGA (from shared pool)? --Moid

Click here for the document.

Moid

MoidIITDocID-532: How to check execution plan from the SQLID? --Moid

Click here for the document.

Moid

MoidIITDocID-515: How to Import full database using Data Pump?

Click here for the document. (temporarily disabled)

Moid

https://docs.google.com/document/d/15OwJBfXlaKEDtcQb-RhAWd8_3f0rRBrcbLpP8wpf1Uw/edit#heading=h.hw4mflqycdgx

MoidIITDocID-514: How to setup passwordless ssh between two Linux servers?

Click here for the document.

Moid

MoidIITDocID-513: How to add start x11 application (xclock, dbca etc) after switching user in Linux?

Click here for the document.

Moid Muhammad

MoidIITDocID-511: How to create a manual replication of a database without using data Guard? --Moid

Click here for the document.

Moid Muhammad

MoidIITDocID-508: Apex upgrade to 5.1 by Umer Hussaini

Click here for the document.

Moid

MoidIITDocID-506: How to get remote Support using Teamviewer or Splashtop?

Click here for the document.

Moid

MoidIITDocID-505: How to move datafiles to new location in Oracle 12c? --Moid

Click here for the document.

Moid

MoidIITDocID-502: How to check the DBID of a database? --Moid

Click here for the document.

Moid Muhammad

MoidIITDocID-998: How to Create Oracle ASM Database Server on AWS? --Moid Muhammad

Click here for the document (Version 1.0 from 2019)

Click here for the document (Version 2.0 from 2023)

Click here for the document (Version 3.0 from 2025)

Moid Muhammad

MoidIITDocID-997: How to Restore and Recover Database on a Remote Server (Chicago to NY)?

Click here for 19c document.

Click here for 12c document

Moid

MIITDocID-996: How To Stabilize the Execution plan using SQL PLAN Baseline --Kaleem Mohammed

Click here for the document.

Moid

MoidIITDocID-911: How to Create Oracle Database Server on AWS? --Moid

Click here for the document.

Moid

MIITDocID-995: How to create redo logs going to FRA (Set IS_RECOVERY_DEST_FILE to YES)? --Moid

Click here for the document.

--Moid

Data Redaction

Click here for the document.

Moid

MIITDocID-991: Upgrade Grid Infrastructure 11G to 12C by Zubeen Ansari

Click here for the document.

Moid

MIITDocID-990: Oracle Patching April-15-2016 PSU Patch implementation in RAC environment by Zubeen Ansari

Click here for the document.

Moid

MIITDocID-989: Notes on Data Redaction by Mohammed Omer Afroze

Click here for the document.

Moid

MIITDocID-988: Notes on Oracle Virtual Private Database by Mohammed Omer Afroze

Click here for the document.

Moid

MIITDocID-987: How to convert non cdb 12.1.0.2 to cdb? --Umer Hussaini

Click here for the document.

Moid

MoidIITDocID-980: How to perform schema level Export and Import using DATA PUMP? --Moid

Click here for the details.

Moid

MIITDocID-979: How to install Oracle 12c R2 client on MacBook? --Sama Muhammad

Click here for the document.

Sama Muhammad

MIITDocID-977: How to duplicate 12c database on remote server from ACTIVE Database Duplication?

Click here for the document

Moid

MIITDocID-976: How to duplicate 12c database on remote server from backup rman backup files? --Moid

Click here for the document.

Moid

MIITDocID-975: Who is locking the oracle user? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-974: How to get the hash value of a password in oracle? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-972: My References / notes on Oracle Hints --Moid

Click here for details.

Moid Muhammad

MIITDocID-971: How to set adrci alertlog ORA errors notifications every 30 mins? --Mohammad Kaleemuddin

Click here for the document.

Mohammed Kaleemuddin 

MIITDocID-970: How to find all tables with Primary Keys in a schema? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-966: How to create non-omf 12c database using “create database” command? --Moid

Click here for 12c document.

Click here for the 19c document.

Moid Muhammad

MIITDocID-804: My notes on Oracle Import commands --Moid

Click here for the details.

Moid Muhammad

MIITDocID-948: How to apply Oct 15 2017 RU Patch on Oracle 12.2.0.1 Database Home? --Shoaib Ali

Click here for the document.

Link will be up shortly.

Shoaib Ali

MIITDocID-947: How to extract DDL of Oracle Table? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-944: List of Oracle Data Broker commands --Moid Muhammad

Click here for the document.

Moid Muhammad

dgmgrl

data broker 

18c

19c

21c

standby

data guard

MIITDocID-943: How to build Oracle 12c R2 standby database using Data Guard? --Moid Muhammad

Click here for the document.

Moid Muhammad

MIITDocID-895: How to manually create 12c database with "create database" statement? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-894: How to manually create 12c Oracle Database using OMF? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-890: How to unlock all user accounts in Oracle Database? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-872: How to install Oracle 12c R2 Client on Windows 10?

Click here for the document.

Moid Muhammad

MIITDocID-868: How to Drop a Pluggable Database (PDB) database manually? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-867: How to create Pluggable Database (PDB) database manually? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-866: How to create Container Database (CDB) database manually? --Moid

Click here for the document.

Moid Muhammad

MoidIITDocID-857: How to create Oracle database using scripts? --Moid

Click here for 19c R3 document (Version3.0) 

Click here for 18c R3 document.

Click here for 12c R2 document.


Moid

MIITDocID-856: How to install 12c R2 non-pluggable database using DBCA on Linux? --Moid

Click here for the document.

Moid Muhammad

My notes on building Oracle Data Guard on Oracle 12c? --Umer Hussaini

Click here for the document.

Umer Hussaini

MIITDocID-854: How to find oracle objects with state statistics? --Moid

Click here for the document.

Moid

MIITDocID-852: How to create 12c home and create database using runInstaller? --Moid

Click here for the document.

Moid

MIITDocID-851: My notes on Oracle Synonyms --Moid

Click here for the document.

Moid