1 2 Previous Next 25 Replies Latest reply: Dec 20, 2012 4:07 AM by 970402 Go to original post RSS
      • 15. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
        71617
        hi,

        Can you double check? when you install/configure Oracle database, your ORACLE_HOME should be set in /home/oracle, not /home/grid.
        Please try to change to new path of ORACLE_HOME when you re-install Oracle Database.

        When I install Oracle database I set GRID_HOME and ORACLE_HOME.

        honestly, Oracle only have general doc for HPUX Itanium. Make sure you have all software requirement.

        HP-UX 11i V3 patch Bundle Sep/ 2008 (B.11.31.0809.326a) or higher
        A.06.20 (HP C/aC++ Swlist Bundle - C.11.31.04) - Sep 2008
        For HP-UX 11i V3 (11.31):
        ■ PHCO_41479 11.31 Disk Owner Patch
        ■ PHKL_38038 VM patch - hot patching/Core file creation directory
        ■ PHKL_38938 11.31 SCSI cumulative I/O patch
        ■ PHKL_40941 Scheduler patch: post wait hang
        ■ PHSS_36354 11.31 assembler patch
        ■ PHSS_37042 11.31 hppac (packed decimal)
        ■ PHSS_37959 Libcl patch for alternate stack issue fix (QXCR1000818011)
        ■ PHSS_39094 11.31 linker + fdp cumulative patch
        ■ PHSS_39100 11.31 Math Library Cumulative Patch
        ■ PHSS_39102 11.31 Integrity Unwind Library
        ■ PHSS_38141 11.31 aC++ Runtime
        ■ PHSS_39824 - 11.31 HP C/aC++ Compiler (A.06.23) patch
        • 16. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
          970402
          I have configured below environment variables for both grid and oracle users;

          User's Home :
          =========
          "grid" Home - /home/grid
          "oracle" Home - /home/oracle

          For "grid" user on host lclc148 -
          ====================
          bash-4.2$ cat ~/.profile
          export LANG=C
          export EDITOR=vi
          export GRID_HOME=/var/RAC/11.2.0/grid
          export ORACLE_BASE=/var/RAC/grid
          export ORACLE_HOME=$GRID_HOME
          export ORACLE_SID=+ASM2
          export PATH=$PATH:$ORACLE_HOME/bin


          For "oracle" user on host lclc148 -
          ======================
          bash-4.2$ cat ~/.profile
          export ORACLE_HOME=/var/RAC/oracle/ODB
          export ORACLE_BASE=/var/RAC/oracle
          export PATH=$PATH:$ORACLE_HOME/bin

          For "grid" user on host lclc150 -
          ====================

          bash-4.2$ cat .profile
          export LANG=C
          export EDITOR=vi
          export GRID_HOME=/var/RAC/11.2.0/grid
          export ORACLE_BASE=/var/RAC/grid
          export ORACLE_HOME=$GRID_HOME
          export ORACLE_SID=+ASM1
          export PATH=$PATH:$ORACLE_HOME/bin

          For "oracle" user on host lclc150 -
          ====================
          bash-4.2$ cat .profile
          export ORACLE_HOME=/var/RAC/oracle/ODB
          export ORACLE_BASE=/var/RAC/oracle
          export PATH=$PATH:$ORACLE_HOME/bin


          Do i need to set any other variables ?
          • 17. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
            71617
            hi,

            I put GRID_HOME=/var/RAC/11.2.0/grid in Oracle user before start DBCA.
            I did not set ORACLE_HOME in grid user profile only GRID_HOME during DBCA.

            After database created completely, than I put ORACLE_HOME in grid user.

            Also have you run "runcluvfy.sh"? It's pre-check for cluster services setup.

            as grid user:
            $runcluvfy.sh stage -pre crsinst -n node1, node2
            • 18. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
              970402
              I have checked running dbca with the same environment variables, but getting same error.

              Btw one question Chen,

              Can we set password with space like "con ley" for below users;
              oracle, grid, SYS, SYSTEM, DBSNMP, SYSMAN etc ?

              Do we can get any sql syntax based error because of this spaces in password ? I am not sure just want to confirm if this could be the reason .


              Also Here is my runcluvfy.sh output :
              ====================


              bash-4.2$ ./runcluvfy.sh stage -pre crsinst -n lclc150,lclc148

              Performing pre-checks for cluster services setup

              Checking node reachability...
              Node reachability check passed from node "lclc150"


              Checking user equivalence...
              User equivalence check passed for user "grid"

              Checking node connectivity...

              Checking hosts config file...

              Verification of the hosts config file successful

              Node connectivity passed for subnet "192.168.155.0" with node(s) lclc150,lclc148
              TCP connectivity check passed for subnet "192.168.155.0"

              Node connectivity passed for subnet "80.0.0.0" with node(s) lclc150,lclc148
              TCP connectivity check passed for subnet "80.0.0.0"


              Interfaces found on subnet "192.168.155.0" that are likely candidates for VIP are:
              lclc150 lan4:192.168.155.222 lan4:192.168.155.227 lan4:192.168.155.226 lan4:192.168.155.150
              lclc148 lan4:192.168.155.221 lan4:192.168.155.225 lan4:192.168.155.148

              Interfaces found on subnet "80.0.0.0" that are likely candidates for VIP are:
              lclc150 lan6:80.0.0.2
              lclc148 lan6:80.0.0.1

              WARNING:
              Could not find a suitable set of interfaces for the private interconnect

              Node connectivity check passed

              Total memory check passed
              Available memory check passed
              Swap space check failed
              Check failed on nodes:
              lclc150,lclc148
              Free disk space check passed for "lclc150:/var/tmp/"
              Free disk space check passed for "lclc148:/var/tmp/"
              Check for multiple users with UID value 1100 passed
              User existence check passed for "grid"
              Group existence check passed for "oinstall"
              Group existence check passed for "dba"
              Membership check for user "grid" in group "oinstall" [as Primary] passed
              Membership check for user "grid" in group "dba" passed
              Run level check passed
              Hard limits check passed for "maximum open file descriptors"
              Soft limits check passed for "maximum open file descriptors"
              Hard limits check passed for "maximum user processes"
              Soft limits check passed for "maximum user processes"
              System architecture check passed
              Kernel version check passed
              Kernel parameter check passed for "ksi_alloc_max"
              Kernel parameter check passed for "executable_stack"
              Kernel parameter check passed for "max_thread_proc"
              Kernel parameter check passed for "maxdsiz"
              Kernel parameter check passed for "maxdsiz_64bit"
              Kernel parameter check passed for "maxssiz"
              Kernel parameter check passed for "maxssiz_64bit"
              Kernel parameter check passed for "maxuprc"
              Kernel parameter check passed for "msgmni"
              Kernel parameter check passed for "msgtql"
              Kernel parameter check passed for "ncsize"
              Kernel parameter check passed for "maxfiles_lim"
              Kernel parameter check passed for "maxfiles"
              Kernel parameter check passed for "nflocks"
              Kernel parameter check passed for "ninode"
              Kernel parameter check passed for "nkthread"
              Kernel parameter check passed for "nproc"
              Kernel parameter check passed for "semmni"
              Kernel parameter check passed for "semmns"
              Kernel parameter check passed for "semmnu"
              Kernel parameter check passed for "semvmx"
              Package existence check failed for "OS-Core-B.11.31"
              Check failed on nodes:
              lclc150,lclc148
              Operating system patch check passed for "Patch PHKL_38938"
              Operating system patch check passed for "Patch PHKL_39351"
              Operating system patch check passed for "Patch PHSS_36354"
              Operating system patch check passed for "Patch PHSS_37042"
              Operating system patch check passed for "Patch PHSS_37959"
              Operating system patch check passed for "Patch PHSS_39094"
              Operating system patch check passed for "Patch PHSS_39100"
              Operating system patch check passed for "Patch PHSS_39102"
              Operating system patch check passed for "Patch PHSS_38141"
              Operating system patch check passed for "Patch PHCO_40381"
              Operating system patch check passed for "Patch PHKL_38038"
              Check for multiple users with UID value 0 passed
              Current group ID check passed
              Core file name pattern consistency check passed.

              User "grid" is not part of "root" group. Check passed
              Default user file creation mask check passed

              Starting Clock synchronization checks using Network Time Protocol(NTP)...

              NTP Configuration file check started...
              Network Time Protocol(NTP) configuration file not found on any of the nodes. Oracle Cluster Time Synchronization Service(CTSS) can be used instead of NTP for time synchronization on the cluster nodes

              Clock synchronization check using Network Time Protocol(NTP) passed


              Pre-check for cluster services setup was unsuccessful on all the nodes.

              ============================================

              1. In my both the hosts, Swap Space plus RAM is total 23GB approx see below output.

              bash-4.2# /usr/contrib/bin/machinfo | grep -i Memory
              Memory: 16277 MB (15.9 GB)
              bash-4.2# /usr/sbin/swapinfo -a
              Kb Kb Kb PCT START/ Kb
              TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
              dev 8388608 0 8388608 0% 0 - 1 /dev/vg00/lvol2
              reserve - 3157848 -3157848
              memory 15851192 11166004 4685188 70%


              2. Also showing "Package existence check failed for "OS-Core-B.11.31" but when i checked using "swlist" it's there !

              bash-4.2# swlist -l product | grep OS-Core
              OS-Core B.11.31 Core Operating System, plus Software Terms & Conditions

              I did full OS installation on both the hosts.
              As per below link we can ignore this message if package exists. :)

              https://forums.oracle.com/forums/thread.jspa?threadID=2145271&tstart=0


              -Ashish

              Edited by: 967399 on Dec 13, 2012 9:58 AM
              • 19. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
                71617
                hi,

                You will not able to login if you put space in your password. you can try to login using sqlplus.

                I am not worry about swap space.
                but what happen your interconnect? without private interconnect, your cluster will have problem.
                **WARNING:**
                **Could not find a suitable set of interfaces for the private interconnect**
                • 20. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
                  970402
                  Hi Chen,

                  I am not sure about the out as shown below,

                  =========================================

                  Node connectivity passed for subnet "192.168.155.0" with node(s) lclc150,lclc148
                  TCP connectivity check passed for subnet "192.168.155.0"

                  Node connectivity passed for subnet "80.0.0.0" with node(s) lclc150,lclc148
                  TCP connectivity check passed for subnet "80.0.0.0"

                  Interfaces found on subnet "192.168.155.0" that are likely candidates for VIP are:
                  lclc150 lan4:192.168.155.222 lan4:192.168.155.227 lan4:192.168.155.226 lan4:192.168.155.150
                  lclc148 lan4:192.168.155.221 lan4:192.168.155.225 lan4:192.168.155.148

                  Interfaces found on subnet "80.0.0.0" that are likely candidates for VIP are:
                  lclc150 lan6:80.0.0.2
                  lclc148 lan6:80.0.0.1

                  WARNING:
                  Could not find a suitable set of interfaces for the private interconnect

                  Node connectivity check passed

                  ================================

                  Here as per my setup,

                  1. My Private IP's are - 80.0.0.1, 80.0.0.2
                  2. VIP's are - 192.168.155.221, 192.168.155.222
                  3. Public IP's - 192.168.155.148, 192.168.155.150
                  4. SCAN IP's - 192.168.155.225, 192.168.155.226, 192.168.155.227

                  Please see my hosts file output,

                  # Public
                  192.168.155.148 lclc148.lss.emc.com lclc148
                  192.168.155.150 lclc150.lss.emc.com lclc150

                  # Private
                  80.0.0.1 lclc148-priv.lss.emc.com lclc148-priv
                  80.0.0.2 lclc150-priv.lss.emc.com lclc150-priv

                  # Virtual
                  192.168.155.221 lclc148-vip.lss.emc.com lclc148-vip
                  192.168.155.222 lclc150-vip.lss.emc.com lclc150-vip

                  # SCAN
                  192.168.155.225 lclc-scan.lss.emc.com lclc-scan
                  192.168.155.226 lclc-scan.lss.emc.com lclc-scan
                  192.168.155.227 lclc-scan.lss.emc.com lclc-scan

                  I think there is some bug in output . Because my cluster is configured properly it seems.

                  -Ashish
                  • 21. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
                    dbarohit
                    Ashish,Please let me know the permission and owner/group for the file "oracle"
                    $ORACLE_HOME/bin/oracle
                    $GRID_HOME/bin/oracle

                    Normally that's file permission and group should be same on both the loc.

                    rohit
                    http://dbarohit.blogspot.in/
                    • 22. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
                      71617
                      hi,

                      Did you change your password without space and try to install again?
                      • 23. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
                        71617
                        Oracle binary should have permission of 6751

                        cd $GRID_HOME/bin
                        chmod 6751 oracle

                        cd $ORACLE_HOME/bin
                        chmod 6751 oracle
                        • 24. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
                          dbarohit
                          check the same over my blog.
                          http://dbarohit.blogspot.in/2012/12/database-installation-gets-fail-in-rac.html

                          I hope this will help you with the relevant solution for your issue.

                          --rohit
                          http://dbarohit.blogspot.in/
                          • 25. Re: " ORA-03114: not connected to ORACLE " error with Oracle DB installation
                            970402
                            Thanks alot Chen & Rohit for helping me.

                            Problem was space in the password. Issue resolved when i reinstalled Grid and Oracle database with new password without space and now it's working fine. Actually oracle never takes password with space.

                            -Ashish
                            1 2 Previous Next