I gather the be ser vice account has full access to the Oracle instance, have a look at the published documentation, I'm sure there is a best practices for Oracle.

Yes, but I have tried to use all Oralce acccount (some with full access right), it's still failed.

In meantime, can give me the path for the published documentation. because I tried to look for it for many times, not found ...

Thanks !

Here you are Patrick

http://support.veritas.com/docs/285758

Good luck

NO Luck...


At Oracle server

Instand User name Recovery Catalog Media Server Job Template
----------------------------------------------------------------------------------------------------------------------
DB1 Backup No Default
DB2 Backup No Default

I tried to type the password in there, but the Oracle agent prompted the message " This user account does not have the privileges that are required to log on the Oracle database." What's I missed ?


At media server, "Resouce not found" message for one of previous database backup job by Resource Credentials testing?

Resource Logon Account Test Results
---------------------------------------------------------------------------------------------
BKServer domain\user1 Successful
Oracle Database "DB1" Backup Resource not found
Oracle Database "DB2" Backup Resource not found

Its been a while since I had to backup oracle databases with an agent, in the past I have had the database backed up using oracle and backed up the flat file, in additition I have stopped the oracle instance so that the backup software is just backing up the directories. Users just had to be aware of the backup window and live with it.

The agent should at least have sys admin rights rights to the instance and probable dbo access to the database. Are there any oracle experts out there?

The oracle server will have a backup exec service running on it and that should be using the same logon as the media server.

Even, I do and check more, it's still failed...


How to create an Oracle account and verify the permissions assigned for the Backup Exec Agent for Oracle
http://seer.entsupport.symantec.com/docs/230036.htm

How to use Oracle DBA Studio to create an Oracle account with the correct permissions for use with the Backup Exec Oracle Agent
http://seer.entsupport.symantec.com/docs/247341.htm

On the Oracle server, run the Oracle command "sqlplus /nolog". Then run "connect dbuser/dbpassword as sysdba" (substituting the Oracle user name and password you were specifying in the Backup Exec Remote Agent Utility on the Oracle tab for dbuser and dbpassword). Were you able to connect?

Did you ever get this figured out?

This is a really similar error to what I have. I have no idea.

I am having the same problem. I cannot connect with sys, system or the account created using the Symantec website recommended credentials. Any new suggestions?

I should also note that I could connect using sqlplus /nolog and then running "connect dbuser/dbpassword as sysdba" However, I still cannot connect using the Oracle Agent. I still get "This user account does not have the privileges that are required to log on the Oracle database."

Is the service account that BE uses on the oracle server the same account that the serv ice account on the media servier uses? Is that the account that the backu credentials use, and does that account have sysadmin access to the oracle instance

Yes, they are the same account. This is not the same account used to connect to the Oracle instance however. I assume you mean sysdba access to Oracle and yes the account does have sysdba access. Thank you.

Hi!

I had the same problem on my Oracle databases.
Finnaly, I found thet I have to enter the following in the sqlnet.ora file:

SQLNET.AUTHENTICATION_SERVICE = (NTS)

This will enable the authentication againt the database.

B�rge :-)

This didn't work for me.

I want to think I have followed the instructions line by line but now I really don't know. I've done this multiple times and still nothing. I have followed the manual and some web instructions.

But, what is in your SQLNET.ORA file then?

Borge :-)

NAMES.DIRECTORY_PATH=(EZCONNECT,TNSNAMES)
SQLNET.AUTHENTICATION_SERVICE = (NTS)


Just for kicks, I changed it to NONE and of course that didn't work either.

What all is in your sqlnet.ora file?

What does NTS mean?

//edit: Ok so I differ a little bit because I'm on Linux. NTS is for Windows. Also, SERVICE above should be SERVICES.Message was edited by:
David Lohry

My SQLNET.ORA file also contains,

NAMES.DIRECTORY_PATH=(EZCONNECT,TNSNAMES)
SQLNET.AUTHENTICATION_SERVICE = (NTS)

and I can now connect with sys but no other Oracle account (not even the one that was created using the BE admin manual and website (of course that was for BE 10)). This account worked in BE 10 but fails in 11d. I would prefer to not use the sys account. I would be interested if anyone knew what 11d used as requirments to backup a database.

But now if I try to select the database in a backup list I get the following error,

Failed to access Oracle Database "dbname' Cannot start an Oracle session. Check that the logon credentials are correct, and have sufficient privileges.

The user has administrator privileges, I have tried adding and removing the user from the ORA_DBA group but with no luck.

Okay, the BE 11d admin guide says

"When you use the Remote Agent Utility to enter Oracle credentials for an instance, the user account with which you are logged in cannot be a member of the Oracle DBA group. If the user account is a member of the Oracle DBA group, the credentials cannot be verified"

and this is what I was doing. However, as a desperate attempt I added the account which I use to log in, to the Oracle DBA group and all of a sudden I can now select my database without error. The job is running and I will have to wait and see if it completes without error. I still had to use sys to login (which I don't like, but one thing at a time). If anybody has any ideas why the above worked or what credentials are needed in Oracle to log on without using sys I would be happy to hear them. I will keep investigating and let you know what I find.

I'm glad that worked for you.

I have tried both for the dba group (adding the users and removing the users per instructions) and nothing works.