Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    9

    Unanswered: Anyone know the bug number??

    Hello everyone,

    Was anyone come across this problem before?

    I am using Oracle EE 8.1.7 and OEM 2.2.

    Every time I try to import and export with OEM wizard the job fails and I get the following message:

    LRM-00109: could not open parameter file 'C:/winnt/temp2404133127.dat'
    LRM-00113: error when processing file 'C:/Winnit/temp/2404133127.dat'

    EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
    EXP-00000: Export terminated unsuccessfully

    As you can see above, the most probable reason why I am getting this error is because the slash’s are the wrong way round.

    They should be ‘\’ not ‘/’

    If this is a bug, Does anyone know the bug or patch number?


    Eddy

  2. #2
    Join Date
    Aug 2003
    Location
    SW Ohio
    Posts
    198

    Re: Anyone know the bug number??

    Originally posted by teched
    Hello everyone,

    Was anyone come across this problem before?

    I am using Oracle EE 8.1.7 and OEM 2.2.

    Every time I try to import and export with OEM wizard the job fails and I get the following message:
    ...
    If this is a bug, Does anyone know the bug or patch number?

    Eddy
    I've never had success with any of the GUI import/export interfaces. I started with 8.0.5 and am at 8i DB w/ a 9i EM.

    Command line works great though with parameter files.
    CMD Line:
    D:\ORACLE\ORA81\BIN\EXP.EXE system/**** PARFILE=D:\ORADUMP\PROD\EXPORT.PAR

    Export.par:
    FILE=D:\oradump\prod\dmp\PROD_20030917_A.dmp, D:\oradump\prod\dmp\PROD_20030917_B.dmp, D:\oradump\prod\dmp\PROD_20030917_C.dmp, D:\oradump\prod\dmp\PROD_20030917_D.dmp, D:\oradump\prod\dmp\PROD_20030917_E.dmp, D:\oradump\prod\dmp\PROD_20030917_F.dmp, D:\oradump\prod\dmp\PROD_20030917_G.dmp, D:\oradump\prod\dmp\PROD_20030917_H.dmp
    FULL=Y
    FILESIZE=671088640
    BUFFER = 30000000
    RECORD=Y
    INCTYPE = COMPLETE
    FEEDBACK=10000
    LOG=D:\oradump\prod\dmp\PROD_20030917.LOG


    Just my 2 centavos....
    Last edited by jimpen; 09-18-03 at 17:14.
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

  3. #3
    Join Date
    Sep 2003
    Posts
    9
    Thanks you the responce jimpen

    I use command prompt for daily and weekly backups through batch files.

    I just would not mind using a GUI for setting up replication between two databases.

    You seem to be doing 8 dmp's at the same time ?? How does that work for you ?


    Eddy

  4. #4
    Join Date
    Aug 2003
    Location
    SW Ohio
    Posts
    198
    Originally posted by teched
    Thanks you the responce jimpen

    I use command prompt for daily and weekly backups through batch files.

    I just would not mind using a GUI for setting up replication between two databases.

    You seem to be doing 8 dmp's at the same time ?? How does that work for you ?


    Eddy

    FILE=D:\oradump\prod\dmp\PROD_20030917_A.dmp, D:\oradump\prod\dmp\PROD_20030917_B.dmp, D:\oradump\prod\dmp\PROD_20030917_C.dmp, D:\oradump\prod\dmp\PROD_20030917_D.dmp, D:\oradump\prod\dmp\PROD_20030917_E.dmp, D:\oradump\prod\dmp\PROD_20030917_F.dmp, D:\oradump\prod\dmp\PROD_20030917_G.dmp, D:\oradump\prod\dmp\PROD_20030917_H.dmp
    FILESIZE=671088640

    Actually I'm only doing one dump. The filesize variable is the key. It makes the dump file 640MB each. When it fills the first file it moves onto the next.

    Makes life easier. This is our accounting database so I need to make permanent backups that can be held onto for auditing purposes. This way at the EOY I can burn a file per CD and put it into storage. Plus, if I have to copy them onto another server to do testing, it makes it easier. I'm running A-D full and my E is a partial. The import.par for building test DB's is the only thing I have to edit. But I would have to do that anyway. The date is in the dump file name.
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

  5. #5
    Join Date
    Sep 2003
    Posts
    9
    Quality.

    Thanks for the info

    I will have to remember that one.

    Fortunately our database is no way near that large.

Posting Permissions

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