MIITDocID-851: My notes on Oracle Synonyms --Moid

Click here for the document.

Moid

MIITDocID-850: Few Examples of Data Pump IMPORT Commands --Moid

Click here for the document.

Moid

MIITDocID-849: How to export (using Data Pump) a schema using parfile? --Moid

Click here for the document.

Moid

MIITDocID-848: My notes on Oracle Data Pump --Moid

Click here for the document.

Moid

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

Click here for the document.

Moid 

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