Cloning is the process of copying an existing Oracle installation to a different location and then updating the copied installation to work in the new environment.
Read more…
I have a 2 Node RAC Standby database (STDBY) . I need to replicate it as a Load TEST database (LDTEST) in a read/write mode.
Read more…
Here I am duplicating 11g RAC database from one RHEL Server to Another by old 10g method.
I could have used 11g “DUPLICATE TARGET DATABASE TO TARGET_DB FROM ACTIVE DATABASE” which doesn’t need previous rman backup at source. But it may not be a good option for large databases or at places with narrow network bandwidth.
Read more…
Here I will be deleting everything from a 2 node 11g RAC cluster
- Use “crs_stop -all” to stop all services on RAC nodes
- Use DBCA GUI to delete all RAC databases from nodes
- Use netca to delete LISTENER config
- Deinstall Grid Infrastructure from Server
- Deinstall Oracle database software from Server
Read more…
XDB enable use of FTP and HTML protocols to access and manage files located on ASM disksgroups. Files can be easily browse or moved in/out from ASM this way.
Read more…
If you have already uninstalled Oracle Clusterware using the Oracle Universal Installer - Please download attached file cleanup.zip that contains a copy of the logpartformat.exe and the guioracleobjmanage.exe (plus necessary dll).
Read more…
How do I install CVU from OTN? Download From Here
Read more…
Note: You must be logged in as the root user, because root owns the OCR files. Make sure there is a recent copy of the OCR file before making any changes: ocrconfig showbackup
Read more…
Step by Step instructions on how to remove temp nodes from RAC cluster. Step by step instruction on how to verify removal of temp nodes.
Read more…
Step by Step instructions on how to fail RAC databases over from temp nodes to prod nodes. Includes step by step instructions on how to verify the failover from temp nodes to prod nodes. Step by Step instructions on how to test RAC database connectivity after failover.
Read more…
Oracle 10g R2 RAC Installation for PROD Nodes:
Step by Step instructions for installing Oracle 10g R2 RAC installation. The procedures will provide STEP By STEP guide you for installing two nodes (prodracsrv1and prodracsrv2) and adding to the existing RAC cluster(Configuring Failover).
Read more…
Oracle 10g R2 RAC Installation for Temp Nodes:
Step by Step instructions for installing Oracle 10g R2 RAC installation. The procedures will provide STEP by STEP guide you for installing two nodes (tempracsrv3 and tempracsrv4). Installation on this phase includes documentation on how to verify the installation and configuration is installed correctly. Step by Step instructions on creating RAC database, importing schemas from oracle 9i database into new databases, and testing database and node connectivity for this phase of the step by step instructions.
Read more…
Objective : The two Solaris 10 prod nodes have Oracle 9i databases and I want to export database to Oracle 10g X 4 node Solaris 10 RAC.
Read more…
The scope of this STEP By STEP documentation will include the following workflow:
*First Phase*
The two prod nodes have Oracle 9i databases and we want to export the database to oracle 10g RAC. Step by Step export instructions for creating a backup copy of databases. Step By Step instruction on how to install new OS version of Sun Solaris 10 to replace Sun Solaris 9.
Read more…
SQL> desc v$mystat
Name Null? Type
—————————————– ——– —————————-
SID NUMBER
STATISTIC# NUMBER
VALUE NUMBER
Read more…
1. Grep occsd Log file
[oracle @ tadrac1]: /u1/app/../cssd >grep -i “master node” ocssd.log | tail -1
[CSSD]CLSS-3001: local node number 1, master node number 1
Read more…
Step A> Sequence of events to pull cluster database down..
1. Bring down load balanced/TAF service
srvctl stop service -d orcl -s RAC
Read more…
PURPOSE : Provide a summary report of all disk groups.
SET LINESIZE 145
SET PAGESIZE 9999
SET VERIFY off
Read more…
– +—————————————————————————-+
– | Jeffrey M. Hunter |
– |—————————————————————————-|
– | PURPOSE : Provide a summary report of all disks contained within all ASM |
– | disk groups along with their performance metrics. |
– | NOTE : As with any code, ensure to test this script in a development |
– | environment before attempting to run it in production. |
– +—————————————————————————-+
Read more…
cd Changes the current directory to the specified directory.
Read more…