7 Replies Latest reply: Jan 27, 2010 8:08 AM by Shankar S.-Oracle RSS

    ORDM OLAP Installation Issues

    user97359 - oracle
      Hello,

      I am getting the following error trying to run the ordm_olap_11g_user_env_install_scr.sql script.
      ERROR at line 1:
      ORA-00600: internal error code, arguments: [kzxdgscl-12], [942], [ORA-00942: table or view does not exist
      ], [], [], [], [], [], [], [], [], []
      ORA-06512: at "SYS.DBMS_AW", line 93
      ORA-06512: at "SYS.DBMS_AW", line 122
      ORA-06512: at line 9


      ERROR:
      ORA-00600: internal error code, arguments: [729], [4360], [space leak], [], [], [], [], [], [], [], [], []

      Any help would be appreciated. Full output from the installation is below.

      Thanks,
      Spencer

      Enter password to use for olap user (bia_rtl_olap) creation... defaults to "bia_rtl_olap"
      Enter the password to use for bia_rtl_olap user creation:

      User created.


      User altered.


      Grant succeeded.


      Grant succeeded.


      Grant succeeded.


      Grant succeeded.


      Grant succeeded.


      Grant succeeded.

      Enter name of olap working directory (full path including ending "/")... defaults to "/biaora/install/rbia_dmp/"
      ORDM OLAP Directory (full path including ending "/"): /oradata/rbia_dmp/

      Directory created.


      Grant succeeded.

      Connecting as main schema user (bia_rtl)...
      Enter password for main schema user (bia_rtl)... defaults to "bia_rtl"
      User:bia_rtl, Password:
      Connected.
      Granting privileges to olap user on main schema user objects
      Do not ignore errors (if any)

      Grant succeeded.

      Elapsed: 00:00:00.09

      Grant succeeded.

      Elapsed: 00:00:00.03

      Grant succeeded.

      Elapsed: 00:00:00.03

      Grant succeeded.

      Elapsed: 00:00:00.02

      Grant succeeded.

      Elapsed: 00:00:00.01

      Grant succeeded.

      Elapsed: 00:00:00.01

      Grant succeeded.

      Elapsed: 00:00:00.01

      Grant succeeded.

      Elapsed: 00:00:00.00

      Grant succeeded.

      Elapsed: 00:00:00.01

      Grant succeeded.

      Elapsed: 00:00:00.01

      Grant succeeded.

      Elapsed: 00:00:00.00

      Grant succeeded.

      Elapsed: 00:00:00.02

      Grant succeeded.

      Elapsed: 00:00:00.02

      Grant succeeded.

      Elapsed: 00:00:00.01

      Grant succeeded.

      Elapsed: 00:00:00.01

      Grant succeeded.

      Elapsed: 00:00:00.01

      Grant succeeded.

      Elapsed: 00:00:00.01

      Grant succeeded.

      Elapsed: 00:00:00.01

      Grant succeeded.

      Elapsed: 00:00:00.00

      Grant succeeded.

      Elapsed: 00:00:00.02

      Grant succeeded.

      Elapsed: 00:00:00.00
      Connecting as bia_rtl_olap user...
      Enter password for olap schema user (bia_rtl_olap)... defaults to "bia_rtl_olap"
      User:bia_rtl_olap, Password:
      Connected.
      Creating the RBIA_OLAP_ETL_AW_LOAD package...

      Package created.

      Elapsed: 00:00:00.32

      Package body created.

      Elapsed: 00:00:00.28
      Creating ORDM OLAP views...
      ignore error in creation of view OOS_CUBEVIEW (as AW PSLSINV has not yet been created).

      View created.

      Elapsed: 00:00:00.05

      View created.

      Elapsed: 00:00:00.03

      View created.

      Elapsed: 00:00:00.07

      View created.

      Elapsed: 00:00:00.05

      View created.

      Elapsed: 00:00:00.05

      View created.

      Elapsed: 00:00:00.06

      View created.

      Elapsed: 00:00:00.06

      View created.

      Elapsed: 00:00:00.05

      View created.

      Elapsed: 00:00:00.06

      Warning: View created with compilation errors.

      Elapsed: 00:00:00.23
      16:51:03 : Database version:11.1.0.7.0

      PL/SQL procedure successfully completed.

      Elapsed: 00:00:00.06
      BEGIN Build of AW PSLSINV from Template
      Build AW from template...

      PL/SQL procedure successfully completed.

      Elapsed: 00:00:19.69
      END Build of AW PSLSINV from Template
      Import addl objects...
      declare
      *
      ERROR at line 1:
      ORA-00600: internal error code, arguments: [kzxdgscl-12], [942], [ORA-00942: table or view does not exist
      ], [], [], [], [], [], [], [], [], []
      ORA-06512: at "SYS.DBMS_AW", line 93
      ORA-06512: at "SYS.DBMS_AW", line 122
      ORA-06512: at line 9


      ERROR:
      ORA-00600: internal error code, arguments: [729], [4360], [space leak], [], [], [], [], [], [], [], [], []


      Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
      With the Partitioning, OLAP and Real Application Testing options (with complications)
        • 1. Re: ORDM OLAP Installation Issues
          718433
          Dear Spencer,

          We are looking into this and shall get back to you at the earlierst.

          Regards,
          KS Kalyan
          Genex Team
          • 2. Re: ORDM OLAP Installation Issues
            ErikYkema
            Hi Spencer,
            Is the issue reproducable? Have you checked the ORA-00600 lookup tool on OracleSupport?
            Regards, Erik
            • 3. Re: ORDM OLAP Installation Issues
              user97359 - oracle
              Hello,

              Yes, this is reproducible, well, in this environment. I have looked up the 600 error code, but I will do so again as I did not see anything pertinent the first time.

              Thanks for you help,
              • 4. Re: ORDM OLAP Installation Issues
                726113
                So you got actually 2 ORA-00600 errors, the 729 and the kzxdgscl-12.

                For the 729, see OracleSupport ORA-600 [729] "UGA Space Leak" [ID 31056.1]. There are some reported issues on 11.1.X and also some instructions on how to file a support request for this.

                For the kzxdgscl-12, there is no known reference yet.
                My guess is that the kzxdgscl-12 is a side effect of the 729 - solve the 729 first, and then see what is needed for any residual errors on the dbms_aw (relating to the active workspace management).

                Of course I risk telling you trivial stuff, but I cannot make up from your post what you know and what not, just trying to help.

                Regards,
                Erik Ykema
                • 5. Re: ORDM OLAP Installation Issues
                  718433
                  Dear Spencer,

                  We might need to understand the details of the environment over which you are installing, can you please address the below queries.

                  1. Is this on a certified environment?
                  2. Are the recomended db patches applied?

                  Regards,
                  KS Kalyan
                  • 6. Re: ORDM OLAP Installation Issues
                    user97359 - oracle
                    Hello,

                    Here's OPatch output on inventory and current linux rev.

                    Thanks,
                    Spencer

                    Invoking OPatch 11.1.0.6.2

                    Oracle Interim Patch Installer version 11.1.0.6.2
                    Copyright (c) 2007, Oracle Corporation. All rights reserved.


                    Oracle Home : /oracle/product/11.1.0.7
                    Central Inventory : /home/oracle/oraInventory
                    from : /etc/oraInst.loc
                    OPatch version : 11.1.0.6.2
                    OUI version : 11.1.0.7.0
                    OUI location : /oracle/product/11.1.0.7/oui
                    Log file location : /oracle/product/11.1.0.7/cfgtoollogs/opatch/opatch2010-01-27_15-03-22PM.log

                    --------------------------------------------------------------------------------
                    Installed Top-level Products (4):

                    Oracle Database 11g 11.1.0.6.0
                    Oracle Database 11g Examples 11.1.0.6.0
                    Oracle Database 11g Patch Set 1 11.1.0.7.0
                    Oracle Retail Data Model 10.2.2.0.0
                    There are 4 products installed in this Oracle Home.


                    Interim patches (5) :

                    Patch 8524113 : applied on Tue Aug 11 03:09:11 CDT 2009
                    Created on 15 Jun 2009, 08:28:49 hrs PST8PDT
                    Bugs fixed:
                    8524113

                    Patch 7695070 : applied on Tue Aug 11 03:07:16 CDT 2009
                    Created on 16 Jun 2009, 21:13:15 hrs PST8PDT
                    Bugs fixed:
                    7695070

                    Patch 6269507 : applied on Mon Jun 22 13:27:44 CDT 2009
                    Created on 23 Jan 2009, 01:59:00 hrs PST8PDT
                    Bugs fixed:
                    6269507

                    Patch 7378322 : applied on Wed Jun 17 16:15:41 CDT 2009
                    Created on 10 Mar 2009, 06:03:33 hrs PST8PDT
                    Bugs fixed:
                    7378322

                    Patch 7036284 : applied on Wed Jun 17 16:13:22 CDT 2009
                    Created on 29 Jan 2009, 01:31:07 hrs US/Pacific
                    Bugs fixed:
                    7036284



                    --------------------------------------------------------------------------------

                    OPatch succeeded.

                    [oracle@ordbsrv OPatch]$ uname -a
                    Linux ordbsrv 2.6.18-92.el5 #1 SMP Fri May 23 23:40:43 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux

                    [oracle@ordbsrv OPatch]$ cat /etc/issue
                    Enterprise Linux Enterprise Linux Server release 5.2 (Carthage)
                    Kernel \r on an \m
                    • 7. Re: ORDM OLAP Installation Issues
                      Shankar S.-Oracle
                      Spencer,

                      ORDM OLAP was certified on 11gR1 using Patch 8641931: OLAP B PATCH for Oracle Database 11g Release 1 (11.1.0.7).

                      We havent come across the specific ORA-600 bug you're encountering during ORDM development/certification.

                      The list of patches you've applied on 11gR1 do not include any of the olap specific patchsets (OLAP A/B/C patchsets for 11.1.0.7 are patches - 7486407/8641931/8908784 respectively).

                      OLAP B Patch is available at metalink (My Oracle Support) for both the Linux 32 bit and the Linux 64 bit versions so be sure to apply the right version (64 bit in your case). Please apply it and retry the ORDM OLAP installation. Recommend that you drop the olap user and the olap user/temp tablespaces before attempting the install once again.

                      Patch 8641931: OLAP B PATCH
                      Last Updated: Aug 21 2009
                      Size: 17.7 Mb
                      Platform: Linux x86-64
                      Release: 11.1.0.7.0

                      This is password protected as its in limited release. Please get in touch with me at shankar (dot) somayajula (at) oracle (dot) com and provide details relating to the customer and i'll procure the password and pass it on to you.

                      Note: As per the [OLAP Certification page|http://www.oracle.com/technology/products/bi/olap/collateral/olap_certification.html], there is a more recent patch for 11gR1 - OLAP C patch for 11.1.0.7 (8908784) Oct 2009 which is available in general (w/o any password) but ORDM OLAP 11gR1 wasn't verified against this patch/patchset.


                      Hope that helps,
                      Shankar