This error most likely occurred when you duplicated a database and the DB_NAME parameter in spfile is not matching the…
Tag ora
This error normally occurs when you are trying to import a dump file which is residing on an NFS file…
Problem —— Error on starting ASM from SQLPLUS or ASMCMD SQL> startup; ORA-01078: failure in processing system parameters ORA-29701: unable…
bash-3.2$ impdp system/***** directory=import_dir nologfile=y dumpfile=exp_swx_20092012.dmp full=y ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open…
// *Cause: The archiver process received an error while trying to archive // a redo log. If the problem is…
When a large number of records neds to be deleted from a table. If you do a normal delete it…
This error occurs when you have a public synonym defined and the object referencing or owning the synonym has been…
CAUTION !!!! DO NOT DO THIS ON YOUR PRIMARY. IF YOU DO THEN YOU WOULD REQUIRE MEDIA RECOVERY ON THE…
Even when sessions are inactive they can be executing SQL’s in the background. You have to identify the SQL’s which…
Error: ORA-01858: a non-numeric character found where a digit was expected Cause: You tried to enter a date value using…
ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302: failure occurred at:…