MIITDocID-846: How to build non-ASM 12c Standby database using Oracle Data Guard? --Moid

Click here for the document.

Moid

MIITDocID-845: How to Configure Data Broker for Oracle 12c Standby DB?

Click here for the document.

Moid

MIITDocID-844: My notes on Linux df command --Moid

Click here for document.

Moid

MIITDocID-843: How to add 12c Agent on database server? --Moid

Click here for the document.

Moid

MIITDocID-842: How to verify if Data Guard is created on a database? --Moid

Click here for the document.

Moid

My collection of SQL scripts for Oracle DBAs --Moid

Click here for the document.

Moid

MIITDocID-840: How to truncate all tables in the schema and refresh from data dump .dmp file? --Moid

Click here for the document.

Moid

MIITDocID-838: How to create a connection string using NETCA? --Moid

Click here for the document.

Moid

MIITDocID:837: How to deinstall 12c Oracle Client from Windows 10? --Moid

Click here for the document.

Moid

MIITDocID-836: How to install 12c client on Windows 10? --Moid

Click here for the document.

Moid

MIITDocID-835: How to stop, start, enable, disable firewall on Linux 7 / CentOS 7? --Moid

Click here for the document.

Moid

MIITDocID-833: How to perform manual upgrade of 11g database to 12c? --Moid

Click here for the document.

Moid

MIITDocID-831: How to Install 12c LISTENER using silent install (12.1.0.2)? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-830: How to Install 12c Oracle Database software using silent install (12.1.0.2)? --Moid

Click here for the document.

Moid

MIITDocID-839: How to add host in 12c Cloud Control? --Moid

Click here for the document.

Moid

MIITDocID-829: How to setup Linux 7 Server with gmail using smtp? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-828: How to setup a shell script to run SQL commands? --Moid

Click here for the document.

Moid Muhammad

RMAN Duplicate Database: Main Document --Moid

1. How to duplicate 11g database on remote server using RMAN? --Moid

2.

3.

4.

5.

6.

7.

8.

9.

10

Moid Muhammad

MIITDocID-827: How to duplicate 11g database on remote server using RMAN? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-826: How to download oracle PSU patches directly on server using wget? --Moid

Click here for the document.

Moid Muhammad




Keywords:
*****************
PSU / wget
Error:

Connecting to login.oracle.com||:443... connected.

HTTP request sent, awaiting response... 401 Authorization Required

Authorization failed.

MoidIITDocID-825: How to add SWAP space in Linux? --Moid

Click here for the document.

Moid Muhammad

MIITDocID-824: How to use screen command to attach and detach Linux session? --Moid

Click here for the details.

Moid

How to change oracle's default group from oinstall to dba? --Moid

Click here for the document.

Moid

How to sign up for oracle Support Request (metalink / SR) account? --Moid

Click here for the document.

Moid

How to Upgrade from 12.1.0.1 to 12.1.0.2 with standby in place (High Level Steps)? --Moid

Click here for the document.

Moid

How to migrate from 10g to 12c via data pump on same server (High Level Steps)? --Moid

Click here for the high level steps.

Moid

MoidIITDocID-543: 13c Cloud Control / OEM : How to manually add a host to OEM? --Moid

Click here for the document.

Moid

MoidIITDocID-816: How to create tables using Random Data in Oracle? --Moid

Click here for the document.

Moid

My notes on different ways of creating Oracle Database --Moid

Click here for the document.

Moid

MIITDocID-814: How to create 11g database manually using "Create Database" statement (without DBCA)? --Moid

Click here for the document.

Moid


key words:
Create database manual Moid

MoidIITDocID-811 | How to solve -bash-4.2$ prompt issue? --Moid

Click here for the document.

Hope this helps.

Moid Muhammad

MIITDocID-950: Few examples of Data Pump EXPORT Commands --Moid

Click here for the document.

How to get the Datafile Number and Block Number of a row? --Moid

Click here for the document.

Moid

MIITDocID-973: How to convert scientific notation value into number in SQL Plus? --Moid

Click here for document.

Moid

Examples using exp (export) commands --Moid

MoidIITDocID-607: How to find the location of all Oracle Database related files? --Moid

Click here for the document.

Moid

Homework on Tablespace Management --Moid

For students Only:
Click here for the document.

Moid

MIITDocID-903: How to find the username and its default tablespace? --Moid

Click here for the document.

Moid

My notes on Oracle ADRCI --Moid

Click here for document.

Moid

How to create incident reports from ADRCI? --Moid

Click here for the document.

Moid

MIITDocID-912: My queries on Oracle Extents --Moid

Click here for the document.

Moid

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

Click here for the document

Moid Muhammad

Linux: How to list all files between two dates? --Moid

Click here for the document.

Moid

SQL script to check failed logins attempts in database by Dave R. --Moid

Click here for the document.

Moid

For my Students Only: How to connect to YOUR Database from client's (Windows) laptop? --Moid

Click here for the document.

Moid

Oracle DBA Training | Registrations are now open | Start Date: May 14th 2016 | Batch-33 | Location: Chicago, IL

Assalamualaikum,

I am starting next batch of 12c Oracle Database Administration (Batch # 33) from Saturday May 14th. This training will continue on weekends for approximately 5 months at 2323 W Devon Avenue # 202, Chicago, IL 60659 (front Door is on Claremont Ave / across from Spinzer Restaurant).. Class timings are from 4 to 7 PM. Each new student is required to have his/her own laptop (Windows 7/8/10) with at least 4+ GB of RAM and ~120+ GB of hard drive.

Click here to register for DBA Training

Course fee is $2000 and can be paid in four monthly payments of $500 each. First payment will be due on Saturday of Week-3.

Remote access will be provided to perform practicals/exercises from home. For the detail printable schedule, click here..Upon successful completion of the DBA training, optional multi-week advance hands-on training on Automatic Storage Management (ASM), Data Guard (Standby Database), Real Application Cluster (RAC) and Oracle GoldenGate (Database Replication) will be conducted for a onetime fee of $1000.

If you are interested in joining this batch, please fill out the registration form. Once the form is submitted, reply back to this email to get the confirmation back on your enrollment. Registration ends at 11:59 PM of May 9th 2016.

Job placement assistance is provided once the course is completed. If you seeking further information, email your queries to Moid@MoidIIT.com or call me @ (224) 616-2786.

For further details, click here at DBA Training FAQs page.

Feel free to forward this email to any one who may be interested in getting this training.

Regards,

Moid Muhammad

www.MyDBANotes.com

Facebook:

https://www.facebook.com/MoidIIT

"Success isn't a result of spontaneous combustion. You must set yourself on fire."

Oracle DBA Check List by Azfar Temuri

Click here for the documentation.

Moid

Script to backup and delete archivelog --Umer Hussaini

Click here for the document.

Umer Hussaini
Sr. Oracle DBA

MIITDocID-853: My Notes on Oracle Sequences --Moid

Click here for the document.

Moid

MoidIITDocID-999: How to expire a oracle password after first login? --Moid

Click here for the document.

Moid

How to check Oracle Database start time / uptime? --Moid

Click here for the document.

Moid

MIITDocID-947: How to extract DDL of Oracle Table? --Moid

Click here for the document.

Moid

My notes on Grid Control / 12c Cloud Control / 13 Cloud control / OMS / OMR / OMA / emctl / OEM --Moid

Click here for the document.

Moid

RMAN: My notes on Oracle RMAN --Moid

Click here for the document.

Moid

Oracle SGA queries --Moid

Click here for the document.

Moid

MIITDocID-889: How to create a read only user in Oracle? --Moid

Click here for the document.

Moid

My notes on Oracle Functions --Moid

Click here for document.

Moid

My notes on Oracle SQL Operators --Moid

Click here for the document.

Moid

MoidIITDocID-597: Query find the oracle users who were assigned a role --Moid

Click here for the document.

Moid Muhammad

How to extract DDL of a role? --Moid

Click here for the document.

Moid

MIITDocID-940: Database is down. Controlfiles are lost. How to rebuild the controlfiles and open database? --Moid

Click here for the document 

Moid

How to upgrade to standalone database from 11g to 12c (11.2.0.2 to 12.1.0.2) using dbua? --Moid

Click here for the document.

Moid

How to solve "ORA-00845: MEMORY_TARGET not supported on this system" error when building 12c ASM? --Mazheruddin

Click here for the document.

Moid

Oracle DBA Training | Batch-32 | Registrations are now open | Chicago --Moid

Click here to register.

Moid

MoidIITDocID-638: How to purge AWR snapshots? --Moid

Click here for the document.

Moid

MoidIITDocID-639: VMWare - How to solve "No route to host" error? --Moid

Click here for the full page

Moid Muhamad

MIITDocID-946: How to extract DDL of all indexes from an Oracle schema? --Moid

Click here for the document.

Moid

MIITDocID-902: How to get DDL of all tablespaces (by Umer, Zubeen)? --Moid

Click here for the details.

Moid 

MIITDocID-887: My notes on Oracle User Management --Moid

Click here for the link.

Moid

What is the "ps -ef |grep pmon" equivalent command in windows? (Contributed by Talha Siraj) --Moid

Click here for the document.

Moid

MIITDocID-929: How to get info on Oracle Active sessions (contributed by Asad Mohammed)? --Moid

Click here for the document.

Moid

Oracle DBA Checklist --Moid

Click here for the document.

Moid

MIITDocID-928: Oracle script to check the database growth (written by Hadi Bhuya) --Moid

Click here for the document.

Moid

MIITDocID-564: My queries on 12c Multitanent, cdb (container database) and pdb (pluggable databases) --Moid

Click here for the document

How to migrate database from Windows to Linux Using RMAN (Shared by Mariyam Shareef) --Moid

Click here for the document shared by Mariyam Shareef 

Moid

MIITDocID-915: Script to check Tablespace Space Utilization (Shared by Talha Siraj) --Moid

Click here for the page.

Moid

My notes on tablespaces and logical structure of databases --Ahmad Bhutta

My notes on tablespaces and logical structure of databases --Ahmad Bhutta

Moid

Document ID: 562: Security: How to create read only user on entire oracle database (except default database users)? --Moid

Document ID-561: My notes on DBMS scheduler (New in 11g instead of dbms_jobs) --Moid

Click here for the document.

Moid

Document ID-560 | RMAN: How to automatically purge archivelog using dbms schedular? --Moid

Week-25 | ASM homework | TASK - ASM100 --Moid

Click here for the document. Moid

Document ID: 558 How to flush shared pool? --Moid

Document ID 557 | How to purge Oracle Audit Files older than 7 days through crontab? --Moid

MIITDocID-873: How to install SQL Developer 4.0.3.16 on Windows 7? --Moid

Click here for the document.

Moid Muhammad

Week-24: Advance Classes: ASM: Managing ASM --Moid

Click here for Task-1
Click here for Task-2
Task-3 How to Create ASM database manually using OMF?
Click here for Task-4
Click here for Task-5

Moid Muhammd

Week-23: Advance Classes: How to build 12c ASM Database Server --Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6

Moid Muhammad

MoidIITDocID-537: How to apply one-off patch using Oracle opatch utility? --Moid

Click here for the document.

Moid

My notes on DBA_jobs (DBA jobs) --Moid

Click here for the full page or see below:

MIITDocID-985: Query to find the last RMAN backup’s log (RMAN logfiles / RMAN output)? --Moid

Click here for the document.

Moid

Performance Tuning: My notes on SQL Plan Management (SPM) --Moid

Click here for details.

Moid

Kill sessios - How to schedule a cronjob to identify and kill oracle session running over 4 hours. --Moid

Click here for the document.

Moid Muhammad

My notes on Oracle Sorts (order by) --Moid

Click here for the document.

Moid Muhammad

MIITDocID-900: How to get Oracle Tablespace Usage History? --Moid

Click here for the document.

Moid

My queries on Oracle Performance Tuning --Moid

Click here for the document.

Moid

How to check Oracle listener's trace level and turn if off? --Moid

Click here for the document.

Moid

MIITDocID-995: My notes on Oracle RAC Commands --Moid

Click here for the document.

Moid

RMAN: How to unregister database from RMAN catalog? --Faisal Hasan

Click here for the document.

Moid

MoidIITDocID-559: How to check the status of Data Pump export? --Moid

Click here for details.

Moid

MoidIITDocID-592: My notes on Oracle RAC Services --Moid

Click here for the document.

Moid

Data Guard: How to remove database from Data Guard Configuration? --Moid

Click here for the document.

Moid