Sometimes you need to recreate spfile from pfile located on filesystem and vice-versa. In Oracle RAC database spfile must be…
While starting oracle database observed, PMON ospid: terminating the instance due to error 12752. SA00 died unexpectedly, VKTM detected a…
We encountered ORA-00845: MEMORY_TARGET not supported on this system, PRCR-1079, CRS-5017, CRS-2674, CRS-2632 while starting the RAC database. Below are…
Sometimes you need to shrink tablespace datafiles to reclaim unused space in Oracle. By Shrinking you can reclaim space from…
You can either use default Oracle database template for installation using DBCA or else you can create new database template…
You may get “ORA-01950: no privileges on tablespace users” while creating tables, indexes, executing some scripts like procedures and triggers.…
As a DBA, you must know the important locations of Oracle database and Exadata log files. Like database alert log…
Java SE includes JDK and JRE. There could be more than one Java version installed on Linux and windows. Sometimes…
While dropping temp files you might have seen this error. SQL > ALTER DATABASE TEMPFILE ‘/home/oracle/app/test11/oradata/temp1.dat’ DROP INCLUDING DATAFILES; ALTER…
Sometimes you need to remove or drop the existing Oracle databases as a part of decommissioning activity. In this post…