DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Anyone know the bug number??

  1. #1
    Join Date
    Jun 2003
    Posts
    7

    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
    May 2002
    Posts
    2,645
    LRM-00109: could not open parameter file 'C:/winnt/temp2404133127.dat'

    Who named the parameter file, where is it, and if any paths are specified in it (dump and log files, for example), are those paths correct?

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    The name of the file occurs twice and I see three differences between the two occurences. Are the diagnostics really like that?

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Something to do with security settings for OEM loggeed user. Also check the user read/write access on those directories.
    You can also try removing "." from the file name.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Jun 2003
    Posts
    7
    Sorry guys I typed the diagnostics wrong its:

    LRM-00109: could not open parameter file 'C:/winnt/temp/2404133127.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

    The parameter file is actual there but at this address:
    C:\WINNT\Temp\2404133127.dat

    Basically the wizard creates the parameter file and then try’s to read from it at the wrong address.

    The wizard only asks for you to specify the destination path of the dmp file which is simply d:\oracle\test190903.dmp and no other.

    The parameters are defined with tick boxes, which I leave fully ticked.

    I originally had the VNI-2015 error, but created a local user for the server (not PDC user) with logon batch rights. This was the only way I could get rid of the VNI-2015 error.

    The database user has sysdba rights.

    And the location of the file is on the C: of the server where the database is.

    SANJAY_G when you say try removing the "." I take it you mean if I where able to enter the path for the parameter file??? and not the destination of the dmp??

    I get the same error message with imports and exports.

    I run exports as daily and weekly backups in command prompt and they seem to work fine.


    I would welcome any thoughts or suggestions on how I should proceed?

    Regards

    Eddy

  6. #6
    Join Date
    Jun 2003
    Posts
    7
    Solved it.

    SANJAY_G. You were right it was a privilege problem.

    I solved it by doing the following.

    To grant privileges on the directory that the jobs get written to (default is c:\winnt\temp):
    Go to Start, Programs, Accessories, Windows Explorer
    Open the navigator until you are on C:\WINNT\TEMP
    Right click on this folder and select properties.
    Click on Security
    Click on Add
    Make sure the "Look in" is the local computer
    Select the relevant group or user and click on Add
    Back on the security tab select the same group/user, then make sure the permissions are set as needed (at least read).
    Click on Apply, then OK

    Tnaks again for all your help

    Eddy

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