| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN / NFS error - solved
My sys admin resolved the problem. It has to do with the permissions and
umasks. Normally on a Unix box, all that matters is the username. However,
NFS relies on the underlying uid to be the same. One of our systems has a
different uid for oracle, so the sys admin is trying to configure NFS to
handle that situation also. He created a separate Unix group named "rman" so
that all systems could write to these NFS directories. However, that group
inherits the umask from the Oracle username, which is RW for Oracle and R
for the group rman. By changing the group permission to RW he was able to
make the backup work. Now we are striving to create a permission scheme that
will work for all our systems. We are looking to try something with umask
and hope that will change the permission of the file that is created. Thanks
for the ideas.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, June 20, 2002 4:49 AM
To: Multiple recipients of list ORACLE-L
Hi Dennis,
I think Bruce meant user name (user id), but not the versions of source and destination OS's. AFAIK, different user starting RMAN should not cause permissions problem because file is created by rman process from oracle instance. So test with CREATE TABLESPACE should be sufficient. I would think that's possible NFS+Oracle problem indeed.
-- Alexandre ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, June 20, 2002 3:53 AMReceived on Thu Jun 20 2002 - 10:28:40 CDT
>
> Bruce - Good thought. However, both are Compaq Tru64, same version.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> [mailto:Bruce.Reardon_at_comalco.riotinto.com.au]
> Sent: Wednesday, June 19, 2002 8:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Dennis,
>
> What OS user does your RMAN run as compared to the OS user that your
Oracle
> instance runs under?
>
> Just a thought,
> Bruce Reardon
>
> -----Original Message-----
> Sent: Thursday, 20 June 2002 9:00
> To: Multiple recipients of list ORACLE-L
>
>
> I have been configuring RMAN to back up to disk on a Compaq Tru64, Oracle
> 8.1.6.
>
> I have my script running successfully. Then the sys admin configures an
> NFS-mounted drive on the target system and asks me to write to it instead.
> When I do, I receive the message:
>
> rMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03007: retryable error occurred during execution of command: backup
> RMAN-07004: unhandled exception during command execution on channel d1
> RMAN-10035: exception raised in RPC: ORA-19504: failed to create file
> "/rman/lpi
> p/df_t464975695_s3_p1"
> ORA-27040: skgfrcre: create error, unable to create file
> Compaq Tru64 UNIX Error: 13: Permission denied
> RMAN-10031: ORA-19624 occurred during call to
> DBMS_BACKUP_RESTORE.BACKUPPIECECRE
> ATE
>
> I recalled that CREATE TABLESPACE is a good criteria of whether RMAN can
> back up to a disk, so I tried that and was successful. I also at the
command
> line used touch to create the exact file RMAN was unable to. I searched
> Google and Metalink and found nothing that applied. I feel it has
something
> to do with the NFS setup since I can write to regular disk just fine. Are
> there any configuration gotchas with NFS? I'm out of ideas. Can anyone
give
> me a hint?
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Reardon, Bruce (CALBBAY)
> INET: Bruce.Reardon_at_comalco.riotinto.com.au
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: alexandre.gorbatchev_at_avermann.de Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |