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

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?

The name of the file occurs twice and I see three differences between the two occurences. Are the diagnostics really like that?

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.

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

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