Oracle 12c 2-node RAC setup in VMware Player 15 -- Part01

Tried to install Oracle 12c 2-node RAC for testing purpose but due to low Hardware configuration, ended up with Single Node RAC. I got lot of issues during Installation and tried to resolve them with my best knowledge. Please find below installation steps and troubleshooting.

Main issues started from Step90. you can go through quickly.


Requirements


Most of the times, bridge option in VMWARE will not connect with host machine.
I tried below option to use internet connection from host machine.



We need to cross verify vmnet8 is NAT or not.





Installation Steps

Step1 launch VMware and click on New Virtual Machine


Step2  select OEL iso Image




Step3 Provide New Virtual Machine Name



Step4 Provide HDD size and select single virtual disk.


Step5  Select host setting for monitor and Network as NAT


Step6 New Virtual Machine is ready for launch.


Step7 OEL Installation starts automatically. Press Enter


Step8 Skip Disk Checking


Step9 Click Next


Step10  Select language and Click Next


Setp11 Select keyboard


Setp12 Select Basic Storage


Step13 Select Discard any Data


Step14 Provide host-name with domain and Click Next


Step15 select Time based on Location and Click Next


Step16 Provide Password for Root and click Next


Step 17 Select Create Custom Layout and  Click Next


Step18  Select SDA and click on Create button


Step19 create / ( root ), /boot, SWAP, and /opt for Oracle binaries. Click Next


Step20 Click Format


Step21 Click on write changes to disk


Step22 Click Next ( it will default select / ( root )


Step23 Select Database Server, Customize Now and Click Next


Step24 Select necessary options in Base System



Step25 Uncheck MYSQL and  PostgreSQL because we will be installing Oracle 12c.


Step26 select all options in Desktop except KDE Desktop. gnome desktop is enough. Click next


Step27 Packages Installations start automatically


Step28 Click Reboot


Step29 Click Forward


Step30 check on accepting License agreement and click Forward


Step31 Check on register later time


Step32 click on Connect later and Click Forward


Step33 Click on Forward


Step34 Select Date and Time . Click Forward


Step35 click ok


Step36 Click Finish


Step37 Install VMware Tools


Step38 Open vmware tool in Archive Manager


Step39 Extract file to Folder.


Step40 Install vmware tool



Step41 Enable Shared Folder between Host and vmware


Step42 After restart OEL, install kmod-oracleasm package. By default yum is configured.
Note Make Sure internet is access inside virtual machine.




Step43 Sometimes yum will be running in back-end. Before installing any package just crosscheck yum process is running or not. If needed you can kill yum running process


Step44 Install oracleasm-support using yum



Step45 Install oracleasmlib rpm manually




Step46 create groups and user and change pasword for user



Step47 Configure Oracelasm


Step48 After shutdown virtual machine, Add extra HDD for DB.


Step49  Select new virtual disk





Step50 Format and Partition newly added HDD. fdisk -l to list disks.





Step51 Install packages related to bind* for DNS configuration


Step52 Configure DNS




Step53 create forward.localdomain file with below entries


Step54 create reverse.localdomain file with below entries



Step55 Change group from root to named for reverse and forward files


Step56 make sure named.conf file should have named_conf_t


Step57 checking forward and reverse


Step58 Start named service


Step59 update nameserver in /etc/resolv.conf


Step60 test named  configuration using dig tool


Step61 Test DNS using nslookup tool


Step62 update rotate timeout and attempts in /etc/resolv.conf


Step63 Change permission for /etc/resolv.conf


Step64 Update /etc/hosts file.


Step65 Install oracle-rdbms-server-12cR1-preinstall using yum tool



Step66 Change owner,group and read/write permissions


Step67 Disable selinux


Step68 Update Kernel Parameters and cross validate.


Step69 Update User limits



Step70 stop and disable iptables


Step71 Change NTP configurations





Step72 After restart virtual machine, Add network card for private address



Step72 After starting virtual machine, validate oracleasm configuration


Step73 Start oracleasm


Step74 createdisk in ASM


Step75 Add disk for DB data in different folder



Step76  Copy  RAC1 virtual machine to RAC2 folder.


Step77  start RAC2 virtual machine



Step78 Click on "I copied it"


Step79 Change Hostname



Step80 Update ipaddress manually


Step81 remove ASM disk and once again add same disk with below option "Use an existing virtual disk"


Step82 By default VMware player will not support disk sharing, so we need to add below parameters in virtual configuration for RAC1 and RAC2



Step83 Unzip oracle grid software


Step84 make ssh password less between RAC1 and RAC2



Step85 testing ssh password less or not



Step86  Run runcluvfy script for pre installation



Step87 Install cvudisk in RAC1 and RAC2


Step88 set GUI enable in root and oracle user and don't close terminal until installation finish



Step89 Start installing Grid


Below not able to see next button because of small screen resolution


Step90 Faced problem in extending screen resolution, so below options tried.

1. right click on vmware player properties and enable scaling override for system  (enchanced )
2. change screen resolution inside virtual machine



Step91 re-started grid installation




1. vip ipaddress is not identified because last number is more than 400, so changed and added vip ipaddress in /etc/hosts and dns configurations


continue grid installation


2. changed private ipaddress and subnet ( less than 300 ), as installation is not accepting same public subnet and ipaddrress more than 300


Continue grid installation




ASM disks are not visible then created once again



got insufficient space error. it requires minimum 38,844 MB space.


Step92 Added additional 60GB to vmware


mount points were changed


formatted new added disk


Mount points still not changed


Set same order for RAC2 machine also


created asmdisks


cross validated asmdisks in RAC2 machine


Step93 re-started grid installation


select asmdisks ( now both disks are more than 40GB )


provide passwords for SYS and ASMSNMP users


we are not enabling IPMI


we are not configuring Enterprise Manager


select groups


select oracle base path


click yes


provide orainventory path


provide root password so that root scripts automatically executed and click next


check per-requistics errors


increased /dev/shm size. update /etc/fstab file


re-mount /dev/shm


ignored ASM errors , they are related with group names


NTP is disabled




ignored remaining errors


click YES


Click Install


Click yes



root.sh script failed


Executed root.sh script manually



Failed root.sh script execution manually also



Increased /dev/shm and physical memory



Restarted Grid installation


Executed root.sh script successfully



Container database creation failed for grid





Copy dbca silent installation command from log file for grid container DB


Got pop-up that host machine is running out of space


Cleared some space


Installation is continuing



Creating Container DB for grid ignored and GIMR configuration failed


Checked logs and it showing Grid Infrastructure Management Repository not running in the cluster
because MGMTDB is not created, So  ignored error



Oracle Cluster verification post failed


After checking logs, noticed olcvfy is not able to get vip ipaddress information



Ignored Oracle Cluster Verification Utility


Grid Installation completed only on RAC1 ( RAC2 ignored )
Stopped Cluster and restarted RAC1 virtual Machine.


Started RAC1 Virtual Machine. Checked Cluster up and running
Grid Container DB installation successfully completed in silent mode using dbca



Checked MGMTDB configuration


Step94 checking Cluster Status 



Step95 Checking Host Memory Consumption


Step96 Increased RAC1 memory to 3GB




Step97 Added two more disks for database data purpose


Formatted new added disks


Added formatted disks to OracleASM




Step98 Started Database Installation


Click Next


Click YES and click next


Select " Create and configure a database "  and click next


select server class  and click next


select RAC database installation and click next


select Admin Managed and click next


Click Next


Select Advanced install and Click Next


Select Enterprise Edition and Click Next


Provide Oracle base, Home path and Click Next


Select General/transaction Processing and Click Next


Provide Container, pluggable DB names and Click Next


Click Next



Select ASM and Click Next


Click Next


Select Recovery, ASM and Click Next


create diskgroups in ASM


Click on diskgroups


select 1 disk for Data and Click OK 


select 1 disk for FRA and Click OK 


Click Exit


Click Refresh and New diskgroups will appear in screen.
Select diskgroup and click next



Comments

Post a Comment

Popular Posts

AWR Report Analysis

Image
AWR report analysis is important for  Oracle DBA on Daily issues or P1/P2 issues time. Below some of the main things we general look to figure out issue. 1. 2.  3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13.
Read more

Goldengate 19c Installation with issue resolution

Image
  Basic Installation of GoldenGate 19c in OEL6. Tested with below requirements: Step1: Vmware requirements:   For installing OEL6.8 and Oracle DB 12c  installation, please refer URL https://venuoracledba.blogspot.com/2020/08/oracle-12c-2-node-rac-setup-in-vmware.html     Step2: After OEL6.8 installation finished. We will use /opt for goldengate installation.   Step3: unzip GG software in folder. Here unzipped in gg_software folder.     Folder fbo_ggs_Linux_x64_shiphome will create. Step4:  Enable GUI by issuing x host + command in root user. and keep open this root terminal.   Step5:  Enable GUI by issuing x host + command in oracle user.   Move to software path   execute ./runInstaller and select database version. Selected 12c version for my environment. and click Next     provide GG home, oracle home and port number and click Next.     After verifying paths and information, Click Install   ...
Read more

Execution_Explain Plan

Whenever we get request for application slowness or sql query then we need to identify sql_id and to analyze sql_id, we need to check SQL execution/explain plan. 1. EXECUTION_PLAN: select id,plan_hash_value,operation, options,object_name,cardinality,cost,bytes,cpu_cost,io_cost,time,partition_start,partition_stop, object_node,other_tag,qblock_name,other_xml from dba_hist_sql_plan where sql_id='<SQL_ID>'; or select * from table(dbms_xplan.display_awr('<SQL_ID>')); EXPLAIN_PLAN: explain plan for <SQL_QUERY>; select * from table(dbms_xplan.display);
Read more

Oracle to Postgres

Image
  Round 1: Created metadata for tables, sequences, packages Round 2: Created indexes Round 3: freeze column name to freezes to_date function updated GEOMETRY datatype , installed POSTGIS package to support this datatype Round 4: created triggers created Functions Migration: bash-4.2$ pwd /usr/edb/migrationtoolkit/etc bash-4.2$ cat toolkit.properties SRC_DB_URL=jdbc:oracle:thin:@localhost:1521:orcl SRC_DB_USER=hr SRC_DB_PASSWORD=hr TARGET_DB_URL=jdbc:edb://postoffline:5444/dev TARGET_DB_USER=enterprisedb TARGET_DB_PASSWORD=password bash-4.2$  -bash-4.2$ pwd /usr/edb/migrationtoolkit/bin -bash-4.2$ ls -lrt total 724 -rwxr-xr-x. 1 root root   2439 Dec 11 13:29 runJavaApplication.sh -rwxr-xr-x. 1 root root    544 Dec 11 13:33 runMTK.sh -rwxr-xr-x. 1 root root 729258 Dec 11 13:33 edb-migrationtoolkit.jar -bash-4.2$  ./runMTK.sh HR OUTPUT: Running EnterpriseDB Migration Toolkit (Build 55.7.0) ... Source database connectivity info... conn =jdbc:oracle:thin:@o...
Read more

Active Session History Analysis

Image
ASH  analysis is important for  Oracle DBA on Daily issues or P1/P2 issues time. Below some of the main events we general look to figure out issue. RAC / Cloud RDS: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. Redo Generation: 14. 15. 16. 17. 18. 19.
Read more

General Queries

                                                                              Tablespace growth Size We can use view to check tablespace size greater than 80% RAC / NON-RAC / Cloud RDS: SELECT tbm.TABLESPACE_NAME,   round(tbm.USED_SPACE * tb.BLOCK_SIZE /(1024*1024*1024),2) as USED_SPACE_GB,   round(tbm.TABLESPACE_SIZE * tb.BLOCK_SIZE /(1024*1024*1024),2) as TBS_SIZE_GB,   round((tbm.TABLESPACE_SIZE - tbm.USED_SPACE) * tb.BLOCK_SIZE /(1024*1024*1024),2) as TBS_FREE_SIZE_GB,   round(tbm.USED_PERCENT) as PERCENT_USEDFROM dba_tablespace_usage_metrics tbm      join dba_tablespaces tb on tb.TABLESPACE_NAME = tbm.TABLESPACE_NAME w...
Read more

Fragmentation & Re-organisation

Total  Savings: set verify off column file_name format a50 word_wrapped column smallest format 999,990 heading "Smallest|Size|Poss." column currsize format 999,990 heading "Current|Size" column savings format 999,990 heading "Poss.|Savings" break on report compute sum of savings on report column value new_val blksize select value from v$parameter where name = 'db_block_size' / select file_name, ceil( (nvl(hwm,1)*&amp;&amp;blksize)/1024/1024 ) smallest, ceil( blocks*&amp;&amp;blksize/1024/1024) currsize, ceil( blocks*&amp;&amp;blksize/1024/1024) - ceil( (nvl(hwm,1)*&amp;&amp;blksize)/1024/1024 ) savings from dba_data_files a, ( select file_id, max(block_id+blocks-1) hwm from dba_extents group by file_id ) b where a.file_id = b.file_id(+) order by savings desc / HWM query for all datafiles: col data_file_name for a50 col tablespace_name for a20 set lines 300 select tablespace_name, file_id, file_name DATA_FILE_NAME, Al...
Read more

Oracle 11g Physical Standy Setup

  Step1: take Binaries tar backup from Primary DB server tar -cvf /path/11.2.0.4.tar 11.2.0.4 Step2: untar Binaries tar back on Standby DB server tar -xvf /path/11.2.0.4.tar -C /path ###################### Binaries Cloning ################### Step3: run clone command on Standby DB server export ORACLE_HOME=<PATH> cd $ORACLE_HOME/clone/bin perl $ORACLE_HOME/clone/bin/clone.pl ORACLE_BASE='<PATH>' ORACLE_HOME='<PATH>' ORACLE_HOME_NAME='<ANY_NAME>' ###################### POST Binaries Cloning ################### Step4: run root scripts $ORACLE_BASE/oraInventory/orainstRoot.sh $ORACLE_HOME/root.sh ###################### Pre-requisites ################### Standby: Step5: update hostnames in listener and tnsnames files Step6: start the listener in standby Server Primary: Step7: check force logging enabled -- to make sys activities will logged in redo logs SQL> select force_logging from v$database; - NO ( default ) to enable force logging - S...
Read more

Postgresql installation offline using NGINX

  [root@localhost yumdownloaddir]# sudo  yum -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm Loaded plugins: langpacks, ulninfo epel-release-latest-7.noarch.rpm                                                                                                                                                            |  15 kB  00:00:00      Examining /var/tmp/yum-root-dewJ5H/epel-release-latest-7.noarch.rpm: epel-release-7-14.noarch Marking /var/tmp/yum-root-dewJ5H/epel-release-latest-7.noarch.rpm to be installed Resolving Dependencies --...
Read more