Oracle backup problem: "Tar ... Permission denied".
- Article Type: General
- Product: Aleph
- Product Version: 16.02
Description:
If anyone can assist, our oracle backups are failing with a permission problem (see excerpt). The backups are setup in the Oracle crontab file:
Backup for Oracle logs started.
tar -cvf /dev/rmt/0cn /exlibris4/oradata/aleph1/arch/
Tar: /dev/rmt/0cn: Permission denied
I've limited experience working with Sun Solaris 10 - but see that the permissions on the /dev/rmt directory is: drwxr-xr-x, owner is root, sys is group ... I'm wondering if this is the problem?
Any assistance is appreciated. I submitted an incident to ExLibris but because ExLibris cannot remote in to our servers, they seem to be unable to assist.
Resolution:
From an ALEPH-NA DBA:
root-ownership with those flag settings means no other account (including an Oracle account) can write to the device.
If she can either chmod ugo+rw /dev/rmt/0cn to allow all users write-access, or run the backup as root, that should do it.
- Article last edited: 10/8/2013