Oracle 11g Error Codes and Solution Suggestions from ORA-02700 to ORA-02800

Posted on by Fatih Acar

Oracle 11g Error Codes and Solution Suggestions from ORA-02700 to ORA-02800

ORA-02700: osnoraenv: error translating ORACLE_SID
Cause: Two-task driver could not find the value of ORACLE_SID in the environment.
Action: Make sure that the ORACLE_SID environment variable has been properly set and exported.
ORA-02701: osnoraenv: error translating oracle image name
Cause: ORACLE_HOME environment variable not set.
Action: Make sure that the ORACLE_HOME environment variable has been properly set and exported.
ORA-02702: osnoraenv: error translating orapop image name
Cause: ORACLE_HOME environment variable not set.
Action: Make sure that the ORACLE_HOME environment variable has been properly set and exported.
ORA-02703: osnpopipe: pipe creation failed
Cause: The pipe driver failed to create pipes for communications with the orapop process.
Action: You 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.
ORA-02704: osndopop: fork failed
Cause: The two-task driver could not fork orapop.
Action: Verify 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.
ORA-02705: osnpol: polling of communication channel failed
Cause: The pipe driver failed while polling the communications channel.
Action: Contact your customer support representative.
ORA-02706: osnshs: host name too long
Cause: The length of your host-string specified by the TWO_TASK environment variable exceeds the ORACLE system-imposed limit.
Action: Contact your customer support representative.

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

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.