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

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)

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

MIITDocID-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 the 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

MIITDocID-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

MIITDocID-850: Few Examples of Data Pump IMPORT Commands --Moid

Click here for the document.

Moid

MIITDocID-849: How to export (using Data Pump) a schema using parfile? --Moid

Click here for the document.

Moid

MIITDocID-848: My notes on Oracle Data Pump --Moid

Click here for the document.

Moid

MIITDocID-847: How to Install 12c Oracle Database using silent install (12.1.0.2)? --Moid

Click here for the document.

Moid 

MIITDocID-846: How to build non-ASM 12c Standby database using Oracle Data Guard? --Moid

Click here for the document.

Moid

MIITDocID-845: How to Configure Data Broker for Oracle 12c Standby DB?

Click here for the document.

Moid

MIITDocID-844: My notes on Linux df command --Moid

Click here for document.

Moid

MIITDocID-843: How to add 12c Agent on database server? --Moid

Click here for the document.

Moid

MIITDocID-842: How to verify if Data Guard is created on a database? --Moid

Click here for the document.

Moid

My collection of SQL scripts for Oracle DBAs --Moid

Click here for the document.

Moid

MIITDocID-840: How to truncate all tables in the schema and refresh from data dump .dmp file? --Moid

Click here for the document.

Moid

MIITDocID-838: How to create a connection string using NETCA? --Moid

Click here for the document.

Moid

MIITDocID:837: How to deinstall 12c Oracle Client from Windows 10? --Moid

Click here for the document.

Moid

MIITDocID-836: How to install 12c client on Windows 10? --Moid

Click here for the document.

Moid

MIITDocID-835: How to stop, start, enable, disable firewall on Linux 7 / CentOS 7? --Moid

Click here for the document.

Moid

MIITDocID-833: How to perform manual upgrade of 11g database to 12c? --Moid

Click here for the document.

Moid

MIITDocID-831: How to Install 12c LISTENER using silent install (12.1.0.2)? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-830: How to Install 12c Oracle Database software using silent install (12.1.0.2)? --Moid

Click here for the document.

Moid

MIITDocID-839: How to add host in 12c Cloud Control? --Moid

Click here for the document.

Moid

MIITDocID-829: How to setup Linux 7 Server with gmail using smtp? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-828: How to setup a shell script to run SQL commands? --Moid

Click here for the document.

Moid Muhammad

RMAN Duplicate Database: Main Document --Moid

1. How to duplicate 11g database on remote server using RMAN? --Moid

2.

3.

4.

5.

6.

7.

8.

9.

10

Moid Muhammad

MIITDocID-827: How to duplicate 11g database on remote server using RMAN? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-826: How to download oracle PSU patches directly on server using wget? --Moid

Click here for the document.

Moid Muhammad




Keywords:
*****************
PSU / wget
Error:

Connecting to login.oracle.com||:443... connected.

HTTP request sent, awaiting response... 401 Authorization Required

Authorization failed.

MoidIITDocID-825: How to add SWAP space in Linux? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-824: How to use screen command to attach and detach Linux session? --Moid

Click here for the details.

Moid

How to change oracle's default group from oinstall to dba? --Moid

Click here for the document.

Moid

How to sign up for oracle Support Request (metalink / SR) account? --Moid

Click here for the document.

Moid

How to Upgrade from 12.1.0.1 to 12.1.0.2 with standby in place (High Level Steps)? --Moid

Click here for the document.

Moid

How to migrate from 10g to 12c via data pump on same server (High Level Steps)? --Moid

Click here for the high level steps.

Moid

MoidIITDocID-543: 13c Cloud Control / OEM : How to manually add a host to OEM? --Moid

Click here for the document.

Moid

MoidIITDocID-816: How to create tables using Random Data in Oracle? --Moid

Click here for the document.

Moid