Document for Students Only: How to create a new schema and load tables? --Moid

Click here for the document.

Moid

URL for Oracle GoldenGate Documentation Library --Moid

Click here for the document.

Moid

My notes on vi editor --Moid

Click here for the document

Moid

How to disable SELinux? --Moid

Click here for the document.

Moid

How to change IP Address of Linux Server (from GUI)? --Moid

Click here for the document.

Moid

MIITDocID-869: How to check the Oracle hidden parameter value? --Moid

Click here for the document.

Moid

Task-391 How to create a READ-ONLY user and how to create an ADMIN user in Oracle?--Moid

Task # 391:

391-A) Please create a Read-Only User called Scott_MM_iuser. This user should be able to read all tables from SCOTT schema.

391-B) Please create a Admin user called Scott_MM_Admin. This user should be able to perform all administrative tasks (Read, Write, Update, Insert) on all tables owned by SCOTT.

Click here for the document.

Note: Before I enable this document, reply with your technical steps that you think will accomplish the above tasks.

--Moid

MIITDocID-927: How to load scripts into the database? --Moid

Click here for the document.

Moid

MIITDocID-920: How to check the size of every schema in Oracle database? --Moid

Click here for the document.

Moid

MoidIITDocID-507: How to deinstall (uninstall) 12c database home from Linux? --Moid

Click here for the document.

Moid

List few basic Dynamic Data Dictionaries views for DBA --Moid

Click here for the document.

Moid

My notes on Oracle Data Dictionary tables for DBA --Moid

Click here for the link.

Moid

MoidIITDocID-:635: Are you a New DBA? How to be prepared for first Day to first few weeks? --Moid

Click here for the document.

Moid

How to check oracle objects owned by different schema? --Moid

Click here for the document.

Moid

MIITDocID-982: How to create mount point in Linux? --Moid

Click here for the document.

Moid

Oracle CASE And DECODE Example -- Moid

Click here for the document.

Moid

MoidIITDocID-859: My notes on Oracle SQL formatting --Moid

Click here for the details.

Moid

12c Cloud Control - How to add database in 12c Cloud Control (OEM)?

Click here for the document.

Moid Muhammad

MIITDocID-852: How to spool SQL output to a file? --Moid

Click here for the document.

How to check number of processors on Linux Server? --Moid

Click here for the document.

Moid

How to check Oracle Database uptime? --Moid

Click here for the document.

Moid

MIITDocID-994: How to disable / drop Oracle redo log thread? --Moid

Click here for the document.

Moid

My queries on Oracle connection count --Moid

Click here for the document.

Moid

MIITDocID-882: How many permissions are assigned to a USER or ROLE?

Click here for the document.

Moid

MIITDocID-852: How to extract synonym's DDL from an Oracle schema? --Moid

Click here for the document.

Moid

How to verify Oracle Database Patchset? --Moid

Click here for the document

--Moid Muhammad




Keywords:
opatch,
patch version,
opatch version,
patcheset version

My notes on Oracle High Availability Services (OHAS) --Moid

Click here for the document.

Moid 

MIITDocID-937: How to check the status of RMAN backup? --Moid

Click here for the document.

Moid

Performance Tuning: How does the optimizer know about stale or missing statistics on the table? --Moid

Click here for the document.

Moid

Sessions: How to count number of sessions connected to Oracle database? --Moid

Click here for the document.

Moid

MIITDocID-871: How to install Oracle 12c R1 Client on Windows 8/10? --Moid

Click here for the document.

Moid

Performance Tuning: My notes on Library Cache --Moid

Click here for the details.

Moid

How to move all oracle datafiles to a new directory? --Moid

Click here for the document.

Moid

My notes on Grid Control Agent --Moid

Click here for the document.

Moid

MoidIITDocID-530: How to find Top 10 current SQLs by elapsed time and check their explain plan? --Moid

Click here for the document.

Moid

What features of Oracle database are in use? --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 24 [How to Manage Cluster Resources using HAS] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 25

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 23

Click here for the link.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 22 [Install 12c R1 Datababase Software (Part-2)] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 21 [Install 12c R1 Database (Part-1)] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 20 [Download and Unzip 12c R1 Database Software] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 19 [Create Diskgroups from sqlplus prompt] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 18 [Install Grid Infrastructure (Part-2)] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 17 [Install Grid Infrastructure (Part-1)] --Moid

Click here for the document

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 16 [Download and unzip 12c Grid Infrastructure software] --Moid

Click here for the document. 

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 15 [Permissions] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 14 [Create and load ASM Disks] --Moid

Click here for the document

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 13 [Configure oracleasm] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 12 [Download and install ASMLib packages] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 11 [Create Partitions for ASM] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 10 [Add Hard Drive for ASM] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 9 [Oracle Software Prereq] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 8 [Create grid User] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 7 [Create oracle User] --Moid

Click here for the document.

--Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 5 [Add Disk for Oracle software Installation] --Moid

Click here for the document.

--Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 6 [Create partitions for Oracle Mount points and label them] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 7.2 - Part 4 [CentOS 7.2 OS Installation] --Moid

Click here for the document

Moid

Standalone 12c Grid Infrastructure install on CentOS 7.2- Part 3 [Setup VMWare] --Moid

Click here for the document. 

Moid

Standalone 12c Grid Infrastructure install on CentOS 7.2 - Part 2 [Preparation] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 1 [Main Document -- How to setup ASM database on VMWare? --Moid

Click here for the document.

--Moid

MIITDocID-909: How to take VMWare snapshot (from VMWare Server)? --Moid

Click here for the document.

Moid

How to create softlink? --Moid

Click here for the document.

--Moid

MoidIITDocID-545: How to restore archivelogs from RMAN Backup? --Moid

Click here for the document.

--Moid

MIITDocID-953: How to create a data pump directory? --Moid

Click here for the document.

--Moid

MoidIITDocID-510: How to take a one time database backup to a different location (without changing existing RMAN configuration)? --Moid

Click here for the document.

--Moid

MoidIITDocID-520: My notes on RAC failover testing --Moid

Click here for the document.

--Moid

MoidIITDocID-535: My notes on Oracle Materialized Views --Moid

Click here for the document.

--Moid

MIITDocID-861: How to transfer files from Linux to Windows using WinSCP? --Moid

Click here for the document.

--Moid

RMAN: RMAN Format Specs --Moid

Click here for the document.

--Moid

Linux: How to disable firewall for Linux Oracle Database server? --Moid

Click here for the document.

--Moid

MIITDocID-888: How to unexpire an Oracle user? --Moid

Click here for the document.

--Moid

Data Guard: My queries on Oracle Data Guard --Moid

Click here for details.

--Moid

RAC: How to restart a node in RAC Cluster? --Moid

Click here for the document.

--Moid

Performance Tuning: How to SQL Trace your own sessions in Oracle? --Moid

Click here for the document.

--Moid

RAC: How to unregister database from OCR after dropping it from dbca? --Moid

Click here for the document.

--Moid

MIITDocID-877: Data Guard: My queries on Oracle Data Guard --Moid

Click here for the link.

--Moid 

Linux Network -- How to restart network interface? --Moid

Click here for the document.

--Moid

Performance Tuning: How to identify sessions that has trace enabled? --Moid

Click here for the document.

--Moid

Performance Tuning: My notes on 11g Automatic Statistics Collection (DBMS_STATS) --Moid

Click here for the document.

--Moid

MIITDocID-914: My notes on Undo Tablespace --Moid

Click here for the document.

--Moid

TNS -- How to create a TNS Entry (Database Address / Connect Identifier) on the Oracle Client Machine using netca?

Click here for the document.

--Moid

MIITDocID-907: My notes on Oracle Alert log file --Moid

Click here for the details.

--Moid

MIITDocID-935: How to Audit an Oracle user in 11g? --Moid

Click here for the document.

--Moid

MIITDocID-893: How to create database manually using OMF (Oracle Managed Filesystem) method? --Moid

Click here for 19c document.

Click here for 12c document.

Click here for 10g or 11g document

--Moid

MIITDocID-881: What object level permission are given to a Role? --Moid

Click here for the document.

--Moid

MIITDocID-879: What Roles and Privileges are given to a User? --Moid

Click here for the document.

--Moid

MIITDocID-891: My notes on Oracle Profiles --Moid

Click here for the document.

--Moid

MIITDocID-880: What object level permission are given to an oracle user? --Moid

Click here for the document.

--Moid

MIITDocID-936: What privileges are given to a Role? --Moid

Click here for the document.

--Moid

How to extract DDL of a Stored Procedure? --Moid

Click here for the document.

--Moid

One Oracle home or multiple Oracle homes [Proposal for new database] --Moid

Click here for the document.

--Moid

How to truncate all tables in a schema? --Moid

Click here for the details.

--Moid

How to monitor export import --Moid

Click here for the document.

--Moid

RMAN: How to monitor RMAN Backup and Restores? --Moid

Click here for the details.

--Moid

How to transfer Putty connections to other putty session? --Moid

Click here for the document.

--Moid



Keyword:
Virtual Terminal
Virtual Putty

My notes on active and Inactive Oracle Database sessions --Moid

Click here for details.

--Moid

MIITDocID-906: My notes on Oracle Startup and Shutdown --Moid

Click here for details.

--Moid

MoidIITDocID-908: My notes on Oracle Parameters (Static Vs Dynamic) --Moid

Click here for the details.

--Moid

MoidIITDocID-501: How to check last password change date of a user? --Moid

Click here for the document.

--Moid