Posts by Velmurugan Ramasubbu

Fix for ORA-03113 end-of-file on communication channel

Fix for ORA-03113: end-of-file on communication channel Oracle Database Server 12c Here is how to fix ORA-03113: end-of-file on communication channel [oracle@host ~]$ sqlplus / as sysdba … … Copyright…

Read More

adapcctl.sh exiting with status 150

adapcctl.sh: exiting with status 150 adapcctl.sh: exiting with status 150 After resolve adoafmctl.sh: exiting with status 204, when i try to start application tier services then getting below error message:…

Read More

ORA-609-opiodr aborting process unknown ospid

ORA-609 : opiodr aborting process unknown ospid Solution: Increase the values for INBOUND_CONNECT_TIMEOUT at both listener and server side sqlnet.ora file as a preventive measure. If the problem  is due…

Read More

ORA-20100 File o2127370.tmp creation failed

ORA-20100: ORA-20100: File o2127370.tmp creation failed. Concurrent request failed with the following error in log file. Error ——– ORA-20100: ORA-20100: File o2127370.tmp creation failed. File could not be opened or…

Read More

ORA-01153–solution

Want to enable flashback on DR but getting the error. Reason is because MRP process is running. So we stop MRP process and then try enabling flashback. After that start…

Read More

displays all unusable indexes

SET VERIFY OFF LINESIZE 200 COLUMN owner FORMAT A30 COLUMN index_name FORMAT A30 COLUMN table_owner FORMAT A30 COLUMN table_name FORMAT A30 SELECT owner, index_name, index_type, table_owner, table_name table_type FROM   dba_indexes…

Read More