Oracle RAC Interview Questions

For more exciting blogs on Oracle, please click the LINK   1. Where are the Clusterware files stored on a RAC environment? The Clusterware is installed on each node (on an Oracle Home) and on the shared disks (the voting disks and the CSR file) 2. Where are the...

Modify SCAN Listener port number

In this post we will see how to change the SCAN Listener port from 1521 to 1585 For more exciting blogs on Oracle, please click the LINK   STEPS : 1. Check the current configuration of your SCAN Listener [oracle@INFRA oracle]$ srvctl config scan_listener SCAN...

Oracle DBA Interview Questions – Part 3

For more exciting blogs on Oracle, please click the LINK 1. How to determine redo log size is not optimal As a general rule of thumb, Oracle recommends that you size your online redo logs not to switch more then 5 times per hour during peak DML times. If you are ever...

Export Dump file not compatible with Target Version

Please click on the INDEX and browse for more interesting posts. Recently while I was trying to import a Dump file from Production to Non Prod, I received the below error:  ORA-39358: Export dump file version 19.0.0.0.0 not compatible with target version 12.1.0.2.0  ...

Oracle DBA Interview Questions – Part 2

Please click on the INDEX and browse for more interesting posts. 1. If you are having an expdp dumpfile and the client missed to give you what all schemas or tablespace are there in the dump. How will you find out? We can generate the DDL for the dumpfile using the...