Unanswered: Data Protector , Sap Configuration Oracle Database
Hello , we are triyng to configure the Hp Data Protector for backing an instance of SAP, working with Oracle 92 database. In the Hp DataProtector SAP bakcup configuration window, we have to complete the user name , password and service name.
We are triyng to use SYS user, but then an error message appears :
ORA-28009: connection to sys should be as sysdba or sysoper
SP2-0640: Not connected.
If we add the text "as sysdba" after the password of SYS suser then the error don`t appears. However when the backup starts the BRTOOLS returns the followed errors:
BR051I BRBACKUP 6.20 (25)
BR154E Unexpected option value 'as' found at position 8
BR154E Unexpected option value 'sysdba' found at position 9
So, we can not use the SYS user.Somebody knows how we have to fill these fields?
yes, when connect with sql*plus I use this methode and works correctly with both users ( SYS and SYSTEM ).
But when we try to use this methode with DataProtector SAP Configuration, only the SYSTEM user seems to works ok , at last for backups ( maybe because the text "as sysdba" in not necessary ), but I'm not sure if this user has the enougth privileges to complete also the futures restores/recovers. So, we want to use SYS user.