on 07-26-2010 6:06 PM
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
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.