COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: kitaeren on 23 May 2010 05:49:15 AM

Title: Please help me set up samples in Cognos 8.4 with Oracle 10g?
Post by: kitaeren on 23 May 2010 05:49:15 AM
 ???

I have set up cognos and Oracle according to the instructions at: http://it.toolbox.com/wiki/index.php/How_to_install_and_configure_Cognos

However, after getting to step 7.4, I am now stuck.  Step 7 reads:
"
1.  You should now import the samples.

2. Create five users in OracleXE called gosales, gosalesdw, gosaleshr, gosalesmr and gosalesrt. The password should be the same as the user id. Make sure to grant them all the privileges.

3. Go to cognos\c8\webcontent\samples\datasources\oracle and extract the .gz files.

4. Under this folder run the following commands:
  imp gosales/gosales@xe file = GOSALES.dmp full=y log=log.txt
  imp gosaleshr/gosaleshr@xe file = GOSALESHR.dmp full=y log=log.txt
  imp gosalesdw/gosalesdw@xe file = GOSALESDW.dmp full=y log=log.txt
  imp gosalesmr/gosalesmr@xe file = GOSALESMR.dmp full=y log=log.txt
  imp gosalesrt/gosalesrt@xe file = GOSALESRT.dmp full=y log=log.txt
"
I have completed 7.1, 7.2, and 7.3 above.  The problem I am running into is right after I attempt to enter the first command of step 7.4 (that is indicated above) under "C:\progra~1\cognos\c8\webcon~1\samples\dataso~1\oracle" I am getting the following error in my dos command window: "IMP-00002: failed to open GOSALES.dmp for read Import file: EXPDAT.DMP >"

The full command window can be viewed here: http://i66.photobucket.com/albums/h249/kitaeren/cognosoracle.jpg

Can anyone please tell me what this means?

Please let me know how to proceed.

Thank you!

Title: Re: Please help me set up samples in Cognos 8.4 with Oracle 10g?
Post by: cogadmin on 24 May 2010 09:01:05 AM
Did you install Cognos Samples? I need to install Cognos Samples after Cognos's installation.