Solved

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

Posted on 2010-11-21
8
760 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
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
 
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
Save on storage to protect fatherhood memories

You're the dad who has everything. This Father's Day, make sure your family memories are protected. My Passport Ultra has automatic backup and password protection to keep your cherished photos and videos safe. With up to 3TB, you have plenty of room to hold the adventures ahead.

 

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
NTBack up cannot recover data 2 58
Restore Server 2012 R2 Registry 4 53
Centos 6.4 ModSecurity: Output filter: Content-Length Error 2 41
help on oracle query 5 30
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

947 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now