Skip to main content
12-Amethyst
April 15, 2011
Solved

Configuring BackupExec

  • April 15, 2011
  • 1 reply
  • 3723 views

Experts:

I have a customer installing Symantec BackupExec on his Windchill 9.1 Oracle database server. In the configuration, it is not accepting the oracle username/password. He has tried both the system account and Windchill dbUser account, and neither one works. I had him use sqlplus to confirm that he was using the correct password.

Which one is he supposed to be using, and does anyone have any tips to get this done? Obviously, I have not done this myself.

Also, BackupExec has a checkbox to use a Recovery Catalog. I assume this is something that a dba would set up and that it is not something that gets configured in an out of the box installation.

Much appreciation for any feedback,

Mark Plimley

PLM Implementor

Best answer by PatrickLee

Mike,

We don't user Oracle here at SNC, so I can't really help you out. However, I did stumble upon this walk through:

http://www.symantec.com/connect/forums/how-configure-backup-exec-oracle-agent-practical-step-step-instructions

You need to trouble shoot your connectivity between the application and Oracle. That's where I would start.

Do you have any monitoring tools that will help you in determining if Backup EXEC is even attempting to authenticate against the Oracle server? I know with MS SQL I can trace in real time who / what is attempting to authenticate. Is the windows firewall or anit-virus running on the server that is preventing a port from being accessed?

Good luck!

Patrick

1 reply

22-Sapphire I
April 15, 2011

1. Please have your DBA check:
tnsnames.ora and listener.ora files (They are in ORACLE_HOME/network/admin folder)
2. BackupExec uses Oracle RMAN to backup/recover your database.
You have 2 choices:
A. For Windchill environment and not many Oracle databases
If you do not check the "Recovery Catalog" then RMAN will write to Oracle controlfiles.
B. For big environment (i.e. many Oracle instances in your shop) and have dedicated DBA
Check the "Recovery Catalog" then RMAN will write to both controlfiles and catalog.
(Yes, you need to ask DBA to create Recovery Catalog for you. If you need help please let us know.

1-Visitor
April 15, 2011

Mike,

We don't user Oracle here at SNC, so I can't really help you out. However, I did stumble upon this walk through:

http://www.symantec.com/connect/forums/how-configure-backup-exec-oracle-agent-practical-step-step-instructions

You need to trouble shoot your connectivity between the application and Oracle. That's where I would start.

Do you have any monitoring tools that will help you in determining if Backup EXEC is even attempting to authenticate against the Oracle server? I know with MS SQL I can trace in real time who / what is attempting to authenticate. Is the windows firewall or anit-virus running on the server that is preventing a port from being accessed?

Good luck!

Patrick

22-Sapphire I
April 16, 2011

I forgot to mention that you need to use the 'sys' user for RMAN; 'system' cannot be used.