Hi Friends, Today we are discussing about error “Exception:TNS-04414: file error”. Generally TNS-04414 errors occurred with exception message using GUI tools like DBCA or NETMGR. Cause of TNS-04414 error: Due to found some mysterious character in network file. While DBCA or NETMGR utility is trying to save network file like sqlnet.ora, tnsnames.ora or listener.ora that [...]
Tag: oracle troubleshooting
Hi Friends, One another solid ORA error called ORA-00942:table or view does not exist. It is really very simple ORA error because if we check error message code of ORA-00942 error it is just looking like as follows. ORA-00942: table or view does not exist Cause: The table or view entered does not exist, a [...]
Hi Friends, This is very tricky and suspenseful error called ORA-00922 with strange detail ORA-00922: missing or invalid option. This ORA-00922 itself shows only message code missing or invalid option. So many times people are confusing after got this typical Oracle error. If we check error code from ORA-00922: missing or invalid option Cause: An [...]
Hi friends, How to resolve LRM-00109 with ORA-01078 errors? New article has been realeased for solution of ORA-01078 with LRM-00109 errors. Generally these errors are occurring due to not exist of pfile or spfile on system. May be oracle doesn’t find out parameter file in default location. Or may be file there but contents of [...]
Oracle’s interim patch and one-off patch is being applied by Opatch utility. Article explains how to apply opatch with one-off interim patch of oracle.