| Datapump log file read permission [message #410336] |
Fri, 26 June 2009 06:58  |
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  |
babuknb
Messages: 1736
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 #412462 is a reply to message #410377] |
Thu, 09 July 2009 09:45 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
