Backup Exec Oracle Agent Configuration

Try adding the "SYS" account under Oracle tab. And under the Database Access tab, add the OS account (in the format domain/user). Add this same account (which is under Database Access tab) in the Backup Exec media server as well.

Grant Backup Exec Oracle Agent sufficient privileges to connect to and back up an Oracle Database, For this sufficient privilege refer below link

http://www.symantec.com/business/support/index?page=content&id=TECH82892

Hello VJware,

Thank you for you trying to help me. 

I don´t see any Oracle tab here, can you tell me where is the Oracle tab? Can you show me some printscreen of it in the Backup Exec.

Thank you,

jmgmad

Hello Mai Ali,

I read that article... and I continue with the same doubts! With this article I concluded that I need to use a Oracle database user and not an operation system user which is the user that I´m using in Symantec tool.

Regarding the oracle databse users I checked in Oracle SQL Plus and this are the oracle database users:

SQL> select username from dba_users;

USERNAME

------------------------------

OPS$SAPSERVICEPRD

OPS$PT\PRDADM

OPS$PT\SAPSERVICEPRD

OUTLN

OPS$PRDADM

SAPR3SHD

DBSNMP

SYSMAN

SAPR3

OPS$LISES1001\SAPSERVICEPRD

MGMT_VIEW

OPS$LISES1001\PRDADM

OPS$ORAPRD

SYS

SYSTEM

DIP

TSMSYS

So... which user I need to use? An oracle database user or an operation system user in the Symantec tool? Can you tell me please with some printscreens!?

Thank you,

jmgmad

Hello VJware,

Thank you, we will test that as you recommended, but before that let me tell you one thing.

Using the SQL Plus in this Oracle instance, when I try to log in with SYS user manually, it show me the following warning/error:

> sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Mon May 26 19:45:15 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

SQL> conn 

Enter user-name: SYS

Enter password: *******

Error:

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

I ask you, this is normal? I should not use the SYS user because probably will get an error or not?! Am I right?

Thank you,

Best regards,

jmgmad

You will need to use user that you created for backup. if you didn't have, you can use system account

and assign it for backup as exist in below screen

Hello Mai Ali,

But the SYSTEM user doesn´t has the sufficient privileges described in the following URL: http://www.symantec.com/docs/TECH82892

SQL> select grantee, privilege from DBA_SYS_PRIVS where grantee = 'SYSTEM' Union select grantee, GRANTED_ROLE from DBA_ROLE_PRIVS where grantee = 'SYSTEM';

GRANTEE                        PRIVILEGE

------------------------------ ----------------------------------------

SYSTEM                         AQ_ADMINISTRATOR_ROLE

SYSTEM                         CREATE MATERIALIZED VIEW

SYSTEM                         CREATE TABLE

SYSTEM                         DBA

SYSTEM                         GLOBAL QUERY REWRITE

SYSTEM                         SAPDBA

SYSTEM                         SELECT ANY TABLE

SYSTEM                         UNLIMITED TABLESPACE

8 rows selected.

Kind regards,

jmgmad

This isn't normal. If not SYS, you can use any other account which has sufficient privileges to connect to the instance and DB.

Hi Jmgmad,

Grant to it privilege as exist in above link and use it for backup.