DB13 - Error during the execution of some database activities

[Former Member]

Hello,

This is a SAP distributed system with three hosts: Central Instance (liszgpsap003); Dialog Instance (liszgpsap004) and the Database in host LISZGPORA001.

I installed a SAP Gateway in database host and now the RFC SAPXPG_DBDEST_LISZGPORA001 (SAPXPG_DBDEST_<DB-HOST>) is working but when I schedule in DB13, for instance, the "Check and update optimizer statistics" or "Check DB" it show me the following information:

Job started

Step 001 started (program RSDBAJOB, variant &0000000000024, user ID ADMINSAP)

Execução do comando lógico BRCONNECT No host liszgpora001

Parâmetros: -jid STATS20131020181756 -u / -c -f stats -t ALL

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

External program terminated with exit code 1

BRCONNECT returned error status E

Job finished

The RFC SAPXPG_DBDEST_LISZGPORA001 is configured like this (the LISZGPORA001 is the DB host) and as I said above, the connection is working without problems:

Any tips? Can you help me to understand what is the problem and how can I solve this error?!

Best regards,

samid

[Former Member]

Samid,

what is OS for SAP? I assume that this is Windows by looks at your problem. If this is the case - sync both systems with the same password and similar, there are plenty of discussions like that.

Regards

M.

[Former Member]

Hello Miroslaw,

I said "All the hosts are Solaris OS" --> Solaris (Unix) is the operation system!

Thank you,

samid

[Former Member]

Dear Samid,

1.Please check the  "sapxpg" executable is present in kernel dir  or not

2. if yes,check the permission

3.Checkthis parameter SAPDBHOST is set properly

4.Check orasid env variable

5. execute sapdba_role.sql script and try again

Regards

sashi

[Former Member]

Hello sashi,

1.Please check the  "sapxpg" executable is present in kernel dir  or not
2. if yes,check the permission

As I answered to Reagan, yes, the sapxpg file is in that location with the following permissions:

liszgpora001# ls -la /usr/sap/AZP/SYS/exe/uc/sun_64/sapxpg

-rwxr-xr-x   1 azpadm   sapsys   7240680 Jan 16  2013 /usr/sap/AZP/SYS/exe/uc/sun_64/sapxpg

3.Checkthis parameter SAPDBHOST is set properly

It´s OK. The SAPDBHOST parameter has the value of DB host (liszgpora001)

4.Check orasid env variable

env (oraazp):

liszgpora001:oraazp 1% env

HOME=/oracle/AZP

PATH=/oracle/AZP/112_64/bin:/usr/bin:.:/usr/sap/AZP/SYS/exe/uc/sun_64:/usr/sap/AZP/SYS/exe/run:/oracle/AZP:/usr/ccs/bin:/usr/ucb

LOGNAME=oraazp

HZ=

TERM=xterm

SHELL=/bin/csh

MAIL=/var/mail/oraazp

TZ=Europe/Lisbon

PWD=/oracle/AZP

USER=oraazp

SAPSYSTEMNAME=AZP

DIR_LIBRARY=/usr/sap/AZP/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/AZP/SYS/exe/run:/usr/sap/AZP/SYS/exe/uc/sun_64:/oracle/AZP/112_64/lib

SAPEXE=/usr/sap/AZP/SYS/exe/run

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=AZP

dbs_ora_schema=SAPSR3

ORACLE_SID=AZP

DB_SID=AZP

ORACLE_BASE=/oracle

ORACLE_HOME=/oracle/AZP/112_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/AZP/sapdata

NB_ORA_CLIENT=liszgpora001.bk.ptlocal

NB_ORA_POLICY=ZAGOPE_liszgpora001_SAP_full

NB_ORA_SERVER=bckpicmst01.bk.ptlocal

5. execute sapdba_role.sql script and try again

Where I can find that sapdba_role.sql script? I believe is in sap note 134592 - Importing the SAPDBA role (sapdba_role.sql), am I right?

Thank you,

samid

[former_member186066]

Pls check and if applicable do the following:

• Copied sapxpg to /sapmnt/<GATEWAY SID>/exe  

• chown <SAP systemSID>adm:sapsys sapxpg
• copy BRTOOLS under /sapmnt/<GATEWAY SID>exe
• Check and change the permissions of BRTOOLS(brbackup,brarchive, brconnect,brtools,brrecover,brspace)
• Ensure s-bit permission is on brarchive,brabckup,brconect
• Copy the environment variables of DBenv (3 csh) files  .dbenv.csh ,.dbenv_<db hostname>.csh, to home of GATEWAY SID
• Edit the .cshrc file of gateway SID with setenv ORACLE_HOME /oracle/<SAP System ID>112_64
• Check if s-bit is enabled on /oracle/<SAP SYSTEM SID>/112_64/bin/oracle
• Login to SQLPLUS and execute the below commands:

create user OPS$GWTADM identified externally;

grant connect, resource to OPS$GWTADM;

grant dba, sapdba to ops$gwtadm;

CREATE TABLE "OPS$<GATEWAY SID>ADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));

INSERT INTO "OPS$<GATEWAY SID>ADM".SAPUSER VALUES ('SAPSR3','<password>');

• Assign dba and oper group to <GATEWAY SID>adm

[Reagan]

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

The system cannot execute the sapxpg program.

Is the sapxpg file present in this location.

ls -la /usr/sap/AZP/SYS/exe/uc/sun_64/sapxpg

Check the environment variables for the oraazp and azpadm users.

Regards

RB

[Former Member]

Hello Reagan,

Yes the sapxpg file is in that location:

liszgpora001# ls -la /usr/sap/AZP/SYS/exe/uc/sun_64/sapxpg

-rwxr-xr-x   1 azpadm   sapsys   7240680 Jan 16  2013 /usr/sap/AZP/SYS/exe/uc/sun_64/sapxpg

Regarding the environment variables for the oraazp and azpadm users... I checked and I will paste it here:

env (oraazp):

liszgpora001:oraazp 1% env

HOME=/oracle/AZP

PATH=/oracle/AZP/112_64/bin:/usr/bin:.:/usr/sap/AZP/SYS/exe/uc/sun_64:/usr/sap/AZP/SYS/exe/run:/oracle/AZP:/usr/ccs/bin:/usr/ucb

LOGNAME=oraazp

HZ=

TERM=xterm

SHELL=/bin/csh

MAIL=/var/mail/oraazp

TZ=Europe/Lisbon

PWD=/oracle/AZP

USER=oraazp

SAPSYSTEMNAME=AZP

DIR_LIBRARY=/usr/sap/AZP/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/AZP/SYS/exe/run:/usr/sap/AZP/SYS/exe/uc/sun_64:/oracle/AZP/112_64/lib

SAPEXE=/usr/sap/AZP/SYS/exe/run

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=AZP

dbs_ora_schema=SAPSR3

ORACLE_SID=AZP

DB_SID=AZP

ORACLE_BASE=/oracle

ORACLE_HOME=/oracle/AZP/112_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/AZP/sapdata

NB_ORA_CLIENT=liszgpora001.bk.ptlocal

NB_ORA_POLICY=ZAGOPE_liszgpora001_SAP_full

NB_ORA_SERVER=bckpicmst01.bk.ptlocal

env (azpadm):

liszgpora001:azpadm 1% env

HOME=/export/home/azpadm

PATH=/oracle/AZP/112_64/bin:/usr/j2se/bin:/usr/bin:.:/usr/sap/AZP/SYS/exe/uc/sun_64:/usr/sap/AZP/SYS/exe/run:/export/home/azpadm:/usr/ccs/bin:/usr/ucb

LOGNAME=azpadm

HZ=

TERM=xterm

SHELL=/bin/csh

MAIL=/var/mail/azpadm

TZ=Europe/Lisbon

PWD=/export/home/azpadm

USER=azpadm

SAPSYSTEMNAME=AZP

DIR_LIBRARY=/usr/sap/AZP/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/AZP/SYS/exe/run:/usr/sap/AZP/SYS/exe/uc/sun_64:/oracle/client/10x_64/instantclient

JAVA_HOME=/usr/j2se

SAPEXE=/usr/sap/AZP/SYS/exe/run

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=AZP

dbs_ora_schema=SAPSR3

ORACLE_SID=AZP

DB_SID=AZP

ORACLE_BASE=/oracle

TNS_ADMIN=/sapmnt/AZP/profile/oracle

ORACLE_HOME=/oracle/AZP/112_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/AZP/sapdata

Any tips?

Kind regards,

samid

[Former Member]

Hi,

I think you have mention it in SM69 under operating system command  like  cmd /c taskkill /f /im iexplore.exe and the remove additional_parameters = '/c'  and check it.

BR,

Prabhakar

[Former Member]

Hi,

The solution to my problem is that the operating system command setup is wrong in SM69. Go check that.

BR,

Prabhakar

[Former Member]

Hello Prabhakar,

In SM69... what I must do to check that?! Can you guide me please?

kind regards,

samid

[Former Member]

Hi Samid,

Somtime back i faced the exact issue.

Can you check the action log as well to get the detailed error?

I will check the solution in parallel as well.

Regards,

Raja. G

[Former Member]

Hello Raja,

Which action log? Where is that action log, can you tell me please?

And... you remember how you solved the situation?

Thank you

samid

[Former Member]

Hi Samid,

Still am not able to recollect.

However in the RFC can you replace the DB hostname as CI hostname and remove the values in the gateway details and check.

Regards,

Raja. G

[Former Member]

Hi,

In the RFC what happens when you remove the path before the program sapxpg.

If it fails then i think some thing is not correct.

You need to revisit the below two notes.

If you want to see the exact error in DB13 then you can activate the trace an see exactly what is happening.

1780001 - How to increase the trace level for the br*tools jobs which are scheduled in DB13

Other Notes.

Note 657999 - Installing a Standalone Gateway in an MSCS Environment

1764650 - How to install a standalone gateway in a Microsoft Failover Cluster for Oracle

Note 1025707 - DBA Cockpit: Planning calendar and remote Oracle databases

Thanks

Rishi Abrol

[Former Member]

Hello Rishi,

All the hosts are Solaris OS.

I change the RFC, I change the field Program and I put only sapxpg

Connection Error

Error when opening an RFC connection (CPIC-CALL: 'ThSAPOCMINIT' : cmRc=1 thRc=66

ERROR: Execução de um programa (exec.) falhou

LOCATION: SAP-Server liszgpsap003_AZP_00 on host liszgpsap003 (wp 4)

COMPONENT: CPIC

COUNTER: 40

MODULE:

LINE:

RETURN CODE: 667

SUBRC: 0

RELEASE: 720

TIME: Mon Oct 21 14:16:39 2013

VERSION:

regards,

samid

[Former Member]

Hi,

I think that you change the server also. Reason why i asked you to change the full patch was ,RFC was able to read the file as you mentioned the full path but when you remove it its not able to get the exact path this means some thing is not correct with the env and that is happening with BRtool .

Did you try to run the trace and see what comes.

Thanks

Rishi abrol

[Former Member]

Dear Samid,

Please go through this note, it might helps you on resolving the issue.

Note 446172 .

And

1.Download the latest sapxpg

2.check Brconnect

3.check BR* permission and kernel also

4.run sapdba_role.sql

5.check the hostname entries

Regards

sashi