Oracle Installer and RAC installation

Log File location

Oracle Installer  log file  location
$  cat  /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
[grid@grac41 logs]$ ls -l /u01/app/oraInventory/logs/install*
-rw-r-----. 1 oracle oinstall 2761865 Sep 14  2013 /u01/app/oraInventory/logs/installActions2013-09-14_10-05-03AM.log

Find valid ORACLE_HOME_NAME by checking file  ContentsXML/inventory.xml

$ grep "HOME NAME"  /u01/app/oraInventory/ContentsXML/inventory.xml
<HOME NAME="OraGI12Home1" LOC="/u01/app/121/grid" TYPE="O" IDX="1">
<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/121/racdb" TYPE="O" IDX="2">
<HOME NAME="OraGI12Home2" LOC="/u01/app/12102/grid" TYPE="O" IDX="3" CRS="true">
<HOME NAME="OraDB12Home2" LOC="/u01/app/oracle/product/12102/racdb" TYPE="O" IDX="4">

Change the CRS active flag after a GRID downgrade

[grid@grac31 ContentsXML]$ $GRID_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME="/u01/app/11204_upg/grid" CRS=false
[grid@grac31 ContentsXML]$ $GRID_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME="/u01/app/11203/grid" CRS=true

Useful  OUI options

• -ignoreSysPrereqs : For ignoring the results of the system prerequisite checks.
• -ignorePrereq     : To install the software, use the ‘-ignorePrereq’ option to suppress prerequisite checks.
• -executePrereqs   : perform a pre-requisite checks

 

OUI/ Addnode.sh considerations ( 12.1.0.2 )

- Script addnodes.sh in $GRID_HOME/addnode invokes OUI
- Following options may be usefull for debugging / problem solving 
  Invoke OUI only checking  prereqs
     ADDNODE="$OHOME/oui/bin/runInstaller -executePrereqs  ORACLE_HOME=$OHOME"
   Invoke OUI with debugging options
     ADDNODE="$OHOME/oui/bin/runInstaller   -debug -J-DTRACING.ENABLED=true -J-DTRACING.LEVEL=2 -J-DSRVM_TRACE_LEVEL=2 -J-DFULLTRACE ORACLE_HOME=$OHOME"
   Invoke OUI by ignoring prereqs 
     ADDNODE="$OHOME/oui/bin/runInstaller  -ignorePreReq  -ignoreSysPrereqs

Start  Oracle Installer in debug mode:

$ script ./DEBUG_Install.`date +%d-%m-%Y_%H-%M-%S`.out  
$ ./runInstaller -debug -J-DTRACING.ENABLED=true -J-DTRACING.LEVEL=2 -J-DSRVM_TRACE_LEVEL=2 -J-DFULLTRACE

 

OUI Errors:

[WARNING] [INS-08109] Unexpected error occurred while validating inputs at state ‘CRSNodeScalerDetails’

Command             : $GRID_HOME/addnode/addnode.sh -silent -noCopy "CLUSTER_NEW_NODES={gract3}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={auto}" "CLUSTER_NEW_NODE_ROLES={hub}
Error               : [WARNING] [INS-08109] Unexpected error occurred while validating inputs at state 'CRSNodeScalerDetails'.
                       CAUSE: No additional information available.
                       ACTION: Contact Oracle Support Services or refer to the software manual.
                       SUMMARY:
                        - java.lang.NullPointerException
Tracing             : [main] [ 2014-08-20 12:17:35.487 CEST ] [NativeSystem.isCmdScv:534]  isCmdScv: cmd=[/usr/bin/ssh -o FallBackToRsh=no  -o PasswordAuthentication=no  
                        StrictHostKeyChecking=yes  -o NumberOfPasswordPrompts=0  gract3 -n /bin/ksh -c "if [  -a /u01/app/12102/grid/inventory/ContentsXML/comps.xml ] ; then echo exists; fi"]
Root Cause          : Missing files 
                       $ ls -l  /u01/app/12102/grid/inventory/ContentsXML/comps.xml
                         ls: cannot access /u01/app/12102/grid/inventory/ContentsXML/comps.xml: No such file or directory
Fix                 :  Run cloning from step 1 again so we should have all the needed xml files

[FATAL] [INS-32167] : The Oracle home is inconsistent on the following nodes: [gract3]

Command             : $GRID_HOME/addnode/addnode.sh -silent -noCopy "CLUSTER_NEW_NODES={gract3}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={auto}" "CLUSTER_NEW_NODE_ROLES={hub}
Error               :[FATAL] [INS-32167] :  The Oracle home is inconsistent on the following nodes: [gract3]
Tracing             :[main] [ 2014-08-20 16:09:49.407 CEST ] [RuntimeExec.runCommand:257]  Returning from RunTimeExec.runCommand
                     [main] [ 2014-08-20 16:09:49.408 CEST ] [UnixSystem.testCFSFile:1845] Command output is empty
                     [main] [ 2014-08-20 16:09:49.408 CEST ] [UnixSystem.testCFSFile:1846] ERROR: /bin/cat: /u01/app/12102/grid/cfgtoollogs/CFSFileName14085437887436629492630243552978.tmp:
                     No such file or directory from node gract3
                     [main] [ 2014-08-20 16:09:49.408 CEST ] [UnixSystem.checkSharedFileSystemPath:1802]  Path (/u01/app/12102/grid/cfgtoollogs) is shared between nodes []
                     [FATAL] [INS-32167] The Oracle home is inconsistent on the following nodes: [gract3]
                     CAUSE: The wizard detects that the Oracle home is inconsistent on some or all of the nodes specified. Review the log file for further details.
                     ACTION: Ensure that the Oracle home is consistent on all nodes.
Root Cause          : Wrong ORA_HOME_NAME
                      Check inventory.xml : /u01/app/oraInventory/ContentsXML/inventory.xml
                      Source : ORACLE_HOME_NAME=OraGI12Home2
                      DEST   : ORACLE_HOME_NAME=ORAGI12Home2
Fix                 : Correct ORACLE_HOME_NAME and run cloning from step 1
Reference           : Bug 13767320 : 12.1_120220:CRS ADDNODE THROUGH CLONING FAILS WITH [INS-32167]

Empty XML file returned running RAC prereq checks

ERROR               :  Empty XML file returned running RAC prereq checks
                       PRKC-1002 : Not all the submitted commands completed successfully
TRACING             : [Worker 0] [ 2014-08-20 10:50:41.441 CEST ] [RuntimeExec.runCommand:137]  /usr/bin/ssh -o FallBackToRsh=no  -o PasswordAuthentication=no  -o StrictHostKeyChecking=yes  
                          -o NumberOfPasswordPrompts=0  gract3 -n /tmp/CVU_12.1.0.2.0_grid/exectask.sh -getver
                       [main] [ 2014-08-20 10:50:42.636 CEST ] [GlobalHandler.submit:181]  CLUSTEREXCEPTION: PRKC-1002 : Not all the submitted commands completed successfully.
Root Cause          : No disk space 
                      Test on a working node gract1: 
                      [grid@gract1 ~]$ /tmp/CVU_12.1.0.2.0_grid/exectask.sh -getver
                         <CV_VRES>0</CV_VRES>
                           <CV_VAL>12.1.0.2.0.06_30_14_x86_64</CV_VAL>
                           <CV_CMDLOG><CV_INITCMD>/tmp/CVU_12.1.0.2.0_grid/exectask -getver </CV_INITCMD><CV_CMDLOG>
                         <CV_ERES>0</CV_ERES>
                       Failing note :
                       [grid@gract3 grid]$  /tmp/CVU_12.1.0.2.0_grid/exectask.sh -getver
                       --> Empty - No XML 
                           After trying strace -I still got en empty file -even strace file was empty 
Fix                  : obvious, cleanup node for sufficient disk space

 [INS-30502] No ASM disk group found.

[INS-30502] No ASM disk group found.

Check installer logs : /u01/app/oraInventory/logs/installActions2013-09-12_06-35-49PM.log
INFO: Starting Output Reader Threads for process /u01/app/11204/grid/bin/kfod
INFO: Parsing KFOD-00300: OCI error [-1] [OCI error] [ORA-01017: invalid username/password; logon denied
INFO: Parsing ] [1017]
INFO: Parsing 
INFO: The process /u01/app/11204/grid/bin/kfod exited with code 1
INFO: Waiting for output processor threads to exit.
INFO: Output processor threads exited.
SEVERE: [FATAL] [INS-30502] No ASM disk group found.
   CAUSE: There were no disk groups managed by the ASM instance +ASM1.
   ACTION: Use Automatic Storage Management Configuration Assistant to add disk groups.

Verify groups for oracle user :
$ id
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),500(vboxsf),54322(dba)
$ dd if=/dev/asmdisk1_udev_sdb1 of=/dev/zeror bs=1M
dd: opening `/dev/asmdisk1_udev_sdb1': Permission denied

Fix : Add oracle user to asmdba group 
$ id
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),500(vboxsf),506(asmdba),54322(dba)

Reference:
From  DBCA Does Not Display ASM Disk Groups In 11.2 (Doc ID 1177483.1)

 

[INS-40714] Single Client Access Name (SCAN) Name: scan.oracle_gns.example.com contains invalid character

[INS-40714] Single Client Access Name (SCAN) Name: scan.oracle_gns.example.com contains invalid characters.  
Fix : Remove underscore in your  hostname

 

[INS-40915] The installer has detected the presence of Oracle Clusterware on the following nodes: grac2.

[INS-40915] The installer has detected the presence of Oracle Clusterware on the following nodes: grac2.
  Fix : If this was an unsuccessfull Clusterware install and you have removed the complete software run :  rm /etc/oracle/ocr.loc

 

[INS-32025] The chosen installation conflicts with software already installed in the given Oracle home.

[INS-32025] The chosen installation conflicts with software already installed in the given Oracle home.
 Fix : If this was an unsuccessfull Clusterware install and you have removed the complete software run : rm -rf u01/app/oraInventory/*