cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-03106: fatal two-task communication protocol

Former Member
0 Kudos

Hi,

I am getting this error with the short dump(in ST22) DBIF_SETG_SQL_ERROR.

The details of the dump is also given.

Please help.

Runtime Error DBIF_SETG_SQL_ERROR

Occurred on 12.08.2008 at 08:30:37

-

-


SQL error occurred in the database when accessing a table.

-

-


What happened?

-

-


-

-


What can you do?

-

-


Make a note of the actions and input which caused the error.

To resolve the problem, contact your SAP system administrator.

You can use transaction ST22 (ABAP Dump Analysis) to view and administer

termination messages, especially those beyond their normal deletion

date.

-

-


Error analysis

-

-


-

-


How to correct the error

-

-


Database error text........: "ORA-03106: fatal two-task communication protocol

error"

Internal call code.........: "[SETG/GET /VBDATA ]"

Please check the entries in the system log (Transaction SM21).

You may able to find an interim solution to the problem

in the SAP note system. If you have access to the note system yourself,

use the following search criteria:

-

-


"DBIF_SETG_SQL_ERROR" C

"SAPLSEUAX" or "LSEUAXV01"

"RS_NEW_PROGRAM_INDEX"

-

-


If you cannot solve the problem yourself, please send the

following documents to SAP:

1. A hard copy print describing the problem.

To obtain this, select the "Print" function on the current screen.

-

2. A suitable hardcopy prinout of the system log.

To obtain this, call the system log with Transaction SM21

and select the "Print" function to print out the relevant

part.

3. If the programs are your own programs or modified SAP programs,

supply the source code.

To do this, you can either use the "PRINT" command in the editor or

print the programs using the report RSINCL00.

4. Details regarding the conditions under which the error occurred

or which actions and input led to the error.

-

-


System environment

-

-


SAP Release.............. "620"

Application server....... "awnts151"

Network address.......... "192.168.10.33"

Operating system......... "Windows NT"

Release.................. "5.2"

Hardware type............ "8x Intel 80686"

Character length......... 8 Bits

Pointer length........... 32 Bits

Work process number...... 10

Short dump setting....... "full"

Database server.......... "AWNTS151"

Database type............ "ORACLE"

Database name............ "DEE"

Database owner........... "SAPR3"

Character set............ "English_United State"

SAP kernel............... "640"

Created on............... "Jun 23 2008 21:48:04"

Created in............... "NT 5.0 2195 Service Pack 4 x86 MS VC++ 13.10"

Database version......... "OCI_920_SHARE "

Patch level.............. "239"

Patch text............... " "

Supported environment....

Database................. "ORACLE 9.2.0.., ORACLE 10.1.0.., ORACLE

10.2.0.."

SAP database version..... "640"

Operating system......... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2,

Windows NT 6.0"

-

-


User, transaction...

-

-


Client.............. 999

User................ "AIL_DEV"

Language key........ "E"

Transaction......... "SE38 "

Program............. "SAPLSEUAX"

Screen.............. "RSM13000 3000"

Screen line......... 2

-

-


Information on where terminated

-

-


The termination occurred in the ABAP program "SAPLSEUAX" in

"RS_NEW_PROGRAM_INDEX".

The main program was "RSM13000 ".

The termination occurred in line 27 of the source code of the (Include)

program "LSEUAXV01"

of the source code of program "LSEUAXV01" (when calling the editor 270).

The program "SAPLSEUAX" was started in the update system.

-

-


Source code extract

-

-


000010 *******************************************************************

000020 * THIS FILE IS GENERATED BY THE FUNCTION LIBRARY. *

000030 * NEVER CHANGE IT MANUALLY, PLEASE! *

000040 *******************************************************************

000050 FORM RS_NEW_PROGRAM_INDEX USING %_KEY.

000060 * Parameter declaration

000070 DATA %_P0000000001 TYPE

000080 PROGRAM

000090 .

000100 DATA %_P0000000002 TYPE

000110 PROGRAM

000120 .

000130 DATA: %_STATE.

000140 * Assign default values

000150 * Get mode for update task

000160 CALL 'GET_SWITCH_UTASK'

000170 ID 'MODE' FIELD 'S'

000180 ID 'STATE' FIELD %_STATE.

000190 IF %_STATE EQ 'N'.

000200 * Import from memory

000210 IMPORT

000220 P_NAME TO %_P0000000001

000230 P_INCLUDE TO %_P0000000002

000240 FROM MEMORY ID %_KEY.

000250 ELSE.

000260 * Import from logfile

-

-


IMPORT

000280 P_NAME TO %_P0000000001

000290 P_INCLUDE TO %_P0000000002

000300 FROM LOGFILE ID %_KEY.

000310 ENDIF.

000320 * Call update task

000330 CALL FUNCTION 'RS_NEW_PROGRAM_INDEX'

000340 EXPORTING

000350 P_NAME = %_P0000000001

000360 P_INCLUDE = %_P0000000002

000370 .

000380 ENDFORM.

-

-


Contents of system fields

-

-


SY field contents..................... SY field contents.....................

-

-


-

-


-

-


-

-


SY-SUBRC 0 SY-INDEX 0

SY-TABIX 1 SY-DBCNT 1

SY-FDPOS 0 SY-LSIND 0

SY-PAGNO 0 SY-LINNO 1

SY-COLNO 1 SY-PFKEY

SY-UCOMM SY-TITLE Update control

SY-MSGTY SY-MSGID

SY-MSGNO 000 SY-MSGV1

SY-MSGV2 SY-MSGV3

SY-MSGV4

-

-


Active calls / events

-

-


No.... Type........ Name..........................

Program

Include Line

Class

-

-


5 FORM RS_NEW_PROGRAM_INDEX

SAPLSEUAX

LSEUAXV01 27

4 FORM VB_CALL_FUNC

RSM13000

RSM13000 5441

3 FORM VB_V1_EXEC

RSM13000

RSM13000 5182

2 FORM VB_V1_NORMAL

RSM13000

RSM13000 3944

1 MODULE (PBO) VBEXEC

RSM13000

RSM13000 3793

-

-


Chosen variables

-

-


-

-


5 FORM RS_NEW_PROGRAM_INDEX

SAPLSEUAX

LSEUAXV01 27

-

-


%_DUMMY$$

2222

0000

%_STATE Y

5

9

RSJOBINFO 00000000

2222222222222222222222222222222233333333

0000000000000000000000000000000000000000

... + 40 000000

3333332222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 80 ####

0000

0000

%_KEY 2CF93538B4E949608CAEF68FCB839DA0####

344333334343333334444334443334430000

236935382459496083156686328394101000

SY-SUBRC 0

0000

0000

SYST-REPID SAPLSEUAX

5454545452222222222222222222222222222222

310C355180000000000000000000000000000000

%_P0000000001

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

%_P0000000002

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

%_VIASELSCR #

0

4

SY-REPID SAPLSEUAX

5454545452222222222222222222222222222222

310C355180000000000000000000000000000000

-

-


4 FORM VB_CALL_FUNC

RSM13000

RSM13000 5441

-

-


SAVE_VBPARAM #

0

3

VBPARAM 2CF93538B4E949608CAEF68FCB839DA00001RS_N

3443333343433333344443344433344333335554

23693538245949608315668632839410000123FE

... + 40 EW_PROGRAM_INDEX AIL_DEV 99

4555544544544445222222222244454452222233

57F02F721DF9E458000000000019CF4560000099

... + 80 9### ##

3000222222222222222222222222222220022222

9612000000000000000000000000000001100000

... + 120

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 160

2222222222222222222

0000000000000000000

VBHDR-VBTCODE SE38

54332222222222222222

35380000000000000000

VBHDR-VBREPORT RS_CALL_PROGRAMM_INDEX_DELTA

5554444555445444544445544454222222222222

23F31CCF02F721DDF9E458F45C41000000000000

VBMODCNT 1

0000

1000

DLDE DLDE

4444222222222222222222222222222222222222

4C45000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

VBPARAM-VBPHASE 538968577

0

1

VB_V1_TEST #

0

2

SYST-REPID RSM13000

5543333322222222222222222222222222222222

23D1300000000000000000000000000000000000

HGEN HGEN

4444222222222222222222222222222222222222

875E000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

IS_A_ARFC #

0

0

TH_TRUE #

0

1

OFFICE_TASO00 SO00

5433222222222222222222222222222222222222

3F00000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

TH_FALSE #

0

0

VBSTAT-START2_REQ

222222222222222

000000000000000

EWST EWST

4555222222222222222222222222222222222222

5734000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

BACK BAC

4442222222222222222222222222222222222222

2130000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

TFDIR RS_NEW_PROGRAM_INDEX SAPLSEUAX

5554455554454454444522222222225454545452

23FE57F02F721DF9E4580000000000310C355180

... + 40 0100000000

2222222222222222222222222222223333333333

0000000000000000000000000000000100000000

... + 80 1

22222222222223

00000000000001

TFDIR-PNAME SAPLSEUAX

5454545452222222222222222222222222222222

310C355180000000000000000000000000000000

VBFUNC RS_NEW_PROGRAM_INDEX

555445555445445444452222222222

23FE57F02F721DF9E4580000000000

%_DUMMY$$

2222

0000

VBID 2CF93538B4E949608CAEF68FCB839DA0####

344333334343333334444334443334430000

236935382459496083156686328394101000

VBDEBUG 538976258

0

2

VB_UPDATE_MODUL_PROCESSED #

1

C

-

-


3 FORM VB_V1_EXEC

RSM13000

RSM13000 5182

-

-


ROLE_SUBST_ACTIVE 3

3

3

VBMOD_TABL-VBMODE 1

3

1

VB_COLLECTOR_FB 5

3

5

SY-REPID RSM13000

5543333322222222222222222222222222222222

23D1300000000000000000000000000000000000

LISL LISL

4454222222222222222222222222222222222222

C93C000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

EXISTS_COLLECTOR #

0

0

VB_V1_FB 1

3

1

VB_V1_NO_UPD_AGAIN_FB 3

3

3

VBHDR-VBSTATE 826605823

F

F

VB_V1_PROCESSED #

0

1

VB_V1_AND_V2_PROCESSED #

0

2

SYST ########################################

0000000000000000000000000000000000000000

0000000010001000000000000000000000000000

... + 40 ####################u0161###############H###

0000000000000000000090000000000000004000

10000000100000001000A0000000000000008000

... + 80 ########################################

0000000000000000000000000000000000000000

0000000000000000000000000000000000000000

... + 120 ########################################

0000000000000000000000000000000010009000

00000000000000000000000000000000B0000000

... + 160 ############XM## ############# E0 3

0000000000005400220000000000000222432223

0000000000008D00000020000C0000C000500003

... + 200 000 N ####__S 999

3332222222420000555222222222222222223332

0000000000E00000FF3000000000000000009990

... + 240 00

222223322222222

000000000000000

MTAS MAS

4452222222222222222222222222222222222222

D130000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

VBMOD_TABL-VBKEY 2CF93538B4E949608CAEF68FCB839DA0

34433333434333333444433444333443

23693538245949608315668632839410

VBMOD_TABL-VBFUNC RS_NEW_PROGRAM_INDEX

555445555445445444452222222222

23FE57F02F721DF9E4580000000000

VBMOD_TABL-VBMODCNT 1

0000

1000

LOC_VBPARAM-VBPHASE 538968577

0

1

LOC_VBPARAM-VBDEBUG 538976258

0

2

READ READ

5444222222222222222222222222222222222222

2514000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

EXISTS_V2 #

0

0

SPACE

2

0

NEW_VBSTATE 0

0

0

OBJA OBJA

4444222222222222222222222222222222222222

F2A1000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

OFFICE_TASO18 SO18

5433222222222222222222222222222222222222

3F18000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

USER_NOT_EXIST 34

2000

2000

SY-XPROG

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

SY-XFORM

222222222222222222222222222222

000000000000000000000000000000

-

-


2 FORM VB_V1_NORMAL

RSM13000

RSM13000 3944

-

-


VBHDR-VBCLIINFO #

0

0

VB_SYNC_VB #

0

1

%_ARCHIVE

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 40

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 80

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 120

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 160

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 200

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 240

222222222222222

000000000000000

SY-MSGID

22222222222222222222

00000000000000000000

ROOM_TAPP30 PP30

5533222222222222222222222222222222222222

0030000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

ADMI ADM

4442222222222222222222222222222222222222

14D0000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

SY-MSGNO 000

333

000

NOTE_NOT_ADDED 11

0000

B000

SY-MSGV1

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 40

2222222222

0000000000

SY-MSGV2

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 40

2222222222

0000000000

SY-MSGV3

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 40

2222222222

0000000000

SY-MSGV4

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 40

2222222222

0000000000

LOGO LOG

4442222222222222222222222222222222222222

CF70000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

VBHDR 2CF93538B4E949608CAEF68FCB839DA0999AIL_D

3443333343433333344443344433344333344454

2369353824594960831566863283941099919CF4

... + 40 EV RS_CALL_PROGRAMM_INDE

4522222222222222222555444455544544454444

560000000000000000023F31CCF02F721DDF9E45

... + 80 X_DELTA SE38

5544454222222222222543322222222222222222

8F45C41000000000000353800000000000000000

... + 120

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 160 ÿ###awnts151_DEE_00

22222222222222222222F0006767733354445332

00000000000000000000F00017E43151F455F000

... + 200

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 240 :E:

222222223432222

00000000A5A0000

-

-


1 MODULE (PBO) VBEXEC

RSM13000

RSM13000 3793

-

-


VB_V1_NORMAL #

0

1

%_SPACE

2

0

STOP RET

5452222222222222222222222222222222222222

2540000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

RSUP RSUP

5555222222222222222222222222222222222222

2350000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

USPR USPR

5555222222222222222222222222222222222222

5302000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

VB_V2_NORMAL #

0

3

ENTER ENTR

4455222222222222222222222222222222222222

5E42000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

USAD USAD

5544222222222222222222222222222222222222

5314000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

VB_MAIL #

0

4

INBO INB

4442222222222222222222222222222222222222

9E20000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

PAGP PAGP

5445222222222222222222222222222222222222

0170000000000000000000000000000000000000

... + 40

222222222222222222222222222222

000000000000000000000000000000

VB_AUTO_SYS_START #

0

5

-

-


Application Calls

-

-


No dump information available

-

-


Application Information

-

-


No dump information available

-

-


Internal notes

-

-


The termination occurred in the function "expInpDb " of the SAP

Basis System, specifically in line 4364 of the module

"//bas/640_REL/src/krn/runt/abexpo.c#14".

The internal operation just processed is "IMPO".

The internal session was started at 20080812083037.

Internal call code.........: "[SETG/GET /VBDATA ]"

-

-


Active calls in SAP kernel

-

-


SAP (R) - R/3(TM) Callstack, Version 1.0

Copyright (C) SAP AG. All rights reserved.

Callstack without Exception:

App : disp+work.EXE (pid=5484)

When : 8/12/2008 8:30:37.808

Threads : 2

Computer Name : AWNTS151

User Name : SAPSERVICEDEE

Number of Processors: 8

Processor Type: x86 Family 6 Model 15 Stepping 11

Windows Version : 5.2 Current Build: 3790

Stack Dump for Thread Id 1578

eax=00000201 ebx=0000040c ecx=00000210 edx=009c35fa esi=0000040c edi=00000000

eip=7c8285ec esp=0410cd10 ebp=0410cd80 iopl=0 nv up ei ng nz ac po cy

cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00200297

function : KiFastSystemCallRet

7c8285ec c3 ret

7c8285ed 8da42400000000 lea esp,[esp] ss:0410cd10=7c827d0b

7c8285f4 8d642400 lea esp,[esp] ss:2571bd23=????????

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name

0410cd80 77e61c8d 0000040c 0001d4c0 00000000 0410cdb8 ntdll!KiFastSystemCallRet

0410cd94 00f6a44d 0000040c 0001d4c0 00000001 7c3ad8c8 kernel32!WaitForSingleObject

0410cdb8 0054011a 00540153 7c3ad8c8 7c3ad8c8 7c3ad8c8 disp+work!NTDebugProcess >

>

0410cdbc 00540153 7c3ad8c8 7c3ad8c8 7c3ad8c8 01778db4 disp+work!NTStack >

>

0410cdd8 00540187 7c3ad8c8 00000000 008224b3 7c3ad8c8 disp+work!CTrcStack2 >

>

0410cde4 008224b3 7c3ad8c8 00040000 41305f59 30303030 disp+work!CTrcStack >

>

0410ce00 008259e9 02079620 0472a370 00000000 00000000 disp+work!rabax_CStackSave >

>

0410d2a0 007a00f8 01223708 012755fc 0000110c 018ac020 disp+work!ab_rabax >

>

0410d30c 00725113 00000001 01223708 0000110c 018ac020 disp+work!ab_setgerr >

>

0410d36c 007ac556 0410d498 0410d49c 00000000 00000000 disp+work!expInpDb >

>

0410e618 007278d3 00000003 00000000 00000000 00000000 disp+work!ab_connread >

>

0410e69c 0072a3a9 00000001 00000000 00000000 00000000 disp+work!ab_expvb >

>

0410e6d4 0067334a 00000003 516c9cf0 00000000 0410e73c disp+work!expo_import >

>

018ac020 2f2f203a 2f736162 5f303436 2f4c4552 2f637273 disp+work!ab_extri >

>

64492420 00000000 00000000 00000000 00000000 00000000

0668ffb8 77e64829 04f7feb0 00000000 00000000 04f7feb0 MSVCR71!endthreadex

0668ffec 00000000 7c3621a4 04f7feb0 00000000 00000000 kernel32!GetModuleHandleA

-

-


List of ABAP programs affected

-

-


-

-


Type

Program

Gen. Date Time

Load Size

-

-


Prg

RSM13000

19.05.2007 19:22:41

242688

Prg

SAPMSSYD

05.06.2002 17:09:33

16384

Prg

SAPFSYSCALLS

14.02.2002 14:22:47

6144

Typ

VBHDR

09.11.2000 14:25:09

5120

Typ

VBMOD

08.08.1995 14:49:58

2048

Typ

TFDIR

29.07.1998 19:49:08

3072

Typ

TFDIR

29.07.1998 19:49:08

3072

Prg

SAPLSEUAX

19.05.2007 19:03:05

8192

Typ

SYST

04.12.2000 14:54:51

27648

Typ

VBPARAM

30.03.1998 09:43:02

4096

Typ

VBSTAT

07.05.1997 13:20:30

9216

Typ

VBMOD

08.08.1995 14:49:58

2048

-

-


-

-


List of internal tables

-

-


No dump information available

-

-


Directory of Application Tables

-

-


Program

Name................ Contents....1........2........3........4........5....+....

-

-


RSM13000

SYST |000000000000x01000000000000000

VBHDR |2CF93538B4E949608CAEF68FCB839DA0999AIL_DEV

VBPARAM |2CF93538B4E949608CAEF68FCB839DA00001RS_NEW_PROGRAM_INDEX

VBSTAT |0

TFDIR |RS_NEW_PROGRAM_INDEX SAPLSEUAX

SAPLSEUAX

RSJOBINFO | 00000000000000

-

-


Directory of Application Tables (Administrative Information)

-

-


Program

Name.......................... Time.......... Length...

-

-


SAPLSEUAX

SYST 00002404

VBHDR 00000432

VBPARAM 20000323224119 00000179

VBSTAT 00000736

TFDIR 00000094

SAPLSEUAX

RSJOBINFO 00000084

-

-


ABAP control blocks CONT

-

-


Include Line source code

Index Name F1 Co Par01 Par2. Par3. Par4. Tabl

-

-


-

-


-- -- -

-


-

-


-

-


-

-


-

-


-

-


LSEUAXV01 19 IF %_STATE EQ 'N'.

61 cmp1 00 42 0020

63 BRAF 02

LSEUAXV01 21 IMPORT

64 TCHK 04 15

66 CLEA 00

67 XDAT 90

69 XDAT 91 03 C000

71 XDAT 91 03 C001

LSEUAXV01 25 ELSE.

73 BRAX 00

LSEUAXV01 27 IMPORT

74 TCHK 07 15

76 IMPO 04 02 0000

80 PAR2 06 C000

82 PAR2 06 C001

>>>>> IMPO 05 0000

LSEUAXV01 33 CALL FUNCTION 'RS_NEW_PROGRAM_

88 FUNC 00

89 FUNC 00

90 PAR2 02 C001

92 PAR2 02 C000

94 FUNC 10

95 FUNC FF

LSEUAXV01 38 ENDFORM.

96 ENDF 00

-

-


End of runtime analysis

-

-


Please help.

Regards,

siddhartha

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi Markus,

Please let me know how to check the permissions and install the new patches.

Sorry for any botheration as i am new to SAP Basis.

Regards,

siddhartha.

markus_doehr2
Active Contributor
0 Kudos

> Please let me know how to check the permissions and install the new patches.

- login as ora<SID>
- ls -l $ORACLE_HOME/bin/oracle

> Sorry for any botheration as i am new to SAP Basis.

it's ok - you're welcome

Markus

Former Member
0 Kudos

Hi Guys,

Thanks for the reply!!

To SriHari,

Just to get the insight of the problem am posting it in the forum.Sometimes, it need not be an oracle issue instead it may be an Kernel issue. I did not know which sort of issue as i am new to Basis. Sorry if i have done anything wrong and against the ethics of this forum. Please pardon.

To Fidel Vales,

1) I have installed 10.2.0.2 patch which is available in the service marketplace.

i have not installed the OPatch

2) My kernel version is 239 (SAP R/3 4.7)

3) The env variables are give beolow.

DBMS_TYPE=ORA

DBS_ORA_SCHEMA=SAPR3

dbs_ora_tnsname=DEE

NLS_LANG=AMERICAN_AMERICA.WE8DEC

NUMBER_OF_PROCESSORS=8

ORACLE_HOME=D:\ORACLE\DEE\102

ORACLE_SID=DEE

OS=Windows_NT

Path=C:\Perl\bin\;D:\oracle\DEE\102\jre\1.4.2\bin\client;D:\oracle\DEE\102\jre\1

.4.2\bin;C:\Program Files\EMC\PowerPath\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDO

WS\System32\Wbem;C:\Program Files\Dell\SysMgt\RAC5;C:\Program Files\Dell\SysMgt\

oma\bin;C:\Program Files\Dell\SysMgt\oma\oldiags\bin;C:\Program Files\EMC\Navisp

here CLI;C:\Program Files\Resource Kit\;D:\Oracle92\Opatch;D:\Oracle92\Opatch;d:

\oracle\DEE\102;D:\usr\sap\DEE\sys\exe\run;D:\Oracle\DEE\102\BIN;d:\oracle92;d:\

oracle92\bin;D:\usr\sap\DEE\sys\exe\run;

SAPARCH=E:\oracle\DEE\saparch

SAPBACKUP=E:\oracle\DEE\sapbackup

SAPCHECK=E:\oracle\DEE\sapcheck

SAPDATA_HOME=E:\oracle\DEE

SAPEXE=D:\usr\sap\DEE\SYS\exe\run

SAPLOCALHOST=awnts151

SAPREORG=E:\oracle\DEE\sapreorg

SAPTRACE=E:\oracle\DEE\saptrace

SAPTRANSHOST=AWNTS151

TNS_ADMIN=D:\usr\sap\DEE\sys\profile\ORACLE

USERDNSDOMAIN=AUDCO9.AILVALVES.COM

USERDOMAIN=AUDCO9

USERNAME=deeadm

USERPROFILE=C:\Documents and Settings\deeadm

USE_KIT=OFF

4) Since there is no application server i have not installed oracle client.

5) Kernel version is 640.

Please help.

Thanks and regards,

siddhartha.

markus_doehr2
Active Contributor
0 Kudos

> 1) I have installed 10.2.0.2 patch which is available in the service marketplace.

>

> i have not installed the OPatch

I suggest you install all available interim patches. They contain important fixes, that can lead to data corruption if you omit them.

As said, one reason can be, the the permissions for the oracle executable ($ORACLE_HOME/bin/oracle) are not correct. Check the uid and gid.

Markus

Former Member
0 Kudos

Hi Siddhartha,

>Sorry if i have done anything wrong and against the ethics of this forum. Please pardon.

There is no need to apologize.

>i am new to Basis.

We are all beginners and have to start at one place. Please take this as an advice.

It will only complicate the number of solutions you have to look for and the potential members keep on replying until you acknowledge and in turn you will end up in implementing the solutions on trail and error basis.

Finally this will only mess up and become chaotic.

Cheer up:-)

Regards,

Srihari

markus_doehr2
Active Contributor
0 Kudos

This problem can be caused by wrong permissions of the $ORACLE_HOME/bin/oracle binary (wrong group).

Markus

Former Member
0 Kudos

Hi,

I have recently upgraded my orcale from 9.2.0.8 to 10.2.0.2.

Now the running version is 10.2.0.2.

Thanks,

siddhartha.

fidel_vales
Employee
Employee
0 Kudos

Good,

but you have not answer my question or Srihari.

I'll put them (and some more) here:

1) what patches have you installed in 10.2.0.2?

2) what is your kernel version?

3) what are your environmental settings?

4) have you installed oracle client 9207 or 9208?

Forgot

5) what is your kernel version?

Edited by: Fidel Vales on Aug 13, 2008 9:10 AM

Former Member
0 Kudos

Hi Sidhartha,

Please post your requirement only in one forum. Do not post duplicate threads in other forums.

You will be confused with the information provided by the potential users and will certainly not get the right direction to resolve the issue.

[This|; is what you've posted in the "Netweaver Administartor" Forum.

Moderators, I hope you're watching. Please help Siddhartha to close either of these two threads.

Regards,

Srihari

Former Member
0 Kudos

Hi Siddhartha,

This might occur due to incorrect setting of ORA_NLS33 (env variable).

Check if this set correctly.

Check the notes: 393620 & 556232.

Regards,

Srihari

fidel_vales
Employee
Employee
0 Kudos

Would you mind to indicate, at least, what is your DB version?

If is it 10g, do you have ALL required patches installed?