on 04-11-2012 3:47 PM
Hi
I had fixed the Error Before by Starting the Listner and again Dispatcher is Getting STOPPED
Could you please identify the problem.
==================================
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "700"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
B
B Wed Apr 11 20:08:31 2012
B create_con (con_name=R/3)
B Loading DB library 'D:\usr\sap\ECC\DVEBMGS04\exe\dboraslib.dll' ...
B Library 'D:\usr\sap\ECC\DVEBMGS04\exe\dboraslib.dll' loaded
B Version of 'D:\usr\sap\ECC\DVEBMGS04\exe\dboraslib.dll' is "700.08", patchlevel (0.73)
B New connection 0 created
M sysno 04
M sid ECC
M systemid 560 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 75
M intno 20050900
M make: multithreaded, Unicode, optimized
M pid 2076
M
M kernel runs with dp version 217000(ext=109000) (@(#) DPLIB-INT-VERSION-217000-UC)
M length of sys_adm_ext is 572 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2076) [dpxxdisp.c 1299]
I MtxInit: 30000 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M
M Wed Apr 11 20:08:32 2012
M DpShMCreate: sizeof(wp_adm) 18304 (1408)
M DpShMCreate: sizeof(tm_adm) 3994272 (19872)
M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)
M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064
M DpShMCreate: sizeof(comm_adm) 528064 (1048)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1440)
M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 05DF0040, size: 4653368)
M DpShMCreate: allocated sys_adm at 05DF0040
M DpShMCreate: allocated wp_adm at 05DF1E40
M DpShMCreate: allocated tm_adm_list at 05DF65C0
M DpShMCreate: allocated tm_adm at 05DF65F0
M DpShMCreate: allocated wp_ca_adm at 061C5890
M DpShMCreate: allocated appc_ca_adm at 061CB650
M DpShMCreate: allocated comm_adm at 061CD590
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 0624E450
M DpShMCreate: allocated gw_adm at 0624E490
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 0624E4C0
M DpShMCreate: allocated wall_adm at 0624E4C8
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation flat
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M ThInit: running on host ecc6
M
M Wed Apr 11 20:08:33 2012
M calling db_connect ...
C Prepending D:\usr\sap\ECC\DVEBMGS04\exe to Path.
C Oracle Client Version: '10.2.0.1.0'
C Client NLS settings: AMERICAN_AMERICA.UTF8
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@C11 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 06376C08 0637C1A4 0637BA2C
C Attaching to DB Server C11 (con_hdl=0,svchp=0637B978,svrhp=0638B704)
C
C Wed Apr 11 20:09:27 2012
C Starting user session (con_hdl=0,svchp=0637B978,srvhp=0638B704,usrhp=0639ECA8)
C Now '/@C11' is connected (con_hdl 0, nls_hdl 0).
C Got SAPSR3's password from OPS$-user
C Disconnecting from connection 0 ...
C Closing user session (con_hdl=0,svchp=0637B978,usrhp=0639ECA8)
C Now I'm disconnected from ORACLE
C Connecting as SAPSR3/<pwd>@C11 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 06376C08 0637C1A4 0637BA2C
C Starting user session (con_hdl=0,svchp=0637B978,srvhp=0638B704,usrhp=0639ECA8)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 28000
[dboci.c 4391]
C Detaching from DB Server (con_hdl=0,svchp=0637B978,srvhp=0638B704)
C *** ERROR => CONNECT failed with sql error '28000'
[dbsloci.c 10933]
B ***LOG BY2=> sql error 28000 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]
B ***LOG BY0=> ORA-28000: the account is locked [dbsh#2 @ 1204] [dbsh 1204 ]
B ***LOG BY2=> sql error 28000 performing CON [dblink#3 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-28000: the account is locked [dblink#3 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1411]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10156]
M
M Info for wp 0
M
M stat = 4
M reqtype = 1
M act_reqtype = -1
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source = 255
M last_tid = 0
M last_mode = 0
M semaphore = 0
M act_cs_count = 0
M control_flag = 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 vm = V-1
M
M *****************************************************************************
M *
M * LOCATION SAP-Server ecc6_ECC_04 on host ecc6 (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Wed Apr 11 20:09:27 2012
M * RELEASE 700
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10354
M * COUNTER 1
M *
M *****************************************************************************
M
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 720]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 260]
M Entering ThSetStatError
M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2076) [dpnttool.c 327]
hi,
the sapsr3 currently is locked, so you just run following command
SQL>ALTER USER <username> ACCOUNT UNLOCK;
SQL> ALTER USER SAPSR3 ACCOUNT UNLOCK;
and restart the sapmmc.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Srinivas,
FYI, before you can start SAP, you need to ensure:
1) oracle is up and running. you can verify by open a cmd, type -> SQLPLUS "/as sysdba". If you see "connected" means your DB is opened and up. You need to start your DB if you see "connect to and idle instance" by issue "startup"
2) Ensure your listener is up and runing. You can do it in Services.msc in windows env.
3) Start your SAP in SAPMMC.
Thanks,
Nicholas Chang
in services.msc OracleDb10ghome1TNSListner and oracleserviceC11 both shows Started (Automatic) but when checked with SQLPLUS "/as sysdba shows....
error 6 initializing SQL*Plus
mesage file sp1<lang>.msb not found
SP2-0750: You many need to set ORACLE_HOME to your Oracle software directory
how to fix this?
(sapmmc dispatcher stopped)
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.