Home » Infrastructure » Linux » Oracle's 10gR2 ASM with Standard Linux I/O in CentOS 4.1 environment
Oracle's 10gR2 ASM with Standard Linux I/O in CentOS 4.1 environment [message #137403] Thu, 15 September 2005 02:05
dba477
Messages: 10
Registered: July 2005
Junior Member
This method creates Oracle database files on raw character devices
managed by ASM using standard Linux I/O system calls.It requires to create
RAW devices for all disk partitions used by ASM.

1.Install CentOS 4.1
2.Run as root:

# groupadd dba # group of users to be granted SYSDBA system privilege
# groupadd oinstall # group owner of Oracle files
# useradd -c "Oracle software owner" -g oinstall -G dba oracle
# passwd oracle
# mkdir -p /u01/app/oracle
# chown -R oracle.oinstall /u01
# mkdir -p /u02/oradata/data
# chown -R oracle.oinstall /u02

Just as an example create 4 partitions: /dev/hda6,/dev/hdc6 5 GB each one
/dev/hda7,/dev/hdc7 3 GB each one

Create raw devices modifying file /etc/sysconfig/rawdevices as follows:

/dev/raw/raw1 /dev/hda6
/dev/raw/raw2 /dev/hdc6
/dev/raw/raw3 /dev/hda7
/dev/raw/raw4 /dev/hdc7

Put in /etc/rc.d/rc.local

chown oracle:dba /dev/raw/raw*
chmod 660 /dev/raw/raw*

I was experiencing problems with loosing "oracle:dba" permissions after Linux
reboot. It came up with "root:disk" .

Restart Linux

Run as root:-

# /sbin/service rawdevices restart

Tune /etc/sysctl.conf,/etc/security/limits.conf,/etc/pam.d/login, /etc/profile.
and oracle's shell environment as advised in [1].
Login as oracle:-


$ cd /tmp/database
$./runInstaller

Select " Advanced installation" and
create ASM instance in $ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/asm
During this run create diskgroup RAWDATA1 with normal redundancy mirroring
/dev/raw/raw1 and /dev/raw/raw2

You should be fine with discovering raw devices if permissions are in place (oracle:dba)

Exit installer.

Export ORACLE_HOME for ASM instance and corresponding PATH.
Then run "dbca" to create diskgroup RAWDATA2 with
normal redundancy mirroring /dev/raw/raw3 and /dev/raw/raw4


$ ./runInstaller


Select " Advanced installation" and create new ASM-database placed in RAWDATA1 diskgroup
and $ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1.
Modify ~oracle/.bash_profile correspondently.Relogin as oracle.

Next:-

$ sqlplus /nolog
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 88082024 bytes
Database Buffers 188743680 bytes
Redo Buffers 7168000 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database rawdbs flashback on;
Database altered.
SQL> alter database open;
Database altered.

Open Enterpise Manager console.(Enterprise Manager 10g Database Control URL http://ServerCentOS41:1158/em). Put flashback recovery area in RAWDATA2 modifying corresponding value on Recovery Settings page of EM.

References.
1.www.puschitz.com/InstallingOracle10g.shtml
Previous Topic: linux
Next Topic: Download 10G for AMD
Goto Forum:
  


Current Time: Thu Mar 28 21:26:00 CDT 2024