Skip to Content
-3

update statistics in distributed environment (oracle DB)

Mar 31, 2017 at 09:34 AM

113

avatar image
Former Member

Hello experts,

we are facing issues during update statistics in distributed environment(oracle DB).

CI running on other host & DB running of other.

Regards,

SAP BASIS

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member
Mar 31, 2017 at 03:54 PM
1

And what issues are those? ;)

Share
10 |10000 characters needed characters left characters exceeded
James Zhang
Apr 03, 2017 at 12:33 AM
0

Hi Vivek,

Better to give us the screenshot to understand this issue.

best regards,
James

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 27, 2017 at 05:39 AM
0

Hi,

If you are using DB13 to schedule the batch job to update Oracle database statistics, you need some additional configuration for brtools

First, the <sid>adm user from SAP application server should be able to ssh logon to Oracle database server as <sid>ora or oracle user without enter any password, you can configure ssh-key for this.

Second, there are some configuration needs to be done in the init<SID>.sap profile for brtools, for example

_remote_exec = ssh

_remote_copy = scp

Regards,

Michael

Share
10 |10000 characters needed characters left characters exceeded