on 12-31-2006 10:59 AM
hi guys
i installed sap r/3 4.7
some of the work processes are ending.
i checked trace file
its showing sql error
please help me
Hello,
I have the same problem in my production database since february 2007, and I have investigated a lot for this error.
for the instance I restart work processes which are ending to work.
the solution can be a reinstall of oracle component on the server.
I havent test this because I can't stop production server, but I project to do it at the end of the year.
if you have found a solution, thank you to tell it to me.
best regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi pavan,
You have upgraded kernel, you haven't changed the user environment of sidadm everything is okay.
So as I said earlier , the problem lies with listener or the oracle client.
Have you checked the listener.trc file, what you can do is , restart the listener and then try starting SAP again.
When you find the Work process ending again, stop the listener and then open the listener.trc.
The file should have some detail about what is going on.
Please note listener.trc and listener.log are two different files.
Regards,
Siddhesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
did u changed sidadm's password
Regards
Umesh K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pavan,
Can you post the sql error ?
Regards,
Siddhesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
oracle 9i
win 2000 server
sap 4.7
-
trc file: "dev_w1", trc level: 1, release: "620"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Sun Dec 31 19:00:01 2006
B create_con (con_name=R/3)
B Loading DB library 'D:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' ...
B Library 'D:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' loaded
B Version of 'D:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.549)
B New connection 0 created
M systemid 560 (PC with Windows NT)
M relno 6200
M patchlevel 0
M patchno 674
M intno 20020600
M pid 2088
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 1 2088) [dpxxdisp.c 1028]
I MtxInit: -2 0 0
M
M Sun Dec 31 19:00:04 2006
M DpShMCreate: sizeof(wp_adm) 9024 (752)
M DpShMCreate: sizeof(tm_adm) 1690816 (8412)
M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
M DpShMCreate: sizeof(comm_adm) 192000 (384)
M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
M DpShMCreate: SHM_DP_ADM_KEY (addr: 001E0040, size: 1974064)
M DpShMCreate: allocated sys_adm at 001E0040
M DpShMCreate: allocated wp_adm at 001E0560
M DpShMCreate: allocated tm_adm_list at 001E28A0
M DpShMCreate: allocated tm_adm at 001E28C8
M DpShMCreate: allocated wp_ca_adm at 0037F588
M DpShMCreate: allocated appc_ca_adm at 00383BD8
M DpShMCreate: allocated comm_adm_list at 00385348
M DpShMCreate: allocated comm_adm at 00385360
M DpShMCreate: allocated ca_info at 003B4160
M DpShMCreate: allocated wall_adm at 003B4168
X EmInit: MmSetImplementation( 2 ).
X <ES> client 1 initializing ....
X Using implementation std
M <EsNT> Memory Reset enabled as NT default
X ES initialized.
M calling db_connect ...
C Got ORACLE_HOME=D:\oracle\ora92 from environment
C Client NLS settings: AMERICAN_AMERICA.WE8DEC
C Logon as OPS$-user to get SAPDEV's password
C Connecting as /@DEV on connection 0 ...
C Attaching to DB Server DEV (con_hdl=0,svchp=06DF422C,svrhp=06DF4E04)
C
C Sun Dec 31 19:00:05 2006
C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12547
[dboci.c 3566]
C *** ERROR => CONNECT failed with sql error '12547'
[dboci.c 9601]
C Try to connect with default password
C Connecting as SAPDEV/<pwd>@DEV on connection 0 ...
C Attaching to DB Server DEV (con_hdl=0,svchp=06DF422C,svrhp=06DF8F10)
C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12547
[dboci.c 3566]
C *** ERROR => CONNECT failed with sql error '12547'
[dboci.c 9601]
B ***LOG BY2=> sql error 12547 performing CON [dbsh#2 @ 962] [dbsh 0962 ]
B ***LOG BY0=> ORA-12547: TNS:lost contact [dbsh#2 @ 962] [dbsh 0962 ]
B ***LOG BY2=> sql error 12547 performing CON [dblink#1 @ 419] [dblink 0419 ]
B ***LOG BY0=> ORA-12547: TNS:lost contact [dblink#1 @ 419] [dblink 0419 ]
M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1102]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 8437]
M
M Info for wp 1
M
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
M *****************************************************************************
M *
M * LOCATION SAP-Server development_DEV_00 on host development (wp 1)
M * ERROR tskh_init: db_connect
M *
M * TIME Sun Dec 31 19:00:05 2006
M * RELEASE 620
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 8569
M * COUNTER 1
M *
M *****************************************************************************
M
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 237]
M Entering ThSetStatError
M Entering ThReadDetachMode
M call ThrShutDown (1)...
B dbtbxbuf: Buffer TBX_SINGLE not available
M ***LOG Q02=> wp_halt, WPStop (Workproc 1 2088) [dpnttool.c 346]
oracle 9i
win 2000 server
sap 4.7
-
trc file: "dev_w1", trc level: 1, release: "620"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Sun Dec 31 19:00:01 2006
B create_con (con_name=R/3)
B Loading DB library 'D:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' ...
B Library 'D:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' loaded
B Version of 'D:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.549)
B New connection 0 created
M systemid 560 (PC with Windows NT)
M relno 6200
M patchlevel 0
M patchno 674
M intno 20020600
M pid 2088
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 1 2088) [dpxxdisp.c 1028]
I MtxInit: -2 0 0
M
M Sun Dec 31 19:00:04 2006
M DpShMCreate: sizeof(wp_adm) 9024 (752)
M DpShMCreate: sizeof(tm_adm) 1690816 (8412)
M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
M DpShMCreate: sizeof(comm_adm) 192000 (384)
M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
M DpShMCreate: SHM_DP_ADM_KEY (addr: 001E0040, size: 1974064)
M DpShMCreate: allocated sys_adm at 001E0040
M DpShMCreate: allocated wp_adm at 001E0560
M DpShMCreate: allocated tm_adm_list at 001E28A0
M DpShMCreate: allocated tm_adm at 001E28C8
M DpShMCreate: allocated wp_ca_adm at 0037F588
M DpShMCreate: allocated appc_ca_adm at 00383BD8
M DpShMCreate: allocated comm_adm_list at 00385348
M DpShMCreate: allocated comm_adm at 00385360
M DpShMCreate: allocated ca_info at 003B4160
M DpShMCreate: allocated wall_adm at 003B4168
X EmInit: MmSetImplementation( 2 ).
X <ES> client 1 initializing ....
X Using implementation std
M <EsNT> Memory Reset enabled as NT default
X ES initialized.
M calling db_connect ...
C Got ORACLE_HOME=D:\oracle\ora92 from environment
C Client NLS settings: AMERICAN_AMERICA.WE8DEC
C Logon as OPS$-user to get SAPDEV's password
C Connecting as /@DEV on connection 0 ...
C Attaching to DB Server DEV (con_hdl=0,svchp=06DF422C,svrhp=06DF4E04)
C
C Sun Dec 31 19:00:05 2006
C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12547
[dboci.c 3566]
C *** ERROR => CONNECT failed with sql error '12547'
[dboci.c 9601]
C Try to connect with default password
C Connecting as SAPDEV/<pwd>@DEV on connection 0 ...
C Attaching to DB Server DEV (con_hdl=0,svchp=06DF422C,svrhp=06DF8F10)
C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12547
[dboci.c 3566]
C *** ERROR => CONNECT failed with sql error '12547'
[dboci.c 9601]
B ***LOG BY2=> sql error 12547 performing CON [dbsh#2 @ 962] [dbsh 0962 ]
B ***LOG BY0=> ORA-12547: TNS:lost contact [dbsh#2 @ 962] [dbsh 0962 ]
B ***LOG BY2=> sql error 12547 performing CON [dblink#1 @ 419] [dblink 0419 ]
B ***LOG BY0=> ORA-12547: TNS:lost contact [dblink#1 @ 419] [dblink 0419 ]
M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1102]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 8437]
M
M Info for wp 1
M
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
M *****************************************************************************
M *
M * LOCATION SAP-Server development_DEV_00 on host development (wp 1)
M * ERROR tskh_init: db_connect
M *
M * TIME Sun Dec 31 19:00:05 2006
M * RELEASE 620
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 8569
M * COUNTER 1
M *
M *****************************************************************************
M
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 237]
M Entering ThSetStatError
M Entering ThReadDetachMode
M call ThrShutDown (1)...
B dbtbxbuf: Buffer TBX_SINGLE not available
M ***LOG Q02=> wp_halt, WPStop (Workproc 1 2088) [dpnttool.c 346]
Hi pavan,
Has the SAP kernel changed recently ? if yes did you extact the sapdbexe.SAR file ?
If SAP kernel hasn't changed there could be two possibilities of this error:
1.Oracle Client library - Check if the Oracle client is installed properly or try re-installing the oracle client.
2.Oracle Listener. - Restart the listener and see the listener.trc (listener.log may not have much information) files for errors.
Also you can try doing this:
Login as <sid>adm
and in the command console window, execute the command : R3trans -d -v
later check the trans.log file in the same directory that you execute the command.
It should tell you something more or point you to specific error.
Also:
I tried the following command:<b>oerr ora 12547</b>
I got the following output:
12547, 00000, "TNS:lost contact"
// *Cause: Partner has unexpectedly gone away, usually during process
// startup.
// *Action: Investigate partner application for abnormal termination. On an
// Interchange, this can happen if the machine is overloaded.
Check if there are too much resources being used when SAP is starting up.
Regards,
Siddhesh
Message was edited by:
Siddhesh Ghag
Hi,
this is not a command ..this is an error message and u can find the solution of this error msag in the internet.
TNS-12547 TNS:lost contact
Cause: Partner has unexpectedly gone away, usually during process startup.
Action: Investigate partner application for abnormal termination. On an
Interchange, this can happen if the machine is overloaded.
Regards
Umesh K
Umesh,
FYI:
Oerr is an oracle executable, you can find more information about oerr on the internet
Pavan,
login to the SAP box as ora<sid> or <sid>adm, start the command console window using START->RUN->cmd.exe
And in the window give the command I mentioned in this fashion:
oerr ora <oracle_error_number>
in your case it would be
oerr ora 12547
Regards,
Siddhesh
Pavan/Umesh,
On second thoughts, the oerr may not be available on Windows, but it is available in UNIX, infact its a shell script:
http://www.oracleutilities.com/OSUtil/oerr.html
Apologies about the confusion.
Regards,
Siddhesh
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.