There are a number of known causes of this issue. Most often the cause is configuration related. Refer to the details of known causes below:

1. tnsname.ora is not correctly configured. After finding a "HOST = " entry, avoracle searches for a line containing the SERVICE_NAME keyword. Until it finds this new keyword, all other entries, other "HOST = " entries are ignored. See example of incorrectly configured entry below:

My_DB =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = MyHost.com)(PORT = 1111))

)

(CONNECT_DATA =

(SID = My_DB)

)

)

2. If you are running 9i and 10 database on the same server you need separate tnsnames.ora file for each path.

3. avoracle browses $ORACLE_HOME/network/admin. By default, tnsnames.ora is not in this path and you will see this type of issue.

Fix

1. This issue can be resolved by adding SERVICE_NAME key word to the tnsname.ora file, e.g:

My_DB =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = MyHost.com)(PORT = 1111))

)

(CONNECT_DATA =

(SID = My_DB)

(SERVICE_NAME = My_DB)

)

)

2. Create a separate tnsnames.ora file.

3. Make sure tnsname.ora is in the $ORACLE_HOME/network/admin path.

Hi,

How do i check for RMAN backups status from the avamar Grid ? (under the scope of Backup and Restore rights).

Is the Activity report tab used for this,how can i differentiate that to a normal filesystem Backup.

what are the 1001 and 1002 plugins ?

We had the same issue and in our case the /etc/oratab file was missing from the oracle client machine,  we had to engage DBA team to have the file created which resolved the problem.