Oracle Tns Error List
Contents |
Improper standard input connection from the terminal. Action: Normally not visible to the user. Start the INTCTL program again. If the error error ora-12154 tns could not resolve the connect identifier specified persists, contact Oracle Support Services. TNS-00002 INTCTL: error while starting the
Ora-12154 Tns Could Not Resolve Service Name
Interchange Cause: The Interchange could not be started. Action: Check the Interchange configuration files (INTCHG.ORA, TNSNET.ORA and ora-12154 tns could not resolve the connect identifier specified windows 7 TNSNAV.ORA) for errors and confirm that no other programs are using the ADDRESS(es) specified. If the error continues, turn on tracing in the Interchange components and examine the tns could not resolve the connect identifier specified odbc trace files to determine the cause of the problem. Be sure to turn tracing off when the problem has been resolved. TNS-00003 INTCTL: error while sending request to the Interchange Cause: Improper command sent to the Interchange or the Interchange is not responding. This message is not normally visible to the user. Action: Verify that the command
Tns Could Not Resolve The Connect Identifier Specified Sqlplus
sent to the Interchange is valid. Also check that the Interchange is running by using the INTCTL STATUS command. If necessary, start the Interchange using the INTCTL START command. TNS-00004 INTCTL: error while starting the Navigator Cause: The Navigator could not be started. Action: Check to make sure that executables for the Navigator (NAVGATR) are present in the Oracle executable directory on your platform. Check the configuration files TNSNET.ORA and TNSNAV.ORA for errors. If the error continues, turn on tracing in the Interchange components and examine the trace files to determine the cause of the problem. Be sure to turn tracing off when the problem has been resolved. TNS-00005 INTCTL: error while sending request to the Navigator Cause: The Navigator is not responding. Either the Navigator is not running or another process is responding. Action: Check that the Navigator is running by using the STATUS command of the Interchange Control Utility. Verify that the correct addresses are listed in the TNSNAMES.ORA, TNSNET.ORA, and TNSNAV.ORA configuration files. TNS-00006 INTCTL:
errors occur. Evaluating this information will help you to diagnose and troubleshoot even the most complex network problems. This chapter describes common network errors and outlines procedures asp.net ora-12154: tns:could not resolve the connect identifier specified for resolving them. It also describes methods for logging and tracing error tns could not resolve the connect identifier specified oracle 10g information to diagnose and troubleshoot more complex network problems. This chapter contains these topics: Diagnosing Net Services Resolving the
Ora-12154 Tns Could Not Resolve Service Name Oracle 11g
Most Common Error Messages for Oracle Net Services Troubleshooting Tips from the Field for Oracle Net Services Troubleshooting the TNS-12154 Error Troubleshooting Network Problems Using Log and Trace Files Logging Error http://docs.oracle.com/cd/B10500_01/server.920/a96525/tnsus.htm Information for Oracle Net Services Tracing Error Information for Oracle Net Services Contacting Oracle Support Services Diagnosing Net Services If an attempt to make a basic peer-to-peer (single protocol network) connection returns an ORA Error, this section may help you diagnose the cause of the problem. Any underlying fault, noticeable or not, is reported by Net Services with an error number https://docs.oracle.com/cd/B19306_01/network.102/b14212/troublestng.htm or message that is not always indicative of the actual problem. This section helps you determine which parts of Net8 Services do function properly rather than the parts that do not work. It also helps you to decide in which of the following categories the fault belongs: Oracle software Operating system layer Other network layers Testing the various network layers progressively should in most cases uncover any problem. Server Diagnostics Note: You may need assistance from your server administrator to follow the instructions in this section. Answer the following questions: Is any other system (workstation/server) able to connect to the server using Net8? Has the server, database, or listener configuration remained the same for some time? If you answered YES to any of the preceding questions/statements, then skip this section and continue to "Client Diagnostics". If you are unsure, or answered NO to any of the preceding questions, then continue. Diagnosing Net8 Services on the server involves the following tasks: Task 1: Verify the Database Is Running Task 2: Perform a Loopback Test Task 1: Verify the Database Is Running To check that the
to 00999) Listener Error Messages (TNS-01000 to 02500) NA Internal Messages (TNS-02501 to 03500) OSN Error Messages (ORA-12150 to 12195) NR Error Messages (ORA-12196 to 12285) TNS Listener Error Messages (ORA-12500 to https://docs.oracle.com/cd/A57673_01/DOC/net/doc/NWTR23/ch6a.htm 12530) NS Error Messages (ORA-12531 to 12629) NA Error Messages (ORA-12630 to 12699) http://www.oracle.com/pls/db92/db92.error_search?prefill=ORA- 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 could not 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 could not resolve "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 Interchange Control Utility (NR) Error Messages (TNS-00001 to 00099) TNS-00001 INTCTL: error while getting command line from the terminal Cause:Improper standard input connection from the terminal. Action:Normally not visible to the user. Start the INTCTL program again. If error persists, contact Worldwide Customer Support. TNS-00
and other troubleshooting information in these books. List of Message Types ORA-00000 to ORA-00899 ORA-00900 to ORA-01499 ORA-01500 to ORA-02099 ORA-02100 to ORA-04099 ORA-04100 to ORA-07499 ORA-07500 to ORA-09857 ORA-09858 to ORA-12299 ORA-12300 to ORA-12399 ORA-12400 to ORA-12699 ORA-12700 to ORA-19399 ORA-19400 to ORA-24279 ORA-24280 to ORA-29249 ORA-29250 to ORA-32799 ORA-32800 to ORA-32999 ORA-33000 to ORA-65535 BFILE-Related Messages (LFI) DBNEWID Messages (NID) DBVERIFY Messages (DBV) Export Messages (EXP) External Naming Messages (NNF) External Tables Messages (KUP) Import Messages (IMP) interMedia Audio Messages (AUD) interMedia Image Messages (IMG) interMedia Video Messages (VID) Network Security Messages (NZE) Object Type Translator Initialization Messages (O2I) Object Type Translator Type File Messages (O2F) Object Type Translator Unparser Messages (O2U) Oracle Names Client Messages (NNC) Oracle Names Control Utility Messages (NNL) Oracle Names Server Messages (NNO) Oracle Names Server Network Presentation Layer Messages (NPL) Oracle Net Messages (TNS) Oracle OLAP Catalog Metadata Messages (AMD) Oracle Text Messages (DRG) Oracle Trace Collection Services Messages (EPC) Parameter Messages (LCD) Parameter Messages (LRM) PCF FIPS Messages (PCF) PL/SQL and FIPS Messages (PLS) Pro*C/C++ Messages (PCC) Pro*COBOL Messages (PCB) Recovery Manager Messages (RMAN) Remote Operation Messages (NCR) Simple Network Management Protocol Messages (NMP) SQL Runtime Messages (SQL) SQL*Module Messages (MOD) Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM) XML Parser Messages (LPX) XML Schema Processor Messages (LSX) Copyright © 2016, Oracle. All rights reserved.