Hi, I would want to script RMAN backup running from a Catalog Server using windows scheduled job which will backup target running in remote machine.
Is there a way I can connect to the target in remote machine without giving the password in the script?
Catalog server and target server are 184.108.40.206
Another way to secure sysdba connections is to use Oracle Internet Directory wich provides different authentication methods such as kerberos, ssl etc.
One more method. You can use Scheduler that will run backup job on remote database. You use CREATE_CREDENTIAL procedure to provide password and sysdba role for the job.
Edited by: Mihael on Jan 18, 2013 7:01 AM
Hi, I created the wallet with UserA and now I want to put a scheduled job with a service account UserB but am not able to access the wallet.
Its Windows 2008 and I have explicitly added the UserB as Full permission for the wallet file. The error message is below
ORA-12578: TNS:wallet open failed
Am pretty sure its a permission issue - but not sure how to provide the permission. UserB is in Admin Group, ORA_DBA Group, can log-in a batch job .........
Any pointer greatly appreciated.