Nested Subquery: A subquery is a query with in a query. It is nested in the where or having clause of another query. Subquery is executed first and then its results are provided to the main clause of the main query.
Monday, November 12, 2012
Saturday, November 10, 2012
Installing 11gR2 RAC on Linux
Environment: OS Oracle Linux 5.4 32bit, Oracle 11gR2 (11.2.0.1) 32bit
See the overview
All the installation process already explained in the overview as mentioned above. Here all JPGs are being provided for the Linux which are self explanatory. Wherever any additional information would be required , it will be provided.
See the overview
All the installation process already explained in the overview as mentioned above. Here all JPGs are being provided for the Linux which are self explanatory. Wherever any additional information would be required , it will be provided.
11gR2 on Linux: Oracle Grid Infrastructure Install
Main Post: Installing 11gR2 RAC on Linux
Start the RAC1 and RAC2 virtual machines, login to RAC1 as the oracle user and start the Oracle installer.
Start the RAC1 and RAC2 virtual machines, login to RAC1 as the oracle user and start the Oracle installer.
11gR2 on Linux: Preparing second VM
Main Post: Installing 11gR2 RAC on Linux
After fulfilling all the pre-reqs now we will shutdown the node1 (RAC1) and make its clone for Node2 (RAC2)
After fulfilling all the pre-reqs now we will shutdown the node1 (RAC1) and make its clone for Node2 (RAC2)
11gR2 on Linux: Prepare the shared storage/Prereq
Main Post: Installing 11gR2 RAC on Linux
After installing the basic installation of linux there are certain requirments which need to be fulfilled for successful installation of RAC 11g.
After installing the basic installation of linux there are certain requirments which need to be fulfilled for successful installation of RAC 11g.
11gR2 on Linux: Prepare the Virtual Machines
Main Post: Installing 11gR2 RAC on Linux
Two virtual machines will be prepared, first VM "RAC1" will be prepared , OS will be installed on it and then its copy ("RAC2")will be made. After copy the first VM , necessary modification for parameters will be made.
Two virtual machines will be prepared, first VM "RAC1" will be prepared , OS will be installed on it and then its copy ("RAC2")will be made. After copy the first VM , necessary modification for parameters will be made.
Wednesday, November 07, 2012
ORA-29270 Too Many Open HTTP Requests
Today one of the developer got the below error, i thought to write the details for him.
Saturday, November 03, 2012
Incomplete Recovery by RMAN from TAPE (ASM) to Single Instance.
-- Incomplete Recovery by RMAN from TAPE (ASM) to Single Instance.
Env. Windows 2008R2 64bit, backup is located at Netbackup (Tape media)
1- first set ORACLE_SID and the DBID of the source DB
C:\> set ORACLE_SID=HOMEDB
RMAN> set dbid=1547250382
executing command: SET DBID
Env. Windows 2008R2 64bit, backup is located at Netbackup (Tape media)
1- first set ORACLE_SID and the DBID of the source DB
C:\> set ORACLE_SID=HOMEDB
RMAN> set dbid=1547250382
executing command: SET DBID
Subscribe to:
Posts (Atom)
