on 10-10-2013 2:08 PM
Hi Friends,
We are getting the dump DBIF_DSQL2_SQL_ERROR in our BW system.
We have seen that when a program run by user SAPSYS in client 000 and we have 6 DI but this dump is coming only on one instance.
The error 12805 occurred in the current database connection "DEFAULT".
Database error text........: "ORA-12805: parallel query server died
unexpectedly"
Database error code........: 12805
Triggering SQL statement...: "FETCH NEXT "
Internal call code.........: "[DBDS/NEW DSQL]"
Please check the entries in the system log (Transaction SM21).
If the error occures in a non-modified SAP program, you may be able to
find an interim solution in an SAP Note.
If you have access to SAP Notes, carry out a search with the following
keywords:
"DBIF_DSQL2_SQL_ERROR" " "
"SAPLSDO0" or "LSDO0U19"
"SDO0_GET_DF_SPACE_INFO"
Regards
Ganesh
Hello Ganesh,
please check notes
1173713 ORA-00904 in RZ20 Oracle remote monitoring with Version 9.X
363546 ORA-12805 or ORA-7445[kkehbs()] or ora-3113
if this does not help we will need the whole dump if you can attach it to the thread.
Regards,
Javier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The ORA-12805 error indicates that a parallel query process terminated in a hard way. In this case you have to analyze trace files and the alert log.
Best regards,
Jeisson Leonel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
can you please check the database alert log.
This error indicates that a parallel query process terminated in a hard way. In this case you have to analyze trace files and the alert log for more information.
Please check that all the tablespace have space.
Alos check the below note.
Thanks
Rishi Abrol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ganesh,
Please refer this SAP note
Note 1528754 - Incorrect space display for PSAPTEMP in RZ20 with Oracle 11g
Regards,
Deepak Kori
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.