Oracle 8.1.7 Backup

There several possible files in question:
- rman script
- nsrnmo
- temp location on the Oracle box

nsrnmo will be executed as root if I remember correctly, while rman wille execute RMAN script as oracle user. Could not open can be due to:
- invalid path
- wrong permissions

So, I would start from checking the paths first. That make sure that rman script can be read by oracle user. For test run chmod +xr /path/to/rman/script. Also you can do +rx for nsrnmo. For tmp area for test do 777 (you can add sticky bit if you wish, but I think that is the default these days which is set by OS). If that will help that correct permissions one by one and you will soon trace where your problem was.

Is this RMAN script? Do you use nsrnmo? If yes having knowledge of how your backup command looks like and nsrnmo would be necessary. RMAN script I believe should be fine (as mannual backup seems to work).

Yep, using rman & nsrnmo for the backup; the only thing that bothers is that the process could not proceed, i believe, due to some restrictions for read/write and maybe ownership rights on a unix platform...

In the end, i've come to the conclusion that a few minor but important issues were preventing the backup from being run smoothly... First of all an oracle passwordfile needs to be created & 'remote_login_passwordfile=exclusive' entry in the initSID.ora file must be allowed for rman user to connect to the database & perform the backup; u might need to grant SYSDBA rights to the rman user as well... Only then u have the chance to invoke the backup from the server... Cheers...

And finally, u might also grant the rman binary with the appropriate rights & ownership...