.gif)
Oracle - Recent User Comments
| Code | When | Id | Who | |
|---|---|---|---|---|
| SP2-1503 | 27/01/2012 08:52:45 | 12 | sunic | |
| thaaakkkssss to nilofer.. it's work for mee.. :) |
||||
| ORA-41017 | 20/01/2012 09:38:49 | 1 | iwopyeyt | |
| Hello! eegbabd interesting eegbabd site! I'm really like it! Very, very eegbabd good! | ||||
| LRM-00101 | 17/01/2012 11:32:47 | 1 | amir | |
| reuse_dumpfiles=y | ||||
| INS-32024 | 11/01/2012 16:31:20 | 1 | Alex | |
| But if you need that location ? | ||||
| IMP-00013 | 09/01/2012 18:47:12 | 3 | CjcarrilloG | |
| solucion a IMP-00013: only a DBA can import a file exported by another DBA a mi me funciono dandole estos privilegios: SQL>GRANT AQ_ADMINISTRATOR_ROLE TO ROYAL WITH ADMIN OPTION; SQL>GRANT MGMT_USER TO ROYAL; SQL>GRANT DBA TO ROYAL WITH ADMIN OPTION; SQL>ALTER USER ROYAL DEFAULT ROLE ALL; Si no te convence darle estos privilegios a tu usuario, despues de acabada la importación se los puedes quitar. saludos. |
||||
| TNS-00525 | 09/01/2012 11:12:13 | 11 | Deepak | |
| Nice tip... Thank you |
||||
| ORA-01967 | 08/01/2012 03:13:12 | 1 | santosh | |
| can anybody tell me how to resolve this problem... pls... | ||||
| ORA-32000 | 03/01/2012 10:18:57 | 1 | scavenger | |
| FALSE you got to create a pfile from the spfile, then edit the pfile, then restart the database with startup pfile='...' then create spfile from pfile, then restart again normally |
||||
| PRVF-07531 | 22/12/2011 05:43:21 | 1 | serach it | |
| If you have the solution then plzz., post it... | ||||
| TNS-00525 | 21/12/2011 17:18:23 | 10 | Marco | |
| Thanks!!!!! | ||||
| ORA-01610 | 16/12/2011 12:11:35 | 25 | RK | |
| I m wondering it is working very good for me too.Very simple steps to follow and before this i tried more but no luck.Not i m good and my DB opened.But i cannt able to see my tables which was in dropped TS. SQL> select count(*) from test_new; select count(*) from test_new * ERROR at line 1: ORA-00376: file 4 cannot be read at this time ORA-01111: name for data file 4 is unknown - rename to correct file ORA-01110: data file 4: 'C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\MISSING00004' looking Help here. Thanks RK |
||||
| PLS-00323 | 01/12/2011 15:19:57 | 16 | Raju | |
| Just Look into the below points 1)Name of procedure; 2)Number of parameters; 3)Name of parameters; 4)Type of parameters; 5)Order of parameters |
||||
| INS-35075 | 29/11/2011 14:45:35 | 3 | krusnik | |
| oh sorry the error code is :ORA-01033 ORACLE initialization or shutdown in progress | ||||
| INS-35075 | 29/11/2011 14:41:25 | 2 | krusnik | |
| I had the same problem too but solved it by doing this In the past I've had many problems uninstalling all Oracle products from Windows systems. Here's my last resort method: Uninstall all Oracle components using the Oracle Universal Installer (OUI). Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key. This contains registry entires for all Oracle products. Delete any references to Oracle services left behind in the following part of the registry: HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora* It should be pretty obvious which ones relate to Oracle. Reboot your machine. Delete the "C:\Oracle" directory, or whatever directory is your ORACLE_BASE. Delete the "C:\Program Files\Oracle" directory. Empty the contents of your "c:\temp" directory. Empty your recycle bin. At this point your machine will be as clean of Oracle components as it can be without a complete OS reinstall. Remember, manually editing your registry can be very destructive and force an OS reinstall so only do it as a last resort. BUT I HAVE ONE PROBLEM FOR WHICH I HAD TO REINSTALL N LOST ALL MY PROJECTS THE ERROR IS ORA-01300 : SHUTTING DOWN OR INSTALLING THAT ALSO WHEN MY PROJECT WAS ALMOST DONE ANY HELP PLZ SUGGEST |
||||
| ORA-30926 | 17/11/2011 18:19:58 | 3 | OPraveen | |
| Merge don't like any functions being used those are deterministic. Look at any functions used in the query and function definition. If the function as "deterministic", it don't like it. | ||||
| ORA-01506 | 17/11/2011 10:31:08 | 3 | prathap | |
| i didnt get any clear cut idea on this error.can you please explain brefly.... | ||||
| ORA-01882 | 15/11/2011 14:39:07 | 8 | elkhodairy | |
| many thanks, it works with me now | ||||
| ORA-01610 | 10/11/2011 17:51:11 | 24 | Frank | |
| hello, thank you for the steps but i get stuck on the recovery opening bit i get this error below ORA-01113: file 1 needs media recovery ORA-01110: data file 1: 'D:\ORACLE\ORADATA\SYSTEM01.DBF' i have tried to recover the file from old backups but it still gives me that error please help, will be greatfull |
||||
| PLS-00323 | 15/10/2011 06:23:21 | 15 | Pratap | |
| do check the order in which the parameters are defined in spec and body. my order of the parameters were different and so i was getting this error. |
||||
| PLS-00382 | 14/10/2011 22:26:16 | 1 | Tim | |
| I've recently encountered this error with ODP.NET. I blogged about it here http://timscyclingblog.wordpress.com/2011/10/14/oracle-odp-net-is-the-devil/ I hope this might be of use to you. | ||||
| PLS-00224 | 14/10/2011 22:23:37 | 1 | Tim | |
| I've recently encountered this error with ODP.NET. I blogged about it here http://timscyclingblog.wordpress.com/2011/10/14/oracle-odp-net-is-the-devil/ I hope this might be of use to you. | ||||
| TNS-12557 | 14/10/2011 14:40:21 | 2 | Threepwood | |
| Edit your sqlnet.ora and add/modify the following line : tnsping.trace_level = admin You may get the following error when re-executing tnsping : ... NL-00511: error opening trace file <OracleHome>\network\trace\tnsping.trc NL-00508 cannot open trace file ... Just create the missing directory and the trace file will be available. |
||||
| TNS-03502 | 28/09/2011 12:20:20 | 1 | ranjan | |
| not enough data | ||||
| ORA-02324 | 27/09/2011 11:49:43 | 1 | Orauser | |
| This is not of any use - I can find this code and its oracle description everywhere, I was expecting to see more information about how to resolve this problem. | ||||
| PLS-00204 | 20/09/2011 07:38:56 | 1 | error-free | |
| Thanks, this helps. :-) | ||||
| INS-40912 | 20/09/2011 07:16:32 | 2 | Anonimous | |
| El problema que tienes cove es que las ip´s virtuales tienen que estar abajo, ya que van a ser las que arranque el servicio. | ||||
| ORA-30373 | 15/09/2011 09:34:46 | 1 | Dave | |
| Check you don't have an order by on your select | ||||
| TNS-00525 | 15/09/2011 04:03:09 | 9 | Chandra Manandhar | |
| Good tips. | ||||
| SP2-1503 | 03/09/2011 13:43:41 | 11 | Obendan | |
| Hey guys this should work. Just follow these steps 1. Go to start and type sqlplus 2. Right click on sqlplus and click on "Run as administrator" CHEERS TO YOU ALL |
||||
| SP2-1503 | 27/08/2011 17:31:44 | 10 | Arun | |
| Thanks a lot. The same issue was resolved for me too. :-))) | ||||
| ORA-01610 | 17/08/2011 14:39:18 | 23 | Ella | |
| It works great. Thanks | ||||
| INS-35075 | 17/08/2011 01:54:37 | 1 | gundsambuu | |
| [INS-35075] The specified SID is already in use I catch this error when installing an oracle. What I do. please HELP me |
||||
| ORA-02167 | 16/08/2011 18:37:35 | 1 | jeevan | |
| Please mention the examples,so that people will understand better.... | ||||
| ORA-38171 | 04/08/2011 00:07:54 | 1 | JJJJ | |
| Que idiotas lo que pusieron no ayuda en ni ma...s | ||||
| ORA-01439 | 02/08/2011 23:14:29 | 3 | Santhosh | |
| Thanks You explained clearly it worked! | ||||
| PLS-00323 | 25/07/2011 12:24:20 | 14 | Setty | |
| Thanks.. Great Help. There was a spelling mistake |
||||
| ORA-01882 | 25/07/2011 11:10:49 | 7 | Sudeep Shakya | |
| i try to connect oracle 11g using jDeveloper but unfortunately the error is time zone problem can i get some help |
||||
| ORA-01735 | 25/07/2011 09:36:43 | 1 | pagal | |
| VEry very funny...hahahah v dint kno tht... |
||||
| PLS-00215 | 19/07/2011 08:10:41 | 1 | marc anthony | |
| thank u for your help. ı solved my problem thanks to your site. |
||||
| TNS-00525 | 14/07/2011 10:46:24 | 8 | Kodero | |
| Worked for me too on Ubuntu 10.04 server editionn.... | ||||
| ORA-22993 | 30/06/2011 14:16:45 | 1 | billy | |
| how | ||||
| TNS-01192 | 23/06/2011 06:51:45 | 1 | Poornima | |
| THANk you very much | ||||
| ORA-30076 | 13/06/2011 14:10:38 | 1 | Renan Malke Stigliani | |
| Just got this error using EXTRACT(SECOND FROM (date1 - date2)), where date1 and date2 were both date, changing it to timestamp solved the problem. | ||||
| ORA-39776 | 09/06/2011 06:23:07 | 4 | krishb4u | |
| This is due to oracle client version problem Upgrade the client to 9.2.0.8 or above or don't user direct load |
||||
| ORA-30657 | 06/06/2011 11:46:10 | 6 | metedor | |
| vaya mierda sitio | ||||
| SP2-1503 | 02/06/2011 23:34:52 | 9 | Nahum | |
| Gracias ho gran Maestro .... has ayudado a un buen número de princiapiantes en database eres un Genio y un Sabio ! Mil gracias por tu sabuduría !!!! |
||||
| SP2-1503 | 24/05/2011 07:59:48 | 8 | ankur | |
| hi nilofer , i am also facing the same problem and has administrator rights too what is the solution for this thanks |
||||
| TNS-00525 | 23/05/2011 10:29:01 | 7 | shanmugam | |
| Thanks .. this one resolved my issue. | ||||
| ORA-30094 | 06/05/2011 13:29:32 | 1 | Craig | |
| Possible action: Check your local / global environment variables for ORACLE_HOME directory, maybe there is the wrong directory set. | ||||
| ORA-23388 | 05/05/2011 14:39:30 | 1 | Chol | |
| ¿Qué pá, qué estáis de cachondeo? | ||||