Unsolved
This post is more than 5 years old
1 Rookie
•
1 Message
0
3060
November 18th, 2011 09:00
Unable to browse Oracle Database on Avamar GUI
Hi,
I've installed an Avamar Oracle client for Linux on a RedHat server but I'm unable to browse the databases in order to create a dataset or to initiate on demand backup from GUI.
Avamar 5.x
Linux file client is register, I can start file backups.
From logs:
2011-11-18 16:16:56 avagent Info <7452>: Registration of client /clients/xxx with MCS avamarun:28001 successful.
2011-11-18 16:16:56 avagent Info <5928>: Registration of plugin 1001 Unix successful.
2011-11-18 16:16:56 avagent Info <5928>: Registration of plugin 1002 Oracle successful.
2011-11-18 16:16:56 avagent Info <5619>: Registration of client and plugins complete.
2011-11-18 16:49:56 avagent Info <8467>: Starting log file maintenance in "/usr/local/avamar/var" and "/usr/local/avamar/var/clientlogs"
2011-11-18 16:49:56 avagent Info <6675>: Log file maintenance complete, 0 file(s) removed
but if I want to create a dataset or to start a backup from the Avamar interface I'm unable to see any database.
In the GUI I can see:
Linux File System
Linux Oracle RMAN - but this one is empty
Backups started from RMAN using libobk_avamar64.so are ok.
Thank you for any suggestions !
5uR68oOE7d12317
48 Posts
0
January 5th, 2012 05:00
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.
pp082c
38 Posts
0
August 13th, 2014 02:00
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 ?
SHUBHAM-SHARMA
2 Posts
0
November 30th, 2022 22:00
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.