Forum Discussion

jmgmad's avatar
jmgmad
Level 3
11 years ago

Backup Exec Oracle Agent Configuration

Hello, I´m with some doubts regarding which user I need to use in Backup Exec Oracle Agent Configuration. I need to perform a backup with this Symantec tool on an Oracle database but I´m facing th...
Backup and Recovery
Backup Exec
Windows Server (2003-2008)
  • VJware's avatar
    VJware
    11 years ago

    On the remote Oracle server, launch the Backup Exec Remote Agent Utility. There would be various tabs such as Status, Publishing, Database Access etc. (A screenshot of this utility was already posted by you)

    The screenshot which you have posted earlier is from the "Oracle" tab. Here the instance information and the user with SYSDBA rights is entered. (Preferably to use SYS account)

    On the same utility, there is a "Database Access" tab. Here is the OS account used to connect to the Oracle server.

    In other words, two types of accounts are used. The account used to connect to the DB under "Oracle" tab and the account used to connect to the server under "Database Access" tab.

jmgmad's avatar
jmgmad
Level 3
11 years ago

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