Mir Sayeed Hassan Blog- Oracle DBA

Install by using the 2 virtual machine -          Create the 2 VM with Oracle Linux 6.7 Installation -          Create the HDD & Shared by 2 VM   -- (Network team handle this step) Oracle Installation Prerequisites on NODE 1 & Setup as fallows Verify & installed the missing RPM PACKAGES from the ISO File: -          # From Oracle Linux 6.7 iso file -          cd /media/OL6.7 x86_64 Disc 1 20150728/Server/Packages Before executing the below packages, verify by using below command Example : rpm –qa binutils*    -- (If you find it means its installed already, if not install) -          rpm -Uvh binutils-2.* -          rpm -Uvh compat-libstdc++-33* -   ...

Step by step procedure: $ rman target / RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters for database with db_unique_name PRIM are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default CONFIGURE ARCHIVELOG DELETION PO...

1 st – Starting ASM [root@asmdb ~]#su - grid [grid@asmdb ~]$ asmcmd Connected to an idle instance ASMCMD> ls ASMCMD-08102: no connection to ASM; command requires ASM to run ASMCMD> [grid@asmdb ~]$ sqlplus / as sysasm SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 23 17:44:30 2017 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Automatic Storage Management option SQL> conn / as sysasm Connected to an idle instance SQL> startup ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service SQL> exit Disconnected 2nd : Starting DB [oracle@asmdb ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 23 17:15:15 2017 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total ...

                                                                 Mir Sayeed Hassan                                          A self-motivated and result oriented Professional with around 7+ years of experience in Oracle DBA at IT Industry & Oracle Certified Professional(OCP)  9i,10g & 11g , which includes Oracle Database Administration, Oracle Golden Gate(OGG) & Corporate Trainer for Oracle DBA, Banking & Information Technology to align Bank’s IT strategy with business objective...