Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Please help me set up samples in Cognos 8.4 with Oracle 10g?

Status
Not open for further replies.

snokijum

MIS
May 23, 2010
1
US
I have set up cognos and Oracle according to the instructions at:
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:
Can anyone please tell me what this means?

Please let me know how to proceed.

Thank you!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top