Home » RDBMS Server » Server Utilities » Datapump log file read permission (11g Rac Red Hat Enterprise Linux Server release 5.3)
Datapump log file read permission [message #410336] Fri, 26 June 2009 06:58 Go to next message
taguey
Messages: 5
Registered: June 2009
Location: Midlands
Junior Member
Hi all

We're moving from 10.2 to 11g Rac and have hit the following problem.

The 11g datapump log files are all created with permission rw-rw---- making them unreadable to non oracle user/group members. On the 10.2 system permission rw-rw--r- so all users can read the log files.

The datapump log files need to be readable for all users on our system.

Is there some setting in datapump that controls or change the default permissions

I've checked the umask, 022 on both systems. I've logged on 11g as oracle user and created a file with touch. This produced a file with permission rw-rw--r-. Tested a output file with utl_file once again rw-rw--r-.

I've checked metalink couldn't find anything. I've raised a service request but so far the response has been "works fine on our system" and "build another 11g box".

I know I could build a wrapper to change permission but would like to fix it.

Any help on this would be greatly appreciated
Taguey
Re: Datapump log file read permission [message #410366 is a reply to message #410336] Fri, 26 June 2009 09:35 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>The 11g datapump log files are all created with permission rw-rw---- making them unreadable to non oracle user/group members. On the 10.2 system permission rw-rw--r- so all users can read the log files.

Proof please.

>>Is there some setting in datapump that controls or change the default permissions

Create a directory & execute default permission to the directory. Export your database schemas to the directory

Babu

[Updated on: Fri, 26 June 2009 09:39]

Report message to a moderator

Re: Datapump log file read permission [message #410367 is a reply to message #410366] Fri, 26 June 2009 09:45 Go to previous messageGo to next message
taguey
Messages: 5
Registered: June 2009
Location: Midlands
Junior Member
Sorry I've tried that one earlier with a chmod o+r on the directory but the log still doesn't have read permission.

Re: Datapump log file read permission [message #410377 is a reply to message #410367] Fri, 26 June 2009 12:22 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Can you provide proof; What you tried (copy from your session & paste here)

Thanks
Re: Datapump log file read permission [message #412462 is a reply to message #410377] Thu, 09 July 2009 09:45 Go to previous messageGo to next message
taguey
Messages: 5
Registered: June 2009
Location: Midlands
Junior Member
Sorry for the slow reply


export.script

contains the following


expdp username/password \
TABLES=accounting_p \
DIRECTORY=datapump \
dumpfile=test1 \
logfile=test1.log

~

~
~
"export.script" 6L, 112C written
[user_k@testname]$ ./export.script

Export: Release 11.1.0.7.0 - 64bit Production on Thursday, 09 July, 2009 15:26:0

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bitn
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Starting "USERNAME"."SYS_EXPORT_TABLE_01": USERNAME/******** TABLES=accounting_p
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "USERNAME"."ACCOUNTING_P" 31.80 KB 394 rows
Master table "USERNAME"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for USERNAME.SYS_EXPORT_TABLE_01 is:
/DIR_EXP/test1.dmp
Job "USERNAME"."SYS_EXPORT_TABLE_01" successfully completed at 15:26:47

[user_k@testname]$ ls -l test1*
-rw-rw---- 1 oracle oinstall 131072 Jul 9 15:26 test1.dmp
-rw-rw---- 1 oracle oinstall 1230 Jul 9 15:26 test1.log
Re: Datapump log file read permission [message #412463 is a reply to message #410336] Thu, 09 July 2009 09:50 Go to previous messageGo to next message
taguey
Messages: 5
Registered: June 2009
Location: Midlands
Junior Member
The permissions on the datapump directory DIR_EXP
drwxrwxrwx 9 root root 4096 Jul 9 15:26 DIR_EXP
Re: Datapump log file read permission [message #421284 is a reply to message #412463] Mon, 07 September 2009 04:57 Go to previous message
taguey
Messages: 5
Registered: June 2009
Location: Midlands
Junior Member
We've eventually tracked this problem down, no thanks to oracle support! From oracle metalink

Subject: Files created using utl_file do not have world read permission
Doc ID: 808017.1 Type: PROBLEM
[Metalink content removed by MC]

[Updated on: Mon, 07 September 2009 05:39] by Moderator

Report message to a moderator

Previous Topic: IMP-00019 error while importing
Next Topic: need to upload huge volume of AP and AR related transaction
Goto Forum:
  


Current Time: Wed Sep 28 12:37:09 CDT 2016

Total time taken to generate the page: 0.09410 seconds