on 08-27-2008 8:28 AM
Dear All,
I am facing a suddenly a problem in Production server
1. In sm50 work process get stop one by one and if try to restart again it get stop.
2.Ther are many dumps of 2 types but in different Tx and Table
(DBIF_RSQL_INVALID_REQUEST, TEXTENV_UNICODE_LANGU_INVALID)in the system .
3. The Database error 1017 at CON
BY0 > ORA-12560: TNS:protocol adapter error
09:26:41 DIA 016 BY0 > ORA-01017: invalid username/password; logon denied
In sm21 there is like to error like these
BY2 Database error 1017 at CON
DIA 014 BY2 Database error 12560 at CON
DIA 014 BY0 > ORA-12560: TNS:protocol adapter error
BY2 Database error 12560 at CON
BY0 > ORA-12560: TNS:protocol adapter error
BY2 Database error 12560 at CON
BY0 > ORA-12560: TNS:protocol adapter error
R19 Initialization DB-Connect Failed, Return Code 000256
Q02 Stop Workproc22, PID 7420
In sm21
23:07:27 DIA 004 BY2 Database error 12560 at CON
23:07:27 DIA 004 BY0 > ORA-12560: TNS:protocol adapter error
23:07:27 DIA 004 BY2 Database error 12560 at CON
23:07:27 DIA 004 BY0 > ORA-12560: TNS:protocol adapter error
23:07:27 DIA 004 R19 Initialization DB-Connect Failed, Return Code 000256
23:07:27 DIA 004 Q02 Stop Workproc 4, PID 8540
23:07:27 SPO 036 BY2 Database error 12560 at CON
23:07:27 SPO 036 BY0 > ORA-12560: TNS:protocol adapter error
23:07:27 SPO 036 BY2 Database error 12560 at CON
23:07:27 SPO 036 BY0 > ORA-12560: TNS:protocol adapter error
23:07:27 SPO 036 R19 Initialization DB-Connect Failed, Return Code 000256
23:08:45 DIA 006 Q02 Stop Workproc 6, PID 7672
23:32:27 DIA 011 R19 Initialization DB-Connect Failed, Return Code 000256
23:32:27 DIA 011 Q02 Stop Workproc11, PID 9120
23:32:27 DIA 015 BY2 Database error 12560 at CON
23:32:27 DIA 015 BY0 > ORA-12560: TNS:protocol adapter error
23:32:27 DIA 015 BY2 Database error 12560 at CON
23:32:27 DIA 015 BY0 > ORA-12560: TNS:protocol adapter error
23:32:27 DIA 015 R19 Initialization DB-Connect Failed, Return Code 000256
23:32:27 DIA 015 Q02 Stop Workproc15, PID 5172
23:32:27 SPO 033 BY2 Database error 12560 at CON
23:32:27 SPO 033 BY0 > ORA-12560: TNS:protocol adapter error
23:32:27 SPO 033 BY2 Database error 12560 at CON
23:32:27 SPO 033 BY0 > ORA-12560: TNS:protocol adapter error
23:32:27 SPO 033 R19 Initialization DB-Connect Failed, Return Code 000256
23:32:27 SPO 033 Q02 Stop Workproc33, PID 1104
23:35:12 ENQ 027 Q02 Stop Workproc27, PID 4196
23:35:12 UP1 024 Q02 Stop Workproc24, PID 5956
23:35:12 UP1 025 Q02 Stop Workproc25, PID 5752
23:35:12 UP2 038 Q02 Stop Workproc38, PID 7196
23:35:12 UP1 026 Q02 Stop Workproc26, PID 4828
23:35:12 UP2 037 Q02 Stop Workproc37, PID 8304
23:35:13 RD S30 SAP gateway was closed
23:35:17 DP Q0M Message server disconnected
23:35:17 DP Q05 R/3 System stop, dispatcher PID 73
23:35:17 MS Q02 Stop Msg Server, PID 7624
23:35:25 MS E10 Buffer SCSA Generated with Length 4096
23:35:25 MS Q01 Start Msg Server, 1 times since system startup. PID 396
23:35:25 DP Q00 R/3 System start, SAPSYSTEM 00, dispatcher PID 1880
23:35:29 DP GZZ > 1 possible network problems detected - check tracefile and adjus
23:35:30 RD S00 SAP Gateway Started (PID: 10008)
23:35:30 DP CPS Active ICU Version 2.6; Compiled With ICU 2.6; Unicode Version 4.0
23:35:30 DP CPS Active ICU Version 2.6; Compiled With ICU 2.6; Unicode Version 4.0
23:35:30 DP Q0K Connection to message server (on rfcl-sap-vir) established
23:35:30 DP Q1C MsgServer Hardware ID Was Determined
23:35:31 WRK 000 Q0Q Start Workproc 3, Pid 6780
23:35:31 WRK 000 Q0Q Start Workproc 4, Pid 9672
23:35:31 WRK 000 Q0Q Start Workproc 7, Pid 7648
23:35:31 WRK 000 Q0Q Start Workproc 9, Pid 7516
23:35:31 WRK 000 Q0Q Start Workproc 5, Pid 10032
23:35:44 DIA 019 BB0 Buffer TABL started with 100000000 bytes
23:35:44 DIA 019 BB0 Buffer TABLP started with 61440000 bytes
23:35:44 DIA 019 BB0 Buffer EIBUF started with 40000k bytes
23:35:44 DIA 019 BB0 Buffer ESM started with 4096k bytes
23:35:45 DIA 019 BB0 Buffer CUA started with 15000k bytes
23:35:45 DIA 019 BB0 Buffer OTR started with 4096k bytes
23:35:45 DIA 019 BB0 Buffer CALE started with 500000 bytes
23:35:50 DIA 019 AV6 Initialization SCSA for Security Audit completed, number of selectio
23:35:53 DIA 007 E10 Buffer RSCPCCC Generated with Length 6000000
23:35:59 DIA 000 000 SAPSYS A10 Initialization complete
23:37:51 DIA 001 000 SAPSYS D01 Transaction Canceled BT 513 ( )
23:37:51 DIA 000 000 SAPSYS D01 Transaction Canceled BT 513 ( )
23:37:51 DIA 001 000 SAPSYS R68 Perform rollback
23:37:51 DIA 000 000 SAPSYS R68 Perform rollback
Date : 27.08.08
00:00:50 DIA 001 000 SAPSYS EEA OPERATION MODES: Switch to operation mode Normal triggered
00:06:10 WRK 000 Q0Q Start Workproc 0, Pid 8304
00:06:10 WRK 000 Q0Q Start Workproc25, Pid 6172
00:06:10 WRK 000 Q0Q Start Workproc37, Pid 5172
00:06:10 WRK 000 Q0Q Start Workproc38, Pid 10132
00:06:10 WRK 000 Q0Q Start Workproc26, Pid 10156
00:06:10 WRK 000 Q0Q Start Workproc24, Pid 10044
00:07:10 WRK 000 Q0Q Start Workproc 1, Pid 7784
00:07:10 WRK 000 Q0Q Start Workproc33, Pid 1908
00:07:50 DIA 000 000 SAPSYS A10 Initialization complete
00:08:10 WRK 000 Q0Q Start Workproc28, Pid 9952
00:08:10 WRK 000 Q0Q Start Workproc 4, Pid 7548
00:08:10 WRK 000 Q0Q Start Workproc 2, Pid 2644
00:08:10 WRK 000 Q0Q Start Workproc 3, Pid 7224
00:08:10 WRK 000 Q0Q Start Workproc29, Pid 5876
00:08:10 WRK 000 Q0Q Start Workproc 5, Pid 5672
00:24:50 WRK 000 Q0Q Start Workproc30, Pid 6632
00:36:10 WRK 000 Q0Q Start Workproc31, Pid 8256
00:36:50 WRK 000 Q0Q Start Workproc 0, Pid 8752
00:37:44 DIA 000 000 SAPSYS A10 Initialization complete
00:38:10 WRK 000 Q0Q Start Workproc33, Pid 9332
09:18:21 WRK 000 Q0Q Start Workproc25, Pid 8476
09:18:21 WRK 000 Q0Q Start Workproc 0, Pid 3544
09:18:21 DIA 000 BY2 Database error 12542 at CON
09:18:21 UP1 025 BY2 Database error 12542 at CON
09:18:21 DIA 000 BY0 > ORA-12542: TNS:address already in use
09:18:21 DIA 000 BY2 Database error 12542 at CON
09:18:21 UP1 025 BY0 > ORA-12542: TNS:address already in use
09:18:21 UP1 025 BY2 Database error 12542 at CON
09:18:21 UP1 025 BY0 > ORA-12542: TNS:address already in use
09:18:21 UP1 025 R19 Initialization DB-Connect Failed, Return Code 000256
09:18:21 DIA 000 BY0 > ORA-12542: TNS:address already in use
09:18:21 DIA 000 R19 Initialization DB-Connect Failed, Return Code 000256
09:18:21 UP1 025 Q02 Stop Workproc25, PID 8476
09:18:21 DIA 000 Q02 Stop Workproc 0, PID 3544
09:19:07 DIA 002 600 ******* Q0I Operating system call connect failed (error no. 10055)
09:19:07 DIA 002 600 ******* S0T NiConnect Unsuccessful, Return Code: -0010
09:19:07 DIA 002 600 ******* S0R > Host: localhost
09:19:07 DIA 002 600 ******* S0S > Service: sapgw00
09:19:07 DIA 002 600 ******* R68 Perform rollback
09:19:07 DIA 002 600 ******* S0T NiConnect Unsuccessful, Return Code: -0010
09:19:07 DIA 002 600 ******* S0R > Host: localhost
09:19:07 DIA 002 600 ******* S0S > Service: sapgw00
09:20:29 DIA 004 600 ******* VF02 Q0I Operating system call connect failed (error no. 10055)
09:20:29 DIA 004 600 ******* VF02 R68 Perform rollback
09:20:40 WRK 000 Q0Q Start Workproc 1, Pid 7744
09:20:40 WRK 000 Q0Q Start Workproc 5, Pid 9680
09:20:41 DIA 004 600 ******* VF02 AB0 Run-time error "DBIF_RSQL_INVALID_REQUEST" occurred
09:20:42 DIA 004 600 RFCL-CFA-CHN VF02 AB1 > Short dump "080827 092041 rfcl-sap RFCL-CFA-CHN" generated
09:20:51 DIA 003 000 SAPSYS Q0I Operating system call connect failed (error no. 10055)
09:20:51 DIA 003 000 SAPSYS S0T NiConnect Unsuccessful, Return Code: -0010
09:20:51 DIA 003 000 SAPSYS S0R > Host: localhost
09:20:51 DIA 003 000 SAPSYS S0S > Service: sapgw00
09:21:00 WRK 000 Q0Q Start Workproc 0, Pid 7024
09:21:00 WRK 000 Q0Q Start Workproc 6, Pid 7196
09:21:00 WRK 000 Q0Q Start Workproc25, Pid 1384
09:21:09 DIA 001 600 ******* ESS Q0I Operating system call connect failed (error no. 10055)
09:21:09 DIA 001 600 ******* SESS R68 Perform rollback
09:21:10 DIA 001 600 ******* SESS AB0 Run-time error "DBIF_RSQL_INVALID_REQUEST" occurred
09:21:10 DIA 001 600 ******* SESS AB1 > Short dump "080827 092110 rfcl-sap ******* " generated
09:21:10 DIA 005 BY2 Database error 12560 at CON
09:21:10 DIA 005 BY0 > ORA-12560: TNS:protocol adapter error
09:21:10 DIA 005 BY2 Database error 12560 at CON
09:21:10 DIA 005 BY0 > ORA-12560: TNS:protocol adapter error
09:21:10 DIA 005 R19 Initialization DB-Connect Failed, Return Code 000256
09:21:10 DIA 005 Q02 Stop Workproc 5, PID 9680
09:21:11 DIA 002 600 ******* S0T NiConnect Unsuccessful, Return Code: -0010
09:21:11 DIA 002 600 ******* S0R > Host: localhost
09:21:11 DIA 002 600 ******* S0S > Service: sapgw00
09:21:11 DIA 002 600 ******* R68 Perform rollback
09:21:11 DIA 002 600 ******* S0T NiConnect Unsuccessful, Return Code: -0010
>?È ÊÁ/ÄÇÁÀ" generated
000256
09:26:31 UP1 025 Q02 Stop Workproc25, PID 7768
09:26:31 DIA 005 BY2 Database error 12560 at CON
09:26:31 DIA 005 BY0 > ORA-12560: TNS:protocol adapter error
09:26:31 DIA 005 BY2 Database error 12560 at CON
09:26:31 DIA 005 BY0 > ORA-12560: TNS:protocol adapter error
09:26:31 DIA 005 R19 Initialization DB-Connect Failed, Return Code 000256
09:26:31 DIA 005 Q02 Stop Workproc 5, PID 8416
09:26:31 DIA 011 BY2 Database error 12560 at CON
09:26:31 DIA 011 BY0 > ORA-12560: TNS:protocol adapter error
09:26:31 DIA 011 BY2 Database error 12560 at CON
09:26:31 DIA 011 BY0 > ORA-12560: TNS:protocol adapter error
09:26:31 DIA 011 R19 Initialization DB-Connect Failed, Return Code 000256
09:26:31 DIA 011 Q02 Stop Workproc11, PID 7944
09:26:31 DIA 000 BY2 Database error 12560 at CON
09:26:31 DIA 000 BY0 > ORA-12560: TNS:protocol adapter error
09:26:31 DIA 000 BY2 Database error 12560 at CON
09:26:31 DIA 000 BY0 > ORA-12560: TNS:protocol adapter error
09:26:31 DIA 000 R19 Initialization DB-Connect Failed, Return Code 000256
09:26:31 DIA 000 Q02 Stop Workproc 0, PID 8400
09:26:38 DIA 001 600******* MIGO Q0I Operating system call connect failed (error no. 10055)
09:26:38 DIA 001 600 ******* MIGO R68 Perform rollback
09:26:38 DIA 001 600 ******* MIGO AB0 Run-time error "DBIF_RSQL_INVALID_REQUEST" occurred
09:26:40 WRK 000 Q0Q Start Workproc13, Pid 9992
09:26:40 WRK 000 Q0Q Start Workproc 4, Pid 10016
09:26:40 WRK 000 Q0Q Start Workproc15, Pid 7820
09:26:40 WRK 000 Q0Q Start Workproc16, Pid 6152
09:26:40 WRK 000 Q0Q Start Workproc18, Pid 8604
09:26:40 WRK 000 Q0Q Start Workproc14, Pid 9712
09:26:41 DIA 016 BY2 Database error 1017 at CON
09:26:41 DIA 016 BY0 > ORA-01017: invalid username/password; logon denied
09:26:41 DIA 016 BY2 Database error 1017 at CON
09:26:41 DIA 016 BY0 > ORA-01017: invalid username/password; logon denied
09:26:41 DIA 016 R19 Initialization DB-Connect Failed, Return Code 000256
09:26:41 DIA 016 Q02 Stop Workproc16, PID 6152
09:26:42 DIA 001 ******* MIGO AB1 > Short dump "080827 092638 rfcl-sap PRD-RANKEM " generated
09:26:42 DIA 018 BY2 Database error 1017 at CON
09:26:42 DIA 018 BY0 > ORA-01017: invalid username/password; logon denied
09:26:42 DIA 018 BY2 Database error 1017 at CON
09:26:42 DIA 018 BY0 > ORA-01017: invalid username/password; logon denied
09:26:42 DIA 018 R19 Initialization DB-Connect Failed, Return Code 000256
09:26:42 DIA 018 Q02 Stop Workproc18, PID 8604
09:27:33 DIA 002 ### ## ####### # AB1 > Short dump "080827 092733 rfcl-sap ## ####### #" generated
09:27:33 DIA 002 ### ## ####### # D01 Transaction Canceled SY 002 ( Invalid language key when setting the text environ
09:27:33 DIA 002 ### ## ####### # R11 No Active Link Found in the Link Table
09:27:33 DIA 002 ### ## ####### # R5A > Conversation ID: 19494967
09:27:33 DIA 002 ### ## ####### # R64 > CPI-C function: CMSEND(A)
09:27:33 DIA 002 ### ## ####### # R11 No Active Link Found in the Link Table
09:27:33 DIA 002 ### ## ####### # R5A > Conversation ID: 19494967
09:27:33 DIA 002 ### ## ####### # R64 > CPI-C function: CMRCV(A)
09:27:33 DIA 002 ### ## ####### # R68 Perform rollback
09:27:33 DIA 002 ### ## ####### # AB0 Run-time error "TEXTENV_UNICODE_LANGU_INVALID" occurred
09:27:34 DIA 002 ### ## ####### # AB1 > Short dump "080827 092733 rfcl-sap ## ####### #" generated
09:27:34 DIA 002 ### ## ####### # D01 Transaction Canceled SY 002 ( Invalid language key when setting the text environ
09:27:34 DIA 002 ### ## ####### # R68 Perform rollback
09:27:34 DIA 002 ### ## ####### # R68 Perform rollback
09:27:34 DIA 002 ### ## ####### # AB0 Run-time error "TEXTENV_UNICODE_LANGU_INVALID" occurred
000256
23:12:26 DIA 008 BY2 Database error 12560 at CON
23:12:26 DIA 008 BY0 > ORA-12560: TNS:protocol adapter error
23:12:26 DIA 008 BY2 Database error 12560 at CON
23:12:26 DIA 008 BY0 > ORA-12560: TNS:protocol adapter error
23:12:26 DIA 008 R19 Initialization DB-Connect Failed, Return Code 000256
23:12:27 DIA 004 Q02 Stop Workproc 4, PID 8964
23:12:27 DIA 001 BY2 Database error 12560 at CON
23:12:27 DIA 001 BY0 > ORA-12560: TNS:protocol adapter error
In trace file dev_w
A ABAP Program SAPLV61A .
A Source LV61AU15 Line 155.
A Error Code DBIF_RSQL_INVALID_REQUEST.
A Module $Id: //bas/640_REL/src/krn/runt/absapsql.c#16 $ SAP.
A Function HandleRsqlErrors Line 759.
A ** RABAX: level LEV_RX_STDERR completed.
A ** RABAX: level LEV_RX_RFC_ERROR entered.
A ** RABAX: level LEV_RX_RFC_ERROR completed.
A ** RABAX: level LEV_RX_RFC_CLOSE entered.
A ** RABAX: level LEV_RX_RFC_CLOSE completed.
A ** RABAX: level LEV_RX_IMC_ERROR entered.
A ** RABAX: level LEV_RX_IMC_ERROR completed.
A ** RABAX: level LEV_RX_DATASET_CLOSE entered.
A ** RABAX: level LEV_RX_DATASET_CLOSE completed.
A ** RABAX: level LEV_RX_RESET_SHMLOCKS entered.
A ** RABAX: level LEV_RX_RESET_SHMLOCKS completed.
A ** RABAX: level LEV_RX_ERROR_SAVE entered.
A ** RABAX: level LEV_RX_ERROR_SAVE completed.
A ** RABAX: level LEV_RX_ERROR_TPDA entered.
A ** RABAX: level LEV_RX_ERROR_TPDA completed.
A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI entered.
A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI completed.
A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP entered.
A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP completed.
A ** RABAX: level LEV_RX_END entered.
A ** RABAX: level LEV_RX_END completed.
A ** RABAX: end no http/smtp
A ** RABAX: end RX_GOTO_RABAX
A Invalid call of database interface. accessed..
A
Edited by: Kumar on Aug 27, 2008 9:28 AM
Edited by: Kumar on Aug 27, 2008 9:30 AM
Please help it bzc due to this error work process get stopped and restart thr server.
Thanks
Mohan
Edited by: Kumar on Aug 27, 2008 9:36 AM
> 2.Ther are many dumps of 2 types but in different Tx and Table
> (DBIF_RSQL_INVALID_REQUEST, TEXTENV_UNICODE_LANGU_INVALID)in the system .
>
> 3. The Database error 1017 at CON
>
> BY0 > ORA-12560: TNS:protocol adapter error
>
> 09:26:41 DIA 016 BY0 > ORA-01017: invalid username/password; logon denied
Recreate the OPS$-User - see note 400241 - Problems with ops$ or sapr3 connect to Oracle
> TEXTENV_UNICODE_LANGU_INVALID
What did you do prior to that error? did you import a language?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi kumar,
it seems that you have a problem on your oracle database connection. Please check your oracle listener. Your SAP instance cannot connect to your database.
best regards,
ardhian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks For the quick replys.
I am able to connect to database with /as sysdba. it happend suddeny this problem past 2 day come time but after restart the R/3 it work fine same thing i have to do yesterday also.
Hey Ardhian
Yes 2 day back we are working on Portal.
Create a commutation user in server and some transport including Unicode Changes request.
Please sugesst how to Solution the Issue.
Best Regards,
Kumar
Hello Markus,
I have seen the note ,it is about ops$. My server is Win2003.
I am able to take backup in sm13 way Br*tools.
It start giving dumps approx 110 and in sm50 work process get stop.This come yeaster day also and today also
But if I restart the R/3 then the Dumps stop comming. Please guide me detail what i have to do Step By Step It will be veruy Helpful..
Best Regards,
Kumar
Edited by: Kumar on Aug 27, 2008 12:04 PM
Thanks Markus for your help.
At present listener is up and running and sap is working. It happen suddenely and after restart of R/3 system it ok but same thing happen today also. we are using windows 2003 Enterprise in server.Please help
Best Regards,
Kumar
Edited by: Kumar on Aug 27, 2008 1:10 PM
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
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.