When I tried to install the example, I get this error message:
... OLAPTRAIN user exists. Attempting to drop the user.
... creating OLAPTRAIN user
... creating OLAPTRAIN_INSTALL directory
... importing dump file into OLAPTRAIN schema.
Import: Release 188.8.131.52.0 - 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 184.108.40.206.0 - 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
I haven't seen this particular problem, but it does look like you were trying to install into 220.127.116.11. The OLAPTRAIN schema requires 18.104.22.168, preferably the 'A' patch, so I would move to that version before spending more time on this issue.
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
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
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
install directory should be same as sbove
8.password same as above
Edited by: karuna nidhan tiwary on Aug 10, 2012 5:51 AM