Shell Script : #BASH export APEX_UTIL_HOME=/u01/Soft/apex/utilities export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 export CLASSPATH=.:${ORACLE_HOME}/oui/jlib/classes12.jar export JAVA_HOME=/usr/java/jdk1.7.0_60/jre export PATH=/usr/java/jdk1.7.0_60/bin:$PATH export BACKUP_LOC=/u02/${ORACLE_SID}/APEX/backups export CURRDATE=`date ‘+%Y”%m”%d”%H”%M’` if [[ ! -e $BACKUP_LOC ]]; then mkdir -p…
Read MoreIntroduction: Zero downtime is used to perform a cross platform database migration (in our scenario Linux to CentOS) and also a database upgrade (in our scenario from 10g to 11g…
Read MoreIntroduction: Oracle Golden Gate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product enables different business requirements like high availability solutions, real-time…
Read MoreAs everyone knows the biggest task of changing the character set is clean up the lossy data. Challenge is if we have records in millions means how we are going…
Read More./runcluvfy.sh stage -pre crsinst -fixup -n racinst1.doyensys.com,racinst2.doyensys.com -verbose Performing pre-checks for cluster services setup Checking node reachability… Check: Node reachability from node “Rac1” Destination Node Reachable? ———————————— ————————…
Read MoreOracle RAC Architecture A general pictorial guide for how to the install RHEL 5.4 for Oracle RAC can be found here Hostname & IP Requirement Machine Public IP Private IP VIP Storage IP RAC Node1 192.168.1.16 192.168.0.21 192.168.1.21…
Read MoreDownload OpenFiler from the link Click here to download Lets start the OpenFiler installation: Bring down the VMware in Power off mode before the start of Disk Creation. …
Read MoreERROR: ====== ORA-00600: internal error code, arguments: [4194], [#], [#], [], [], [], [], [] CAUSE: ====== This also can be cause by the following defect Bug 8240762 Abstract: Undo…
Read MoreExperience on EXP JOB Hangs :- Oracle DB Version – 10.1/Sun Solaris 5.8 Expdp/Exp hangs for more than 4 hrs, No errors were reported in the alert log and no blocking Session.…
Read MoreDisk creation in vmware Click Add Button Click Next Button Click Next Button Click ide and next Button Size 3gb Click Next Button Click Finish Button Add another one…
Read More