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
This comment has been removed by the author.
ReplyDeleteHello Sir,
ReplyDeletecan 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
You can download from below oracle site.
ReplyDeletehttp://www.oracle.com/technetwork/jp/server-storage/linux/downloads/rhel5-083144-ja.html
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