Failed With Oracle Error 1917
importing Controller Oracle database Technote (troubleshooting) Problem(Abstract) Oracle DBA tries to import Controller user/schema into Oracle database, using ora-01917 user or role 'oracle' does not exist a command similar to the following: imp system/password@databasename file=exp_SOURCEUSERNAME.dmp log=DESTINATION_USERNAME-imp.log fromuser=SOURCEUSERNAME touser=DESTINATION_USERNAME ora-1917 DBA receives error message. Symptom Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production Export file created by EXPORT:V09.02.00 via conventional path Warning: the objects were exported by ADMIN_USERNAME, not by you import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) . importing SOURCEUSERNAME's objects into DESTINATION_USERNAME IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "CCOJ_ICMPNJRNLS_GTCSMMTN_ALS" TO "FTIQA"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'FTIQA' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "CCOJ_ICMPNJRNLS_GTCSMMTN_SM" TO "FTIQA"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'FTIQA' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "CCOJ_ICMPNJRNLS_GTCSMMTN_SMD" TO "FTIQA"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'FTIQA' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "CCOJ_ICMPNJRNLS_JRNLS_ALS" TO "FTIQA"" IMP-00003: ORACLE error 1917 encountered... Cause The environment from where the original backup (export / .DMP) file was created is using the (optional) Oracle feature which creates additional grants on objects in the Controller schema. Resolving the problem Delete the schema, then re-create a blank schema. Finally, import the user (into the new schema) but this time use the optional switch: grants=no. Steps: Modify your import script, to something similar to: imp system/password@databasename file=exp_SOURCEUSERNAME.dmp log=DESTINATION_USERNAME-imp.log fromuser=SOURCEUSERNAME touser=DESTINATION_USERNAME grants=no Historical Number 1039437 Document information More support for: Cognos Controller Controller Software version: 8.3, 8.4, 8.5, 8.5.1, 10.1, 10.1.1 Operating system(s): Windows Reference #: 1371533 Modified date: 2008-04-16 Site availability Site assistance Conta
Topic Backup and recovery Database Admin View All Cloud infrastructure Availability Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real http://www.ibm.com/support/docview.wss?uid=swg21371533 Application Clusters (RAC) Applications View All Enterprise and business performance management Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM http://searchoracle.techtarget.com/answer/How-to-solve-an-Oracle-import-error Data Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All
DUMP FILE If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can http://www.dbasupport.com/forums/showthread.php?6475-IMPORT-PROBLEMS-WITH-DUMP-FILE post: click the register link above to proceed. To start viewing messages, select http://dbaforums.org/oracle/lofiversion/index.php?t22509.html the forum that you want to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 11 Thread: IMPORT PROBLEMS WITH DUMP FILE Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid failed with Mode Switch to Threaded Mode 02-03-2001,12:48 AM #1 treedstang View Profile View Forum Posts Junior Member Join Date Jan 2001 Posts 91 I just installed oracle 8i on a win2k system. I used the default preconfigured database setup. This is what I typeD to import dump file. imp system/manager@auafin full=y file=auafin22mar00.dmp.z was that correct?? and yes the dump file name is that long failed with oracle do I need to rename it or anything? Here's the error message IMP-00037: CHARACTER SET MARKER UNKNOWN IMP-00000: IMPORT TERMINATED UNSUCESSFULLY Reply With Quote 02-03-2001,12:50 AM #2 treedstang View Profile View Forum Posts Junior Member Join Date Jan 2001 Posts 91 Oh yeah I forgot to mention that the dump file came from oracle 7.3.4 Sun System Reply With Quote 02-03-2001,10:24 AM #3 sreddy View Profile View Forum Posts Senior Advisor Join Date Feb 2000 Location Washington DC Posts 1,843 Is that dumpfile is compressed or uncompressed. I have mentioned to use 8i binaries for imp. Executables binaries should match with version of database. wants to take 734 exp - use 734 exp utility wants to imp on 816 imp - use 816 imp utility Strange Message, which I have never seen for exp/imp. Reply With Quote 02-03-2001,06:52 PM #4 treedstang View Profile View Forum Posts Junior Member Join Date Jan 2001 Posts 91 Ok Sreddy I'm rilling now the import is goin on right now as I right this email. I'm getting a lot of error messages take a look at the messages and tell me if
parfile which syntax is below and the log error is also below please help me out iam very new ...I also tried full=y but not works for me (:log=LOG.logfile=20130117_oom.dmpbuffer=98888888ignore=ycommit=ygrants=yrows=yfeedback=1000000constraints = nindexes=nfromuser=system touser=system Username: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.02.01 via conventional pathimport done in WE8MSWIN1252 character set and UTF8 NCHAR character setimport server uses UTF8 character set (possible charset conversion)export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)IMP-00017: following statement failed with ORACLE error 959: "CREATE USER "RMAN" IDENTIFIED BY VALUES 'E7B5D92911C831E1' DEFAULT TABLESPA" "CE "RMAN_TBS" TEMPORARY TABLESPACE "TEMP""IMP-00003: ORACLE error 959 encounteredORA-00959: tablespace 'RMAN_TBS' does not existIMP-00017: following statement failed with ORACLE error 959: "CREATE USER "WDMADMIN" IDENTIFIED BY VALUES 'D58687B8BB3BDE6E' DEFAULT TABL" "ESPACE "WDM_DATA" TEMPORARY TABLESPACE "TEMP""IMP-00003: ORACLE error 959 encounteredORA-00959: tablespace 'WDM_DATA' does not existIMP-00017: following statement failed with ORACLE error 959: "CREATE USER "EDM2" IDENTIFIED BY VALUES '256F8AEE865A5540' DEFAULT TABLESPA" "CE "SDS_TABLE" TEMPORARY TABLESPACE "TEMP""IMP-00003: ORACLE error 959 encounteredORA-00959: tablespace 'SDS_TABLE' does not existIMP-00017: following statement failed with ORACLE error 959: "CREATE USER "EDM3" IDENTIFIED BY VALUES '8880C65084AC2B72' DEFAULT TABLESPA" "CE "SDS_TABLE" TEMPORARY TABLESPACE "TEMP""IMP-00003: ORACLE error 959 encounteredORA-00959: tablespace 'SDS_TABLE' does not existIMP-00017: following statement failed with ORACLE error 959: "CREATE USER "WDMDEMO" IDENTIFIED BY VALUES 'C9CD21C98E1C045F' DEFAULT TABLE" "SPACE "WDM_DATA" TEMPORARY TABLESPACE "TEMP""IMP-00003: ORACLE error 959 encounteredORA-00959: tablespace 'WDM_DATA' does not existIMP-00017: following statement failed with ORACLE error 959: "CREATE USER "WDM_DEMO" IDENTIFIED BY VALUES '6E0EB4C2FCEEF010' DEFAULT TABL" "ESPACE "SDS_TABLE" TEMP