Error in DB13

[Former Member]

Hello,

We are getting errors in DB13 for CheckDB and Update Stat activity. We have Redhat Cluster.

Oracle_home is defined on node2. SAPDB is virtual Hostname.

Logs are below.

30.01.2012 02:00:36 Job started

30.01.2012 02:00:37 Step 001 started (program RSDBAJOB, variant &0000000000026, user ID OSIBASIS1)

30.01.2012 02:00:37 Execute logical command BRCONNECT On host SAPDB

30.01.2012 02:00:37 Parameters: -u / -jid CHECK20111215020000 -c -f check

30.01.2012 02:00:37 BR0801I BRCONNECT 7.00 (40)

30.01.2012 02:00:37 BR0152E Environment variable ORACLE_HOME is not set

30.01.2012 02:00:37

30.01.2012 02:00:37 BR0806I End of BRCONNECT processing: cehtuaqv.log2012-01-30 02.00.37

30.01.2012 02:00:37 BR0280I BRCONNECT time stamp: 2012-01-30 02.00.37

30.01.2012 02:00:37 BR0804I BRCONNECT terminated with errors

30.01.2012 02:00:37 External program terminated with exit code 3

30.01.2012 02:00:37 BRCONNECT returned error status E

30.01.2012 02:00:37 Job finished

From node2 the RFC SAPXPG_DBDEST_SAPDB is working fine

From node1 the RFC SAPXPG_DBDEST_SAPDB gives the following below error.

Logon Connection Error

Error Details Error when opening an RFC connection

Error Details ERROR: timeout during allocate

Error Details LOCATION: SAP-Gateway on host SPLECCPRDN1.squaregroup.com / sapgw02

Error Details DETAIL: no connect of TP sapxpg from host SAPDB.squaregroup.com after 20 sec

Error Details COMPONENT: SAP-Gateway

Error Details COUNTER: 31929

Error Details MODULE: gwr3cpic.c

Error Details LINE: 2066

Error Details RETURN CODE: 242

Error Details SUBRC: 0

Error Details RELEASE: 701

Error Details TIME: Mon Jan 30 18:29:19 2012

Error Details VERSION: 2

Please advice how to proceed.

Regards

Abhishek

[Former Member]

Hi Abhishek,

>> From node2 the RFC SAPXPG_DBDEST_SAPDB is working fine

>> From node1 the RFC SAPXPG_DBDEST_SAPDB gives the following below error.

Firstly, check you set the "gateway options" on SM59 -> TCP/IP Connection -> SAPXPG_DBDEST_SAPDB.

Secondly, the firewall configuration between the hosts. TCP 33xx should be available.

@Deepak: Gateway is available at the standard installation, already. Don't need to install an additional gateway instance.

Best regards,

Orkun Gedik

[Former Member]

Hello,

In Sm59-> RFC SAPXPG_DBDEST_SAPDB->startup type for ext program> default gateway value>Under gateway Option--Blank.My doubt is since these are auto generated so do we need to specfically give the values for gateway like gateway host and gateway service.

There is no firewall between the hosts.

Regards

Abhishek

Edited by: abhishek sharma on Jan 30, 2012 3:52 PM

[Former Member]

Hello,

Now the RFC is working.

But we are still getting the error in DB13 for checkDb with status Scheduling failed.

30.01.2012 18:12:42 Job started

30.01.2012 18:12:42 Step 001 started (program RSDBAJOB, variant &0000000000050, user ID OSIBASIS1)

30.01.2012 18:12:42 Execute logical command BRCONNECT On host SAPDB

30.01.2012 18:12:42 Parameters: -u / -jid CHECK20120130181242 -c -f check

30.01.2012 18:12:42 BR0801I BRCONNECT 7.00 (40)

30.01.2012 18:12:42 BR0152E Environment variable ORACLE_HOME is not set

30.01.2012 18:12:42

30.01.2012 18:12:42 BR0806I End of BRCONNECT processing: cehtxiyc.log2012-01-30 18.12.42

30.01.2012 18:12:42 BR0280I BRCONNECT time stamp: 2012-01-30 18.12.42

30.01.2012 18:12:42 BR0804I BRCONNECT terminated with errors

30.01.2012 18:12:42 External program terminated with exit code 3

30.01.2012 18:12:42 BRCONNECT returned error status E

30.01.2012 18:12:42 Job finished

Please advise how to proceed.

Regards

Abhishek

[former_member188883]

Hi Abhishek,

Could you set the parameter ORACLE_HOME with relevant path for eg /oracle/<SID>/102_64

in the envionment of user <sid>adm.

Regards,

Deepak Kori

[Former Member]

Hello,

We have two nodes SPLECCPRDN1 and SPLECCPRDN2.

For user SID<adm> we have environment oracle_home defined on node 2.

Should we define Oracle_home on SPLECCPRDN1 as well.

Regards

Abhishek

[Former Member]

Hello,
> We have two nodes SPLECCPRDN1 and SPLECCPRDN2.
> For user SID<adm>  we have environment oracle_home defined on node 2.
> Should we define Oracle_home on SPLECCPRDN1 as well.
> 
> Regards
> Abhishek

Yes, you should define not only ORACLE_HOME, but also the other environment variables on both nodes.

Best regards,

Orkun Gedik

[former_member188883]

Hi Abhishek,

you need to install SAP gateway on node 2 and specify the gateway host details in the SAPXPG_DBDEST_SAPDB RFC destination.

Regards,

Deepak Kori