Solved: ERROR => ORA-1403 after 10.2.0.4 64 bit upgrade

Former Member · ‎08-04-2010

Hi Gurus

Hope someone can help me with this one

Database upgrade on same server

From :Win 2003 64 bit /Ora 9.2.0.4 32 bit / R3E47X200 Kernel 640 32bit

To: Win2003 64 / Oracle 10.2.0.4 64bit / R3E47X200 Kernel 640 64 bit

No database errors after upgrade and can mount and open database

E:\oracle\PRD\102\BIN>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Aug 3 19:00:03 2010

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1627389952 bytes

Fixed Size 2213600 bytes

Variable Size 550353184 bytes

Database Buffers 1073741824 bytes

Redo Buffers 1081344 bytes

Database mounted.

Database opened.

SQL>

But funny thing is R3trans -d show no conenction errors but problem is when I start SAP - Work+Disp fails shortly after with ERROR => ORA-1403 Backup SAP and drop SAPUSER table and recreated SAP OPS$ accounts , double checked it SAP not 834917 but got exectly same error .

. Below is R3trans - d and last dev_w0 , any help would greatly be appreciated

4 ETW000 R3trans version 6.13 (release 640 - 17.02.10 - 13:07:00).

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

4 ETW000

4 ETW000 date&time : 03.08.2010 - 18:04:24

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] Tue Aug 03 18:04:24 2010 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0.000000

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

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0.000000

4 ETW000 [dev trc ,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 0000000010000000

4 ETW000 0.000000

4 ETW000 [dev trc ,00000] using "E:\usr\sap\PRD\SYS\exe\run\dboraslib.dll"

4 ETW000 0.000000

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 0.000000

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 0.000000

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlevel (0.335)

4 ETW000 0.000000

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 0.000000

4 ETW000 [dev trc ,00000] Setting DIR_CLIENT_ORAHOME is not set as environment variable,

4 ETW000 assuming using instant client with unspecified location.

4 ETW000 0.000000

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 0.000000

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 0.000000

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 3993 0.003993

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPPRD's password 10 0.004003

4 ETW000 [dev trc ,00000] Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 210610)

4 ETW000 11 0.004014

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 53 0.004067

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 0000000007AD1110 0000000007AD9340 0000000007AE8448

4 ETW000 11 0.004078

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 10 0.004088

4 ETW000 [dev trc ,00000] Assigning user session 0000000007B4EAD0 to service context 0000000007AE8308

4 ETW000 17961 0.047565

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:A0,:A1); END;

4 ETW000 27 0.047592

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:A0); END;

4 ETW000 34 0.047626

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

4 ETW000 1526 0.049152

4 ETW000 [dev trc ,00000] Connected to session 30. 1212 0.050364

4 ETW000 [dev trc ,00000] Now '/@PRD' is connected: con_hdl=0, nls_hdl=0, session_id=30.

4 ETW000 11 0.050375

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT=BINARY

4 ETW000 14 0.050389

4 ETW000 [dev trc ,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

4 ETW000 324 0.050713

4 ETW000 [dev trc ,00000] Got SAPPRD's password from OPS$-user 2322 0.053035

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 10 0.053045

4 ETW000 [dev trc ,00000] Rolling back transaction ... 8 0.053053

4 ETW000 [dev trc ,00000] Close user session (con_hdl=0,svchp=0000000007AE8308,usrhp=0000000007B4EAD0)

4 ETW000 248 0.053301

4 ETW000 [dev trc ,00000] Now connection 0 is disconnected 402 0.053703

4 ETW000 [dev trc ,00000] Connecting as SAPPRD/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 210610)

4 ETW000 12 0.053715

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 13 0.053728

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 0000000007AD1110 0000000007AD9340 0000000007AE8448

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 7745 0.007745

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 15 0.007760

4 ETW000 [dev trc ,00000] Close user session (con_hdl=0,svchp=0000000007AE8308,usrhp=0000000007B4EAD0)

\DVEBMGS00\work

-

trc file: "dev_w0", trc level: 1, release: "640"

-

*

ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M

*

B

B Tue Aug 03 18:05:47 2010

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' ...

B Library 'E:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'E:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.335)

B New connection 0 created

M sysno 00

M sid PRD

M systemid 562 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 339

M intno 20020600

M make: multithreaded, ASCII, 64 bit

M pid 3008

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3008) [dpxxdisp.c 1193]

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpShMCreate: sizeof(wp_adm) 17568 (976)

M DpShMCreate: sizeof(tm_adm) 3267456 (16256)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 212000 (424)

M DpShMCreate: sizeof(vmc_adm) 0 (448)

M DpShMCreate: sizeof(wall_adm) (22440/36712/56/104)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000E950050, size: 3586544)

M DpShMCreate: allocated sys_adm at 000000000E950050

M DpShMCreate: allocated wp_adm at 000000000E951880

M DpShMCreate: allocated tm_adm_list at 000000000E955D20

M DpShMCreate: allocated tm_adm at 000000000E955D48

M DpShMCreate: allocated wp_ca_adm at 000000000EC738C8

M DpShMCreate: allocated appc_ca_adm at 000000000EC77F18

M DpShMCreate: allocated comm_adm_list at 000000000EC79688

M DpShMCreate: allocated comm_adm at 000000000EC796A0

M DpShMCreate: allocated vmc_adm_list at 000000000ECAD2C0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000ECAD2E8

M DpShMCreate: allocated wall_adm at 000000000ECAD2F8

M DpRqQInit: Parameter rdisp/queue_lock_level = 2

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M tskh_init: rdisp/cleanup_after_crash = 1

M

M Tue Aug 03 18:05:48 2010

M calling db_connect ...

C Prepending unknown to Path.

C Client NLS settings: AMERICAN_AMERICA.US7ASCII

C Logon as OPS$-user to get SAPR3's password

C Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 210610)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 US7ASCII 1 0000000013827130 000000001382F360 000000001383A6B8

C Attaching to DB Server PRD (con_hdl=0,svchp=000000001383A578,srvhp=000000001383AE38)

C Starting user session

(con_hdl=0,svchp=000000001383A578,srvhp=000000001383AE38,usrhp=00000000138900E0)

C Now '/@PRD' is connected: con_hdl=0, nls_hdl=0, session_id=27.

C *** ERROR => ORA-1403 when accessing table SAPUSER

[dbsloci.c 11881]

C Disconnecting from connection 0 ...

C Close user session (con_hdl=0,svchp=000000001383A578,usrhp=00000000138900E0)

C Now connection 0 is disconnected

C Try to connect with default password

C Connecting as SAPR3/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 210610)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 US7ASCII 1

0000000013827130 000000001382F360 000000001383A6B8

C Starting user session (con_hdl=0,svchp=000000001383A578,srvhp=000000001383AE38,usrhp=00000000138900E0)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 4481]

C *** ERROR => CONNECT failed with sql error 1017.

[dbsloci.c 11479]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#4 @ 1208] [dbsh 1208 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#4 @ 1208] [dbsh 1208 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#6 @ 430] [dblink 0430 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#6 @ 430] [dblink 0430 ]

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

M in_ThErrHandle: 1

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

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 735]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 255]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3008) [dpnttool.c 357]

former_member204746 · ‎08-04-2010

stop sap

stop sap[SID]_00

run sapdba_role.sql (SAP note 400241)

then , from OS level, use command:

ntenv2reg

restret SAP service

start SAP

pray.

ERROR => ORA-1403 after 10.2.0.4 64 bit upgrade

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)

Re: Developer extendibility for custom table and p...

Dynamic URL's in Build Process Automation

Re: SAC Header Image Insert trouble

Re: Can SAP's OData Framework be used as API endpo...

CSS sap-custom-chart-subtitle is having no effect