Tag: oracle

ORA-00107: failed to connect to network listener process

Oracle/PLSQL: ORA-00107 Learn the cause and how to resolve the ORA-00107 error message in Oracle. Description When you encounter an ORA-00107 error, the following error message will appear: ORA-00107: failed to connect to network listener process Cause The network listener process was not been successfully started. Resolution The option(s) to resolve this Oracle error are: […]

ORA-00100: no data found

Oracle/PLSQL: ORA-00100 Learn the cause and how to resolve the ORA-00100 error message in Oracle. Description When you encounter an ORA-00100 error, the following error message will appear: ORA-00100: no data found Cause An application tried to access data that was either inaccessible or does not exist. Resolution The option(s) to resolve this Oracle error […]

ORA-00078: cannot dump variables by name

Oracle/PLSQL: ORA-00078 Learn the cause and how to resolve the ORA-00078 error message in Oracle. Description When you encounter an ORA-00078 error, the following error message will appear: ORA-00078: cannot dump variables by name Cause You tried to dump a variable by name, but your system does not support this option. Resolution The option(s) to […]

ORA-00071: process number must be between 1 and num

Oracle/PLSQL: ORA-00071 Learn the cause and how to resolve the ORA-00071 error message in Oracle. Description When you encounter an ORA-00071 error, the following error message will appear: ORA-00071: process number must be between 1 and num Cause You tried to specify a process number that was not valid. Resolution The option(s) to resolve this […]

ORA-00063: LOG_FILES initialization parameter exceeded

Oracle/PLSQL: ORA-00063 Learn the cause and how to resolve the ORA-00063 error message in Oracle. Description When you encounter an ORA-00063 error, the following error message will appear: ORA-00063: LOG_FILES initialization parameter exceeded Cause The value of the LOG_FILES parameter must be as large as the highest number log that exists. Resolution The option(s) to […]

ORA-01002: fetch out of sequence

Oracle/PLSQL: ORA-01002 Learn the cause and how to resolve the error message in Oracle. Description When you encounter this error, the following error message will appear: ORA-01002: fetch out of sequence Cause You tried to perform a FETCH at a time when it is not allowed. Resolution The option(s) to resolve this Oracle error are: Option […]