Pages

Advertisement

Friday, March 29, 2019

Oracle Database RAC: Create Application VIP (CRS-2534)

 
In this blog I list out the steps to be used to create application specific VIP on Oracle Cluster
$ srvctl remove network -k 2
$ srvctl add network -k 2 -S 172.31.2.208/255.255.255.240
$ crsctl start resource ora.net2.network
$ crsctl add type ora.cluster_vip_net2.type -basetype ora.cluster_vip.type
$ appvipcfg create -network=2 -ip=172.31.2.214 -vipname=myvip -user=root -failback=1
$ crsctl start resource myvip-n myserver01
$  ifconfig | grep 214
$ crsctl modify res myvip -attr "HOSTING_MEMBERS=myserver01 myserver02"
$ crsctl stop resource myvip
$ crsctl start resource myvip -n  myserver02

 This also takes care of error CRS-2534

Tuesday, March 19, 2019

Oracle Database 12,18,19: Practices for using ASMLib with Multipath Devices (Linux 7)

 
In this document I list out the key things to keep in mind when using ASMLib with Multipathed devices

  1. Ensure to have the right Scan order (ORACLEASM_SCANORDER AND EXCLUDE)
to find out the right configuration for your type of multipathing you can refer
https://www.oracle.com/technetwork/server-storage/linux/multipath-097959.html
How to Configure LUNs for ASM Disks using WWID, DM-Multipathing, and ASMLIB on RHEL 5/OL 5 and RHEL 6/OL 6 and RHEL7 (Doc ID 1365511.1)

Remember you will need to put the right value as per the type of your multipathing - Linux Native, Multipathd, Emc etc


2. Ensure to create file /etc/udev/rules.d/99-oracle-asmdevices.rules
This file is used to set the right permissions on reboot of the node.
For this you can refer - 
https://access.redhat.com/solutions/272153
or 
Redhat Reference Document: https://access.redhat.com/sites/default/files/attachments/deploying_oracle_rac_12c_rhel7_v1.2_updated_08-01-2016.pdf 

 3. Ensure to start oracleasm.service after multipathd and iscsci
$ cat /usr/lib/systemd/system/oracleasm.service
[Unit]
Description=Load oracleasm Modules
Requires=multipathd.service iscsi.service

After=multipathd.service iscsi.service

The configuration can be quite complex when using multipath devices. In case you are facing any issues you can contact me, I will be glad to help. 

Friday, March 15, 2019

Oracle Database 11g/18c: Installing 11gr2 on 18c (Things to Keep in Mind)

 
In this blog I list out key things to keep in mind when doing installation of 11gR2 on 18c Cluster
This can be a useful case when you are thinking of migrating and Upgrading your infrastructure.
1. Keep Note of all the rpms and create a superset of both lists of 18c and 11g.
elfutils-libelf-devel.x86_64 is the rpm which is missing from 18c install. 

 2. Prefer ASM LIB always for installation 
For RHEL - the kmod-oracleasm is available from RHN or in the Product DVD
for other libraries use - https://www.oracle.com/technetwork/server-storage/linux/asmlib/rhel7-2773795.html

3. If you want to share some FS with your previous severs, remember to create the users/groups with same UID / GID.

 4. In the Grid Installation 


5. Before DB Binaries Installation, follow below docs - 
  • RAC RDBMS Installation fails with Error:"PRVF-4037 : CRS is not installed on any of the nodes" (Doc ID 2315020.1)
  • Error PRVF-4037 On Install Of Oracle Database 11.2 Binaries With 12.2.0.1 Grid Infrastructure (Doc ID 2302700.1)
  • PRVF-4037 : CRS is not installed on any of the nodes (Doc ID 1316815.1)
  • error in invoking target 'agent nmhs' of make file ins_emagent.mk while installing Oracle 11.2.0.4 on Linux (Doc ID 2299494.1)     
  • Linux:CVU NTP Prerequisite check fails with PRVF-7590, PRVG-1024 and PRVF-5415 (Doc ID 2126223.1)          

And as always refer MoS for any other erros.

Thursday, March 14, 2019

Oracle Database 18c: Apply -applyRU Patch before Grid Installation 18.5.0.0.0

 
With the advent of newer features with Oracle Releases.
One of the good feature of 12c Series is to patch the GI release to latest patch even before the installation.

 This has now become possible because of the image based installation, as the zip file is just a "tar ball" of the Grid Home with re-linking required

 If you want you can patch to the latest release then after unzipping the home - 

 1. Download the Patch
2. Stage it
3. Ensure OPatch is of the version as mentioned in Read me 
4. Apply Patch 

 In this example or a one liner I apply patch for 18.5.0.0.0 

 $ cd $GRID_HOME
$ ./gridSetup.sh -silent -applyRU /oracle/patch/28828717
Preparing the home to patch...
Applying the patch /images/oracle/28828717...
Successfully applied the patch.
The log can be found at: /opt/oracle/oraInventory/logs/GridSetupActions2019-03-13_05-09-20AM/installerPatchActions_2019-03-13_05-09-20AM.log
Launching Oracle Grid Infrastructure Setup Wizard...

 [FATAL] [INS-40426] Grid installation option has not been specified.

   ACTION: Specify the valid installation option.

 The last error is ignorable.

 If you want to apply one Offs then 
./gridSetup.sh -silent -applyOneOff <unzipped Path of the Patch>

Wednesday, March 13, 2019

Oracle Database 18c/19c: "-Networks" Parameter for cluvfy

 
In this blog I tell you, how do you specify, how to specify the settings for cluvfy run for -networks parameter.
this parameter is used to tell which all networks are going to perform what tasks in you cluster install.

 An example as below. 
./runcluvfy.sh stage -pre crsinst -n MUMR1DB001,MUMR1DB002 -r 18 -networks "bond0.111"[:1[PUBLIC]]/"bond2" -osdba dba -osoper dba -orainv dba -asm -presence local -asmgrp dba -asmdev /dev/oracleasm/disks/OCR_VOTE1,/dev/oracleasm/disks/OCR_VOTE2,/dev/oracleasm/disks/OCR_VOTE3  -crshome /opt/oracle/product/180/grid -fixup -verbose
In this example 
-networks is 
"bond0" - ethernet name
:1 - Subnet ID
PUBLIC - Type of Interface
then a \ is a seperator
finally bond2 is the second interface (will be taken as private by the cluvfy)


 For 18c: cluvfy Reference see below address.
https://docs.oracle.com/en/database/oracle/oracle-database/18/cwadd/cluster-verification-utility-reference.html#GUID-B445A858-9F00-4423-990E-109545AC11C3

Popular Posts

© Copyright 2019 DBA to DA. . Powered by Blogger.