Oracle Network Products Troubleshooting Guide

CHAPTER 6. Networking Error Messages

This chapter lists the error messages that may be returned by the following Oracle network components:

SQL*Net release 2.0 and later

client

server

listener

MultiProtocol Interchange release 2.0 and later

Connection Manager

Pump

Navigator

MultiProtocol Interchange Control Program

Transparent Network Substrate (TNS)

Oracle Protocol Adapters

Secure Network Services

Native Naming

Oracle network product error messages are identified by two prefixes. The first prefix is "ORA-" and the other is "TNS-." Error messages beginning with the "ORA-" prefixes are generated by the Oracle Server and other Oracle utilities. The error numbers within the range from 12150 through 12629 are network related errors, and these errors contain text that begins with "TNS:" Error messages from 12630 through 12699 are generated by Secure Network Services.

Please consult the appropriate documentation for detailed information on other "ORA-" prefixed errors outside this range. For more information on the error message prefixes, please refer to Chapter 1, "Coping with Error Messages."

Table 3-1 shows the networking software components that generate error messages with "ORA" or "TNS"prefixes.

Table 6 - 1. Error Message Prefix, Numbers, and Components

Prefix Error Number Component Type of Error
TNS 1 to 500 NR (routing) MultiProtocol Interchange
TNS 501 to 1000 NT (transport) Protocol Adapter
TNS 1001 to 1500 Listener Control Program Listener Control Program
ORA/TNS 12150 to 12195 SQL*Net Oracle SQL*Net
ORA/TNS 12196 to 12285 NR (routing) TNS
ORA/TNS 12500 to 12530 Listener Listener to client
ORA/TNS 12531 to 12629 NS (session) TNS
ORA 12630 to 12699 NA Native Services

*Prefix*	*Error Number*	*Component*	*Type of Error*
TNS	1 to 500	NR (routing)	MultiProtocol Interchange
TNS	501 to 1000	NT (transport)	Protocol Adapter
TNS	1001 to 1500	Listener Control Program	Listener Control Program
ORA/TNS	12150 to 12195	SQL*Net	Oracle SQL*Net
ORA/TNS	12196 to 12285	NR (routing)	TNS
ORA/TNS	12500 to 12530	Listener	Listener to client
ORA/TNS	12531 to 12629	NS (session)	TNS
ORA	12630 to 12699	NA	Native Services