Oracle Database Errors or Warnings from Error ORA-06111 to ORA-06120

SQLServerF1

 

ORA-06111: NETTCP: disconnect failure
Cause: Error occurred while closing a socket.
Action: Contact your customer support representative.
ORA-06112: NETTCP: invalid buffer size
Cause: The buffer size specified in the login string exceeds the allowed maximum (of 4096).
Action: Re-submit with valid buffer size.
ORA-06113: NETTCP: Too many connections
Cause: The maximum no. of concurrently open connections has been reached.
Action: Exit an application with an open connection which is no longer required.

ORA-06114: NETTCP: SID lookup failure
Cause: From the remote host’s SQL*Net TCP/IP server: the database SID, specified in the login (connect) string, was not recognized.
Action: Add the appropriate SID entry to the CONFIG.ORA file on the remote host (and restart the SQL*Net TCP/IP server).
ORA-06115: NETTCP: unable to create ORACLE logicals
Cause: The host’s SQL*Net TCP/IP server was unable to create the necessary logicals required by the ORACLE server process. See the SQL*Net TCP/IP server log file for more details.
Action: Contact your system administrator.
ORA-06116: NETTCP: unable to create ORASRV process
Cause: The host’s SQL*Net TCP/IP server was unable to create the ORACLE server process. See the SQL*Net TCP/IP server log file for more details.
Action: Contact your system administrator.

ORA-06117: NETTCP: unable to create ORASRV: quota exceeded
Cause: The host’s SQL*Net TCP/IP server was unable to create the ORACLE server process because of quota depletion.
Action: Increase quota allocations to the SQL*Net TCP/IP server process.
ORA-06118: NETTCP: unable to complete handshake with ORASRV
Cause: The ORACLE server process was started but failed to complete its initialization.
Action: Contact your customer support representative.
ORA-06119: NETTCP: spurious client request
Cause: The host’s SQL*Net TCP/IP server was unable to recognize this connection request. See the SQL*Net TCP/IP server log file for more details.
Action: Contact your customer support representative.
ORA-06120: NETTCP: network driver not loaded
Cause: The TCP/IP network driver is not loaded.
Action: Check that the TCP/IP driver is loaded correctly.

Above are list of Oracle Database Errors or Warnings from Error ORA-06111 to ORA-06120 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

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