Solved

Configuring Backup Exec Agente installed on a Linux machine to detect a ORACLE database,

Posted on 2010-11-21
8
763 Views
Last Modified: 2012-05-10
Hi Guys

The Situation

i got 22 servers, 5 of them are Linux machines with oracle installed on them, i bought backup exec agents so i can bakcup everything centralised, all agents installed ok no issues there, both machines LINUX and Widnows, did a backup run and the managment server sees all machines and can backup them up.

I now need to configure the agent to see the oracle database, i am doing this on a test server because of issues and well all other are in production and i dont want to mess with them.

What am i doing:

There is a script backup exec asks you to tun in order to configure the orcale access to the database and to detect the instances of oracle, it can detect all instances the problem starts when it ask me for the password and username for the oracle local system, i used the SYSDBA user and the root users both for linux and oracle, both keep telling me either the user-name is incorrect or is not part of the groups with access to the database, i confirm the groups and they are in the groups for sure.

Ideas

Well i guess my question is, is there a workaround for the agent to see the instance without having to use the script? been Linux i guess there must be a manual file somewhere i can edit to get past this annoyance.

Thanks for help,
0
Comment
Question by:mcgurupro1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 

Author Comment

by:mcgurupro1
ID: 34186267
Any Admin out there that can help me out getting some attention to this question?
0
 
LVL 16

Accepted Solution

by:
Richard Olutola earned 500 total points
ID: 34186927
Ensure that your oracle user that you supply is a member of the linux dba group. I don't know how how you've setup your installation.

If you've installed oracle with as the user 'oracle'. Then oracle user would have been a member of dba and oinstall linux groups. Also, ensure that you have a password file created on linux with orapwd and try again.

If you're struggling, then I'll suggest taking disk-disk backups with RMAN and simply using netbackup/backup exec to archive the backup files. Following this method does not rely on the agent detecting Oracle instance. It simply copies the offline backup files from disk to tape.

R.
0
 

Author Comment

by:mcgurupro1
ID: 34187780
R

Will check on this and come back to you, thanks for your time.

Regards
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 34187895
Does "it ask me for the password and username for the oracle local system" mean the OS password or the database password?

It it means the database password,  does it require an oracle account with SYSDBA privileges?

Generally non-oracle backup utilities require only the  OS password.

Otherwise if it's for a one time configuration purpose only, you may want to supply the SYS account and password.


0
 

Author Comment

by:mcgurupro1
ID: 34188186
Mike

Yes it would be the database password. An account with backup privileges only was created and added to the needed groups according to the Symantec step by step instructions.

We tried using the SYS account it did not work, it keeps telling me the account doe not have enough privileges or is not part fo the backup group.

Any other ideas?

Thanks for your time.
0
 
LVL 5

Expert Comment

by:Zopilote
ID: 34188534
you should log sys as sysdba
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 34189333
"An account with backup privileges only was created and added to the needed groups according to the Symantec step by step instructions."

If it's not working, open service request with Symantec.
Good luck!
0
 

Author Closing Comment

by:mcgurupro1
ID: 34285504
Somehow the Oracle user had something wrong... thanks for the tip. The client is now happy, sorry for the delay in awarding the points
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question