Oracle/PLSQL: ORA-00301 Learn the cause and how to resolve the ORA-00301 error message in Oracle. Description When you encounter an error, the following error message will appear: ORA-00301: error in adding log file <name> – file cannot be created Cause You tried to create a redo log file, but the creation failed. Resolution The option(s) […]
Tag: oracle
ORA-00201: control file version num incompatible with Oracle version num
Oracle/PLSQL: ORA-00201 Learn the cause and how to resolve the ORA-00201 error message in Oracle. Description When you encounter an error, the following error message will appear: ORA-00201: control file version num incompatible with Oracle version num Cause The control file was created by a version of Oracle that is different than the version of […]
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-00068: invalid value num for parameter num, must be between num and num
Oracle/PLSQL: ORA-00068 Learn the cause and how to resolve the ORA-00068 error message in Oracle. Description When you encounter an ORA-00068 error, the following error message will appear: ORA-00068: invalid value num for parameter num, must be between num and num Cause The value for the initialization parameter must be between the numbers specified in […]
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-00058: DB_BLOCK_SIZE must be num to mount this database not num
Oracle/PLSQL: ORA-00058 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-00058: DB_BLOCK_SIZE must be num to mount this database not num Cause You tried to start a database whose DB_BLOCK_SIZE parameter value in the initialization file does not match […]
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 […]