cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Failover not working on secondary node

0 Kudos

Hi All

We have configured HA of SAP on DB2: ASCS,CI and SCS is running on primary node with HACMP clustering installed with virtual hostname,and just running DB2 client on secondary node.

Now we are receiving following error while switching over manually on the secondary node:

Starting SAP-Collector Daemon

-


21:34:58 26.07.2010 LOG: Effective User Id is root

***********************************************************************

  • This is Saposcol Version COLL 20.94 700 - AIX v10.35 5L-64 bit 070123

  • Usage: saposcol -l: Start OS Collector

  • saposcol -k: Stop OS Collector

  • saposcol -d: OS Collector Dialog Mode

  • saposcol -s: OS Collector Status

  • The OS Collector (PID 233504) is already running .....

************************************************************************

saposcol already running

Running /usr/sap/BP1/SYS/exe/run/startdb

DB startup failed

Below is the output of R3trans -d

This is R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

unicode enabled version

2EETW169 no connect possible: "environment variable dbms_type is not set."

R3trans finished (0012).

And the output of tran.log is as follows:

4 ETW000 R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 26.07.2010 - 21:35:52

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Jul 26 21:35:52 2010

51 0.000051

4 ETW000 [dev trc ,00000] db_con_init called

20 0.000071

4 ETW000 [dev trc ,00000] create_con (con_name=R/3)

33 0.000104

*4 ETW000 [dbcon.c ,00000] *** ERROR => Invalid profile parameter dbms/type*

(or environment variable dbms_type) = <undef>, cannot load DB library

4 ETW000

52 0.000156

2EETW169 no connect possible: "environment variable dbms_type is not set."

Kindly let us know how to go about in resolving this issue.

Thanks in Advance

Hemant

Accepted Solutions (0)

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
0 Kudos

> Now we are receiving following error while switching over manually on the secondary node:

> 2EETW169 no connect possible: "environment variable dbms_type is not set."

The user <sid>adm lacks the proper environment. Is this environment variable set on both nodes?

Markus

0 Kudos

Hi Markus

Thank you very much for your reply.

We have set the environment for the user <sid>adm on the secondary node by ourself,however on the primary node SAP had created and set the enviroments, we have just created the user and copied the enviroments from primary node.

Regards

Hemant