Online DBA

<<Back to Oracle RAC Main Page Hardware and Software Requirements To Install Oracle 12c RAC Note: The requirement in this post is, to install oracle RAC on your Laptop and therefore the requirement in your actual environment could be lightly different and will also depend the business requirement. In this post I will explain you about minimum hardware as well as software requirements to successfully install and configure oracle RAC using virtual machine on your laptop. In real environment you need few less things as well there are most OS, Network and storage preparation task is performed by specialists you just need to specify the requirements to them. Hardware Requirements In real environment you need exactly the amount of servers you need to configure in RAC cluster. eg. you need 2 servers for 2 Node RAC cluster however here we will need 4 Servers as mentioned below Minimum 2 Servers each with following Configurations <= used for Oracle RAC clust...

<<Back to Oracle RAC Main Page runcluvfy.sh stage -pre crsinst -n node1,node2 -fixup -verbose Cluster Verification Pre Installation check failed. Verifying Physical Memory ...FAILED (PRVF-7530) $./runcluvfy.sh stage -pre crsinst -n node1,node2 -fixup -verbose Verifying Physical Memory ... Node Name     Available                 Required                  Status   ------------  ------------------------  ------------------------  ----------   node2         7.5443GB (7910784.0KB)    8GB (8388608.0KB)         failed   node1         7.5443GB (7910784.0KB)    8GB (8388608.0KB)      ...

<<Back to Linux Main Page How to Configure NTP Server Locally Without Internet Access I wrote this post just to full fill the requirement of having NTP server for oracle RAC  installation  on your laptop. If you are installing RAC in your company NTP server already configured for time synchronization can be used.  Step1: Install Packages for NTP Mount your CD and Install following RPM if already  not installed #rpm -ivh ntp-4.2.6p5-25.0.1.el7.x86_64.rpm #rpm -ivh ntpdate-4.2.6p5-25.0.1.el7.x86_64.rpm Step2: Configure   /etc/ntp.conf Edit /etc/ntp.conf file and locate the below entry and uncomment it. Also modify IP address and mask according to your network restrict 192.9.1.0 mask 255.255.255.0 nomodify notrap Step3: Comment out the default ntp servers listed in /etc/ntp.conf. In my case it is #server 0.rhel.pool.ntp.org iburst #server 1.rhel.pool.ntp.org iburst #server 2.rhel.pool.ntp.org iburst #server 3.rhel.pool.n...

<<Back to Linux Main Page To resolve the SCAN IPs in round robin fashion you need DNS configuration. If you are installing RAC on your laptop for practice purpose, It is obvious that you don't have DNS server. In this post I will explain you, how you can configure DNS server which you can use to resolve SCAN IPs to install and configure oracle RAC Step by Step How to Configure DNS Server for  Oracle RAC Installation Step1: Install Bind Packages Bind packages are required to configure DNS. Check whether the required bind packages are installed. To see what packages are installed you can use rpm or yum command #rpm –qa bind* #yum list installed  bind* Install individual packages using yum or rpm Utility. Here I am using rpm #rpm -ivh bind-9.9.4-37.el7.x86_64.rpm #rpm -ivh bind-dyndb-ldap-10.0-5.el7.x86_64.rpm #rpm -ivh bind-libs-lite-9.9.4-37.el7.x86_64.rpm #rpm -ivh bind-utils-9.9.4-37.el7.x86_64.rpm #rpm -ivh bind-libs-9.9.4-37.el7.x86_64.rpm #r...

<<Back to Oracle RAC Main Page Configuring Shared Storage  for Oracle RAC Using Openfiler Step1: Install Openfiler Storage Management Appliance.  You can find Step by step instruction at  How to Install OpenFiler Storage Management Appliance Step2: Login to Openfiler Login to your openfiler with username openfiler and Default Password password. After  successful Installation of openfiler GUI is accessible at port 446. https://192.9.1.105:446/ Step3: Add Storage Clients Navigate to System tab and enter the Name of all the Client Servers who will Access the storage provided by this openfiler. To save the entry just click update Step4: Create and Configure Storage volume Navigate to Volumes tab and click on the link "create new physical volumes" You will be navigated to the below page. on this page just select the disk listed in the Edit Disk column On this page just click Create The physical volume is now successfu...

<<Back to Oracle RAC Main Page Finding Out Oracle RAC Cluster Name and Version There are several ways to find the name of an Oracle RAC cluster. You can use any of the method described below. Option 1 execute below command from CRS_HOME/bin $ cemutlo -n rac11 Option 2 execute below command from CRS_HOME/bin $ olsnodes -c rac11 Option 3 navigate to the directory $CRS_HOME/cdata. Under this directory you will find a directory with the name of cluster which includes the OCR backup cd $CRS_HOME/cdata ls localhost  node1 node1.olr  rac11 How to Find the Clusterware (CRS) version in Oracle RAC follow the steps below to find the clusterware version (Grid infrastructure ) of your RAC cluster to see on current node $ crsctl query crs softwareversion Oracle Clusterware version on node [node1] is [12.1.0.2.0] to see on all the nodes $ crsctl query crs softwareversion -all Oracle Clusterware version on node [node1] i...