My notes on Oracle Database Administration -- Moid: 2013

Wednesday, December 4, 2013

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

Click here for the document.

Moid

Tuesday, December 3, 2013

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

Friday, November 29, 2013

My queries on Oracle connection count --Moid

Click here for the document.

Moid

Thursday, November 28, 2013

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

Click here for the document.

Moid

Friday, November 22, 2013

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

Click here for the document.

Moid

Friday, November 15, 2013

How to verify Oracle Database Patchset? --Moid

Click here for the document

--Moid Muhammad

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

Wednesday, November 6, 2013

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

Click here for the document.

Moid

Saturday, November 2, 2013

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

Click here for the document.

Moid

Thursday, October 31, 2013

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

Click here for the document.

Moid

Monday, October 28, 2013

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

Click here for the document.

Moid

Saturday, October 26, 2013

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

Click here for the document.

Moid

Friday, October 25, 2013

Performance Tuning: My notes on Library Cache --Moid

Click here for the details.

Moid

Thursday, October 24, 2013

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

Wednesday, October 23, 2013

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

Click here for the document.

Moid

Tuesday, October 22, 2013

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

Saturday, October 19, 2013

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

Thursday, October 17, 2013

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

Click here for the document.

Moid

Wednesday, October 9, 2013

How to create softlink? --Moid

Click here for the document.

--Moid

Friday, October 4, 2013

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

Click here for the document.

--Moid

Thursday, October 3, 2013

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

Click here for the document.

--Moid

Thursday, September 26, 2013

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

Wednesday, September 25, 2013

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

Click here for the document.

--Moid

Tuesday, September 24, 2013

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

Click here for the document.

--Moid

Saturday, September 14, 2013

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

Click here for the document.

--Moid

Wednesday, August 28, 2013

RMAN: RMAN Format Specs --Moid

Click here for the document.

--Moid

Tuesday, August 6, 2013

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

Click here for the document.

--Moid

Thursday, August 1, 2013

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

Click here for the document.

--Moid

Wednesday, July 31, 2013

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

Tuesday, July 30, 2013

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

Monday, July 22, 2013

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

Click here for the document.

--Moid

Wednesday, July 10, 2013

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

Sunday, July 7, 2013

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

Wednesday, June 26, 2013

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

Click here for the document.

--Moid

Sunday, June 23, 2013

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

Monday, June 17, 2013

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

Click here for the document.

--Moid

Friday, June 14, 2013

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

Click here for the document.

--Moid

Wednesday, June 12, 2013

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

Click here for the document.

--Moid

Tuesday, June 11, 2013

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

Saturday, June 1, 2013

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

Click here for the document.

--Moid

Sunday, May 26, 2013

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

Click here for the document.

--Moid

Wednesday, May 15, 2013

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

Tuesday, May 14, 2013

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

Click here for the document.

--Moid

Keyword:
Virtual Terminal
Virtual Putty

Friday, May 10, 2013

Thursday, May 2, 2013

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

Click here for the document.

--Moid

Thursday, April 25, 2013

MoidIITDocID-641: My queries on SNAPSHOTs from AWR (Automatic Workload Repository) --Moid Muhammad

Click here for the document.

--Moid

Thursday, March 21, 2013

MoidIITDocID-568: How to purge statspack snapshots? --Moid

Click here for the document.

Moid

Wednesday, March 20, 2013

--

--

--Moid

Tuesday, March 19, 2013

MIITDocID-904: How to check the root blocker (blocking session) and kill it? --Moid

Click here for the document.

--Moid

Sunday, March 10, 2013

MoidIITDocID-642: How to solve "WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!"? --Moid Muhammad

Click here for the document.

--Moid

Monday, March 4, 2013

MIITDocID-949: How to extract the DDL (underlying code) from Oracle VIEW? --Moid

Click here for the document.

--Moid

MoidIITDocID-529: How to become Oracle 11g OCA / OCP / OCM Certified? --Moid

Click here for the document.

--Moid

Saturday, March 2, 2013

MIITDocID-879: How to create 11g R2 database using scripts? --Moid

Click here for the document.

To create 12c R2 database using script, click here.

--Moid

How to build 10g RAC on VMware? --Moid

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-20)

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-19)

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-18)

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-17)

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-16)

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-15)

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-14)

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-13)

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-12)

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-11)

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-10)

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-9)

Click here for the link.

--Moid

10g RAC Build on VWMware (Part-8) -- Configure iSCSI Volumes using Openfiler

Click here for the document.

--Moid

10g RAC Build on VWMware (Part-7) -- Add entries in hosts file --Moid

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-6) -- Install Openfiler on VMWare --Moid

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-5) -- Install OEL5 on Node-2 --Moid

Click here for the document.

--Moid

10g RAC Build on VMWare (Part-4) -- Install OEL5 on Node-1 --Moid

Click here for the document.

-- Moid

10g RAC Build on VMWare (Part3) -- VMWare Setup of SAN using openfiler --Moid

Click here for the document.

--Moid

10g RAC Build on VWWare (Part-2) -- VMWare Setup of Node-2 --Moid

Click here for the link.

--Moid

10g RAC Build on VMWare (Part1) -- VMWare Setup of Node-1 --Moid

Click here for the document.

--Moid

Monday, February 25, 2013

MoidIITDocID-645: How to generate ADDM reports? --Moid

Click here for the document.

--Moid

Sunday, February 24, 2013

MoidIITDocID-644: How to generate AWR Report? --Moid

Click here for the document.

--Moid

MoidIITDocID-643: How to generate ASH report? --Moid

Click here for the document.

--Moid

Saturday, February 23, 2013

MoidIITDocID-571: ASCII - Binary Character Table

Click here for the document.

--Moid

GoldenGate: How to uninstall GG from Linux --Moid

Click here for the document.

--Moid

Tuesday, February 19, 2013

MIITDocID-945: How to extract the DDL of a "PACKAGE" from Oracle schema? --Moid

Click here for the document.

--Moid

Monday, February 4, 2013

MIITDocID-905: My notes on Oracle Root Blocker (locks in database) --Moid

Click here for the document.

--Moid

Tuesday, January 15, 2013

How to run a script in other schema as "SYS" user? --Moid

Click here for the documents.

--Moid

Monday, January 14, 2013

How to restart a node in RAC Cluster for OS maintenance? --Moid

Click here for the document.

--Moid

Sunday, January 13, 2013

Presentation on Cache Fusion --Moid

Click here to download the presentation in pdf

Click here for YouTube link (Web Presentation by Arup Nanda)

--Moid

Thursday, January 10, 2013

How to check number of rows in each table of a schema? --Moid

Click here for the document.

--Moid

Monday, January 7, 2013

How to check the object counts are same after export/import? --Moid

Click here for the document.

--Moid

MoidIITDocID-525: How to provide permissions to a user to access OEM (Cloud Control) --Moid

Click here for the document.

--Moid

Friday, January 4, 2013

MIITDocID-875: My notes on Automatic Statistics Collection (AOSC - DBMS_STATS) --Moid

Click here for the document.

--Moid