Data Protector 7 Integration with SAP

[Former Member]

Hi Guy,

       Can anyone help, I'm trying to integrate sap ecc6 to data protector 7 from the gui of hp unix 11i v3 . Below is the error , can someone advice??

Appreicate

Vince

[Former Member]

[Former Member]

Hi,

     The error is ORA-01031 : insufficient Privileges

                         SP2-0640: Not connected

                          sqlcode 1031

By the way, just curious have anyone tested integration with sap ecc6 on data protector 7.0. I understand ecc6 onwards the oramid user no longer in use is being replace by OPS$ORAMID . How can I configure this user to dp7.0 to integrate with sap ecc6

Regards

Vincent 

[former_member227150]

Hi Vince,

Use system user for Oracle Login.

and, for OS user - ora<sid>

Group Domain Name - dba

I think this will work in DP 7 as well.

Thanks

[former_member227150]

For Oracle Login user should have sysdba authorization.

Thanks

[Former Member]

Hi Kumar,

      Thanks for replying the email, attach is a few screen shot of dp7.0 config for your referrence?? Kindly help??

[Former Member]

Hi Kumar,

      Attach is the dba oramid account used by it give the following error.

[former_member227150]

Hi Vince,

Why are u entering OPS$ORAMID as DB User? I think sys or system (with sysdba privilege) will be the right choice there.

Thanks

[Former Member]

Hi Kumar,

     Attach is the requirement from sap for your referrence

REQUIREMENTS FOR BACKUPS USING RMAN

BRBACKUP and BRARCHIVE support backups using the Oracle Recovery Manager (RMAN). To perform database backups, RMAN requires SYSDBA privilege. To enable RMAN backups (for example, incremental backups) from the transaction DBACOCKPIT or DB13 (DBA Planning Calendar), the OS users <sid>adm (UNIX) and SAPSERVICE<SID> (Windows) must be entered in the corresponding operating system groups:

 

UNIX OS User	OS Group	DB Role	DB User
ora<sid>	dba     oper	SYSDBA     SYSOPER     SAPDBA	OPS$ORA<SID>
<sid>adm	dba     oper	SYSDBA     SYSOPER     SAPDBA	OPS$<SID>AD

As written on the table the syydba has already been replace by OPS$ORA<SID>, that why I'm using this account. Kindly advice??

Regards

Vincent

[former_member227150]

But recently we have configured SAP backups through HP Data Protector with the settings I have mentioned previously.

[Former Member]

Hi Kumar,

      I have try using the command to run util_sap.exe , but it still fail . Attach is the error from command line for your referrence?? Kindly advice??

Regards

Vincent

[Former Member]

Hi Vince,

Please check the OPS$ user configuration and read the notes, below;

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Note 361641 - Creating OPS$ users on UNIX

If I understand correctly, OPS$ORAMID exist at the OS level. Why did you created this user? Instead use the "ora<sid>" user.

Best regards,

Orkun Gedik

[Former Member]

Hi Orkun Gedik,

     Thanks for the reply, I don't have access to the link attach, how can I view the doc ?? Ussing my existing sap account it does not work ?? Please advice??

Regards

Vincent

[Former Member]

You can access the notes from SAP service marketplace https://service.sap.com/notes

Best regards,

Orkun Gedik

[former_member227150]

Hi Vince,

I'm not able to see the image. Please upload it again.

Thanks

[paul_power]

Hi Vince,

Unfortunately the error doesnt display and I cant download or view the jpg.

Could you specify exactly what error you are getting and copy the error fro the latest logs if there are any?

Regards,

Paul