{"id":1750,"date":"2016-03-05T08:57:48","date_gmt":"2016-03-05T05:57:48","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1750"},"modified":"2016-10-21T09:00:27","modified_gmt":"2016-10-21T06:00:27","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-02700-to-ora-02800","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-02700-to-ora-02800\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-02700 to ORA-02800"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-02700 to ORA-02800<\/strong><\/p>\n

\n
ORA-02700: osnoraenv: error translating ORACLE_SID<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Two-task driver could not find the value of ORACLE_SID in the environment.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the ORACLE_SID environment variable has been properly set and exported.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02701: osnoraenv: error translating oracle image name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE_HOME environment variable not set.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the ORACLE_HOME environment variable has been properly set and exported.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02702: osnoraenv: error translating orapop image name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE_HOME environment variable not set.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the ORACLE_HOME environment variable has been properly set and exported.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02703: osnpopipe: pipe creation failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The pipe driver failed to create pipes for communications with the orapop process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0You have probably exceeded the maximum number of open file descriptors per user or the system file table is full. Note the operating system error code and contact your system administrator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02704: osndopop: fork failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The two-task driver could not fork orapop.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02705: osnpol: polling of communication channel failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The pipe driver failed while polling the communications channel.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02706: osnshs: host name too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The length of your host-string specified by the TWO_TASK environment variable exceeds the ORACLE system-imposed limit.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-02707: osnacx: cannot allocate context area<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The invoked Unix two-task driver could not allocate heap space for the context area.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02708: osnrntab: connect to host failed, unknown ORACLE_SID<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The invoked Unix two-task driver failed to find an entry in oratab for the sid you supplied.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0First, check whether you have read access to oratab, and see if the desired sid is there. Add an entry to oratab for the desired sid, if necessary.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02709: osnpop: pipe creation failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The pipe driver failed to create pipes for two-task communications with the oracle shadow process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0You have probably exceeded the maximum number of open file descriptors per user or the system file table is full. Note the operating system error code and contact your system administrator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02710: osnpop: fork failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The pipe driver could not fork the oracle shadow process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02711: osnpvalid: write to validation channel failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The pipe driver failed to write to the orapop process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02712: osnpop: malloc failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The pipe driver failed to allocate enough heap space for its context area buffers.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02713: osnprd: message receive failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The pipe driver failed to read a message from the communications channel.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02714: osnpwr: message send failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The pipe driver failed to write a message to the communications channel.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02715: osnpgetbrkmsg: message from host had incorrect message type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The pipe driver received a message having an unrecognizable message type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02716: osnpgetdatmsg: message from host had incorrect message type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Pipe driver received a message having an unrecognizable message type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02717: osnpfs: incorrect number of bytes written<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Pipe driver sent a message that was apparently successful, but the number of bytes transmitted did not match the number of bytes furnished to the driver.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02718: osnprs: reset protocol error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The two-task driver could not reset the connection.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02719: osnfop: fork failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The fast driver could not fork the oracle shadow process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02720: osnfop: shmat failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When the fast driver was invoked, processes failed to attach to the shared memory buffer. You probably supplied an illegal shared memory attach address, or the system ran out of data space to accomodate the buffer.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Try invoking the Fast driver later, or use the default attach address.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02721: osnseminit: cannot create semaphore set<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast driver failed to get a semaphore set.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0The system-imposed limit on semaphores or semaphore identifiers may have been exceeded. Read the returned operating system error code and check with your system administrator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02722: osnpui: cannot send break message to orapop<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Pipe driver could not send a break message to orapop.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02723: osnpui: cannot send break signal<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Pipe driver could not send a break message to the ORACLE shadow process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02724: osnpbr: cannot send break message to orapop<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Pipe driver could not send a break message to orapop.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02725: osnpbr: cannot send break signal<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Pipe driver could not send a break message to the ORACLE shadow process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Kill system call failed. Check errno and contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02726: osnpop: access error on oracle executable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Pipe driver could not access the oracle executable.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the permissions on the ORACLE executable and each component of the ORACLE_HOME\/bin path.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02727: osnpop: access error on orapop executable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Pipe driver could not access the orapop executable.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the permissions on the orapop executable and each component of the ORACLE_HOME\/bin path.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02728: osnfop: access error on oracle executable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast driver could not access the oracle executable.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the permissions on the ORACLE executable and each component of the ORACLE_HOME\/bin path.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02729: osncon: driver not in osntab<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The driver you have specified is not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check with your database administrator which drivers are supported.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02730: osnrnf: cannot find user logon directory<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The driver you have specified could not find your logon directory while searching for your local .sqlnet file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Set and export the HOME environment variable to identify your home directory. Check with your system administrator to make sure that your uid and home directory are correct in the \/etc\/passwd file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02731: osnrnf: malloc of buffer failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified driver could not find enough heap space to malloc a buffer.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02732: osnrnf: cannot find a matching database alias<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Database alias specified was not identified in either $HOME\/.sqlnet or \/etc\/sqlnet.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create the alias in a file called .sqlnet in your home directory for personal use or ask your system administrator to create the alias in \/etc\/sqlnet for system-wide use.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02733: osnsnf: database string too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0While converting a database alias to a database ID, the resulting database ID string exceeded the ORACLE system-imposed limit.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02734: osnftt: cannot reset shared memory permission<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast driver was unable to reset shared memory permissions.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02735: osnfpm: cannot create shared memory segment<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast driver failed to create a shared memory segment for two-task communication.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check whether the system-imposed limit on shared memory identifiers has already been reached for your system.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02736: osnfpm: illegal default shared memory address<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast driver failed to establish a default shared memory address.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02737: osnpcl: cannot tell orapop to exit<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Pipe driver failed to send orapop the command to exit.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02738: osnpwrtbrkmsg: incorrect number of bytes written<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The pipe driver apparently sent an imcomplete break message.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02739: osncon: host alias is too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The alias used for a sqlnet host is longer than 161 characters.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a shorter alias.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02750: osnfsmmap: cannot open shared memory file ?\/dbs\/ftt_<pid>.dbf<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast driver failed to create a shared memory file for two-task communication.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the permissions on the directory ?\/dbs<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02751: osnfsmmap: cannot map shared memory file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast driver failed to map a shared memory file for two-task communication.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02752: osnfsmmap: illegal shared memory address<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast driver failed to attach shared memory at the expected location.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02753: osnfsmmap: cannot close shared memory file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast driver cannot close the shared memory file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02754: osnfsmmap: cannot change shared memory inheritence<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast driver could not alter the inheritence attributes of the shared memory.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02755: osnfsmcre: cannot create chared memory file ?\/dbs\/ftt_<pid>.dbf<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast driver failed to create a file for shared memory.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the permissions on the directory ?\/dbs<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02756: osnfsmnam: name translation failure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast driver encountered an error translating the shared memory filename ?\/dbs\/ftt_<pid>.dbf.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02757: osnfop: fork_and_bind failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Fast driver failed to fork a process onto the desired cluster and node number.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the desired node number in sercose[0] and cluster ID in sercose[1]. If these seem valid, contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02758: Allocation of internal array failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The package was unable to allocate memory for an array because the system ran out of memory.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either reclaim memory by killing other processes or reboot the machine with more memory.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02759: Not enough request descriptors available<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0All of the package’s request descriptors are in use performing other requests.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either wait until enough requests are done, or shut the package down and re-initialize it with more request descriptors.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02760: Client close of file failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The client was unable to close a file after forking the servers.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is a system problem – contact your System Administrator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02761: File number to be canceled is negative.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The file number contained with the sfiov structure is less than zero.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This may be a programming error. If it is not, contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02762: file number to be cancelled is greater than the maximum.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The file number contained with the sfiov structure is greater than the maximum.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This may be a programming error. If it is not, contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02763: Unable to cancel at least one request<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0No requests were found that could be cancelled.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This error can occur if all the requests dealing with that file number have already been filled.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02764: Invalid package mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The mode of the package can only be parallel or duplex.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See sfa.h for the correct values.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02765: Invalid maximum number of servers<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The number of servers given was less than or equal to zero.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a number greater than zero.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02766: Invalid maximum of request descriptors<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The number of request descriptors was less than or equal to zero.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a number greater than zero.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02767: Less than one request descriptor was allocated per server<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The package requires that the number of request descriptors be greater than or equal to the number of servers used.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a higher number<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02768: Maximum number of files is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The maximum number of files to be used by the package was less than or equal to zero.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02769: Setting of handler for SIGTERM failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The package was unable to set up handling by the server for the termination signal. This is an internal error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02770: Total number of blocks is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The total number of blocks to be allocated for use by the package was not greater than zero.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02771: Illegal request time out value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The number was not a positive number.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02772: Invalid maximum server idle time<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The time given was not a positive number.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02773: Invalid maximum client wait time<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The time given was not a positive number.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02774: Invalid request list latch time out value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The time given was not a positive number.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02775: Invalid request done signal<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The signal number was not a positive number.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02776: Value for request done signal exceeds maximum<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The value sent to the package for use as the “request done” signal exceeds the maximum allowed by the operating system.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02777: Stat failed on log directory<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The package was unable to get information about the directory in which the log files are to reside.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the permissions on the directory or use a different directory name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02778: Name given for the log directory is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The name given for the directory in which the logs are to be kept does not correspond to a directory.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a different name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02779: Stat failed on core dump directory<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The package was unable to get information about the directory into which the servers are to dump core in the event of an exception.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the permissions on the directory or use a different directory name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02780: Name given for the core dump directory is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The name given for the directory in which the server processes are to dump core in the event of an exception does not correspond to a directory.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a different name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02781: Invalid value given for the timing wanted flag<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The value given was not TRUE or FALSE.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02782: Both read and write functions were not specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0To ensure that the functions act symmetrically, pointers to both the read and write functions must be given.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either specify both functions or specify neither. The package will supply its own functions.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02783: Both post and wait functions were not specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0To ensure that the functions act symmetrically, pointers to both the posting and waiting functions must be given.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either specify both functions or specify neither. The package will supply its own functions.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02784: Invalid shared memory ID specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The ID of the segment specified for use as the shared buffer region was invalid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a different ID, or let the package specify its own.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02785: Invalid shared memory buffer size<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The size given for the shared memory segment to be used as the shared buffer region was less than or equal to zero.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02786: Size needed for shared region is greater than segment size<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The size of the shared segment that was specified for the shared buffer region is less than the number of bytes required. The first field of the “additional information” field is the size needed. The second is the size of the segment.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a larger size segment or let the package allocate its own.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02787: Unable to allocate memory for segment list<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The package cannot allocate memory for an internal segment list because the system has run out of memory. The “additional information” field is the amount of memory that the package attempted to allocate.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02788: Unable to find kernel process pointer in async process array<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal error – Contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02789: Maximum number of files reached<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The maximum number of files that can be used for asynchronous I\/O has been reached.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Shut down the servers and re-initialize the package with a higher number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02790: File name is too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The length of the name of a file that is being opened for asynchronous I\/O is longer than the maximum. The “additional information” field is the maximum length.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a shorter name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02791: Unable to open file for use with asynchronous I\/O<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The package could not open file for some reason.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the file name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02792: Unable to fstat() a file being used for asynchronous I\/O.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The fstat(2) call on a file being used for asynchronous I\/O failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the file name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02793: Close of asynchronous I\/O failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The client was unable to close a file being used for asynchronous I\/O.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact ORACLE support – this should not happen.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02794: Client unable to get key for shared memory<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The client was unable to get a key so that it obtain shared memory for use with shared memory.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact ORACLE support – this is an internal error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02795: Request list is empty<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The client was signalled by a server that it was done with a request but the “done” list was empty.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error – contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02796: Done request is not in correct state<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A request is not in the right state.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error – contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02797: No requests available<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0No free request descriptors are available.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Wait until some requests are filled and then retry the request, or shutdown the servers and initialize the package with a higher number of requests.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02798: Invalid number of requests<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The number of operations sent to either sfard() or sfawrite() is less than zero.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is a user programming error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02799: Unable to arm signal handler<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The arming of a signal handler for the “done” signal failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error – contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02800: Requests timed out<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Some of the requests for asynchronous input or output were not serviced in the required amount of time.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If the load on the system is high, it is possible that the timeout limit is too low. Reset it with sfainit(). If the server processes are dying due to unexpected signals, this is an internal error, and ORACLE support should be contacted.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-02700 to ORA-02800 ORA-02700: osnoraenv: error translating ORACLE_SID Cause:\u00a0Two-task driver could not find the value of ORACLE_SID in the environment. Action:\u00a0Make sure that the ORACLE_SID environment variable has been properly set and exported. ORA-02701: osnoraenv: error translating oracle image name Cause:\u00a0ORACLE_HOME environment variable not set. Action:\u00a0Make sure…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1750","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-se","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1750","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1750"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1750\/revisions"}],"predecessor-version":[{"id":1751,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1750\/revisions\/1751"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1750"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}