Legato Can Not Connect To The Database

Today I was setting up a database backup using Legato, one of the most powerful backup tools. When aparantemente is well configured as shown in the following image;

fail_setup_legato

This error appears;

fail_setup_legato_2

It’s strange because accessing directly using sqlplus is no problem and connects. after investigating for a while I realized that I was possibly making a connection with sysdba or equivalent, in my case, giving permission to sysbackup was enough;

GRANT SYSBACKUP TO USERBACKUP;

You can see these permissions in the view v$pwfile_users.

 

HTH – Antonio NAVARRO

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s