on 08-04-2010 12:33 AM
Hi Gurus <br><br>
Hope someone can help me with this one <br>
Database upgrade on same server<br>
From :Win 2003 64 bit /Ora 9.2.0.4 32 bit / R3E47X200 Kernel 640 32bit <br>
To: Win2003 64 / Oracle 10.2.0.4 64bit / R3E47X200 Kernel 640 64 bit <br><br>
No database errors after upgrade and can mount and open database <br>
E:\oracle\PRD\102\BIN>sqlplus / as sysdba<br>
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Aug 3 19:00:03 2010<br>
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.<br><br>
Connected to:<br>
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production<br>
With the Partitioning, OLAP, Data Mining and Real Application Testing options<br>
SQL> shutdown immediate<br>
Database closed.<br>
Database dismounted.<br>
ORACLE instance shut down.<br>
SQL> startup<br>
ORACLE instance started.<br><br>
Total System Global Area 1627389952 bytes<br>
Fixed Size 2213600 bytes<br>
Variable Size 550353184 bytes<br>
Database Buffers 1073741824 bytes<br>
Redo Buffers 1081344 bytes<br>
Database mounted.<br>
Database opened.<br>
SQL><br><br><br>
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 <br> <br>Backup SAP and drop SAPUSER table and recreated SAP OPS$ accounts , double checked it SAP not 834917 but got <br>exectly same error . <br><br>
. Below is R3trans - d and last dev_w0 , any help would greatly be appreciated <br> <br>
4 ETW000 R3trans version 6.13 (release 640 - 17.02.10 - 13:07:00).<br>
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 03.08.2010 - 18:04:24<br>
4 ETW000 control file: <no ctrlfile><br>
4 ETW000 R3trans was called as follows: R3trans -d<br>
4 ETW000 trace at level 2 opened for a given file pointer<br>
4 ETW000 [dev trc ,00000] Tue Aug 03 18:04:24 2010 0.000000<br>
4 ETW000 [dev trc ,00000] db_con_init called 0.000000<br>
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0.000000<br>
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0.000000<br>
4 ETW000 [dev trc ,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 0000000010000000<br>
4 ETW000 0.000000<br>
4 ETW000 [dev trc ,00000] using "E:\usr\sap\PRD\SYS\exe\run\dboraslib.dll"<br>
4 ETW000 0.000000<br>
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 0.000000<br>
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll<br>
4 ETW000 0.000000<br>
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlevel (0.335)<br>
4 ETW000 0.000000<br>
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll<br>
4 ETW000 0.000000<br>
4 ETW000 [dev trc ,00000] Setting DIR_CLIENT_ORAHOME is not set as environment variable,<br>
4 ETW000 assuming using instant client with unspecified location.<br>
4 ETW000 0.000000<br>
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 0.000000<br>
4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment<br>
4 ETW000 0.000000<br>
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 3993 0.003993<br>
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPPRD's password 10 0.004003<br>
4 ETW000 [dev trc ,00000] Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 210610)<br>
4 ETW000 11 0.004014
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp <br>ErrHpBatch<br>
4 ETW000 <br> 53 0.004067<br>
4 ETW000 [dev trc ,00000] 0 WE8DEC 1 0000000007AD1110 <br>0000000007AD9340 0000000007AE8448<br>
4 ETW000 11 0.004078<br>
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 10 0.004088<br>
4 ETW000 [dev trc ,00000] Assigning user session 0000000007B4EAD0 to service context 0000000007AE8308<br>
4 ETW000 17961 0.047565<br>
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:A0,:A1); END; <br>
4 ETW000 27 0.047592<br>
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:A0); END; <br>
4 ETW000 34 0.047626<br>
4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2 <br>
4 ETW000 1526 0.049152<br>
4 ETW000 [dev trc ,00000] Connected to session 30. 1212 0.050364<br>
4 ETW000 [dev trc ,00000] Now '/@PRD' is connected: con_hdl=0, nls_hdl=0, session_id=30.<br>
4 ETW000 11 0.050375<br>
4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT=BINARY <br>
4 ETW000 14 0.050389<br>
4 ETW000 [dev trc ,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1) <br>
4 ETW000 324 0.050713<br>
4 ETW000 [dev trc ,00000] Got SAPPRD's password from OPS$-user 2322 0.053035<br>
4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 10 0.053045<br>
4 ETW000 [dev trc ,00000] Rolling back transaction ... 8 0.053053<br>
4 ETW000 [dev trc ,00000] Close user session (con_hdl=0,svchp=0000000007AE8308,usrhp=0000000007B4EAD0)<br>
4 ETW000 248 0.053301<br>
4 ETW000 [dev trc ,00000] Now connection 0 is disconnected 402 0.053703<br>
4 ETW000 [dev trc ,00000] Connecting as SAPPRD/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 210610)<br>
4 ETW000 12 0.053715
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp <br>ErrHpBatch<br>
4 ETW000 13 0.053728<br>
4 ETW000 [dev trc ,00000] 0 WE8DEC <br> 1 0000000007AD1110 <br><br>0000000007AD9340 0000000007AE8448<br>
4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 7745 0.007745<br>
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)<br>
\DVEBMGS00\work<br><br>
-
<br>
trc file: "dev_w0", trc level: 1, release: "640"<br>
-
<br>
*<br>
ACTIVE TRACE LEVEL 1<br>
ACTIVE TRACE COMPONENTS all, M<br>
*<br>
B <br>
B Tue Aug 03 18:05:47 2010<br>
B create_con (con_name=R/3)<br>
B Loading DB library 'E:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' ...<br>
B Library 'E:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' loaded<br>
B Version of 'E:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel<br> (0.335)<br>
B New connection 0 created<br>
M sysno 00<br>
M sid PRD<br>
M systemid 562 (PC with Windows NT)<br>
M relno 6400<br>
M patchlevel 0<br>
M patchno 339<br>
M intno 20020600<br>
M make: multithreaded, ASCII, 64 bit<br>
M pid 3008<br>
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3008) [dpxxdisp.c 1193]<br>
I MtxInit: -2 0 0<br>
M DpSysAdmExtCreate: ABAP is active<br>
M DpShMCreate: sizeof(wp_adm) 17568 (976)<br>
M DpShMCreate: sizeof(tm_adm) 3267456 (16256)<br>
M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)<br>
M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)<br>
M DpShMCreate: sizeof(comm_adm) 212000 (424)<br>
M DpShMCreate: sizeof(vmc_adm) 0 (448)<br>
M DpShMCreate: sizeof(wall_adm) (22440/36712/56/104)<br>
M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000E950050, size: 3586544)<br>
M DpShMCreate: allocated sys_adm at 000000000E950050<br>
M DpShMCreate: allocated wp_adm at 000000000E951880<br>
M DpShMCreate: allocated tm_adm_list at 000000000E955D20<br>
M DpShMCreate: allocated tm_adm at 000000000E955D48<br>
M DpShMCreate: allocated wp_ca_adm at 000000000EC738C8<br>
M DpShMCreate: allocated appc_ca_adm at 000000000EC77F18<br>
M DpShMCreate: allocated comm_adm_list at 000000000EC79688<br>
M DpShMCreate: allocated comm_adm at 000000000EC796A0<br>
M DpShMCreate: allocated vmc_adm_list at 000000000ECAD2C0<br>
M DpShMCreate: system runs without vmc_adm<br>
M DpShMCreate: allocated ca_info at 000000000ECAD2E8<br>
M DpShMCreate: allocated wall_adm at 000000000ECAD2F8<br>
M DpRqQInit: Parameter rdisp/queue_lock_level = 2<br>
M ThTaskStatus: rdisp/reset_online_during_debug 0<br>
X EmInit: MmSetImplementation( 2 ).<br>
X <ES> client 0 initializing ....<br>
X Using implementation flat<br>
M <EsNT> Memory Reset disabled as NT default<br>
X ES initialized.<br>
M tskh_init: rdisp/cleanup_after_crash = 1<br>
M <br>
M Tue Aug 03 18:05:48 2010<br>
M calling db_connect ...<br>
C Prepending unknown to Path.<br>
C Client NLS settings: AMERICAN_AMERICA.US7ASCII<br>
C Logon as OPS$-user to get SAPR3's password<br>
C Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 210610)<br>
C Nls CharacterSet NationalCharSet C EnvHp<br> ErrHp ErrHpBatch<br>
C 0 US7ASCII<br> 1 0000000013827130<br> 000000001382F360 000000001383A6B8<br>
C Attaching to DB Server PRD<br> (con_hdl=0,svchp=000000001383A578,srvhp=000000001383AE38)<br>
C Starting user session <br>
(con_hdl=0,svchp=000000001383A578,srvhp=000000001383AE38,usrhp=00000000138900E0)<br>
C Now '/@PRD' is connected: con_hdl=0, nls_hdl=0, session_id=27.<br>
C *** ERROR => ORA-1403 when accessing table SAPUSER<br>
[dbsloci.c 11881]<br>
C Disconnecting from connection 0 ...<br>
C Close user session (con_hdl=0,svchp=000000001383A578,usrhp=00000000138900E0)<br>
C Now connection 0 is disconnected<br>
C Try to connect with default password<br>
C Connecting as SAPR3/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 210610)<br>
C Nls CharacterSet NationalCharSet C EnvHp<br> ErrHp ErrHpBatch<br>
C 0 US7ASCII 1 <br>
0000000013827130 000000001382F360 000000001383A6B8<br>
C Starting user session<br> (con_hdl=0,svchp=000000001383A578,srvhp=000000001383AE38,usrhp=00000000138900E0)<br>
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017<br>
[dboci.c 4481]<br>
C *** ERROR => CONNECT failed with sql error 1017.<br>
[dbsloci.c 11479]<br>
B ***LOG BY2=> sql error 1017 performing CON [dbsh#4 @ 1208] [dbsh 1208 ]<br>
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#4 @ 1208] <br>[dbsh 1208 ]<br>
B ***LOG BY2=> sql error 1017 performing CON [dblink#6 @ 430] [dblink 0430 ]<br>
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#6 @ 430] <br>[dblink 0430 ]<br>
M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1340]<br>
M in_ThErrHandle: 1<br>
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) <br>[thxxhead.c 9808]<br>
M PfStatDisconnect: disconnect statistics<br>
M Entering TH_CALLHOOKS<br>
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP<br>
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 735]<br>
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP <br>failed [thxxtool3.c 255]<br>
M Entering ThSetStatError<br>
M Entering ThReadDetachMode<br>
M call ThrShutDown (1)...<br>
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3008) [dpnttool.c 357]<br>
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
8 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.