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

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the details.

--Moid

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

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

Click here for the document.

--Moid

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

Part-1) How to perform non-rolling CRS upgrade from 10.2.0.1 to 10.2.0.4?

Part-2) How to perform non-rolling ORACLE_HOME upgrade from 10.2.0.1 to 10.2.0.4?

Part-3) How to apply Latest CPU Patches and CRS Bundle Patch-4 on 10g R2 RAC?

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

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

--Moid

Document is deleted.

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid Muhammad

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

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

Click here for the document.

--Moid

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

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

Click here for the detail.

--Moid



Read more on Redo and Archivelog queries

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

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

Backup and Recovery ()

Backup and Recovery ()

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

Click here for details

Moid

MoidIITDocID-938: My notes on RMAN --Moid

Click here for the document.

--Moid Muhammad

MIITDocID-958: Command Line Reference Guide --Moid

Click here for the document.

Moid

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

Click here for the document.

Moid

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

Click here for the document.

Moid

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

Click here for the document.

Moid

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

Click here for the document.

Moid

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

Click here for the document

Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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;

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

Click here for Part-1

Click here for Part-2

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

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

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

Click here for the document.

--Moid

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

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

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

Oracle Background Processes

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid

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

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

Homework - Export Import Exercise-1

Click here for the document.

--Moid

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

Click here for the document (students only).

--Moid

Oracle Books

Click here for the document.

--Moid

How to recover spfile from crashed spfile?

Click here for the document.

--Moid

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

Click here for the document.

--Moid Muhammad

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

Click here for the document.

--Moid Muhammad

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

Click here for the document.

--Moid

Class exercise on Oracle Segments, Extents and blocks

Click here for the document.

--Moid

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

Click here for the document.

--Moid

VNC Setup for Oracle User in 64-bit CentOS 5.6

Click here for the document

--Moid Muhammad

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

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

Click here for the document.

--Moid

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

Click here for the document.

--Moid Muhammad

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

Click here for the document.

--Moid

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

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

Click here for the document.

--Moid Muhammad

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

Click here for the document.

--Moid Muhammad

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

Click here for the instructions:

--Moid

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

Click here for the document.

--Moid Muhammad

10g DBConsole Startup issue

Click here for the document.

--Moid Muhammad

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

Click here for the document.

--Moid Muhammad

How to manually DROP / CREATE / RECREATE dbconsole repository?

Click here for the document.

--Moid

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

Click here for the document

--Moid

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

Click here for the script.

--Moid

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

Click here for the Script.

--Moid

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

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

Oracle 10g RAC database not shown from dbca

Click here for the document.


--Moid Muhammad



Keywords:
10g RAC databases not visible using dbca

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"

Few RAC Practice sessions with helpful Interview Questions --Moid

Click here for the instructions

--Moid Muhammad

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

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

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

This page is moved to Homework (Week-5) [Select statements with conditions only] --Moid

--Moid

Linux: How to change Linux hostname? --Moid

Click here for the document.


--Moid Muhammad

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

Click here for the document

--Moid




Keywords: FRA

MIITDocID-963: ASM Queries --Moid

Click here for the document.

--Moid