Monday, July 11, 2011

Installation of RHEL on HP

Author           : Gandhi Sakyi
HP Hardware:  HP DL 380 G7
Redhat Linux:  RHEL 5.4 (64bits)
RAM                :   8GB

DISK CONFIGURATION

I Implemented RAID 1+0 Configuration for 8 , 300 GB DISKS with the help of the HP SmartStart accompanying CD. I created 2 SAS Array Logical Drives & volume each of 558.7 GB of size.

For Steps on how to implement and configure RAID 1+0 please follow the below links:


Mount  Points
volumes                Sizes(MB)                                            Mount Point
lvol0                        5536                                                          swap
lvol1                        10240                                                       /
lvol2                        2048                                                         /stand
lvol3                        8192                                                         /var
lvol4                        8192                                                         /usr
lvol5                        15360                                                       /tmp
lvol6                        15360                                                       /opt
lvhome                  20480                                                       /home
lvappl                     30814                                                       /appl
lvora01                   50000                                                       /ra/oradata/u01

Saturday, July 9, 2011

DATA - GUARD Trouble Shooting (Warning: ORA-16608: one or more databases have warnings)

Warning: ORA-16608: one or more databases have warnings

DGMGRL> show configuration

Configuration
  Name:                FDSS_PRDB
  Enabled:             YES
  Protection Mode:     MaxPerformance
  Fast-Start Failover: DISABLED
  Databases:
    FDSS_PRDB - Primary database
    FDSS_DRDB - Physical standby database

Current status for "FDSS_PRDB":
Warning: ORA-16608: one or more databases have warnings

DR TROUBLESHOOTING
  1. select group#,thread#,archived from v$log;

  1. DGMGRL> SHOW DATABASE 'FDCORE_DRDB' StatusReport;
STATUS REPORT
       INSTANCE_NAME   SEVERITY ERROR_TEXT
                   *    WARNING ORA-16826: apply service state is inconsistent with the DelayMins property

  1. DGMGRL> SHOW DATABASE 'FDCORE_PRDB' StatusReport;
STATUS REPORT
       INSTANCE_NAME   SEVERITY ERROR_TEXT

  1. THE SOLUTION IS TO DISABLE AND ENABLE THE CONFIGURATION


Monday, May 2, 2011

Monday, November 22, 2010

Title: ASMLib Installation and Configuration (Quick Guide)

  1. Part A: With Partition Disks
System Requirement
  1. RHEL 4 (UPDATE 5)
  2. ORACLE 10g R2
  3. VM WORKSTATION ACE EDITION V6

  1. Install your "oracle software only" installation
Click on the below for installation manuals : www.oracle-base.com

  1. Run the below command on your linux box for the kernel version you using
    1. #uname -rm

  1. Download the ORACLE ASMLIB for your kernel from the below link:

Ex:
[root3orcl oracleasm—2. 6. 9-55.ELsmp]# uname —rm
2.6.9—SS.ELsmp_i686

I then click on the above link and then scrolled down to the section with the below heading since I was using a 32-bit Inter Achitecture:
Intel IA32 (x86) Architecture

I then downloaded the below:

Library and Tools

Drivers for kernel 2.6.9-55.EL

  1. Install the packages by running the below command:
    1. # rpm -Uvh oracleasm-support-2.1.3-1.el4.i386.rpm  \
                           oracleasm-2.6.9-55.EL-2.0.3-1.i686.rpm \
                           oracleasm-2.6.9-55.EL-2.0.3-1.i686.rpm

  1. Configure the ASMLib
    1. #  /etc/init.d/oracleasm configure
                          Default user to own the driver interface []: oracle
                          Default group to own the driver interface []: oinstall
                          Start Oracle ASM library driver on boot (y/n) [n]: y
                          Fix permissions of Oracle ASM disks on boot (y/n) [y]:
                          Writing Oracle ASM library driver configuration:           [  OK  ]
                          Creating /dev/oracleasm mount point:                       [  OK  ]
                          Loading module "oracleasm":                                [  OK  ]
                          Mounting ASMlib driver filesystem:                         [  OK  ]
                          Scanning system for ASM disks:                             [  OK  ]
  1. Format your hard drive to get at least three (3) partitions

               Ex:
               # fdisk /dev/sda

               Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
           Building a new DOS disklabel. Changes will remain in memory only,
           until you decide to write them. After that, of course, the previous
           content won't be recoverable.

           The number of cylinders for this disk is set to 1305.
           There is nothing wrong with that, but this is larger than 1024,
           and could in certain setups cause problems with:
           1) software that runs at boot time (e.g., old versions of LILO)
           2) booting and partitioning software from other OSs
           (e.g., DOS FDISK, OS/2 FDISK)
           Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
               
                 
               A.
               Command (m for help): n
           First cylinder (1416-2610, default 1416):
           Using default value 1416
           Last cylinder or +size or +sizeM or +sizeK (1-1305, default 1305): +2000M
                         
              B.
              Command (m for help): w
           WARNING: … drive is busy.
           The partition table has been altered!

           Calling ioctl() to re-read partition table.
           Syncing disks.

              #

              NB: The remaining disks ("/dev/sda7" and "/dev/sda8") must be partitioned in the         
                       same way, repeat from A to B to complete the sda7 - sda8.

When you are done reboot the system.

  1. Once the kernel module is loaded, stamp (or label) the partitions created earlier as ASM disks  


  1. [root@0rc1 dev]# /etc/init.d/oracleasm createdisk VOL1 /dev/sda6

  1. [root@0rc1 dev]# /etc/init.d/oracleasm createdisk VOL2 /dev/sda7

  1. [root@0rc1 dev]# /etc/init.d/oracleasm createdisk VOL3 /dev/sda8 

  1. Scan for the ASM Disks
                        Ex:
  1. [root@orcl dev]# /etc/init.d/oracleasm scandisks
Scanning the system for oracle ASMLib disks:   [OK]

  1. List the stamped disks.
                       Ex:
  1. [root@orcl dev]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3

  1. The disks are now ready to be used by ASM.

NB: For full documentation access the below link: