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

Click here for the document.

--Moid

Oracle Data Pump Exercise # 9

Click here for the document.

--Moid

Oracle Data Pump Exercise # 8

Click here for the document.

--Moid

Oracle Data Pump Exercise # 7

Click here for the document.

--Moid

Oracle Data Pump Exercise # 11

Click here for the document.

--Moid

Oracle Data Pump Exercise # 5

Click here for the document.

--Moid

Oracle Data Pump Exercise # 6

Click here for the document.

--Moid

Oracle Data Pump Exercise # 4

Click here for the document.

--Moid

Oracle Data Pump Exercise # 3

Click here for the document.

--Moid

Oracle Data Pump Exercise # 2

Click here for the document.

--Moid

Oracle Data Pump Exercise # 1

Click here for the document.

--Moid

Export / Import Exercise-10

Click here for the document.

--Moid

Export / Import Exercise-9

Click here for the document.

--Moid

Export / Import Exercise-8

Click here for the document.

--Moid

Export / Import Exercise-7

Click here for the document.

--Moid

Export / Import Exercise-6

Click here for the document.

--Moid

Export / Import Exercise-5

Click here for the document.

--Moid

Export / Import Exercise-4

Click here for the document.

--Moid

Export / Import Exercise-3

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.
--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

MLC Student's Task List --Moid

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

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

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

1. Batch-30: Week-17: Classwork.
2. Click here for the homework.
3. Batch-30: How to Identify Root Blocker in Oracle?
4. Batch-30: How to kill session from SQL Plus under various scenarios?
5. My notes on SGA and PGA --Moid
6. How to identify SQL ID and Plan Hash Value? --Moid

--Moid

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

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

Classwork and Homework

http://www.mydbanotes.com/2015/06/my-notes-on-tablespaces-and-logical.html
Week-15: Classwork on Tablespace and Datafiles
Week-15: Homework on Tablespace and Datafile.
Week-15: Classwork on Row Chaining

Other links:

My notes on Tablespace and Datafiles --Moid
My notes on Temporary Tablespace --Moid
My notes on Undo Tablespace --Moid
Notes on Row Chaining and Row Migration


--Moid

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

Click here for class work on Oracle Startup and Shutdown

Click here for class work on Monitoring alert log

Click here for class work on Oracle Parameters

Click here for Homework

--Moid

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

1. Click here for the Saturday class work.
2. My notes on Oracle Extents.
3. Click here for the homework.

Moid Muhammad

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

1. Click here for Homework Exercise-1

2. Click here for Homework Exercise-2

3. Security -- What Roles and Privileges are given to a User? 

4. Security -- What object level permission are given to an oracle user?

5. Security -- What object level permission are given to a Role? 

6. Security -- How many (system level) permissions are assigned to a Role?

7. Security -- My queries on Oracle Roles 

8. Security -- My queries on Oracle Grants, Roles and Privilege

9. Security -- How to copy / extract a user's Roles and permissions?

--Moid

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

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

Click here for the Class Notes

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

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

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

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

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

--Moid

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

Click here for the in-class notes.
Click here for the homework.

For Part-2, click here.
--Moid

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

Batch-30: Click here for class work (Sub-Query, CASE, Decode)

Click here for Homework on Oracle Dictionary
Click here for Homework on CASE and DECODE
Click here for Homework on Sub-Queries (Part-1).
Click here for Homework on Joins (Part-1)


Archive:
Batch-27: Click here for Saturday Notes.
Batch-27: Click here for Sunday Notes.

Batch-28: Click here for Saturday Class Work
Batch-28: Click here for Sunday Class work

Click here for class notes on Sub-Queries

Batch-29: Click here for Saturday Class Work (04/11/15)
Batch-29: Click here for Sunday Class Work (04/12/15)

--Moid Muhammad

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

Constraints:
What to read in Book?
Week-7 - Understanding Constraints Part-1
Week-7 - Understanding Constraints Part-2


Classwork:
Batch-30: Saturday: Week-7 Class Notes 7/25/15
Batch-30: Sunday: Week-7 Class Notes 7/26/15

Homework:
Week-7 Part-1 Homework [Oracle Views and Concatenation]
Week-7 Part-2 Homework [Constraints]


Archive:
Batch-29: Saturday Week-7 Class Notes (04-05-15)
Batch-29: Sunday Week-7 Class Notes (04-04-16)
Batch-26 Week-7 SQL Revision on 3/1/14 with Dictionary Views
Batch-26 Week-7 Class work 3/2/14 (concatenation)
Batch-26 Week-7 Class work 3/2/14 (Sub Query)
Batch-25 Week-7 Class work 9/28/13


--Moid Muhammad

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

Batch-31: Week-7: Saturday Class: 12/5/15
Batch-31: Week-7: Sunday Class: 12/06/15

Week-6: Homework | Select, DDL, DML and Views -
Week-6: Homework: Question and Answers via email

Archive:
Batch-24: Class work
Batch-27: Week-6: Saturday Class Notes: 06-07-14
Batch-27: Week-6: Sunday Class Notes: 06-08-14
Batch-28: Week-6: Classwork: Saturday 11/1/14 --Moid
Batch-28: Week-6: Classwork: Sunday 11/2/14 --Moid
Batch-29: Week-6: Saturday Class Notes: 03/14/15
Batch-29: Week-6: Sunday Class Notes: 03/15/15

--Moid

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:

• Batch-31: Week-6: Class Notes | Saturday 11-04-15
• Batch-31: Week-6: Class Notes | Saturday 11-05-15
• Batch-30: Week-5 Class Notes | Saturday 06-27-15
• Batch-30: Week-5 Class Notes | Sunday 06-28-15
• Batch-29: Week-5 Class Notes | Saturday 03-07-15
• Batch-29: Week-5 Class Notes | Sunday 03-08-15
• Batch-28: Week-5 Class Notes: Saturday 10-25-2014
• Batch-28: Week-5 Class Notes: Sunday 10-26-2014
• Batch-27: Week-5 Class Note | Saturday 05/31/14
• Batch-27: Week-5 Class Note | Sunday 06/01/14

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

--Moid

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. 

Homework-2 | Answer the following Questions:

Archives:

1. Batch 23: Week-4: Classwork: [Saturday and Sunday SQL Notes]
2. Batch-28: Week-4: Classwork: [Saturday & Classwork | 10/11 and 10/12]
3. Batch-29: Week-4: Classwork: [Saturday & Sunday Classwork | 02/28/15 and 03/01/15]
4. Batch-30: Classwork: Week-4: [Saturday 06/13/15]
5. Batch-30: Classwork: Week-4: [Sunday 06/14/15]

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

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

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

Click here for the class work.

Click here for the homework.

--Moid

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 Muhammad