on 11-25-2008 5:36 AM
Hi All,
While observing my Production System I can see some errors in the trace files of the Work Processes.
Below is some lines of the error.
C Sat Nov 22 23:20:57 2008
C got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment
C Client NLS settings:
C Logon as OPS$-user to get SAPPRD's password
C Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 070308)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 WE8DEC 1 000000000FBB50B0 0000000009FD1D70 0000000009FD4EB8
C Attaching to DB Server PRD (con_hdl=0,svchp=0000000009FD2A48,srvhp=000000000FBC5108)
C Starting user session (con_hdl=0,svchp=0000000009FD2A48,srvhp=000000000FBC5108,usrhp=0000000009FD48B8)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034
[dboci.c 4508]
C Detaching from DB Server (con_hdl=0,svchp=0000000009FD2A48,srvhp=000000000FBC5108)
C *** ERROR => CONNECT failed with sql error '1034'
[dbsloci.c 11395]
C Try to connect with default password
C Connecting as SAPPRD/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 070308)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 WE8DEC 1 000000000FBB50B0 0000000009FD1D70 0000000009FD4EB8
C Attaching to DB Server PRD (con_hdl=0,svchp=0000000009FD2A48,srvhp=000000000FBC5108)
C Starting user session (con_hdl=0,svchp=0000000009FD2A48,srvhp=000000000FBC5108,usrhp=0000000009FD48B8)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034
[dboci.c 4508]
C Detaching from DB Server (con_hdl=0,svchp=0000000009FD2A48,srvhp=000000000FBC5108)
C *** ERROR => CONNECT failed with sql error '1034'
[dbsloci.c 11395]
B Reconnect failed for connection:
B 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = YES, timeout = 000, con_max = 255, con_opt = 255, occ
M *** ERROR => ThHdlReconnect: db_reconnect failed (2048) [thxxhead.c 16066]
B db_con_reconnect disconnecting connection:
B 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = YES, timeout = 000, con_max = 255, con_opt = 255, occ
My SAP Environment is
SAP: - R/3 4.7 Enterprise Extn 2
DB: - ORACLE 10.2.0.2
OS: - Windows 2003 Enterprise Server 64 bit.
Kernel Patch Level: - 247
Recently we have migrated from Informix to Oracle. Please help me to resolve this issue.
Thanks & Regards,
Shambo
Hi,Shambo
I have the error message as same as yours.
Can U tell me how to slove it?
Thanks.
Wensent
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please read the following note
Note 131561 - Work processes sometimes abend during database connect
[https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=131561]
Thanks
karan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Please read the note . there may be more than reasion for this problem in your senrio. I am pating here a some part of the note .
During start of one or several R/3 instances, many work processes try to connect to the database concurrently over the Listener. For every work process, the Listener must create a shadow process and coordinate the connection setup between the work process and the shadow process. If other connection requests reach the Listener while it is still busy setting up the connections for the previous requests, the requests are put into a queue. If the size of the queue ist not dimensioned adequately for accepting all incoming requests for work processes, additional connection requests are denied with errors
The solution of this proble is increass the queue size in listner.ora file under /oracle/<SID>/102_64/network/admin/listner.ora.
1. If the problem occurs with TCP connections, it can frequently be corrected by enlarging the Listener queue using the parameter QUEUESIZE. If this parameter is not defined in listener.ora, the operating system default value is used. For some platforms (e.g. NT/Windows 2000), this is set to the small number of 5
.
Please supplement the queue length in the file listener.ora using the parameter QUEUESIZE. To set the length e.g. to 30, add the following parameter at the end of the ADDRESS list for the TCP protocol:
LISTENER =
(ADDRESS_LIST =
...
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = <hostname>)
(PORT = <port>)
(QUEUESIZE = 30)
)
)
After that, restart the Listener.
karan
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.