الأخوة الأعزاء
السلام عليكم ورحمة الله وبركاته
باذن الله تعالى سنبدا خطوة بخطوة فى تنزيل الراك بالستخدام الاصدار 10gr2 على نظام تشغيل لينكس ( علما بان نسخة اللينكس المستخدمة هى RedHat Enterprise 5.4 )
اولا نبدا بشرح فكرة الراك وعذرا لو كان الشرح بالانجليزية

RAC (Real Application Cluster) is more than one instance that can connect to single database

This database id stored in shared storage area that can be not in any one of local servers
we will split This process into small process:-
-install Linux os and configure kernel parameter for installing oracle software
-create oracle groups and users and directories on both nodes
-configure ssh for oracle user in both linux servers ( both nodes )
-how to create ASM disks that will be used for data files storage and for store OCR and Voting disks
-install oracle clusterware in tow nodes and running needed scripts
-create and install ASM instance in tow nodes
-install oracle software
-create database
-patching clustwrware and ASM instance and database
-configure database services on tow nodes
- configure Fail over and load balance
-Enjoy your RAC

Configure_linux_OS_For_RAC_Install.txt

السلام عليكم ورحمة الله وبركاته

ممتاز يا استاذ وإلى الأمام
ممكن بعد اذنك يكون الشرح بالتفصيل
شكراً

[email protected]

Now we come to the first step which it is how to configure you Linux OS for installing RAC and how to configure ssh

1- install Linux os and configure kernel parameter for installing oracle software
---------------------------------------------------------------------------------------------
-First you must have at least tow network cards one for public IP and the second for private that will take an ip but in different range from public ip
as same as the hosts file written
I thinks on this step the only thing we can do is how to update kernel parameter ( i mean we can not explan how to install linux os here as there is many posts explain that )
all we have to do here is to take the following steps and execute then after installing your linux os
-go to hosts file in path /etc/hosts and add the following lines
# Public addresses
10.20.0.101 Your_Node_Name1
10.20.0.102 Your_Node_Name2

# Private Interconnect
10.0.0.1 Your_Node_Name1-priv
10.0.0.2 Your_Node_Name2-priv

# Public Virtual IP (VIP) addresses
10.20.0.103 Your_Node_Name1-vip
10.20.0.104 Your_Node_Name2-vip

NOTE : Replace the word Your_Node_Name with your server (node) name
now we come to create user oracle and oinstall and dba groups -
/usr/sbin/groupadd -g oinstall
/usr/sbin/groupadd -g dba
/usr/sbin/useradd -m -g oinstall -G dba -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle
- setting oracle password
passwd oracle
enter your password and press enter and reenter it again
-now the step for create specified directories that will hold that clusterware data (OCR+Voting disks)
and ASM and datafiles and change the owner for those directories for oracle and oinstall
# Oracle Base directory
-mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app/oracle

# Oracle Home Directory
# crs will hlod clusterware files
mkdir -p /u01/app/oracle/product/10.2.0/crs
chown -R oracle:oinstall /u01/app/oracle/product/10.2.0/crs
chmod -R 775 /u01/app/oracle/product/10.2.0/crs

# Oracle ASM home
mkdir -p /u01/app/oracle/product/10.2.0/+ASM
chown -R oracle:oinstall /u01/app/oracle/product/10.2.0/+ASM
chmod -R 775 /u01/app/oracle/product/10.2.0/+ASM

# Oracle Database Home
mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle:oinstall /u01/app/oracle/product/10.2.0/db_1
chmod -R 775 /u01/app/oracle/product/10.2.0/db_1

-When you create oracle user there is file called .bash_profile will be created in path /home/oracle
open this file with vi command and add the following lines to it
************* Begin of lines to be added ************
# .bash_profile
# Get the aliases and functions
# User specific environment and startup programs
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORA_CRS_HOME=/u01/app/oracle/product/10.2.0/crs
export ORACLE_PATH=$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin
export CV_JDKHOME=/usr/local/java
# Each RAC node must have a unique ORACLE_SID. (i.e. racdb1, racdb2,...)
export ORACLE_SID=racdb2
export PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
***************************End of lines**************************************
this files should be updated in both nodes and for NODE1 ORACLE_SID paramter should be racdb1 and for NODE2 =racdb2

- There is some kernel parameter should be updated for oracle and those updates must be updated according to Linux release that you use and way
just make those
-open /etc/sysctl.conf with any editor and add
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.ipv4.ip_local_port_range = 32768 65000
net.core.rmem_default=1048576
net.core.rmem_max=1048576
net.core.wmem_default=262144
net.core.wmem_max=262144

Save and close the file

- open /etc/security/limits.conf and add

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

Save and close the file

open the file /etc/pam.d/login
session required /lib/security/pam_limits.so

save and colse file

open file /etc/profile
if [ \$USER = "oracle" ]; then
if [ \$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi

save and colse

open file /etc/csh.login
if ( \$USER == "oracle" ) then
limit maxproc 16384
limit descriptors 65536
endif

save and close

and reboot your tow machines after making those updates
********************************************************************************
*****************************
NOTE : The following steps must be made in tow nodes
********************************************************************************
*****************************
- Now come to configure ssh for oracle user on tow nodes (making oracle user to make ssh for the other oracle user in the other node without password
log in tow one node with user oracle and do the following
-mkdir -p ~/.ssh
chmod 700 ~/.ssh

-generate RSA keys
/usr/bin/ssh-keygen -t rsa
press enter and enter until finishing generating the keys ( do note enter any passwords )

-generate DSA keys
/usr/bin/ssh-keygen -t dsa
press enter and enter until finishing generating the keys ( do note enter any passwords )

-create file that will hold the rsa and dsa contents
touch ~/.ssh/authorized_keys
chmod 600 ~/.ssh/authorized_keys

- Now go to the other node and execute the previous steps and after this copy the contents for rsa and dsa file to authorized file (from node1 with user ORACLE login)

ssh Your_Node_Name1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh Your_Node_Name1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
ssh Your_Node_Name2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh Your_Node_Name2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys

- copy the authorized_keys to Node2

scp ~/.ssh/authorized_keys Your_Node_Name2:.ssh/authorized_keys

-After this we will test ssh from one node to anther node
-from node1 with oracle user do
ssh node1 date
ssh node2 date
ssh node1-priv date
ssh node2-priv date

if any command ask you about password enter the password for oracle user and re enter the command again
on second time you execute the ssh command it should not ask you about any password

-Now go to the second node and do the same ssh commands

UNTIL this steps we will go the INSTALL ORACLE CLUSTEWRWARE on both nodes and this will be in the next lesson and this will be screen shoots pics

Configure_linux_OS_For_RAC_Install.txt

السلام عليكم ورحمة الله وبركاته

سؤال ممكن اسطب الـ RAC على وندوز XP
ولا لازم اللينكس
وشكراً

[email protected]

This step will take us to oracle clusterware installation on tow nodes

first go to oracle website and download clusterware and database software
الرابـــــط

and then login to linux os with root user and issue

كـود SQL

unzip /you_path_which_you_put_files/10201_clusterware_linux_x86_64.cpio.gz
this will give you 10201_clusterware_linux_x86_64.cpio file
then issue
cpio -idmv << 10201_clusterware_linux_x86_64.cpio
this will give Disk1
go to the top directory for Disk1 and issue
chmod -R 775 /path_for Disk1

and make the same thing for database file when you download it
الرابــــــط

- first go to node1 and log in with oracle user and go to the path for clusterware
then issue ./runInstaller

1_5.rar

اسف لانه هناك خطوات يجب ان تسبق الوصول الى تنزيل ال Clusterwareوهى تهيئة وانشاء البارتشنز الازمة ل ASM Instance
وهى ما سنتناولة فى الدرس القادم ان شاء الله

تم تعديل 13 فبراير 201016 سنة بواسطة searcher

الاخ محمد من الافضل انك تنزل virsual machine on vmware and install linux on it and go on

السلام عليكم ورحمة الله وبركاته

استاذي العزيز
ممكن تقولي منين احصل على نسخة لينكس وازاي اسطبها
شكراً لك جدا جدا جدا

[email protected]

الاخ محمد منتدى اللينكس حفيدك كتير ابحث فيه

السلام عليكم ورحمة الله وبركاته

وجدت redhat Enterprise 5.3
على الرابط
http://www.araboug.org/ib/index.php?showtopic=35024
تؤدي الغرض
واللا لازم redhat Enterprise 5.4

[email protected]

تم تعديل 14 فبراير 201016 سنة بواسطة محمد جمعه

الاخ محمد
النسخة الموجودة تؤدى الغرض
ولكن هناك بعض التغيرات سوف الفت نظرك اليها عند المجىء للنقط التى تتطلب ذلك وهى (oracleasm)

الأخوة الأعزاء
نعود الى الجزء المفقود الذى نوهت له قبل تنزيل oracle clusterware وهو تهيئة الاماكن التى ستخزن فيها OCR and Voting disk وايضا data files and archive logs
هنا سوف نستخدم تقنية ASM لتخزين data files and archive log files اما ال OCR and Voting disks will be stored in raw devices
Now to configure ASM disks that will hold data files that will be in shared storage
Note :Here I used HP storage EVA 4000 but most of us will make it in his test so you can use open-filer software and you must create a third virsual machine in vmware to install open filer that will be instead of my storage
You can download it from this link
الــــرابـــــــــــــــــطــــ

Now we come to how to create asm disks
after you install your Linux OS and update you kernel parameter as explained in previous post
issue this command to know your kernel version
uname -r
this will return your kernel version like >> 2.6.18-164.el5xen
according to you kernel version you must download the suitable Oracle ASM library driver from this website

الـــرابــــــــط

after downloading the Oracle ASM library driver files
There is tow files attached with this post download them and put them in same folder with your asm library driver for your kernel which you previously downloaded and then install the three files as following :

[root@your_node_name1 /]#cd /your_path_for_asm_files
then issue this command :

[root@your_node_name1 /]# rpm -Uvh oracleasm-support-2.1.3-1.el5.x86_64.rpm \
oracleasmlib-2.0.4-1.el5.x86_64.rpm \
oracleasm-2.6.18-164.2.1.el5-2.0.5-1.el5.x86_64.rpm

ملحوظة هامة:-
فى الامر السابق تم تنزيل 3 rpms الاخيرة هى التى سوف يتم تغيرها حسب اصدار الكيرنل الخاص بنظام التشغيل اى انها تختلف من حسب النسخة المستخدمة

after completing the installation

login to your linux machine with root user and issue the following :-

[root@your_node_name1 /]# /etc/init.d/oracleasm configure
it will ask you about the owner of of the driver and the group enter oracle as user and dba as group and complete the question by entering (y) as answer for any question like the following

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 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
Fix permissions of Oracle ASM disks on boot (y/n) [y]: 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 ]

now we finished oracleasm configuration

we will create ASM DISKS later
Thanks

oracleasm_driver.rar

تم تعديل 15 فبراير 201016 سنة بواسطة searcher

مشكور يا غالي جزاك الله خيرا

اخي الكريم
اي نسخة من اليونكس استخدامتها مع الراك
كيف يكمن الحصول عليها
وشكرا

يفضل الرد هات اى اصدار ان استخدم 5.0