Tag: oracle troubleshooting

Exception:TNS-04414: file error in DBCA or NETMGR

Exception:TNS-04414: file error in DBCA or NETMGR

November 29, 2012 | By | Add a Comment

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 […]

Read More

ORA-00942:table or view does not exist

ORA-00942:table or view does not exist

August 26, 2010 | By | Add a Comment

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 […]

Read More

ORA-00922: missing or invalid option

ORA-00922: missing or invalid option

August 26, 2010 | By | 1 Comment

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 […]

Read More

ORA-01078 with LRM-00109 errors

ORA-01078 with LRM-00109 errors

March 19, 2010 | By | Add a Comment

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 […]

Read More

Oracle one-off patch or interim patch using opatch utility

Oracle one-off patch or interim patch using opatch utility

December 22, 2009 | By | Add a Comment

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.

Read More

Oracle 9i Hidden Parameters

Oracle 9i Hidden Parameters

October 5, 2009 | By | Add a Comment

Oracle 9i hidden and undocumented parameters with default values and description dowload from following link
http://www.dbametrix.com/download_info.php

Read More