Re: [sap-basis] Oracle archive job getting message 'BR0252E - Function fopen() failed
Posted by
Admin at
Share this post:
|
0 Comments
Posted by SAP BASIS Admin on Apr 11 at 12:54 PM | Mark as helpful |
Authorizations to access log files are missing. In addition to the obvious
cause of incorrect directory authorizations, the authorizations of the
executables SAPDBA, BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRCONNECT and
BRTOOLS are usually responsible for the errors.
In particular, these problems are caused by an s-bit that has not been set
correctly and an incorrect file owner.
The errors usually occur only with certain operating system users
(generally, <sid>adm) while the tools are working with another user
(generally, ora<sid>).
*Solution*
Set the access authorizations and the file owner as described in Note
113747.
On Thu, Apr 8, 2010 at 8:22 PM, Michael Hayden via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:
> Posted by Michael Hayden
> on Apr 8 at 10:57 AM
> when running an Oracle arhive job using BRTOOLS, we get the following
> error message: BR0006I Start of offline redo log processing: aecytqgf.sve
> 2010-04-08 14.50.01 BR0252E Function fopen() failed for
> '/oracle/NSD/saparch/aecyBR0477I Oracle pfil e
> /oracle/NSD/102_64/dbs/initNSD.ora created from spfile
> /oracle/NSD/102_64/dbs/ spfileNSD.ora I've checked permissions and
> ownerships and even compared the settings to another DB server where it is
> functioning and I'm lost as to why we are getting this message. Any help
> would be greatly appreciated! - Mike
__.____._ cause of incorrect directory authorizations, the authorizations of the
executables SAPDBA, BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRCONNECT and
BRTOOLS are usually responsible for the errors.
In particular, these problems are caused by an s-bit that has not been set
correctly and an incorrect file owner.
The errors usually occur only with certain operating system users
(generally, <sid>adm) while the tools are working with another user
(generally, ora<sid>).
*Solution*
Set the access authorizations and the file owner as described in Note
113747.
On Thu, Apr 8, 2010 at 8:22 PM, Michael Hayden via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:
> Posted by Michael Hayden
> on Apr 8 at 10:57 AM
> when running an Oracle arhive job using BRTOOLS, we get the following
> error message: BR0006I Start of offline redo log processing: aecytqgf.sve
> 2010-04-08 14.50.01 BR0252E Function fopen() failed for
> '/oracle/NSD/saparch/aecyBR0477I Oracle pfil e
> /oracle/NSD/102_64/dbs/initNSD.ora created from spfile
> /oracle/NSD/102_64/dbs/ spfileNSD.ora I've checked permissions and
> ownerships and even compared the settings to another DB server where it is
> functioning and I'm lost as to why we are getting this message. Any help
> would be greatly appreciated! - Mike
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
In the Spotlight
_.____.__ Did this response help you resolve your issue? Click the green 'Mark as helpful' arrow to vote on the entry.