Saturday, December 31, 2011

How to Install Oracle 10g on XP? --Moid

Click here for document.

--Moid
Posted by at No comments:

How to uninstall Oracle 11g R2 from Windows 7? --Moid

Click here for the document.

--Moid
Posted by at No comments:

Friday, December 30, 2011

How to Install Oracle 11g R2 on Windows 7? --Moid

Click here for the document.

--Moid
Posted by at 1 comment:

Friday, December 23, 2011

MIITDocID-967: How to change the background color in putty? --Moid

Posted by at No comments:

Thursday, December 15, 2011

How to find Oracle RAC Cluster name? --Moid

Depending on how you set up environment for CRS home in Linux, one of the following can be used to find the cluster name of you RAC environment.

$ORA_CRS_HOME/bin/cemutlo -n
or
$CRS_HOME/bin/cemutlo -n


--Moid
Posted by at No comments:

Thursday, December 1, 2011

How to find large Oracle files in Linux DB Server? --Moid

Click here for the document.

--Moid
Posted by at No comments:

Wednesday, November 30, 2011

How to kill all client connections from an Oracle instance/database? --Moid

Click here for the document.

--Moid
Posted by at No comments:

Monday, November 28, 2011

How to set Date & Time on Linux Servers?

Click here for the document.

--Moid
Posted by at No comments:

Saturday, November 19, 2011

MIITDocID-956: How to Disable archivelog mode? --Moid

Posted by at No comments:

Thursday, November 10, 2011

How to get shorter version of ipconfig? --Moid

Click here for the document

--Moid
Posted by at No comments:

MoidIITDocID-631: Oracle Background processes --Moid

Oracle link

--Moid 
Posted by at No comments:

Tuesday, November 8, 2011

SQL Test Part-1

Click here for the Test.

--Moid


Note: Test is accessible to only my students.
Posted by at No comments:

Wednesday, November 2, 2011

MIITDocID-921: How to find the Oracle Database Size? --Moid

Posted by at No comments:

Sunday, October 30, 2011

Oracle Data Pump Exercise # 10 (How to send datapump exports to multiple mount points?)

Posted by at No comments:

Oracle Data Pump Exercise # 9

Click here for the document.

--Moid
Posted by at No comments:

Oracle Data Pump Exercise # 8

Click here for the document.

--Moid
Posted by at 1 comment:

Oracle Data Pump Exercise # 7

Click here for the document.

--Moid
Posted by at No comments:

Oracle Data Pump Exercise # 11

Click here for the document.

--Moid
Posted by at No comments:

Oracle Data Pump Exercise # 5

Click here for the document.

--Moid
Posted by at No comments:

Oracle Data Pump Exercise # 6

Click here for the document.

--Moid
Posted by at No comments:

Oracle Data Pump Exercise # 4

Click here for the document.

--Moid
Posted by at No comments:

Oracle Data Pump Exercise # 3

Click here for the document.

--Moid
Posted by at No comments:

Oracle Data Pump Exercise # 2

Click here for the document.

--Moid
Posted by at No comments:

Oracle Data Pump Exercise # 1

Click here for the document.

--Moid
Posted by at No comments:

Tuesday, October 25, 2011

Export / Import Exercise-10

Click here for the document.

--Moid
Posted by at No comments:

Export / Import Exercise-9

Click here for the document.

--Moid
Posted by at No comments:

Export / Import Exercise-8

Click here for the document.

--Moid
Posted by at No comments:

Export / Import Exercise-7

Click here for the document.

--Moid
Posted by at No comments:

Export / Import Exercise-6

Click here for the document.

--Moid
Posted by at No comments:

Export / Import Exercise-5

Click here for the document.

--Moid
Posted by at No comments:

Export / Import Exercise-4

Click here for the document.

--Moid
Posted by at No comments:

Export / Import Exercise-3

Click here for the document.

--Moid
Posted by at No comments:

Export / Import Exercise-1 - [How to export database and import one schema into different database?]

Posted by at No comments:

Export / Import - Exercise-2 [How to refresh tables?] --Moid

Posted by at No comments:

Saturday, October 22, 2011

MoidIITDocID-983: DBA Handy Scripts Part-2 [Scripts for Daily DBA activites] --Moid

Posted by at No comments:

Friday, October 21, 2011

MoidIITDocID-941: DBA Handy Scripts Part-1 [Top 10 SQLs]

Posted by at No comments:

Sunday, October 16, 2011

MoidIITDocID-554: My notes on SGA and PGA --Moid

Posted by at No comments:

Saturday, October 15, 2011

MIITDocID-899- My notes on Tablespace and Datafiles --Moid

Posted by at No comments:

Friday, October 14, 2011

VNC Setup for Oracle user in 64-bit CentOS 5.6 --Moid

Click here for the document.

--Moid
Posted by at No comments:

Wednesday, October 12, 2011

10g RAC Commands [srvctl, ocrconfig, crsctl] --Moid

Posted by at No comments:

Tuesday, October 11, 2011

MLC Student's Task List --Moid

Click here for the document.

--Moid
Posted by at No comments:

Saturday, October 8, 2011

MIITDocID-8734: How to SQL Trace other sessions in Oracle? --Moid

Posted by at No comments:

MoidIITDocID-533: My queries on Oracle Wait events --Moid

Posted by at No comments:

Homework (Week-20) RMAN Restore and Recovery of Oracle Databases

Batch Specific Notes:

 Batch-30: Sunday 10/18/15: Class Notes on RMAN settings and Management.
Batch-30: Saturday 10/24/15: Class Notes on RMAN restore

RMAN Tasks:

Create database using scripts -- Class Notes-1

Setting up RMAN Backup Configuration -- Class notes-2

My notes on RMAN -- Class Notes-3

Testing of Redo Logs generation -- Class Notes-4

RMAN Command Line Reference Guide -- Class Notes-5

How to restore db on a remote server? (Chicago to NY) -- Class Notes-6

How to restore db on a remote server? (NY to Chicago) -- Class Notes-6

How to restore db on remote server (Chicago to TN) --Class Notes-6

RMAN Scenario-16 | How to restore Oracle database? --Moid

RMAN: Scenario-17: How to restore Oracle tablespace? --Moid

RMAN: Scenario-18: How to restore Oracle datafile? --Moid

RMAN: Scenario-19: How to perform point in time recovery? --Moid

RMAN: Scenario-20: How to perform TABLESPACE point in time recovery? --Moid

Task: How to rename and/or move datafiles (ALL Datafiles) to a new directory? --Moid

Week-20 | RMAN Homework | Part-1 --Moid


Batch Specific Class Notes:

 Batch-26: RMAN | Saturday and Sunday class notes | June 2014
--Moid
Posted by at No comments:

Homework (Week-19) | Redo Logs | Archive Logs | Oracle Cold and Hot Backup Strategy

Class work: In Class Notes

Class work: How to perform Consistent (COLD) User Managed Backup and recover the database on a different host?

Class Work: My queries on Redo and Archive Logs --Moid

Homework: Change redo log size --Moid

Homework: Change redo log location --Moid

Homework: Change the datafile location --Moid

Homework: Perform a User Managed Hot Backup --Moid

Homework: Perform a User Managed Restore from a hot Backup --Moid

Homework: One of the control file is lost. Restore it and open database --Moid

Homework: All controlfiles are lost. Re-create them. --Moid

How to enable archivelog mode? --Moid

How to Disable archivelog mode? --Moid

How to recover database when a redo log is accidentally dropped? --Moid

--Moid
Posted by at No comments:

Homework (Week-17) | Oracle Memory Architecture | SGA and PGA --Moid

Posted by at No comments:

Homework (Week-18) [Export Import and Data Pump] --Moid

Batch Related Notes:

  1. Batch-32: Class work on Export Import | 05/14/16
  2. Batch-32: Class work on Export Import | 05/15/16

Export / Import:

  1. Click here for Export Import Notes-1
  2. Click here for Export Import Notes-2
  3. My notes on Oracle Export - Examples --Moid
  4. My notes on Oracle Import - Examples --Moid
  5. How to export (using Data Pump) a schema using parfile? --Moid
  6. Click here for Export Homework.
  7. Click here for Import Homework.

Data Pump:

  1. Click here for Class notes on Data Pump - 12/29/13
  2. My notes on Data Pump
  3. Click here for the Schema level Export Import using DATA PUMP
  4. Click here for Data Pump Homework.
  5. How to name, start, stop, kill an export job using Oracle Data Pump? --Moid
  6. Data Pump: How to check the status of Data Pump export? --Moid

Archive:

  1. Batch-28: Classwork on Export Import | 02/08/15
  2. Batch-27: Class work on Export Import | 10-12-14
  3. Batch-27: Class work on Export Import | 10-25-14
  4. Batch-30: Class work on Export Import | 10/10/15
  5. Batch-30: Class work on Export Import | 10/11/15

--Moid Muhammad
Posted by at No comments:

Homework (Week-15) Row Chaining | Row Migration | Tablespace | Datafiles

Posted by at No comments:

Homework (Week-13) Database shutdown/startup, static/dynamic, monitoring Alert log changes --Moid

Posted by at No comments:

Homework (Week-14) Exercise on Segments, Extents and Blocks --Moid

Posted by at 17 comments:

Homework (Week-12) [Oracle Permissions, Grants, Privileges and Roles Exercise] --Moid

Posted by at No comments:

Homework (Week-9) [Oracle Client Side Networking Overview, Oracle Client Installation, Server Side Networking Overview] --Moid


My documents on Oracle Networking:
  1. Download Oracle 11g R2 Client for 32/64-bit Windows
  2. Download Oracle 12c R1 Client for 32/64-bit Windows
  3. Click here for 11g R2 Client Installation on Windows 7
  4. Click here for 12c R1 Client Installation on Windows 8
  5. How to deinstall Oracle 11g R2 Client from Windows 7?
  6. How to deinstall Oracle 12g R1 Client from Windows 8?
  7. How to deinstall Oracle 11g client from Linux?
  8. How to deinstall Oracle 11g R2 "DATABASE" from Windows 7?
  9. How to deinstall Oracle 11g R2 "DATABASE" from Windows 8?
  10. How to deinstall (uninstall) 12c database home from Linux?
  11. How to create a TNS Entry (Database Address / Connect Identifier) on the Oracle Client Machine using netca?
  12. On Linux - How to register database on a non-default listener?
Classwork:
  1. Click here for Class Notes on Client Side Networking
  2. Click here for Class Notes on Server Side Networking
Homework:
  1. Click here for the "Server Side Networking" homework. 
  2. Click here for the "Client Side Networking" homework.

--Moid
Posted by at No comments:

Homework (Week-11) [Install 11g R2 on 64-bit CentOS 5.6] --Moid

Posted by at No comments:

Homework (Week-12) [Part-1] [Listener Notes and Homework] --Moid

Posted by at No comments:

Homework (Week-8) [Oracle Dictionary / CASE & Decode / Joins / Sub-Queries] --Moid

Posted by at No comments:

Homework (Week-7) [Oracle View, Concatenation and Constraints] --Moid

Posted by at No comments:

Homework (Week-6) - [Select, DDL, DML, Views] --Moid

Posted by at No comments:

Homework (Week-5) [Select statements with conditions only] --Moid

  1. Batch-32: Week-5: Class Notes 03/05/16 and 03/06/16
  2. Document for Student Only: How to create a new schema and load tables?
  3. How to find the date format of Oracle Database Server?
  4. Week-5 Homework (SQL on select statements with conditions only)
  5. Oracle SQL Operators --Moid
  6. Oracle Functions --Moid
Archive:


Please Note: Only my students has access to these document.

--Moid
Posted by at No comments:

Homework Week-4 [SQL Part-1 Create Table and Insert Values]

Class work Part-1: [How to login to Database?]

Class work Part-2: [User Management]

Class work Part-3: [Class Notes - Create Table]

Class work Part-4 [Different Ways of Inserting data into a table]

How to spool SQL output to a file?

How to transfer files from Linux to Windows using WinSCP?

Your homework for week-4 is:
  1. Login to your database schema.
  2. Start spool.
    Spool output to  /home/oracle/SpooledFiles/Khan_A13_spool_file.log.
    Replace Khan_A13 with your schema name.
  3. Ceate and insert values in all tables mentioned on page 57, 58 and 58 in your book. Tables are also located at http://www.mydbanotes.com/2011/09/table-screenshots-of-indo-us-college.html
  4. Turn off spool.
  5. Transfer file from Server-223 to your laptop using WinSCP.
  6. Send me the file from Step-5 from your email as attachment. 

Archives:

As a final note, please be sure to save all the Create and insert statements into a notepad in your laptop. We will reusing the same code again to recreate the database objects.

--Moid Muhammad
Posted by at No comments:

Homework (Week-3) - grep, find, ssh, scp, awk, sed and vi editor

Section-1:

 Click here for Classwork (Linux Commands)
Click here for Classwork (find Commands)
Click here for Classword (grep Commands)
Click here for Classwork (awk Commands)
Click here for Classwork (sed Command)

Click here for SSH & SCP Classwork
Click here for homework | Part-1

Section-2:

Click here for vi editor class notes.
Click here for homework | Part-2

--Moid
Posted by at No comments:

Homework (Week-2) [UNIX Part-2]

Posted by at No comments:

Friday, October 7, 2011

Homework (Week-1) [Basics of Networking and Linux Part-1] --Moid

Basics of Networking:
Click here for the networking class notes.

Basics of Linux:
Click here for the Linux class notes
Click here for the homework on Linux Basics


--Moid MuhammadLink
Posted by at No comments:

Wednesday, September 28, 2011

MIITDocID-901: How to find empty tablespaces (orphan tablespaces) in Oracle database? --Moid

Posted by at No comments:

Tuesday, September 27, 2011

How to gather table stats on multiple tables in 11g R2? --Moid

Click here for the document.

--Moid
Posted by at No comments:

Saturday, September 24, 2011

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

Posted by at No comments:

Friday, September 23, 2011

How to install Oracle SQL Developer 3.0.04 on 64-bit Windows 7? --Moid

Click here for the document.

--Moid
Posted by at No comments:

Table screenshots of Naman Navan-N2 Database (Page 61-62) from Nilesh Shah Book --Moid

Click here for the details.

--Moid
Posted by at No comments:

Table screenshots of Indo US College Database (Page 57, 58, 59) From Nilesh Shah's book --Moid

Click here for the document.

--Moid


Keywords:
Table screenshots of Indo US College Database (Page 55, 56 and 57) From Nilesh Shah's book
Posted by at No comments:

Sunday, September 18, 2011

Test Questions on Oracle Networking, alertlog, shutdown/startup commands --Moid

Click here for the document.

--Moid
Posted by at No comments:

Monday, August 22, 2011

MoidIITDocID-521: How to upgrade 10g R2 RAC clusterware from 10.2.0.1 to 10.2.0.4? --Moid

Posted by at No comments:

Sunday, August 21, 2011

MoidIITDocID-522: How to apply CRS Bundle-4 Patch on 32-bit RHEL4 u8 in 10.2.0.4 CRS HOME? --Moid

Posted by at No comments:

Sunday, August 14, 2011

MoidIITDocID-519: My notes on RAC Failover Queries --Moid

Posted by at No comments:

Monday, August 8, 2011

Document is deleted.

Click here for the document.

--Moid
Posted by at No comments:

Thursday, August 4, 2011

MoidIITDocID-518.2: How to transport a tablespace using "Transportable Tablespace" feature of Oracle (Part-2)? --Moid

Posted by at No comments:

MoidIITDocID-518.1: How to transport a tablespace using "Transportable Tablespace" feature of Oracle (Part-1)? --Moid

Posted by at No comments:

Thursday, July 28, 2011

MoidIITDocID-546: Quick reference to Oracle Patchset patch numbers --Moid

As per the Oracle's Document ID 753736.1, the following are the quick reference to Oracle Patchset patch numbers:

Click here for the document.

--Moid


keywords:
oracle version
oracle patches
oracle patchset
Posted by at No comments:

Tuesday, July 26, 2011

MoidIITDocID-547: How to change Oracle Database Name and DBID? --Moid

Posted by at No comments:

Friday, July 22, 2011

MoidIITDocID-548: 11g RAC using openfiler (Jeff Hunter's Document) --Moid

Build Your Own 11g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-1
Build Your Own 11g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-2
Build Your Own 11g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-3

--Moid
Posted by at No comments:

Monday, July 11, 2011

MIITDocID-955: How to enable archivelog mode? --Moid

Posted by at No comments:

MoidIITDocID-548: Queries to identify Oracle Foreign Keys (child tables) refrencing Primary Key of Parent Tables.-- Moid

Posted by at No comments:

Wednesday, July 6, 2011

MoidIITDocID-541: How to install Oracle 11g R2 Client on Windows 7? --Moid

Posted by at 1 comment:

Tuesday, July 5, 2011

Download Tora from here --Moid

from http://torasql.com/about

"TOra is an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle, MySQL, and Postgres, as well as limited support for any target that can be accessed through Qt's ODBC support. TOra has been built for various Linux distributions, Mac OS X, MS Windows, and UNIX platforms.

In addition to regular query and data browsing functionality, it includes several additional tools useful for database administrators and developers – which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools."

Tora (a tool similar to TOAD) can be downloaded from here. Main download page is at http://sourceforge.net/projects/tora/

--Moid Muhammad
Posted by at No comments:

Download Oracle 11g R2 Client for 32/64-bit Windows --Moid

Oracle Database 11g Release 2 (11.2.0.1.0) Client for 32/64-bit Windows.

1) Go to http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

2) Click on "Accept License Agreement"

3) And then start browsing as per your need. Few links to download Oracle client are as follows:

 32-bit http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

Direct Download: http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_client.zip

64-bit http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

Direct Download: http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_client.zip

Click here for step-by-step Oracle 11g R2 Client Installation on Windows 7.

Click here for step-by-step Oracle 12c R1 Client Installation on Windows 8.

Note: In order for TOAD to work, use 32-bit client installation.

--Moid Muhammad
Posted by at 3 comments:

Monday, July 4, 2011

Backup and Recovery ()

Posted by at No comments:

Backup and Recovery ()

Posted by at No comments:

RMAN Scenario-21: How to recover database from lost controlfiles? --Moid

Posted by at No comments:

MoidIITDocID-938: My notes on RMAN --Moid

Posted by at No comments:

MIITDocID-958: Command Line Reference Guide --Moid

Posted by at No comments:

MoidIITDocID-540: How to perform TABLESPACE point in time recovery? --Moid

Posted by at No comments:

MoidIITDocID-528: How to perform point in time recovery? --Moid

Posted by at No comments:

MoidIITDocID-549: Scenario-18: How to restore Oracle datafile? --Moid

Posted by at No comments:

RMAN: Scenario-17: How to restore Oracle tablespace? --Moid

Posted by at No comments:

RMAN Scenario-16 | How to restore Oracle database? --Moid

Posted by at No comments:

RMAN: Scenerio-15: How to restore database with a new name from Cold Backup --Moid

Posted by at No comments:

Backup and Recovery Scenerio-14 | How to restore archivelogs from backups? --Moid

Posted by at No comments:

Backup and Recovery Scenerio-13 | How to perform time-based Oracle Point-In-Time recovery using RMAN? --Moid

Posted by at No comments:

Backup and Recovery Scenerio-10 [How to duplex Oracle 10g RMAN backups?] --Moid

Click here for the document.

--Moid
Posted by at No comments:

Backup and Recovery Scenerio-9 (How to perform a point in time tablespace recovery)

How to perform a point in time tablespace recovery? In this exercise, tablespace name is CT_COMMON_DATA?
$ export ORACLE_SID=PrimeDG
$ rman target /
RMAN> sql 'alter tablespace CT_COMMON_DATA offline';

RMAN> run

{

set until time "to_date('FEB 28 2008 13:59:00','Mon DD YYYY HH24:MI:SS')";

recover tablespace CT_COMMON_DATA;

}

RMAN> sql 'alter tablespace CT_COMMON_DATA online';
RMAN> exit;
Posted by at No comments:

Backup and Recovery Scenerio-12 (How to transport a tablespace?) -- Moid

Posted by at No comments:

Backup and Recovery Scenerio-11 (How to restore and rename database on a different server) --Moid

Posted by at No comments:

MIITDocID-942: Controlfiles are lost and database is still open. How to rebuild the lost controlfiles? --Moid

Posted by at No comments:

Backup and Recovery Scenario-7 | How to duplicate (clone) database on the DIFFERENT HOST from NON-ASM to ASM using RMAN? --Moid

Click here for the document.


Migrate NON-ASM to ASM on a different host.

--Moid Muhammad
Posted by at No comments:

Backup and Recovery Scenario-6 | How to duplicate (clone) database on the same server from NON-ASM to ASM using RMAN?

Click here for the document.

Migrate NON-ASM to ASM.

--Moid Muhammad
Posted by at No comments:

Backup and Recovery Scenario-5 | How to duplicate (clone) database on the different server using RMAN?

Click here for the document.

--Moid
Posted by at No comments:

Backup and Recovery Scenario-3 | How to restore and recover database on a remote server using RMAN?

Click here for 10g document.

Click here for 11g document.

--Moid
Posted by at No comments:

Backup and Recovery Scenario-4 | How to duplicate (clone) database on the same server using RMAN? --Moid

Click here for the document.

NON-ASM to NON-ASM

--Moid
Posted by at No comments:

Backup and Recovery Scenerio-2 | How to recover a datafile when all archivelogs are available?

Click here for the document.

--Moid
Posted by at No comments:

Backup and Recovery Scenario-1 (Recover Lost Datafile from User-Managed Full Backup)

Click here for the document.

--Moid
Posted by at No comments:

Backup and Recovery Scenario-0 |How to perform a user-managed cold backup?

Click here for the document.

--Moid
Posted by at No comments:

Oracle Background Processes

Click here for the document.

--Moid
Posted by at No comments:

Thursday, June 16, 2011

How to duplicate (clone) database on the DIFFERENT server from NON-ASM to ASM using RMAN? --Moid

Posted by at No comments:

Sunday, May 29, 2011

How to duplicate (clone) database on the same server from NON-ASM to ASM using RMAN?

Click here for the document.

--Moid
Posted by at No comments:

MoidIITDocID-523: How to duplicate (clone) database on the same server using RMAN? --Moid

Click here for the document.

Moid Muhammad


Keywords:
non-asm to non-asm
duplicate
clone
Posted by at No comments:

Saturday, May 28, 2011

MoidIITDocID-502: How to create a password file? --Moid

$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password='abc123' ignorecase=Y entries=5 force=y


Starting from 19c, atleast 8 bytes are required for SYS password.

orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password='abc123'  force=y
OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters.

Solution is to add "format=12". See below:
orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password='abc123'  force=y  format=12


--Moid Muhammad
Posted by at 1 comment:

Thursday, May 26, 2011

Homework - Export Import Exercise-1

Click here for the document.

--Moid
Posted by at No comments:

Wednesday, May 25, 2011

How to connect to YOUR Database (on Server-223) from TOAD?

Posted by at No comments:

Saturday, May 21, 2011

Oracle Books

Click here for the document.

--Moid
Posted by at No comments:

How to recover spfile from crashed spfile?

Click here for the document.

--Moid
Posted by at No comments:

Friday, May 20, 2011

Upgrade database from 10g R2 to 11g R2 Part-2

Click here for the document.

--Moid Muhammad
Posted by at No comments:

Upgrade database from 10g R2 to 11g R2 Part-1 --Moid

Posted by at No comments:

Tuesday, May 17, 2011

Install 11g R2 on 64-bit CentOS 5.6 Part-5 (Oracle 11g R2 Database Installation) Final --Moid

Click here for the document.

--Moid
Posted by at 2 comments:

Sunday, May 15, 2011

Class exercise on Oracle Segments, Extents and blocks

Click here for the document.

--Moid
Posted by at No comments:

Friday, May 13, 2011

Install 11g R2 on 64-bit CentOS 5.6 Part-4 (Oracle 11g R2 Software Installation) --Moid

Click here for the document.

--Moid
Posted by at No comments:

Tuesday, May 10, 2011

VNC Setup for Oracle User in 64-bit CentOS 5.6

Click here for the document

--Moid Muhammad
Posted by at No comments:

Install 11g R2 on 64-bit CentOS 5.6 Part-3 (Create Oracle Directories and download 11g R2 software)

Click here for the document.

--Moid Muhammad
Posted by at No comments:

Monday, May 9, 2011

Install 11g R2 on 64-bit CentOS 5.6 Part-2 (Oracle Pre-requisites & Kernel Parameter Changes) --Moid

Click here for the document.

--Moid
Posted by at 3 comments:

MoidIITDocID-542 Install 11g R2 on 64-bit CentOS 5.6 Part-1 (Create Virtual CentOS Machine for Oracle)

Posted by at No comments:

Sunday, May 8, 2011

Key to "Practice vi editor and test your vi skills" paper

Click here for the document.

--Moid
Posted by at No comments:

Monday, May 2, 2011

11g GoldenGate Installation (High Level steps) v1.4 --Moid

Very high level GG installation can be found from the following document.

Click here for the document.

--Moid





Golden Gate
GoldenGate
uni-directional
unidirectional
GG
Posted by at No comments:

Thursday, April 28, 2011

Oracle Permissions, Grants, Privileges and Roles.......Exercise-1

Click here for the document.

--Moid Muhammad
Posted by at No comments:

Tuesday, April 26, 2011

Oracle Permissions, Grants, Privileges and Roles......Exercise-2

Click here for the document.

--Moid Muhammad
Posted by at No comments:

Monday, April 18, 2011

How to [For my students only] open VMWare Console from home? --Moid

Click here for the instructions:

--Moid
Posted by at No comments:

Sunday, April 10, 2011

MIITDocID-870: My notes on Temporary Tablespace --Moid

Posted by at 1 comment:

10g DBConsole Startup issue

Click here for the document.

--Moid Muhammad
Posted by at No comments:

Saturday, April 9, 2011

MoidIITDocID-539: How to apply Jan'11 CPU patches on 32-bit Linux? --Moid

Posted by at No comments:

How to manually DROP / CREATE / RECREATE dbconsole repository?

Click here for the document.

--Moid
Posted by at No comments:

Sunday, April 3, 2011

MIITDocID-938: My notes on oracle RMAN --Moid

Posted by at No comments:

Friday, April 1, 2011

Script to create Naman-Navan (N2) Database from Page 61, 62 (Nilesh Shah's Book) --Moid

Click here for the script.

--Moid
Posted by at No comments:

Script to create Indo-US College Database from Page # 57, 58 and 59 (Nilesh Shah's Book) --Moid

Posted by at No comments:

Friday, March 25, 2011

Steps to migrate NON-ASM Oracle 10g database to ASM on remote server v1.1 --Moid

Click here for the document.


Hope this helps.
--Moid Muhammad
Posted by at 1 comment:

Steps to migrate (clone) Oracle database to a remote server (non-asm to non-asm)? --Moid

Click here for the document.


--Moid Muhammad


Keywords:
RMAN Migrate
non-asm to non-asm
Posted by at No comments:

Thursday, March 24, 2011

Oracle 10g RAC database not shown from dbca

Click here for the document.


--Moid Muhammad



Keywords:
10g RAC databases not visible using dbca
Posted by at No comments:

How to unregister database from OCR after dropping the db from dbca?

Click here for the document?


--Moid Muhammad


Keywords:
crs_unregister unregister remove ocr cleanup "srvctl remove database"
Posted by at No comments:

Tuesday, March 22, 2011

Few RAC Practice sessions with helpful Interview Questions --Moid

Posted by at No comments:

Sunday, March 20, 2011

MIITDocID-923: How to replace / Resize the current Oracle redo log member --Moid

Click here for the document.
Key words:
Rename redo logs
Resize online redo logs

--Moid
Posted by at No comments:

Friday, March 18, 2011

How to recover Oracle database without any archivelogs?

Click here for the document.


--Moid Muhammad






Keywords:
Missing archivelogs
no archivelogs
archive logs
archivelogs are not backed up
Posted by at No comments:

Thursday, March 17, 2011

Homework (Week-5) [Select statements with conditions only] --Moid

Posted by at No comments:

Monday, March 14, 2011

Linux: How to change Linux hostname? --Moid

Posted by at No comments:

Sunday, March 6, 2011

MoidIITDocID-557: My queries on Oracle FRA (Flash Recovery Area) --Moid

Click here for the document

--Moid




Keywords: FRA
Posted by at No comments:

Thursday, March 3, 2011

MIITDocID-963: ASM Queries --Moid

Posted by at No comments:

Monday, February 28, 2011

10g RAC using openfiler (Jeff Hunter's Document)

Build Your Own 10g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-1
Build Your Own 10g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-2
Build Your Own 10g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-3


Also the cached pages are at my network at the following location:
\\192.168.0.61\lsi_shared_files\Build_10g_RAC_(Jeff_Hunter_Oracle_Document)

--Moid
Posted by at No comments:

Sunday, February 27, 2011

How to Identify the physical location of an Oracle Block?

Click here for the Document

--Moid
Posted by at No comments:

Saturday, February 26, 2011

Oracle Block Architecture with PCTUSED and PCTFREE --Moid

Posted by at No comments:

How to build an Oracle VMware machine and install 10g R2 (Part-3 Final)?

Click on the following link:

Part-III Install 10.2.0.1 and upgrade to 10.2.0.4


--Moid Muhammad
Posted by at No comments:

How to build an Oracle VMware machine and install 10g R2 (Part-2)?

Click on the following link:

Part-II Prepare Linux for Oracle (all prerequisites) v1.3

--Moid Muhammad
Posted by at No comments:

How to build an Oracle VMware machine and install 10g R2 (Part-1)?

Click on the following link:

Part-I Operating System Install (RHEL4 Update-8) v1.2

--Moid Muhammad
Posted by at No comments:

Thursday, February 24, 2011

Linux Command Reference Part-4

Click here for the document
Posted by at No comments:

Linux Command Reference Part-3

Click here for the document
Posted by at No comments:

Linux Command Reference Part-1

Click here for the document
Posted by at No comments:

Linux Command Reference Part-2

Click here for the document
Posted by at No comments:

Tuesday, February 22, 2011

Practice vi editor and test your vi skills.

Practice vi editor and test your vi skills from the following link.


Click here for the document.
Posted by at 1 comment:

Friday, February 11, 2011

How to tar and untar a directory in Linux?

Read the document from here.


--Moid Muhammad




Key words:
Archiving tar zip Linux Unix untar unzip
Posted by at No comments:

MoidIITDocID-553: How to purge large log file in Linux? --Moid

Click here to read the document.


Keywords: Truncate large files, clean up large files
Posted by at No comments:

How to find Large directories (directories with minimum of 1G in size) in Linux?

My document can be found here.
Posted by at No comments:

Friday, February 4, 2011

MIITDocID-876: How to Configure Data Guard Broker for Oracle 10g standby database?

Click here for the document.

--Moid Muhammad
Posted by at 1 comment:

Thursday, February 3, 2011

MoidIITDocID-625: How to perform Data Guard MANUAL Switchover? --Moid

Click here for the instructions.

--Moid Muhammad
Posted by at No comments:

Wednesday, February 2, 2011

How to change the protection mode from "maximum performance" to "maximum availability" in a 10g Data Guard environment?

Let's see how many different kind of protection modes Oracle offers in a Data Guard Environment.

Maximum Protection—This mode offers the highest level of data protection. Data is synchronously transmitted to the standby database from the primary database and transactions are not committed on the primary database unless the redo data is available on at least one standby database configured in this mode. If the last standby database configured in this mode becomes unavailable, processing stops on the primary database. This mode ensures no-data-loss.

Maximum Availability—This mode is similar to the maximum protection mode, including zero data loss. However, if a standby database becomes unavailable (for example, because of network connectivity problems), processing continues on the primary database. When the fault is corrected, the standby database is automatically resynchronized with the primary database.

Maximum Performance—This mode offers slightly less data protection on the primary database, but higher performance than maximum availability mode. In this mode, as the primary database processes transactions, redo data is asynchronously shipped to the standby database. The commit operation of the primary database does not wait for the standby database to acknowledge receipt of redo data before completing write operations on the primary database. If any standby destination becomes unavailable, processing continues on the primary database and there is little effect on primary database performance.

How to change from "maximum performance" to "maximum availability"? Click here for the instructions.

--Moid


Keywords:

Data Guard Protection Mode.
Posted by at No comments:

Monday, January 24, 2011

How to start GUI (dbca, netca etc) from RDP Server? --Moid

Click Here for the Document.

--Moid
Posted by at No comments:

Wednesday, January 19, 2011

How to duplicate VMWare machine from an existing VMWare Machine v1.1

clicking here for the document..

--Moid Muhammad


Keyword: VMWare Cloning with screenshot, VMWare Duplicate, VMWare Oracle Database Cloning, step-by-step VMWare Cloning, VMWare image, VM Machine Image
Posted by at No comments:

Wednesday, January 12, 2011

Oracle Listener Commands

In class Listener Notes can be found from here.

--Moid
Posted by at No comments:
Subscribe to: Posts (Atom)

Followers