DB13 on distributed system ECC 6 EHP 4 Solaris - Oracle error

[Former Member]

Dear all,

I have a new ECC 6 EHP 4 ABAP only distributed system installation on Solaris 10- Oracle 10 platform. Kernel version 7.01.

Let call application/CI hostname = apphost

and DB Instance hostname = dbhost

I tried to set up DBA job (checkdb, update statistic, backup) via DB13, but its always end with error like this:

Can't exec external program (No such file or directory)

External program terminated with exit code 1.

RFC SAPXPG_DBDDEST_dbhost settings are like this:

Program : /sapmnt/KCP/exe/sapxpg

Target host: dbhost

Gateway host: apphost

Gateway service: sapgwxx

I have set rhosts on both server already.

Shell : sh

Looks like it cannot find executable program when try to do it remotely.

Please help..

Thanks

Fendhy

[markus_doehr2]

> Can't exec external program (No such file or directory)

> External program terminated with exit code 1.

> Shell : sh

Try to use

/bin/sh

as shell, not just "sh".

Any more information in the dev traces (dev_sapxpg)?

Markus

[Former Member]

Sorry, i mean the Shell is /bin/sh

I tried to follow this Note 1025707 - DBA Cockpit planning calendar and remote Oracle databases and tried to set up the scenario using rsh.

I copied all brtools files to home dir of <sid>adm on dbhost and tried again on DB13.

It can find the br*tools executables but now it show error :

BR0152E Environment variable ORACLE_SID is not set

So i got a clue for this error. I think since it was run on rsh, the environment variables weren't loaded for the rsh session.

Still searching to load this Environment variable on the rsh session.

Regards,

[Former Member]

I followed guidance on the note Note 1025707 - DBA Cockpit planning calendar and remote Oracle databases.

I changed shell to csh and force permanent environment variable on file .cshrc

Now, DB13 worked for checkdb and backup to disk.

Thanks & Regards,

Fendhy

[Former Member]

Please check the authorization of the br* tools.

Please check whether the OPS$ user is created correctly.

login to <sid>adm and call sqlplus /

if you get connected to the oracle , then OPS$ user is correctly setup.

if you receive error, your must the configuration of the OPS$ user.

You can refer to the note 361641

Also check for below notes which helps to resolve the problem:

134592: for sap dba role

12741: access authorizations