DBA SUPPORT

CREATE A PHYSCIAL STANDBY DATABASE - ORACLE 10G DATAGUARD CONCEPT. 1. Os versions / Database Versions / Patchset Level should be same. 2. SID should be same , if not use convert parameter in pfile. · Here SID = CLONE is the same between two servers. Primary side Hostname : devr12.xoffice.com Sid : CLONE Ip : 192.168.0.209 a).Install the Linux Operating system , and #setup -à Disable Firewall at OS Level Mandatory b).Install the Oracle 10g Software System pwd : sadha ; Sys pwd : xxx ---à these two password should same into two nodes. Rman configuration -- if require. Database in the Archive log mode. c). configure ssh between two servers. ** Ssh configuration between to nodes ( servers ) 1 st Node side side : 192.168.0.209 Primary side. a). Login – oracle user b). mkdir ~/.ssh chmod 755 ~/.ssh $/usr/bin/ssh-keygen –t rsa $ /usr/bin/ssh-keygen –t -dsa $ cd .ssh $ cat id_rsa.pub > devr12 Cat id_dsa.pub >> devr12 2nd Node side: 192.168.0.99 Standby side. a). Login – or...

Database up gradation from 10g ( 10.2.0.4 ) to 11g ( 11.1.0.7) in Oracle Application 11i Metalink Note : 452783.1 Step 1 : Down Load the Database Software from (edelivery.oracle.com/ or. http://www.oracle.com/tehnology/software/products/database/index.html 1. 11g Database ( Base versions 11.1.0.6) --- V14215-01_1of2.zip 2. Oracle Database 11g Examples ( formerly Companion ) ---- aix.ppc64_11gR1_examples.zip 3. 11g Database (11.1.0.7) Patch set ---- p6890831_111070_AIX5L_1of2.zip Step 2: Stop the Oracle Application services , and Shutdown the Database and Db Listener. Take Full Cold Backup. Step 3: Create a New 11g Database Home : /B01/oracle $ mkdir test11gdb Step 4 : Install the 11g Database only Software only. $ export Oracle_Base = /B01/oracle/test11gdb …. Export Oracle_SID = TESTNW cd /t01/clone/others/patches/upgrd_db11g/database_11g/database$ $ ./runInstaller -invPtrLoc /B01/oracle/test11gdb /oraInst.loc Note: For oracle Inventory Location Create OraInst.loc file in the ( at New...