IMPORT PROBLEMS WITH DUMP FILE
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: IMPORT PROBLEMS WITH DUMP FILE

  1. #1
    Join Date
    Jan 2001
    Posts
    91

    Angry

    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 do I need to rename it or anything?

    Here's the error message

    IMP-00037: CHARACTER SET MARKER UNKNOWN
    IMP-00000: IMPORT TERMINATED UNSUCESSFULLY




  2. #2
    Join Date
    Jan 2001
    Posts
    91
    Oh yeah I forgot to mention that the dump file came from oracle 7.3.4 Sun System

  3. #3
    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.

  4. #4
    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 I should stop it and start over with a 8.1.6 dump file that I just recieved or is this something unrelated to oracle versions take a look..

    __________________________________________________

    Connected to: Personal Oracle8i Release 8.1.6.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production

    Export file created by EXPORT:V07.03.04 via conventional path
    IMP-00017: following statement failed with ORACLE error 1119:
    "CREATE TABLESPACE "AUAFINDATA" DATAFILE '/data1/oradata/AUAFIN/AUAFINdat1."
    "dbf' SIZE 1258291200 DEFAULT STORAGE (INITIAL 40960 NEXT 40960 MINEXT"
    "ENTS 1 MAXEXTENTS 505 PCTINCREASE 50) ONLINE PERMANENT"
    IMP-00003: ORACLE error 1119 encountered
    ORA-01119: error in creating database file '/data1/oradata/AUAFIN/AUAFINdat1.dbf'
    ORA-27040: skgfrcre: create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.
    IMP-00017: following statement failed with ORACLE error 1119:
    "CREATE TABLESPACE "SQLIDX" DATAFILE '/data1/oradata/AUAFIN/AUAFINidx1.dbf'"
    " SIZE 943718400 DEFAULT STORAGE (INITIAL 40960 NEXT 40960 MINEXTENTS "
    "1 MAXEXTENTS 505 PCTINCREASE 50) ONLINE PERMANENT"
    IMP-00003: ORACLE error 1119 encountered
    ORA-01119: error in creating database file '/data1/oradata/AUAFIN/AUAFINidx1.dbf'
    ORA-27040: skgfrcre: create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.
    IMP-00017: following statement failed with ORACLE error 1119:
    "CREATE TABLESPACE "ROLLBACK" DATAFILE '/data1/oradata/AUAFIN/AUAFINrbs1.db"
    "f' SIZE 419430400 DEFAULT STORAGE (INITIAL 40960 NEXT 40960 MINEXTENT"
    "S 1 MAXEXTENTS 505 PCTINCREASE 50) ONLINE PERMANENT"
    IMP-00003: ORACLE error 1119 encountered
    ORA-01119: error in creating database file '/data1/oradata/AUAFIN/AUAFINrbs1.dbf'
    ORA-27040: skgfrcre: create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.
    IMP-00017: following statement failed with ORACLE error 1119:
    "CREATE TABLESPACE "TEMPDB" DATAFILE '/data1/oradata/AUAFIN/AUAFINtmp1.dbf'"
    " SIZE 335544320 DEFAULT STORAGE (INITIAL 40960 NEXT 40960 MINEXTENTS "
    "1 MAXEXTENTS 505 PCTINCREASE 50) ONLINE TEMPORARY"

    ___________________________________________________

    This bottom piece looks like it's having problems granting rights to the users

    ___________________________________________________


    IMP-00003: ORACLE error 1917 encountered
    ORA-01917: user or role 'LASHLEY' does not exist
    IMP-00017: following statement failed with ORACLE error 1917:
    "GRANT SELECT ON "GLBUDGETACCTS" TO "LASHLEY""
    IMP-00003: ORACLE error 1917 encountered
    ORA-01917: user or role 'LASHLEY' does not exist
    IMP-00017: following statement failed with ORACLE error 1917:
    "GRANT UPDATE ON "GLBUDGETACCTS" TO "LASHLEY""
    IMP-00003: ORACLE error 1917 encountered
    ORA-01917: user or role 'LASHLEY' does not exist
    IMP-00017: following statement failed with ORACLE error 1917:
    ___________________________________________________

    it's doing that for everyone in the database

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    if you wanna import to create the tablespaces you have to "made up" the path for them for example if you want to create a file in c:\temp\test and this directory does not exist then obviously you will get errors, import wont make directories, it only creates files and if path is incorrect then you get erros, seems like you are importing from an unix dump file into personal oracle, create the tablespaces manually before you run import

  6. #6
    Join Date
    Jan 2001
    Posts
    91
    Thats exactly what I did pando..

    Since it's almost done should I let it keep going?

    What state will the database be in once it's complete will be usable??



  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    what did you do...? create the tablespaces manually? with same name I hope. If you have done this then just let import going, the errors you are getting would be just warnings

  8. #8
    Join Date
    Jan 2001
    Posts
    91
    Your right on the Money Panda!!! I finished the import and all I got was warnings. I'm able to connect to the database Via Sqlplus and other oracle tools.

    I am expericening a another problem. When try to access the database with third party apps like cognos report writer I get

    this error message


    ORA-12154

    My financial package hangs when I attempt to login. Seem strange the only thing I can connect to the imported database with is oracle tools only any reason why?


    Thanks

  9. #9
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    ora 12154 refers tnsnames.ora/listener.ora etc.
    You might need to run catalog.sql and catproc.sql as userid SYS/INTERNAL and try accessing db.

  10. #10
    Join Date
    Jan 2001
    Posts
    91
    Where do I find the catalog.sql and catproc.sql so I can get this started ASAP


    Thanks for you help again


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width