WP dies ENV problem

[Former Member]

Hello all,

a backgroud process dies and its trace contains these:

C Got ORACLE_HOME=/oracle/BHT/920_64 from environment

C got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment

C <b>*** ERROR => OCI-call 'OCIEnvCreate' failed: rc = -1

[dboci.c 2281]</b>

C <b>*** ERROR => OCI-call 'OCIErrorGet' failed: rc = -2

[dboci.c 2081]</b>

B ***<b>LOG BY2=> sql error -1 performing CON [dbsh#3 @ 1204] [dbsh 1204 ]</b>

B ***<b>LOG BY0=> Cannot get Oracle error text.[dbsh#3 @ 1204] [dbsh 1204 ]</b>

B ***LOG BY2=> sql error -1 performing CON [dblink#3 @ 428] [dblink 0428 ]

B ***LOG BY0=> Cannot get Oracle error text. [dblink#3 @ 428] [dblink 0428 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1277]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9610]

M

M Info for wp 8

M

M stat = 4

M reqtype = 4

M act_reqtype = 4

M rq_info = 0

M tid = -1

M mode = 255

M len = 24

M rq_id = 47685

M rq_source = 2

M last_tid = 8

M last_mode = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]

M <b>*** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 252]</b>

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 8 27933) [dpuxtool.c 317]

Can somebody help?

[Former Member]

Hello all,

sorry for the delay but we had the similar issue on several system.

We could do these for solving the problem:

- SAP kernel refresh,

- Oracle upgrade from 9 to 10,

- upgrade the Oracle client.

I cannot say which one is the only one what can solve the problem becasue we did these steps in same time.

My opinion is the order is probably is the same as I wrote.

I hope it should help.

[former_member204746]

check Oracle parameters and increase SESSIONS and PROCESSES to a higher value.

[Former Member]

The situation worst than yesterday.

The system is an R/3 on Oracle 9.2.05, UNIX and it is an UNICODE system as you could see.

There are three background processes and yesterday only one was affected. After it lost the connection with the Oracle couldn't start again. Today all of them stopped so now there is not any BGD process. The traces report the same.

I chekced the mentioned Notes but everything is OK.

The connection between the R/3 and Oracle is OK, the listener has been restarted and it works properly.

[Former Member]

which client version do you use for this system? The Client Version is dependent on the SAP Kernel and it shouldn't be higher than the Oracle database version.

Are there other systems on the same host with different oracle and sap versions? Which SAP Kernel do you have?

If you have more systems with different SAP Kernels, see please this SAP Note:

<i><b><u>964783 - Updating Oracle client on host with multiple SAP systems</u></b></i>

Could you please post the results of the following commands (as <i><sid>adm</i> user under kernel directory)

<b><u>ldd dboraslib.so</u></b>

<b><u>ldd brconnect</u></b>

as <i><sid>adm</i> under /home/<sid>adm:

and the result of <b><u>R3trans -d</u></b>

[fidel_vales]

Hi,

a little more information would be helpfull.

<i>a backgroud process dies and its trace contains these:</i>

Is SAP workign fine and "suddenly" dies like that?

IS there anything BEFORE the mentioned error.it looks like it is trying to do a connection to the DB. Is it the first connection or the WP has died BEFORE and the reconnect fails?

Is there any error on the other WPs?

The error :

<b>C *** ERROR => OCI-call 'OCIEnvCreate' failed: rc = -1

[dboci.c 2281]

C *** ERROR => OCI-call 'OCIErrorGet' failed: rc = -2

[dboci.c 2081]

B ***LOG BY2=> sql error -1 performing CON [dbsh#3 @ 1204] [dbsh 1204 ]</b>

is related to the client, but it not normal that would happen ONLY on one WP.

What is your DB version ( 920? ), kernel version, client version and environment variables?

is this a CI or AS?

[Former Member]

Try to clear env variable NLS_LANG.

Regs,

FS

[Former Member]

Which system art do you have? Is it an UNICODE System, maybe XI, because of the following NLS_LANG set to UTF8?

<b><i>NLS_LANG='AMERICAN_AMERICA.UTF8'</i></b>

See please this SAP Note:<b><u> 606359</u></b> - FAQ: Oracle National Language Support (NLS)

Which Client version do you have?

How are your environment variables set? Check them please according to the SAP note: <b><u>602843</u></b> - Environment settings for R/3/Oracle on UNIX

Best regards

Baran