Page 1 of 1
Oracle_Enterprise_1,1: Unable to create FIFO with name
Posted: Tue Aug 07, 2007 4:28 am
by 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
Posted: Tue Aug 07, 2007 4:45 am
by 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"
Posted: Tue Feb 12, 2008 9:42 am
by 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?
Posted: Tue Feb 12, 2008 10:15 am
by ArndW
Shin - could you post your exact error message?
Posted: Tue Feb 12, 2008 10:35 am
by 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
Posted: Tue Feb 12, 2008 10:36 am
by 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
Posted: Tue Feb 12, 2008 11:26 am
by ArndW
What happens when you try the command "mkfifo -m 00666 /scratch/ordb228195941463796c_.026"?
Posted: Tue Feb 12, 2008 11:31 am
by 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.