Java SE includes JDK and JRE. There could be more than one Java version installed on Linux and windows. Sometimes…
One of our development database backup failed with RMAN-06817: Pluggable Database DEVPDB1 cannot be backed up in NOARCHIVELOG mode and…
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…
Data mining option is enabled by default during installation of Oracle database. However you can verify the settings, enable and…
Kill the hung RMAN session if stuck in Oracle
It is very easy to monitor RMAN backup status and see the log file if you have redirected RMAN output…
Frequently accessed tables should be kept in Oracle Keep cache buffer pool. Keep buffer pool is the part of SGA…
Sometime SQL queries takes long time to complete. You can check long running sessions using v$session_longops script which will show…
Remotely you can access any Linux server using putty but to open gui tools like DBCA you need to configure…