1 2 3 Previous Next 40 Replies Latest reply: May 13, 2013 11:35 PM by user11952526 Go to original post RSS
      • 30. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
        user11952526
        Hi Hussein,

        I am using the below doc...

        Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0) [ID *216550.1*]


        From Section 2: Upgrading an Existing Oracle9i Release 2 (9.2.0) Database

        Step# 6 Perform 9.2.0.8 Patch Set installation tasks : ---> Here I need to install 9.2.0.8 RDBMS software and for that I need to execute runInstaller...

        On the database server node, as the owner of the Oracle RDBMS file system and database instance, perform the tasks in the "Installing the Oracle9i Release 2 Patch Set Interactively" section.

        Thanks.
        • 31. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
          Hussein Sawwan-Oracle
          You need to install the software, so is there any reason you are running "uninstall"?

          Thanks,
          Hussein
          • 32. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
            Hussein Sawwan-Oracle
            If you get the error when you run the installer to install the software, then please run the installer using "./runInstaller -ignoreSysPrereqs" -- Explanation and Options To Handle "Checking operating system version: must be ... Failed" OUI errors [ID 763143.1]

            Thanks,
            Hussein
            • 33. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
              user11952526
              Hi Hussein,

              Thanks it is working now [I have installed successfully Oracle9i Patch Set (p4547809_92080_LINUX.zip)] and OUI is opening now with this command "./runInstaller -ignoreSysPrereqs".
              From the readme file of p4547809_92080_LINUX.zip Step# 7 Postinstallation Tasks : when I try to start the database, getting the following error...

              ========================================================================================================================================
              [oravis@linux1 ~]$ sqlplus "/as sysdba"

              SQL*Plus: Release 9.2.0.8.0 - Production on Thu May 9 12:05:47 2013

              Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

              Connected to an idle instance.

              SQL> startup
              ORACLE instance started.

              Total System Global Area 581505840 bytes
              Fixed Size 451376 bytes
              Variable Size 402653184 bytes
              Database Buffers 167772160 bytes
              Redo Buffers 10629120 bytes
              ORA-32700: error occurred in DIAG Group Service

              [oravis@linux1 ~]$ oerr ora 32700
              32700, 00000, "error occurred in DIAG Group Service"
              // *Cause: An unexpected error occurred while performing a DIAG Group Service
              // operation.
              // *Action: Verify that the DIAG process is still active. Also, check the
              // Oracle DIAG trace files for errors.

              From alert log :
              --------------------

              SSKGXP_IP: Primary interface down
              operation cannot open cmcfg.ora
              location clusterip1
              error No such file or directory
              Thu May 9 11:59:45 2013
              cluster interconnect IPC version:Oracle UDP/IP
              IPC Vendor 1 proto 2 Version 1.0
              Thu May 9 11:59:45 2013
              SSKGXP_IP: Primary interface down
              operation cannot open cmcfg.ora
              location clusterip1
              error No such file or directory
              Thu May 9 11:59:45 2013
              WARNING:Oracle instance running on a system with low open file descriptor
              limit. Tune your system to increase this limit to avoid
              severe performance degradation.
              PMON started with pid=2, OS id=15443

              From DIAG trace files :
              -------------------------------
              [oravis@linux1 bdump]$ more vis_diag_15548.trc
              Dump file /u01/vis/visdb/9.2.0/admin/VIS_linux1/bdump/vis_diag_15548.trc
              Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
              With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
              JServer Release 9.2.0.8.0 - Production
              ORACLE_HOME = /u01/vis/visdb/9.2.0
              System name: Linux
              Node name: linux1.oracle.com
              Release: 2.6.18-238.el5xen
              Version: #1 SMP Tue Jan 4 16:18:33 EST 2011
              Machine: i686
              Instance name: VIS
              Redo thread mounted by this instance: 0 <none>
              Oracle process number: 3
              Unix process pid: 15548, image: oracle@linux1.oracle.com (DIAG)

              *** SESSION ID:(2.1) 2013-05-09 12:07:09.951
              kjzmini1: slos err[1 skgxnnfy_failed skgxncini1 9402]
              [kjzmini1]: Error [category=1] is encountered
              Node monitor problem:[32700][kjzmini1]
              Membership is lost in DIAG group
              *** 2013-05-09 12:07:39.574
              DIAG is exiting

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

              # ulimit -a
              core file size (blocks, -c) 0
              data seg size (kbytes, -d) unlimited
              scheduling priority (-e) 0
              file size (blocks, -f) unlimited
              pending signals (-i) 28201
              max locked memory (kbytes, -l) 32
              max memory size (kbytes, -m) unlimited
              open files (-n) 1024
              pipe size (512 bytes, -p) 8
              POSIX message queues (bytes, -q) 819200
              real-time priority (-r) 0
              stack size (kbytes, -s) 10240
              cpu time (seconds, -t) unlimited
              max user processes (-u) 28201
              virtual memory (kbytes, -v) unlimited
              file locks (-x) unlimited

              Thanks
              • 34. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                Hussein Sawwan-Oracle
                Please see the following docs.

                Linux AS 2.1 RAC Startup Fails With ORA-32700: Error Occurred In DIAG Group Service [ID 224422.1]
                OERR: ORA-32700 Error occurred in DIAG Group Service [ID 183516.1]
                Alert Log Warning For Open File Descriptor Limit [ID 1508298.1]
                Background Process Terminated, e.g. ORA-471, Accompanied By Alert Log Warning "Low open file descriptor limit" [ID 375517.1]

                Thanks,
                Hussein
                • 35. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                  user11952526
                  Hi Hussein,

                  From the note "Alert Log Warning For Open File Descriptor Limit [ID 1508298.1]"
                  I have increased the no of open files by executing the below command...

                  ulimit -Hn 65536

                  My /etc/security/limits.conf settings as below...
                  hard nofile 65535
                  soft nofile 4096

                  Still unable to startup the database getting the same error...

                  Thanks.
                  • 36. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                    Hussein Sawwan-Oracle
                    Did you reboot the server after doing the necessary changes?

                    Thanks,
                    Hussein
                    • 37. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                      user11952526
                      Hi Hussein,

                      Yes, I rebooted the server.

                      Thanks.
                      • 38. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                        user11952526
                        Hi Hussein,

                        Waiting for you input.

                        Thanks.
                        • 39. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                          Hussein Sawwan-Oracle
                          If none of the above helps, then please log a SR.

                          Thanks,
                          Hussein
                          • 40. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                            user11952526
                            Okay Hussein. Thanks for your help!

                            Regards.
                            1 2 3 Previous Next