Upgrade oracle 9.2.0.6 (urgent)

Dear support,

During my upgrade project i have finished my system copy activity for 4.0B system from source NT 4.0 to Target Win 2000 machine. Now i am upgrading my database from 8.1.7.4 to 9.2.0.6 on Win 2000 server. I have successfully finished upgradation and database working fine. Even R3trans -d , Tnsping , Lsnrctl service

all commands works perfectly ,

BUT WHEN I start sap MMC it just does not respond .It neither shows anything in box not even gray or yellow status.I have done my oracle upgradation previously on NT machine and worked perfectly but this time the error is difficult to figure out becaz nether dispatcher or message server is shown in SAP MMC , when i click on start it just hangs.

Best Regards,

AjitR

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (2)

SAPMMC starts working with 4.5B.

4.0B is/was not supported by MMC.

Maybe the MMC is automatically installed with the EXT-Kernel CD (which was derivied from an 4.6 installation), but it will not work.

you have to use the old SAP Service Manager.

regards

Peter

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello peter,

I am extremely sorry to mention SAP MMC as our practise is , yes you are right

my SAP SERVICE MANAGER is not working getting hanged , one imp thing is it was working fine before upgrading database , please go through logs which i have posted , i dont find any problem with compatibility or connection to database.

also 996 is the latest patch for 4.0B_ext

ok, that make sense.

I assume that the step starting the database is not working.

have a look at the stderr* files (typically the first one) in the instance work directory.

strdbs.cmd is Oracle release dependend and normally a part of dbatools.sar.

If you are using one of the old generation it might wait on stdin for input in case of an error.

have a look at the process list, is there a sqlplus hanging around?

peter

NO sqlplus works perfect as shown in my post and database is able to start and stop perfectly.also how would i see process list as sap service manager gets hanged and not responding when i click on start button.

Even log file like sapstart soesnt get started. If u say stardbs.cmd is version dependent then how would i det latest strdbs.cmd for service manager.

Ajit,

strdbs.cmd has changed from Oracle 8 to 9.

in Oracle 8, it was calling svrmgrl (or svrmgr23 or svrmgr30)

now, it uses command sqlplus which is more universal.

Thanks peter now sap service manager is working fine but when i start dispatcher is going down , i am attaching few logs for your concern, i dont know why it is taking old oracle home in dev_w0 log as below when i have already set env variables to new oracle home.

dev_W0:

trc file: "dev_w0", trc level: 1, release: "40B"

ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M

M Wed Apr 25 06:06:10 2007

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 1748) [dpxxdisp 0876]

M relno 40B

M makevariant 40B_EXT

M patchlevel 996

M compiled on NT 4.0 1381 Service Pack 6 x86 MS VC++ 12.00

M compiled at Oct 31 2003 00:31:44

M pid 1748

M calling db_connect ...

C Try to connect as default user

C TNSNAME = PRD

<b>C Got 'K:\oracle\ora81' for ORACLE_HOME from environment</b>C Got 'PRD' for SID from profile-parameter 'rsdb/oracle_sid'

C Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

C Try to connect as SAPR3/<pwd>@PRD on connection 0 ...

C *** ERROR => CONNECT failed with sql error '1019'

[dbsloci. 5997]

B ***LOG BY2=> sql error 1019 performing CON [ 0729]

B ***LOG BY0=> [ 0729]

B ***LOG BY2=> sql error 1019 performing CON [ 0515]

B ***LOG BY0=> [ 0515]

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

M in_ThErrHandle: 1

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

M *****************************************************************************

M *

M * LOCATION SAP-Server CYPRD_PRD_00 on host CYPRD (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Wed Apr 25 06:06:10 2007

M * RELEASE 40B

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 7614

M * COUNTER 1

M *

M *****************************************************************************

M Info for wp 0

M stat = 4

M reqtype = 1

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M rfc_req = 0

M report = > <

M action = 0

M tab_name = > <

M call ab_shutdown (1) ...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 1748) [dpnttool 0433]

dev_disp:

trc file: "dev_disp", trc level: 1, release: "40B"

Wed Apr 25 06:06:09 2007

***LOG Q00=> DpSapEnvInit, DPStart (00 1720) [dpxxdisp 0860]

relno 40B

makevariant 40B_EXT

patchlevel 996

compiled on NT 4.0 1381 Service Pack 6 x86 MS VC++ 12.00

compiled at Oct 31 2003 00:31:44

pid 1720

MBUF state OFF

MBUF opmode USE

Wed Apr 25 06:07:00 2007

***LOG Q0K=> DpMsAttach, mscon ( CYPRD) [dpxxdisp 7056]

MBUF set hwid_state to HWID_PENDING

CCMS: start to initalize 3.X shared alert area (first segment).

SecAudit: new day, change current audit file

SecAudit(check_daily_file): audit file opened K:\usr\sap\PRD\DVEBMGS00\log\20070425.AUD

MBUF state PREPARED

MBUF component UP

MBUF set hwid_state to SAP_O_K (S1814662205 )

Wed Apr 25 06:07:40 2007

ERROR => W0 (pid 1748) died [dpxxdisp 9039]
ERROR => W1 (pid 1772) died [dpxxdisp 9039]
ERROR => W2 (pid 1780) died [dpxxdisp 9039]
ERROR => W3 (pid 1788) died [dpxxdisp 9039]
ERROR => W4 (pid 1792) died [dpxxdisp 9039]
ERROR => W5 (pid 1804) died [dpxxdisp 9039]
ERROR => W6 (pid 1808) died [dpxxdisp 9039]
ERROR => W7 (pid 1820) died [dpxxdisp 9039]
ERROR => W8 (pid 1828) died [dpxxdisp 9039]
ERROR => W9 (pid 1836) died [dpxxdisp 9039]
ERROR => W10 (pid 1844) died [dpxxdisp 9039]
ERROR => W11 (pid 1852) died [dpxxdisp 9039]
ERROR => W12 (pid 1860) died [dpxxdisp 9039]
ERROR => W13 (pid 1768) died [dpxxdisp 9039]
ERROR => W14 (pid 1872) died [dpxxdisp 9039]
ERROR => W15 (pid 1880) died [dpxxdisp 9039]
ERROR => W16 (pid 1900) died [dpxxdisp 9039]
ERROR => W17 (pid 1916) died [dpxxdisp 9039]
ERROR => W18 (pid 1924) died [dpxxdisp 9039]
ERROR => W19 (pid 1864) died [dpxxdisp 9039]
ERROR => W20 (pid 1932) died [dpxxdisp 9039]
ERROR => W21 (pid 1940) died [dpxxdisp 9039]
ERROR => W22 (pid 1884) died [dpxxdisp 9039]
ERROR => W23 (pid 1960) died [dpxxdisp 9039]
ERROR => W24 (pid 1928) died [dpxxdisp 9039]
ERROR => W25 (pid 1964) died [dpxxdisp 9039]
ERROR => W26 (pid 1972) died [dpxxdisp 9039]
ERROR => W27 (pid 1976) died [dpxxdisp 9039]
ERROR => W28 (pid 1984) died [dpxxdisp 9039]
ERROR => W29 (pid 1992) died [dpxxdisp 9039]
ERROR => W30 (pid 2000) died [dpxxdisp 9039]

my types changed after wp death/restart 0x3f --> 0x0

DP_FATAL_ERROR => DpEnvCheck: no more work processes
DISPATCHER EMERGENCY SHUTDOWN ***
ERROR => DpHalt: gateway (pid 1740) still alive ... [dpxxdisp 5712]

Wed Apr 25 06:07:43 2007

ERROR => DpAsKill: kill [dpntdisp 0411]

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp 7258]

MBUF state OFF

MBUF component DOWN

***LOG Q05=> DpHalt, DPStop ( 1720) [dpxxdisp 5753]

>>>>C Got 'K:\oracle\ora81' for ORACLE_HOME from environment

did you change ORACLE_HOME environment variable for prdadm to point to the Oracle9 ORACLE_HOME?

if yes, you have forgotten to update the environment of the SAP System (has to be done manually if R/3 version < 4.5B).

run ntenv2reg.

stop the sap system

stop windows service sapprd_00

start windows service sapprd_00

start the sap system.

regards

Peter

Peter,

i am giving u my ENV list again and u can see that ORACLE_HOME is set to right point .Also please let me know that ntenv2reg is different from what we set at command promt with SET command.

C:\Documents and Settings\prdadm>set

ALLUSERSPROFILE=C:\Documents and Settings\All Users

APPDATA=C:\Documents and Settings\prdadm\Application Data

CommonProgramFiles=C:\Program Files\Common Files

COMPUTERNAME=CYPRD

ComSpec=C:\WINNT\system32\cmd.exe

DBMS_TYPE=ORA

DBS_ORA_SCHEMA=SAPPRD

dbs_ora_tnsname=PRD

HOMEDRIVE=C:

HOMEPATH=\Documents and Settings\prdadm

LOGONSERVER=
CYPRD

NLS_LANG=AMERICAN_AMERICA.WE8DEC

NUMBER_OF_PROCESSORS=4

ORACLE_HOME=E:\oracle\Prd\920

ORACLE_SID=PRD

OS=Windows_NT

Os2LibPath=C:\WINNT\system32\os2\dll;

Path=E:\oracle\Prd\920\jre\1.4.2\bin\client;E:\oracle\Prd\920\jre\1.4.2\bin;E:\o

racle\Prd\920\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\

jre\1.1.8\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C

:\WINNT\System32\Wbem;;K:\usr\sap\PRD\sys\exe\run;E:\oracle\Prd\920\bin;

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PROCESSOR_ARCHITECTURE=x86

PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=0f06

ProgramFiles=C:\Program Files

PROMPT=$P$G

SAPARCH=E:\oracle\Prd\saparch

SAPBACKUP=E:\oracle\Prd\sapbackup

SAPCHECK=E:\oracle\Prd\sapcheck

SAPDATA1=E:\oracle\Prd\sapdata1

SAPDATA2=E:\oracle\Prd\sapdata2

SAPDATA3=F:\oracle\Prd\sapdata3

SAPDATA4=F:\oracle\Prd\sapdata4

SAPDATA5=F:\oracle\Prd\sapdata5

SAPDATA6=F:\oracle\Prd\sapdata6

SAPDATA_HOME=E:\oracle\Prd

SAPLOCALHOST=CYPRD

SAPREORG=E:\oracle\Prd\sapreorg

SAPTRACE=E:\oracle\Prd\saptrace

SystemDrive=C:

SystemRoot=C:\WINNT

TEMP=C:\WINNT\TEMP

TMP=C:\DOCUME_{1\prdadm\LOCALS}1\Temp

USERDOMAIN=CYPRD

USERNAME=prdadm

USERPROFILE=C:\Documents and Settings\prdadm

windir=C:\WINNT

Cheers! Thanks a lot peter,

Problem has been resolved , i think the problem was with REGEDIT

may be that you have recognized that the SAP System itself is started under a different user (SAPServiceSID) than you are doing the environment changes?

how does the environment of the SAP System is set?

In all SAP Windows versions the environment is set by the sapstart*.exe based Windows Service SAP<SID>_##. During Startup of an SAP System the Service reads HKEY_LOCAL_MACHINE\Software\SAP\<SID>\Environment variables and set the variables in it's process.

environment changes are done to the environment of sidadm using standard windows methods (setx.exe W2K3 or Properties on My Computer...)

How is the environment of <SID>adm is transfered to SAPService<SID> user?

SAP R/3 before 4.5B / after 4.5B if admuser is not set:

after every environment change on <SID>adms environment you have to run ntenv2reg.exe in order to transfer the actual user specific environment of <SID>adm to HKEY_LOCAL_MACHINE\Software\SAP\<SID>\Environment. Well you can do it manually using regedit, but It's not recommended.

SAP Systems as of 4.5B and admuser set:

Everytime you start your SAP System the registry values in KEY_LOCAL_MACHINE\Software\SAP\<SID>\Environment are deleted, the SAP Start Service (sapstart*.exe) opens the registry hive of the user specified in KEY_LOCAL_MACHINE\Software\SAP\<SID>\AdmUser, reads his environment variables and transfers them to KEY_LOCAL_MACHINE\Software\SAP\<SID>\Environment.

KEY_LOCAL_MACHINE\Software\SAP\<SID>\AdmUser is filled from sapstartsrv.exe's <b>Use environment of User</b> field when creating the service.

there are two more tools dealing with environment:

1. ntreg2env in the case you want permanently copy a SAP System specific environment to users environment.

2. ntreg2cmd which creates a command file for setting up environment for a DOS-Shell.

ntenv2reg would have fixed your problems!

points are appreciated (at least for the tip that the environment is causing your problem)!

-> did you patch the sap kernel (mmc is part of that)?

GreetZ, AH

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

My kernel level is 996 which is latest patch available for 4.0B_EXT kernel

I dont think patch should be an issue bacause work process not getting died

the MMC itself is not responding

C:\Documents and Settings\prdadm>R3trans -d

This is R3trans version 6.03 (release 40B - 14.10.03 - 14:49:00).

R3trans finished (0000).

C:\Documents and Settings\prdadm>Tnsping PRD

TNS Ping Utility for 32-bit Windows: Version 9.2.0.6.0 - Production on 21-APR-20

07 10:51:38

Used parameter files:

E:\oracle\Prd\920\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)

(HOST = CYPRD)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = CYPRD)(PORT = 15

27))) (CONNECT_DATA = (SID = PRD) (SERVER = DEDICATED)))

OK (40 msec)

C:\Documents and Settings\prdadm>disp+work

R/3 kernel information

kernel release 40B

kernel make variant 40B_EXT

database library ora OCI_920_SHARE

compiled on NT 4.0 1381 Service Pack 6 x86 MS VC++ 12.00

compile time Oct 31 2003 00:31:44

patch level 996

Sapstart logs:

SAP-R/3-Startup Program

Starting at 2007/04/21 10:56:07

Startup Profile: "K:\usr\sap\PRD\sys\profile\START_DVEBMGS00_CYPRD"

Starting Programs

C:\Documents and Settings\prdadm>set

ALLUSERSPROFILE=C:\Documents and Settings\All Users

APPDATA=C:\Documents and Settings\prdadm\Application Data

CommonProgramFiles=C:\Program Files\Common Files

COMPUTERNAME=CYPRD

ComSpec=C:\WINNT\system32\cmd.exe

DBMS_TYPE=ORA

DBS_ORA_SCHEMA=SAPPRD

dbs_ora_tnsname=PRD

HOMEDRIVE=C:

HOMEPATH=\Documents and Settings\prdadm

LOGONSERVER=
CYPRD

NLS_LANG=AMERICAN_AMERICA.WE8DEC

NUMBER_OF_PROCESSORS=4

ORACLE_HOME=E:\oracle\Prd\920

ORACLE_SID=PRD

OS=Windows_NT

Os2LibPath=C:\WINNT\system32\os2\dll;

Path=E:\oracle\Prd\920\jre\1.4.2\bin\client;E:\oracle\Prd\920\jre\1.4.2\bin;E:\o

racle\Prd\920\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\

jre\1.1.8\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C

:\WINNT\System32\Wbem;;K:\usr\sap\PRD\sys\exe\run;E:\oracle\Prd\920\bin;

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PROCESSOR_ARCHITECTURE=x86

PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=0f06

ProgramFiles=C:\Program Files

PROMPT=$P$G

SAPARCH=E:\oracle\Prd\saparch

SAPBACKUP=E:\oracle\Prd\sapbackup

SAPCHECK=E:\oracle\Prd\sapcheck

SAPDATA1=E:\oracle\Prd\sapdata1

SAPDATA2=E:\oracle\Prd\sapdata2

SAPDATA3=F:\oracle\Prd\sapdata3

SAPDATA4=F:\oracle\Prd\sapdata4

SAPDATA5=F:\oracle\Prd\sapdata5

SAPDATA6=F:\oracle\Prd\sapdata6

SAPDATA_HOME=E:\oracle\Prd

SAPLOCALHOST=CYPRD

SAPREORG=E:\oracle\Prd\sapreorg

SAPTRACE=E:\oracle\Prd\saptrace

SystemDrive=C:

SystemRoot=C:\WINNT

TEMP=C:\WINNT\TEMP

TMP=C:\DOCUME_{1\prdadm\LOCALS}1\Temp

USERDOMAIN=CYPRD

USERNAME=prdadm

USERPROFILE=C:\Documents and Settings\prdadm

windir=C:\WINNT

Ask a Question

Top Q&A Solution Author

User

Count