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
Wednesday, January 12, 2011
Wednesday, December 29, 2010
11g R2 (11.2.0.2) -- Script to Auto Start/Shutdown databases during reboots.
Step 1:
Login as root and create a file called /etc/init.d/oracle. Add the following lines in the script.
#!/bin/bash
#######################################################################
#
# Run-level Startup script for the Oracle Instance and Listener
#
# chkconfig: 345 98 34
# description: Startup/Shutdown script for 11g Oracle instances
#
#######################################################################
#######################################################################
#
# Note:
# cp $ORACLE_HOME/bin/dbstart $ORACLE_HOME/bin/dbstart.orig
# Make the following changes in $ORACLE_HOME/bin/dbstart
#
# Line#80 has the following:
# ORACLE_HOME_LISTNER=$1
#
# Replace it with the following two lines:
# export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
# ORACLE_HOME_LISTNER=$ORACLE_HOME
#
# cp $ORACLE_HOME/bin/dbshut $ORACLE_HOME/bin/dbshut.orig
# Make the following changes in $ORACLE_HOME/bin/dbshut
#
# Line#50 has the following:
# ORACLE_HOME_LISTNER=$1
#
# Replace it with the following two lines:
# export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
# ORACLE_HOME_LISTNER=$ORACLE_HOME
#
# save the file and proceed with the steps below
#
#######################################################################
#######################################################################
#Instructions to start start isntances manually
#
# To Start --> /etc/init.d/oracle start
# To Stop --> /etc/init.d/oracle stop
# To restrart --> /etc/init.d/oracle restart
#
#######################################################################
ORA_HM="/u01/app/oracle/product/11.2.0/db_1"
ORA_OWNR="oracle"
# if the executables do not exist -- display error
if [ ! -f $ORA_HM/bin/dbstart -o ! -d $ORA_HM ]
then
echo "Oracle startup: cannot start"
exit 1
fi
# depending on parameter -- startup, shutdown, restart
# of the instance and listener or usage display
case "$1" in
start)
# starting Oracle instances
echo -n "starting Oracle Instances"
su - $ORA_OWNR -c $ORA_HM/bin/dbstart
touch /var/lock/subsys/oracle
ps -ef |grep pmon |grep -v grep
ps -ef |grep lsnr |grep -v grep
echo "OK"
;;
stop)
# Oracle listener and instance shutdown
su - $ORA_OWNR -c $ORA_HM/bin/dbshut
rm -f /var/lock/subsys/oracle
ps -ef |grep pmon |grep -v grep
ps -ef |grep lsnr |grep -v grep
echo "OK"
;;
reload|restart)
$0 stop
$0 start
ps -ef |grep pmon |grep -v grep
ps -ef |grep lsnr |grep -v grep
echo "OK"
;;
*)
echo "Usage: $0 start|stop|restart|reload"
exit 1
esac
exit 0
clear
###################### END of SCRIPT ##############################
Step-2:
Change the permission of the script
chmod 750 /etc/init.d/oracle
Step-3:
Execute the following so that runlevel 3,4 & 5 will execute the script during system reboots.
chkconfig --level 345 oracle on
Step-4
Execute the script and verify everything is working as expected. Alternatively, you can download the script directory from here.
Additionally you can turn on and turn on with the following.
[root@bl-mm-db-dev ~]# /sbin/chkconfig oracle off
[root@bl-mm-db-dev ~]# /sbin/chkconfig --levels 345 oracle on
That's it. We are done.
--Moid