2 Replies Latest reply: Aug 10, 2012 7:55 AM by 939857 RSS

    Error installing OLAPTRAIN sample schema

      When I tried to install the example, I get this error message:

      Begin installation
      ... OLAPTRAIN user exists. Attempting to drop the user.
      ... creating OLAPTRAIN user
      ... creating OLAPTRAIN_INSTALL directory
      ... importing dump file into OLAPTRAIN schema.

      Import: Release - Production on Thursday, 22 January, 2009 0:55:04

      Copyright (c) 2003, 2007, Oracle. All rights reserved.

      Connected to: Oracle Database 11g Enterprise Edition Release - Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      ORA-39002: invalid operation
      ORA-31694: master table "OLAPTRAIN"."SYS_IMPORT_FULL_01" failed to load/unload
      ORA-02354: error in exporting/importing data
      ORA-02373: Error parsing insert statement for table "OLAPTRAIN"."SYS_IMPORT_FULL_01".
      ORA-00904: "ORIGINAL_OBJECT_NAME": invalid identifier

      ... dropping OLAPTRAIN_INSTALL directory
      Installation complete.
        • 1. Re: Error installing OLAPTRAIN sample schema
          I haven't seen this particular problem, but it does look like you were trying to install into The OLAPTRAIN schema requires, preferably the 'A' patch, so I would move to that version before spending more time on this issue.

          See http://www.oracle.com/technology/products/bi/olap/11g/samples/schemas/readme.html
          • 2. Re: Error installing OLAPTRAIN sample schema
            installing the olaptrain schema

            proceed through following steps

            1.unzip the olaptrain schema

            2.change tha name olaptrain_home (unzipped

            directory name to *[install_home]*.

            3.copy the *[install_home]* folder to the

            oracle database folder.
            for example suppose your oracle 11gr2 database

            location is
            *" D:\app\karuna\product\11.2.0\dbhome_1\database"*

            then copy your *[install_home]* folder into the

            above directory folder.so location of your

            [install_home] should also be

            4.now open cmd

            go to the directory where u have copied


            ex:- cd D:\app\karuna\product\11.2.0\dbhome_1\database\[install_home]\olaptrain_install

            that was in my case

            5.now login to sqlplus

            ex:-type sqlplus in cmd

            login as dba

            ex:- system/password as sysdba

            then it will ask u for the directory
            so directory name should be the same where

            u have kept the [olaptrain_schema]
            in my case it was

            Directory: *D:\app\karuna\product\11.2.0\dbhome_1\database\[install_home]\olaptrain_install*

            the directory address ws given by me...
            u can see here its location is same as the

            location where i have copied olaptrain


            6.then it wl prompt for password

            password can be anything u want.

            and voila installation


            now building olaptrain cubes

            7. @create_olaptrain_cubes
            install directory should be same as sbove
            8.password same as above

            installation started...

            Edited by: karuna nidhan tiwary on Aug 10, 2012 5:51 AM