Installation of SAP on RAC with Oracle ASM
Dear All,
I am writing this blog , as i faced issue on installing SAP system on oracle RAC with ASM.
When i raised a message with SAP , SAP told me to install SAP on oracle and then migrate it to RAC with ASM.
So i want to add few points to make it easier for others. There are few importants points which we need to remember.
1. SWPM will give you four options to install SAP
i. Single Instance on Filesystem
ii. Single Instance on Oracle ASM
iii. RAC on Filesystem
iv. RAC on oracle ASM
2.Database RAC Parameter
3. We need to know about the scan listener name and port which it is using. By default it uses a port 1521.
4. Listener Configuration for each RAC Node.
I have to install the SAP on RAC with oracle ASM , in a distributed environment, so i installed the SCS first , which got completed successfully.
After this ,i started the installation with Database instance installation.
What option should we select in SWPM for RAC?
SWPM will give you four options for Database installation scenario.
i. Single Instance on Filesystem (normal)
ii. Single Instance on Oracle ASM(oracle is on ASM without RAC )
iii. RAC on Filesystem (RAC nodes without ASM )
iv. RAC on oracle ASM(RAC node will exists with ASM)
I have selected option RAC on oracle ASM as we are having RAC with ASM environment.
Database RAC Parameter
In the below diagram , where you need to provide the RAC Parameters
i. Database Name : You need to enter the Database name(DBSID) as per your requirement for example i have given DBSID as RAD.
ii. Number of instances : You need to specify the number of instances to be created which in turn depends on the number of RAC Node.
Suppose , we are having three RAC node RACN1 , RACN2 , RACN3 and i have mentioned DBSID as RAD.
Since we are using three RAC node so Number of Instances we need to mentioned 3 and it will create three instances of DB and assigned them to each RAC node.
RACN1—–>RACN2—–>RACN3
RAD1 RAD2 RAD3
iii. Length of Instance Number : i. One character
ii. Three character.
if we select the one character option , then DBSID(in our case which is RAD) followed by one character digit for each instance on RAC node.
For eample
RACN1—–>RACN2—–>RACN3
RAD<N> RAD<N+1> RAD<N+2> Where N stands for Length for Instance Number
Since we have selected the option one character so here value of N will start from 1.
RACN1—–>RACN2—–>RACN3
RAD1 RAD2 RAD3 where N=1
So it will be same for three character option where N starts from 001 and so the naming convention for the instances will be
RACN1——->RACN2——->RACN3
RAD001 RAD002 RAD003 where N=001
What we need to know about the SCAN Listener?
SWPM asked for scan listener name only but we need to input port number as well , which it didn’t asked for?
if you don’t specify the port number , it will give I/O network error and will not able to connect to Database.
When we setup the RAC environment , a Server control utility get installed on each RAC node by default which is used to start ,stop , manage configuration information and also used to add and remove the instances from RAC environment. By the help of Server control utility , we can get the scan listener name and its port number.
When we run below command on the primary RAC node , we will be get the scan listener name.
srvctl config scan
It will give us the scan listener name and ip information(Generally we keep three scan listener)
srvctl config scan_listener
The above command , will let us know which port is configured for the scan listener.
Here we need to enter the correct scan listener name which is configured on RAC environment as it will have it own scan listener.
SCAN stands for Single client Access Name.
Scan Listener* : Enter the scan listener name which will be used by the SAP to connect to Database and if , it is a Dual stack or only Java stack then JDBC string will be created using the scan listener name.
After firing the command ” srvctl config scan” and “srvctl config scan_listener” we will get the scan listener name and its port number
Suppose our scan listener name is scan1 and port number is 1521 (which is default) so in Label
Oracle RAC secure store connect* will be like this
jdbc:oracle:thin:@/scan1:1521/Service_name since the Service_name is the DBSID which is RAD.
So the final string , will be
jdbc:oracle:thin:@/scan1:1521/RAD (Here i have mentioned the port 1521 explicitly)
Listener Configuration for each RAC Node
You need to configure the local listener parameter for each RAC node and remote listener parameter will be scan listener which will be common for each RAC node.
In Spfile<SID>.ora , you need to add local listener for each RAC node with the port number which will be different from scan listener port number.
In Spfile<SID>.ora , you need to remove the parameter *.local_listener and in place of it you need to add three parameter for each RAC node and the corresponding instance. For example , we are having three instance distributed on each RAC node RACN1 , RACN2 , RACN3.
Local Listener parameter will be like this
RAD1.local_listener=’//RACN1:1527′ (for RAC node RACN1 having a instance RAD1)
RAD2.local_listener=’//RACN1:1527′ (for RAC node RACN2 having a instance RAD2)
RAD3.local_listener=’//RACN1:1527′ (for RAC node RACN3 having a instance RAD3)
But
There will be only remote listener which will have the scan listener name and its port number
*.remote_listener=’//scan1:1521′ (it will be common on all the RAC Node)
Now why we are configuring the local listener on each RAC node with a a different port number.
We are configuring the local listener so that we can take the backup for Database using a BR*TOOLS.
I will be writing a next blog on BRTOOLS in RAC environment.
Please follow the below SAP Notes and While Paper published from SAP
1. Note 581320 – FAQ: Oracle Real Application Cluster (RAC)
2. Note 527843 – Oracle RAC support in the SAP environment
3. http://scn.sap.com/docs/DOC-8835
Kindly also check the blogs
Installation of SAP on RAC with Oracle ASM part 1(Distributed Environment)
Installation of SAP on RAC with Oracle ASM part 2(Distributed Environment)
Installation of SAP on RAC with Oracle ASM part 3(Distributed Environment)
With Regards
Ashutosh Chaturvedi
Thanks for sharing...Ashutosh Chaturvedi
regards
kartik
Thank you Karthik
With Regards
Ashutosh Chaturvedi
Thanks for sharing this great article on installation of SAP on RAC. I was looking for information on this installation option for a longtime and there were exact info available till now. Really appreciate for sharing.
I have one doubt do we need to start the SAPINST with user “ORACLE” or can we start with any admin user.
Regards
Kishore
Dear Ketu,
You need to start sapinst with root user!!
Thanks Ashutosh. Can we set manually the "cluster_database" parameter to true. Because the sapinst is taking it as "false" and also the comment says don't modify this parameter.
Hi Ketu,
SAPinst will change the parameter to true in perform oracle post load activities
With Regards
Ashutosh Chaturvedi
Hi Ashutosh,
Thank you for sharing this valuable info
Regards
Sudhir Sadhu
Nice Document
Thank you abhishek!!!
Thanks a lot for the nice document. I am in the process of planning migration of a SAP/Oracle database to Oracle RAC. Can I use the SWPM in the source system and export & use the spainst in the target server and do the import process - during the import process install the oracle in RAC/ASM & import from the dump the source system?
(similar to system copy except installing the oracle RAC/ASM in the target)
Will this method work? Would appreicate if you can share your experience on this?
Venkat
Nice blog....
Nice document, is there any document which provides end to end SAP installation document on Oracle11gr2 RAC with ASM including Grid infrastructure installation with ASM and Oracle software installation, those binaries will be provided by Oracle or SAP.
A step by step guide can be found here: http://goo.gl/wncNqN
Excellent post, It really helped me in my first installation on RAC
Hi All,
I have requirement to install SAP on oracle RAC , but oracle RAC was already installed by another vendor. Now I have to install SAP on it .
Please help me how to proceed.
Dear Balamurugan,
Kindly share your email id , i will drop you a mail.
With Regards
Ashutosh Chaturvedi
Dear Ashutonsh,
Thanks. Please share the details to balamurugan44.r@gmail.com
And also I have to install 4 applications on the RAC whcih contains two nodes.
When I check the scan listener name in server , I can see LISTENER_SCAN1 in node one and LISTENER_SCAN2 in node 2 .
While installing applications which listener name should I give .
Can I use same listener name for all 4 applications .
Please advise.
Regards
Bala
Hi Ashutosh,
Could you please share me the details.
balamurugan44.r@gmail.com
Regards
Bala
Hi Bala,
I have dropped you a mail with the details
With Regards
Ashutosh Chaturvedi
Thank you Michael Rodrigo
Hello Ashutosh,
Could you please share some document on Installation and Configuration of SAP HA
ASCS/ERS Instances On Oracle 12 RAC on ASM , Mail ID : raju.basis@gmail.com.
Hello Ashutosh,
We currently have an environment in which the Oracle Database is setup and configured in a Oracle RAC environment and is working fine. Our CI is configured in a Broken Red Hat Cluster. We would like to Replace the CI with a new installation on SAP HA ASCS/ERS Instances On Oracle 12 RAC on ASM and connect it back to the existing database. SAP has told me that I just need to install on Host A - PAS and Host B - AAS with ERS. Do you know the steps I would take to do this and how I would configure it? E-Mail is Marilyn.Daffron@yahoo.com
Thanks!
Marilyn
Hello Ashutosh,
Do you have any documentation on upgrading SAP databases from 11gR2 to 12cR1 with RAC, ASM , and Multi-Tenant?