Sunday, August 21, 2011
Sunday, August 14, 2011
Monday, August 8, 2011
Thursday, August 4, 2011
Thursday, July 28, 2011
MoidIITDocID-546: Quick reference to Oracle Patchset patch numbers --Moid
Click here for the document.
--Moid
keywords:
oracle version
oracle patches
oracle patchset
Tuesday, July 26, 2011
Friday, July 22, 2011
Monday, July 11, 2011
Wednesday, July 6, 2011
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."
--Moid Muhammad
Download Oracle 11g R2 Client for 32/64-bit Windows --Moid
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
Monday, July 4, 2011
Backup and Recovery Scenerio-9 (How to perform a point in time tablespace recovery)
$ 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; |
Thursday, June 16, 2011
Sunday, May 29, 2011
Saturday, May 28, 2011
MoidIITDocID-502: How to create a password file? --Moid
Starting from 19c, atleast 8 bytes are required for SYS password.
Thursday, May 26, 2011
Wednesday, May 25, 2011
Saturday, May 21, 2011
Friday, May 20, 2011
Tuesday, May 17, 2011
Sunday, May 15, 2011
Friday, May 13, 2011
Tuesday, May 10, 2011
Monday, May 9, 2011
Sunday, May 8, 2011
Monday, May 2, 2011
11g GoldenGate Installation (High Level steps) v1.4 --Moid
Click here for the document.
--Moid
Golden Gate
GoldenGate
uni-directional
unidirectional
GG
Thursday, April 28, 2011
Tuesday, April 26, 2011
Monday, April 18, 2011
Sunday, April 10, 2011
Saturday, April 9, 2011
Sunday, April 3, 2011
Friday, April 1, 2011
Friday, March 25, 2011
Thursday, March 24, 2011
How to unregister database from OCR after dropping the db from dbca?
--Moid Muhammad
Keywords:
crs_unregister unregister remove ocr cleanup "srvctl remove database"
Tuesday, March 22, 2011
Sunday, March 20, 2011
Friday, March 18, 2011
How to recover Oracle database without any archivelogs?
--Moid Muhammad
Keywords:
Missing archivelogs
no archivelogs
archive logs
archivelogs are not backed up
Thursday, March 17, 2011
Monday, March 14, 2011
Sunday, March 6, 2011
Thursday, March 3, 2011
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-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
Sunday, February 27, 2011
Saturday, February 26, 2011
How to build an Oracle VMware machine and install 10g R2 (Part-2)?
Part-II Prepare Linux for Oracle (all prerequisites) v1.3
--Moid Muhammad
Thursday, February 24, 2011
Tuesday, February 22, 2011
Friday, February 11, 2011
Friday, February 4, 2011
Thursday, February 3, 2011
Wednesday, February 2, 2011
How to change the protection mode from "maximum performance" to "maximum availability" in a 10g 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.
Monday, January 24, 2011
Wednesday, January 19, 2011
How to duplicate VMWare machine from an existing VMWare Machine v1.1
--Moid Muhammad
Keyword: VMWare Cloning with screenshot, VMWare Duplicate, VMWare Oracle Database Cloning, step-by-step VMWare Cloning, VMWare image, VM Machine Image