error-code.org.uk
One stop error reference, a place to browse, search and find solutions to error messages
Oracle - Recent User Comments
| Code | When | Id | Who | |
|---|---|---|---|---|
| ORA-30657 | 03/12/2008 17:36:27 | 4 | Error-Code | |
| This site sucks!... first and last time I search something here | ||||
| ORA-28000 | 03/12/2008 07:05:25 | 1 | Murugan | |
| How can i reproduce this issue | ||||
| ORA-01224 | 03/12/2008 03:48:30 | 1 | samuel | |
| w6c9NO dkg93jfbkSdLk496c | ||||
| ORA-27038 | 02/12/2008 11:22:41 | 1 | asdasf | |
| chetha vedava | ||||
| ORA-38500 | 23/10/2008 15:13:59 | 1 | shakil | |
| Dash u all. u dont knw the answer and saying see documentation.. no need to say this |
||||
| PLS-00323 | 18/10/2008 23:23:24 | 5 | Saravanan. | |
| What a nice explanation. It is very helpful. | ||||
| ORA-04050 | 12/10/2008 08:55:03 | 1 | sreeraj | |
| wat a bad description it is automatically comes with database tools | ||||
| RMAN-06026 | 09/10/2008 22:33:11 | 1 | bryan | |
| Check to see if the restore you are asking for is from a previous incarnation. If so you must reset the database incarnation before doing the restore. | ||||
| ORA-06532 | 06/10/2008 16:27:16 | 4 | Shweta | |
| How could i increase varray size? should i need to declare another type? | ||||
| ORA-26028 | 29/09/2008 03:34:35 | 1 | Ray Wurlod | |
| It seems that this condition can reliably be generated by "successfully" loading 0 rows into the table using sqlldr (direct) in APPEND mode. | ||||
| TNS-12535 | 25/09/2008 12:14:33 | 1 | PJ | |
| Check firewall settings - open port 1521 (or whatever port you are using for the service) | ||||
| PLS-00435 | 18/09/2008 21:02:04 | 1 | konezero | |
| This was the most useless description....ever. | ||||
| SP2-0024 | 11/09/2008 09:00:14 | 1 | Lungy | |
| I got this error when tried to run "set ORACLE_SID=ESKOM" the reason I was running that command is that when I tried to run "connect /as sysdba" is got error ORA-12560. | ||||
| ORA-01426 | 10/09/2008 16:39:49 | 1 | aa | |
| Thank you ! | ||||
| ORA-12704 | 09/09/2008 17:52:31 | 2 | Slinky | |
| AAAAARRRRRGGGGGGGGGHHHHHH!!!! | ||||
| ORA-01610 | 28/08/2008 07:54:51 | 8 | leo | |
| great steps.... been looking for this for ages, finally did it within 5 minutes... had a problem understanding step 4. Actually it's just copy and paste what's inside the latest .trc file inside udump directory starting from CREATE CONTROLFILE ...... thanks so much for the guide, really helpful... |
||||
| ORA-01855 | 22/08/2008 14:40:21 | 1 | Tomik | |
| Check NLS_LANG in your connection. If it is not american/english it can cause such errors. Try the same with AMERICAN_AMERICA.WE8MSWIN1252 if you work on Win. | ||||
| ORA-00988 | 07/08/2008 13:32:33 | 1 | RaviKiran | |
| This information is ok, but some problem is ther if some one got the other problem in this what we can be down. | ||||
| ORA-02097 | 05/08/2008 14:11:04 | 1 | arc | |
| alter system set log_archive_dest='archlv/logs' | ||||
| PLS-00323 | 05/08/2008 13:42:11 | 4 | yrene | |
| en una actualizacion, considerar que los tipos de datos de las nuevas variales deben ser iguales a la de los campos que se desean actualizar A mi daba este error justamente por eso |
||||
| SP2-0678 | 05/08/2008 13:17:57 | 1 | Benno | |
| Hey, this is of great help You get an error message "this doesn't work" and you suggest "make it work". No explanation, no help nothing - bah |
||||
| ORA-01455 | 05/08/2008 11:55:46 | 1 | Bhaskar | |
| How to solve th problem | ||||
| ORA-22835 | 03/08/2008 18:46:25 | 1 | John Gentry | |
| Note that the behavior has changed as of Oracle 10g: http://escuelle.blogspot.com/2008/05/ora-22835.html. |
||||
| ORA-00904 | 29/07/2008 21:22:25 | 2 | Sunny | |
| Thank you very much. It took me some time to figure it out. It was a grant issue wasted so much time on this error. Anyways Thanks | ||||
| ORA-32004 | 25/07/2008 23:02:13 | 1 | jimbo | |
| It'd be nice if this "obsoleted" parameter were actually IN the Alert log. I'm guessing in 10g its the log_archive_start parameter. Any takers? | ||||
| ORA-01610 | 24/07/2008 21:06:56 | 7 | dschulenberg | |
| This procedure just saved our test instance :) Thanks | ||||
| ORA-21602 | 21/07/2008 17:35:03 | 1 | Roger | |
| That explanation is like a mechanic telling you "you can fix your knuter valve by taking the mchamistam and dropjawing it on the bearing muffler". |
||||
| ORA-12169 | 18/07/2008 07:49:17 | 2 | Harry | |
| Could also be a DNS hosts issue. sometimes a.host.in.here may resolve to multiple IP addresses in which case it becomes too long for oracle to handle. | ||||
| ORA-06502 | 17/07/2008 16:14:22 | 1 | David | |
| More info of this error in spanish here: http://www.orasite.com/errores/ORA-06502.html | ||||
| ORA-16810 | 17/07/2008 12:22:26 | 1 | suresh kumar | |
| add standby redolog file in your standby database you also check errors no redo standby database in alert log of physical standby database. | ||||
| ORA-01555 | 16/07/2008 15:08:10 | 1 | mandarbailur | |
| Increase undo_retention parameter value or set undo_retention as GUARANTEED. In this later case new transaction may fail at cost of retaining undo data. | ||||
| ORA-29278 | 11/07/2008 12:49:44 | 5 | Ellision | |
| Great solution , Your suggestion gave me big relief I just "corrected the error" and it worked he he he | ||||
| ORA-00904 | 08/07/2008 20:20:43 | 1 | Hal | |
| I am also getting that error because of a bad synonym point to a function in another set of tables. If the function is not seen, this error occurs. | ||||
| PLS-00323 | 02/07/2008 15:50:09 | 3 | Rajesh | |
| I had declared the fucntion in the body but was getting the error because my return type in spec was number and in the body was integer | ||||
| PLS-00312 | 01/07/2008 14:55:53 | 1 | Oguzhan | |
| I had the same runtime error from the following line: :1 := sys_cmp.pkg_change.get_history( p_action => :2, 1 ); changed the line to the following and cleared the error: :1 := sys_cmp.pkg_change.get_history( p_action => :2, p_nrows => 1 ); |
||||
| PLS-00436 | 01/07/2008 07:03:11 | 1 | Kavish Jha | |
| So If u are using bulk bind,then u have to INSERT into the table as a whole. I can't be selective. FORALL i IN 1..l_table.COUNT INSERT INTO s VALUES l_table(i); But this will work on 11g. In 11g, you should find that that FORALL implementation restriction has been lifted, i.e. you can reference the fields. |
||||
| ORA-00603 | 27/06/2008 16:16:54 | 1 | Colm | |
| This solution is completely useless. | ||||
| ORA-08189 | 24/06/2008 14:52:01 | 1 | Pablo | |
| Is must better, say an example witch sintaxis for enable row movement on the table | ||||
| ORA-32109 | 23/06/2008 15:20:13 | 1 | me | |
| thanks, I would not guess without your help... | ||||
| RMAN-05503 | 10/06/2008 09:02:12 | 1 | DBA | |
| how do we allocate? | ||||
| ORA-19715 | 05/06/2008 09:52:59 | 2 | sorted | |
| ok so here is how I solved the issue. I was having this error only when running a backup archivelog all command. When I read the oracle manual for the error it provided this information: ORA-19715: invalid format string for generated name Cause: A restricted format or undefined format was used incorrectly. Action: Change the format specified in the additional information by removing the restricted format. A bit more than what is here. It turns out that oracle does not manage your backup files if you are using any of the format parameters because the backup is not then managed by oracle. And I guess (as I am no dba) that it needs to manage the archivelog backups. If anyone is out there who can provide a better understanding then please do so. |
||||
| ORA-19715 | 05/06/2008 09:41:55 | 1 | annoying | |
| It pi$$es me off all these site requoting the manual but not adding any vaule. So I have this error and cannot understand how to solve it! |
||||
| ORA-39726 | 04/06/2008 15:22:23 | 3 | Wifey Mc Beatey | |
| To avoid this error when adding a column is to add a column without a DEFAULT value (it can be done afterwards) To avoid this error when dropping a column is to perform a SET UNUSED of the desired column "ALTER TABLE table SET UNUSED COLUMN column" and to follow with a "ALTER TABLE Table DROP UNUSED COLUMNS" |
||||
| ORA-00926 | 02/06/2008 20:00:20 | 1 | Hugo Matos | |
| I dont understand what you want to say. can you give me one exemplo? |
||||
| IMP-00031 | 30/05/2008 09:58:25 | 1 | imp-00031 | |
| plz give solution | ||||
| ORA-31202 | 28/05/2008 23:18:37 | 1 | Victor | |
| ORA-31202: DBMS_LDAP: Sizelimit exceeded Este error viene provocado por una limitacion del Active Directory, ya que por defecto no puede devolver mas de un numero maximo de resultados en una consulta SEARCH. Una posible solucion es recorrer mediante 2 bucles las letras del alfabeto y hacer consultas que empiecen por cada una de estas letras. En esta direccion podeis ver un ejemplo: http://hoterder.blogspot.com/2008/05/dbmsldap-obtener-todos-los-usuarios-del.html |
||||
| PLS-00323 | 26/05/2008 19:30:18 | 2 | ei03062@FEUP | |
| Check whether the subprogram specification in the package specification has all the subprogram parameters. | ||||
| ORA-16796 | 22/05/2008 13:54:06 | 2 | Jean-Yves | |
| Same error if the passwd file (orapwSID) not exist on the standby database. | ||||
| ORA-16055 | 14/05/2008 11:59:27 | 1 | Hemant Pande | |
| The one of the reason is archive destination is full so check and remove all the applied archivlog from the Standby. | ||||
| ORA-01506 | 14/05/2008 00:23:08 | 2 | jahanzeb khan | |
| when i use after database shutdown or startup sya than i use | ||||