Visit Counter

Monday, May 5, 2014

ORACLE 10g ASM Creation on Oracle Linux 5


Environment:

Oracle Virtual Box
Oracle Linux 5
Oracle Database 10g


1- Install Oracle Linux 5 on virtual machine.


2- Create oracle user & group oinstall,dba,oper


3- Download & install ASMLib packages.


http://www.oracle.com/technetwork/server-storage/linux/downloads/rhel5-084877.html#oracleasm_rhel5_amd64

oracleasm-2.6.18-8.el5-2.0.4-1.el5.x86_64.rpm
oracleasmlib-2.0.4-1.el5.x86_64.rpm
oracleasm-support-2.1.8-1.el5.x86_64.rpm

# rpm -ivh oracleasm-2.6.18-8.el5-2.0.4-1.el5.x86_64.rpm
# rpm -ivh oracleasmlib-2.0.4-1.el5.x86_64.rpm
# rpm -ivh oracleasm-support-2.1.8-1.el5.x86_64.rpm

4- Virtual machine and add 4 disks.

5- Create required partitions

[root@oraasm1 ~]# fdisk -l

Disk /dev/sda: 107.6 GB, 107660443648 bytes
255 heads, 63 sectors/track, 13088 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1        2295    18434556   83  Linux
/dev/sda2            2296        9307    56323890   83  Linux
/dev/sda3            9308       10582    10241437+  83  Linux
/dev/sda4           10583       13088    20129445    5  Extended
/dev/sda5           10583       11857    10241406   82  Linux swap / Solaris
/dev/sda6           11858       13004     9213246   83  Linux

Disk /dev/sdb: 17.7 GB, 17752522752 bytes
255 heads, 63 sectors/track, 2158 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Disk /dev/sdb doesn't contain a valid partition table

Disk /dev/sdc: 17.7 GB, 17752522752 bytes
255 heads, 63 sectors/track, 2158 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Disk /dev/sdc doesn't contain a valid partition table

Disk /dev/sdd: 17.7 GB, 17752522752 bytes
255 heads, 63 sectors/track, 2158 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Disk /dev/sdd doesn't contain a valid partition table

Disk /dev/sde: 17.7 GB, 17752522752 bytes
255 heads, 63 sectors/track, 2158 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Disk /dev/sde doesn't contain a valid partition table


[root@oraasm1 ~]# fdisk /dev/sdb
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 2158.
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)

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-2158, default 1): 1
Last cylinder or +size or +sizeM or +sizeK (1-2158, default 2158):
Using default value 2158

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@oraasm1 ~]# fdisk /dev/sdc
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 2158.
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)

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-2158, default 1): 1
Last cylinder or +size or +sizeM or +sizeK (1-2158, default 2158):
Using default value 2158

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@oraasm1 ~]# fdisk /dev/sdd
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 2158.
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)

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-2158, default 1): 1
Last cylinder or +size or +sizeM or +sizeK (1-2158, default 2158):
Using default value 2158

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@oraasm1 ~]#


[root@oraasm1 ~]# fdisk /dev/sde
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 2158.
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)

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-2158, default 1): 1
Last cylinder or +size or +sizeM or +sizeK (1-2158, default 2158):
Using default value 2158

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@oraasm1 ~]#


6- Configure ASM options.

[root@oraasm1 ~]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting <ENTER> without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]
[root@oraasm1 ~]#
[root@oraasm1 ~]# /etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]
[root@oraasm1 ~]#


7- label Disks

[root@oraasm1 ~]#
[root@oraasm1 ~]# /etc/init.d/oracleasm createdisk vol1 /dev/sdb1
Marking disk "vol1" as an ASM disk:                        [  OK  ]

[root@oraasm1 ~]# /etc/init.d/oracleasm createdisk vol2 /dev/sdc1
Marking disk "vol2" as an ASM disk:                        [  OK  ]

[root@oraasm1 ~]# /etc/init.d/oracleasm createdisk vol3 /dev/sdd1
Marking disk "vol3" as an ASM disk:                        [  OK  ]

[root@oraasm1 ~]# /etc/init.d/oracleasm createdisk vol4 /dev/sde1
Marking disk "vol4" as an ASM disk:                        [  OK  ]

[root@oraasm1 ~]#


8- Install Oracle 10g database software only.
 

Note: Add the redhat-5 in oraparm.ini file

/ora/oracle/Desktop/database/install/oraparam.ini
 
[Certified Version]
Linux=redhat-3,SuSE-9,redhat-4,redhat-5

Install the below packages.

xorg-x11-deprecated-libs-6.8.2-1.EL.52.x86_64.rpm
openmotif21-2.1.30-11.RHEL4.6.i386.rpm
openmotif-2.2.3-10.2.e14.x86_64.rpm
compat-glibc-headers-2.3.2-95.30.x86_64.rpm
compat-glibc-2.3.2-95.30.x86_64.rpm
compat-libstdc++-296-132.7.2.i386.rpm
compat-db-4.1.25-9.i386.rpm
compat-db-4.1.25-9.x86_64.rpm
libstdc++-devel-3.4.6-9.i386
libaio-0.3.105.2.x86_64.rpm
libaio-devel-0.3.105-2.x86_65.rpm
libobjc-3.4.6-10.x86_64.rpm
libieee1284-0.2.8-4.x86_64.rpm
sysstat-5.0.5-16.rhel4.x86_64.rpm
glibc-kernheaders-2.4-9.1.100.EL.x86_64.rpm
glibc-headers-2.3.4-2.39.x86_64.rpm
glibc-devel-2.3.4-2.39.i386.rpm
glibc-devel-2.3.4-2.39.x86_64.rpm
glibc-2.3.4-2.41.x86_64.rpm
gcc-3.4.6-9.x86_64.rpm
gcc-c++-3.4.6-9.x86_64.rpm
gcc-objc-3.4.6-10.x86_64.rpm
sane-backends-1.0.14-6.e14.1.x86_64.rpm


9- Create Database using DBCA

$./dbca

























































4 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Hello Sir,

    can you please provide me a direct rpm file

    oracleasmlib-2.6.18-8.el5.rpm

    [root@node2 rpms]# uname -rm
    2.6.18-8.el5 x86_64

    Regards,
    Syed Ali

    ReplyDelete
  3. You can download from below oracle site.

    http://www.oracle.com/technetwork/jp/server-storage/linux/downloads/rhel5-083144-ja.html

    ReplyDelete
  4. As you use theAWS Database Migration Serviceall you need to worry about is the structure of your data; the service handles the rest. With the AWS Database Migration Service, you can migrate your data to a regional database in as little as 15 minutes. The service supports SQL Server, Oracle, PostgreSQL, MySQL, SAP ASE, and IBM DB2 databases. The AWS Database Migration

    ReplyDelete