Oracle_Enterprise_1,1: Unable to create FIFO with name

[Seya]

Hi,

When i am trying to load data to oracle database using Oracle Enterprise Stage i am getting the following error:

Oracle_Enterprise_1,1: Unable to create FIFO with name '/Data/CDH/Scratch/ora.10487.567021.fifo.1' and mode 00666 - Permission denied

[ArndW]

login as the same user you are running in datastage, then "cd Data/CDH/Scratch" and see if you can do a "touch testme"

[shin0066]

i am also getting same kind of error - but with db2 process -
We checked to touch a file on scratch disk file system and we were able to touch the test file but still the job aborting with same error. what could be the reason?

[ArndW]

Shin - could you post your exact error message?

[shin0066]

here is fatal error message from director log

Code: Select all

output_table,22: Unable to create FIFO with name '/scratch/ordb228195941463796c_.026' and mode 00666 - Permission denied

and file permissions on /scratch is drwxrwsr-x

Thanks

[shin0066]

here is fatal error message from director log

Code: Select all

output_table,22: Unable to create FIFO with name '/scratch/ordb228195941463796c_.026' and mode 00666 - Permission denied

and file permissions on /scratch is drwxrwsr-x

Thanks

[ArndW]

What happens when you try the command "mkfifo -m 00666 /scratch/ordb228195941463796c_.026"?

[Teej]

It is pretty simple --

The account that you are running the job as do not have the permission to modify/create files within this directory - /scratch/ and /Data/CDH/Scratch/

You need to discuss this with your UNIX administrator to ensure that the account you are using be given group read/write permission for that directory at the very minimum.

If you do not know UNIX well, please talk with your UNIX administrator.