Solved

Ora-12203 error

Posted on 1998-12-18
1
1,365 Views
Last Modified: 2012-08-14
This seems tobe an TNS error.  What does it mean? (Ora-12203) and how can it be fixed?
0
Comment
Question by:sandrapei
1 Comment
 
LVL 3

Accepted Solution

by:
poncejua earned 100 total points
ID: 1083415
The ORA-12203/TNS-12203 error message means:    
  "TNS:unable to connect to destination"    
This message can be displayed for a variety of reasons.    
1) An invalid TNS service name was supplied in the connect string.    
   Verify that the TNS service name supplied in your connect string exists in your TNSNAMES.ORA file.  Also verify that the ADDRESS information for that TNS service name is valid.    
    a) Is the HOST or SERVICE name correct?  
    b) Is the PORT specified correct?    
2) The destination system's listener is not listening. Verify that the remote system's SQL*Net listener is running and that the instance is started.    
3) There may be underlying network transport problems.    
   Verify with utilities supplied with the networking protocol being used that the protocol itself is functional. For esample, with TCP/IP, try PINGing the remote system.    
4) TNSNAMES.ORA file is not in the %ORACLE_HOME%\NETWORK\ADMIN directory.    
   Make sure the Windows workstation has its TNSNAMES.ORA file located in  the directory specified by: %ORACLE_HOME%\NETWORK\ADMIN    
   The %ORACLE_HOME% string should be replaced with the value that is present in your workstation's ORACLE.INI parameter named ORACLE_HOME.    
   If your workstation's ORACLE.INI file has a parameter named TNS_ADMIN, make sure that the TNSNAMES.ORA file is located in the directory pointed to by the TNS_ADMIN parameter.    
5) Make sure the Oracle Protocol adapter for the selected networking protocol is installed.    
   For 16-bit, the %ORACLE_HOME%\BIN directory should have the following  files for each protocol:        
TCP/IP:   NTT.DLL       SPX:      NTS.DLL  
DECNET:   NTD.DLL    
   For 32-bit, the %ORACLE_HOME%\BIN directory should have the following  files for each protocol:        
TCP/IP   :   NTTNT.DLL  
SPX      :   NTSNT.DLL      
NamedPipe:   NTNNT.DLL    
   A missing protocol adapter driver will usually produce the following errors in the SQLNET.LOG and or any client trace file:    
TNS-12203  
TNS-12538        
TNS-00508    
6) Make sure any Oracle Interchanges (if any) used for this connection  are running.    

7) Ensure that the (HOST=tcpiphostname) for TCP/IP and  
   (SERVICE=spxservicename) for SPX are the the same on the server and client  workstations.    
   This assumes a global knowledge and usage of the same TCP/IP hostname on  the server and client workstations.    
   For TCP/IP setups, make sure that the HOST parameter in the LISTENER.ORA on the server and the TNSNAMES.ORA file on the client point to the same name, or at least to names that are then translated to the same IP  address by each system.  This is especially important for servers with  multiple IP addresses assigned to the various network interfaces on the  server.    
   For SPX setups, the name must be the same on the server and client  workstations.    
8) When using the V2 APPC Adapter for Windows, the alias descriptor in the tnsnames.ora file should have the value for PLU_LA always in upper case or a TNS-12203 will result.  This is irrespective of the case used in the SIDEINFO.NSD file for the symbolic destination name. For example:    
    os2=         (DESCRIPTION=            
(ADDRESS=(PROTOCOL=LU62)  
(PLU_LA=os2)))          
will result in a TNS-12203 error.  
    os2=         (DESCRIPTION=            
(ADDRESS=(PROTOCOL=LU62)  
(PLU_LA=OS2)))  
    will connect fine; where os2 or OS2 is defined as the SYMBOLIC DESTINATION NAME in the SIDEINFO.NSD file.      
9)  When using the V2 NETBIOS Adapter 2.1.4.1.3 for Windows, and getting  either an ORA-12203 or ORA-12224, reference BUG #301274 and #302380 for  the following patch:    
      Patch 378:  NETBIOS Protocol Adapter V2.1.4.1.4 Windows.  This patch will fix BUGS # 301274 and 302380.    
10) Each machine on the network must have a unique IP address.  If  there are multiple machines using the same IP address then the network will not know which address to send information packets to.  
    This will result in lost packets and maybe lost connections.    
11) Make sure that a ping of the host returns the same IP as the target host.  
    This may occur using RAS (Remote Access Server) on Windows NT. Upgrade NT v4.0 to service pack 3.  
12) ORA-12203 may occur with ORA-12571. If it does, replace the hostname in the HOST parameter of the client tnsnames.ora with the IP address:
      HOST = (111.11.22.11)        
Stop and start the listener on the server.  
    On Macintosh clients, go into the CONTROL PANEL -> TCP/IP and remove the Name server entries. Unlike PC's, Macintosh clients will use the host/ipaddress lookup server regardless if the (HOST = ipaddress) is  in the tnsnames.ora.  
13) Even if the configuration files appear correct, the listener may be starting with parameters from a checkpoint file with different information than the listener.ora. Remove the following parameter from the listener.ora:        USE_CKPFILE_LISTENER=TRUE  
14) There is also a bug on the USE_PLUG_AND_PLAY_LISTENER parameter (379247) that causes the listener to start on a random port number. Remove the following parameter from the listener.ora:  
      USE_PLUG_AND_PLAY_LISTENER=TRUE
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now