Skip to Content
avatar image
-3
Former Member

update statistics in distributed environment (oracle DB)

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

    And what issues are those? ;)

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 03, 2017 at 12:33 AM

    Hi Vivek,

    Better to give us the screenshot to understand this issue.

    best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2017 at 05:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded