| Directory issue in 11g [message #645662] |
Thu, 10 December 2015 11:08  |
 |
hboswell
Messages: 5
Registered: December 2015
|
Junior Member |
|
|
I'm having a problem getting a directory to work in 11gr2 (11.2.0.1). I've set the Linux permissions - the oracle Linux user can create a file in that directory. I've created the directory as SYS and granted read,write to the Oracle user. But when I test against the directory, with either SYS or the granted user, it doesn't see the file that Oracle created:
DECLARE
l_exists boolean;
l_size integer;
l_block_size integer;
BEGIN
utl_file.fgetattr( 'HB_ORA_DIR',
'test.fil',
l_exists,
l_size,
l_block_size );
if( l_exists )
then
dbms_output.put_line( 'The file exists and has a size of ' || l_size );
else
dbms_output.put_line( 'The file does not exist or is not visible to Oracle - l_exists = ' ||case l_exists when true then 'True' else 'False' end );
end if;
END;
/
DBMS_OUTPUT --> The file does not exist or is not visible to Oracle - l_exists = False
Linux directory permissions: drwxrwxr-x 2 hboswell users 4096 Dec 10 11:23 oradir
Directory:
CREATE OR REPLACE DIRECTORY
HB_ORA_DIR AS
'/home/hboswell/oradir';
GRANT READ, WRITE ON DIRECTORY HB_ORA_DIR TO OPC_WRIMS;
It appears to be set up the same way it was on 10g (different server), but the database just doesn't seem to have visibility into that directory. What am I forgetting?
Thanks,
Harry
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
