{"id":2139,"date":"2013-03-10T09:20:50","date_gmt":"2013-03-10T09:20:50","guid":{"rendered":"http:\/\/www.oratraining.com\/blog\/?p=2139"},"modified":"2013-03-19T09:39:00","modified_gmt":"2013-03-19T09:39:00","slug":"installing-11g-rac-on-linux-vm-install-oracle-database-software-and-create-rac-database-2","status":"publish","type":"post","link":"https:\/\/www.oratraining.com\/blog\/2013\/03\/installing-11g-rac-on-linux-vm-install-oracle-database-software-and-create-rac-database-2\/","title":{"rendered":"Installing 11g RAC on Linux VM: Install Oracle Database software and create RAC database"},"content":{"rendered":"

Previous:<\/strong><\/p>\n

You can start database installation from <stage>\/database directory as follows. Make sure to use database owner user oradb<\/strong>.<\/p>\n

[oradb@dbhost1 ~]$ cd \/mnt\/hgfs\/setup\/database\/<\/strong><\/p>\n

[oradb@dbhost1 database]$ .\/runInstaller<\/strong><\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Deselect the checkbox and click Next<\/strong><\/p>\n

\"\"<\/p>\n

Click Yes<\/strong><\/p>\n

\"\"<\/p>\n

Select “Create and configure a database”. We can also install database software and later create database using DBCA. But here we will choose to create database as well. Click Next<\/strong><\/p>\n

\"\"<\/p>\n

Select Server Class<\/strong> and click Next
\n<\/strong><\/p>\n

\"\"<\/p>\n

Since it detects presence of clusterware, it will prompt you to select RAC database installation. Select RAC and also select all nodes. Click Next<\/strong><\/p>\n

Note:<\/strong> If this screen does not come then do not proceed, since it may not have detected cluster services running. You must get this screen for proper installation of RAC database.<\/p>\n

\"\"<\/p>\n

It will test passwordless connectivity for oradb user on both nodes.<\/p>\n

\"\"<\/p>\n

Select “Advanced install” and click Next
\n<\/strong><\/p>\n

\"\"<\/p>\n

Click Next<\/strong><\/p>\n

\"\"<\/p>\n

Select Enterprise Edition. Click on Select Options.<\/p>\n

\"\"<\/p>\n

Select whichever options you need. In production systems be careful to select only those options which you have licensed.<\/p>\n

\"\"<\/p>\n

Select Software Location as \/app\/oracle\/product\/11.2.0\/dbhome_1<\/p>\n

This will be your ORACLE_HOME. Click Next<\/strong><\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Select “General Purpose \/ Transactional Processing”. Click Next
\n<\/strong><\/p>\n

\"\"<\/p>\n

Select appropriate name for your database. Click Next
\n<\/strong><\/p>\n

\"\"<\/p>\n

Select “Enable Automatic Memory Management” and the amount of memory to be allocated. Click on second tab “Character sets”.<\/p>\n

\"\"<\/p>\n

Select Unicode. This is best option if you are planning to use non-English characters in future since it supports all Unicode characters. Click Next
\n<\/strong><\/p>\n

\"\"<\/p>\n

Click Next<\/strong><\/p>\n

\"\"<\/p>\n

Select File System<\/strong> and specify location as \/u01\/oradata<\/strong><\/p>\n

Click Next
\n<\/strong><\/p>\n

\"\"<\/p>\n

Since this is demo database, select “Do not enable automated backups”. Click Next<\/strong><\/p>\n

\"\"<\/p>\n

For Demo database you can choose same password for all accounts. Click Next<\/strong><\/p>\n

\"\"<\/p>\n

Click Yes<\/strong> if you want to keep simple password.<\/p>\n

\"\"<\/p>\n

Select dba and oinstall respectively. Click Next
\n<\/strong><\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Review the summary and save response file if required. Click Finish once response file is saved.<\/p>\n

\"\"<\/p>\n

[oracle@dbhost1 database]$ You can find the log of this install session at:<\/p>\n

\/app\/oraInventory\/logs\/installActions<timestamp>.log<\/p>\n

\"\"<\/p>\n

Next it will create the database as we had selected to create database as well. Please make sure that \/app\/oracle\/cfgtoollogs directory has write permission for group members. If not, please execute following to avoid log file write errors.<\/p>\n

 <\/p>\n

chmod g+w \/app\/oracle\/cfgtoollogs\/
\n<\/strong><\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

Once this completes, it will prompt you to run $ORACLE_HOME\/root.sh file on both nodes. I have missed to take that last part screenshot so not including in this post<\/span>. This script will run multiple scripts within it which change a few permissions, ownership and add entry for database in \/etc\/oratab file<\/p>\n

 <\/p>\n

 <\/p>\n

Once installation is finished, you can make sure that the database is running on both nodes using following command.<\/p>\n

 <\/p>\n

[oradb@dbhost1 ~]$ srvctl status database -d rac11g<\/strong><\/p>\n

Instance rac11g1 is running on node dbhost1<\/p>\n

Instance rac11g2 is running on node dbhost2<\/p>\n

 <\/p>\n

Also you can login to the database and check.<\/p>\n

 <\/p>\n

[oradb@dbhost1 ~]$ sqlplus \/ as sysdba<\/p>\n

SQL*Plus: Release 11.2.0.1.0 Production on **<\/p>\n

Copyright (c) 1982, 2009, Oracle. All rights reserved.<\/p>\n

Connected to:<\/p>\n

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production<\/p>\n

With the Partitioning, Real Application Clusters, OLAP, Data Mining<\/p>\n

and Real Application Testing options<\/p>\n

SQL> select inst_id, instance_name, status from gv$instance;<\/p>\n

 <\/p>\n

INST_ID INSTANCE_NAME STATUS<\/p>\n

———- —————- ————<\/p>\n

1 rac11g1 OPEN<\/p>\n

2 rac11g2 OPEN<\/p>\n

 <\/p>\n

 <\/p>\n

Shutdown\/Startup steps for 11gR2 RAC on VMs
\n<\/strong><\/p>\n

 <\/p>\n

1. Shutdown steps
\n<\/strong><\/p>\n

 <\/p>\n

Since all cluster resources including database, listeners etc can be controlled by Oracle Clusterware Control script (crsctl), we can directly shutdown all services using this crsctl or crs_stop script.<\/p>\n

 <\/p>\n

oracle@dbhost1 ~]# \/app\/oracle\/11.2.0\/grid\/bin\/crs_stop \u2013all<\/p>\n

 <\/p>\n

if you want to only shutdown database or listener, use following commands.<\/p>\n

 <\/p>\n

oracle@dbhost1 ~]# \/app\/oracle\/11.2.0\/grid\/bin\/srvctl stop listener<\/p>\n

 <\/p>\n

oracle@dbhost1 ~]# \/app\/oracle\/11.2.0\/grid\/bin\/srvctl stop database \u2013d rac11g<\/p>\n

 <\/p>\n

2. Startup steps
\n<\/strong><\/p>\n

 <\/p>\n

You can startup all cluster resources including database and listener using crsctl or crs_start script.<\/p>\n

 <\/p>\n

Before this, make sure that you have booted Node 1 first and then Node 2. Give it some time to bring up clusterware related services so that they both can communicate to the CRS daemon.<\/p>\n

 <\/p>\n

Run following command to verify cluster is up.<\/p>\n

 <\/p>\n

root@dbhost2 ~]# \/app\/11.2.0\/grid\/bin\/srvctl status nodeapps<\/strong><\/p>\n

VIP dbhost1-vip is enabled<\/p>\n

VIP dbhost1-vip is running on node: dbhost1<\/p>\n

VIP dbhost2-vip is enabled<\/p>\n

VIP dbhost2-vip is running on node: dbhost2<\/p>\n

Network is enabled<\/p>\n

Network is running on node: dbhost1<\/p>\n

Network is running on node: dbhost2<\/p>\n

GSD is disabled<\/p>\n

GSD is not running on node: dbhost1<\/p>\n

GSD is not running on node: dbhost2<\/p>\n

ONS is enabled<\/p>\n

ONS daemon is running on node: dbhost1<\/p>\n

ONS daemon is running on node: dbhost2<\/p>\n

eONS is enabled<\/p>\n

eONS daemon is running on node: dbhost1<\/p>\n

eONS daemon is running on node: dbhost2<\/p>\n

 <\/p>\n

if everything is fine the use following commands to startup cluster resources including database and listener.<\/p>\n

 <\/p>\n

oracle@dbhost1 ~]# \/app\/11.2.0\/grid\/bin\/crs_start -all
\n<\/strong><\/p>\n

 <\/p>\n

if you want to only start database or listener, use following commands.<\/p>\n

 <\/p>\n

oracle@dbhost1 ~]# \/app\/11.2.0\/grid\/bin\/srvctl start listener<\/strong><\/p>\n

 <\/p>\n

oracle@dbhost1 ~]# \/app\/11.2.0\/grid\/bin\/srvctl start database -d rac11g
\n<\/strong><\/p>\n

 <\/p>\n

This concludes the installation of Oracle 11gR2 RAC (11.2.0.1) on 2 VM nodes. You should upgrade this to 11.2.0.3 to leverage best functionalities and bug fixes in 11gR2. I will cover this in another post.<\/p>\n

 <\/p>\n

If your installation had failed during database creation\/configuration part, no need to restart the installation. You can manually create database using Database Configuration Assistant (DBCA). This will automatically detect presence of Oracle clusterware and register database into RAC.<\/p>\n

 <\/p>\n

Thanks for reading this article and feel free to ask any questions or help others who have questions in the comments section.<\/p>\n

 <\/p>\n

Happy Learning !<\/p>\n

 <\/p>\n

Tushar<\/p>\n

 <\/p>\n

 <\/p>\n

Installing 11g Release 2 Real Application Clusters (11gR2 RAC) on Linux x86-64 Virtual Machine (VM) \u2013 Steps<\/a><\/strong><\/p>\n

1.\u00a0Create Virtual Machine and install 64 bit Linux<\/a>\u00a0(generic step from previous post, not specific to this guide)<\/strong><\/p>\n

2.\u00a0Add additional virtual Ethernet card and perform prerequisites in Linux<\/strong><\/a><\/p>\n

3.\u00a0Copy\/clone this virtual machine to create second node and modify host details<\/strong><\/a><\/p>\n

4.\u00a0Setup shared file system and other pre-requisites<\/strong><\/a><\/p>\n

5.\u00a0Install Oracle Clusterware<\/strong><\/a><\/p>\n

6.\u00a0Install Oracle Database software and create RAC database<\/a><\/b><\/p>\n

\u00a0<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Previous: You can start database installation from <stage>\/database directory as follows. Make sure to use database owner user oradb. [oradb@dbhost1 ~]$ cd \/mnt\/hgfs\/setup\/database\/ [oradb@dbhost1 database]$ .\/runInstaller Deselect the checkbox and click Next Click Yes Select “Create and configure a database”. We can also install database software and later create database using DBCA. But here we […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2139","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts\/2139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/comments?post=2139"}],"version-history":[{"count":0,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts\/2139\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/media?parent=2139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/categories?post=2139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/tags?post=2139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}