Fatal Ni Connect Error 12203 Oracle
Contents |
2008 02:08 didiera Messages: 134Registered: August 2007 Location: Mauritius Senior Member Hello, I cannot connect to an oracle database (remote) on Forms6i with error code ORA-12203 "TNS:Unable to connect to destination" while: 1 I have Identical tnsnames.ora files defined for Toad and oracle
Oracle Trace_level_client
forms builder 2 I can connect and query in Toad any of the SIDs defined. oracle listener log format 3 When I tnsping any given SID , it's ok (e.g tnsping WM) 4 When I tnsping80 the same SIDs from forms/bin dir oracle database error 12154: ora-12154: tns:could not resolve the connect identifier specified (e.g tnsping80 WM), it fails. See screen dump attached. please Help regards, Didier Attachment: screenDump.JPG (Size: 61.36KB, Downloaded 425 times) Report message to a moderator Re: Forms6i ORA-12203 [message #304813 is a reply to
Listener Completed Notification To Crs On Start
message #304681] Thu, 06 March 2008 16:56 djmartin Messages: 10180Registered: March 2005 Location: Canberra ACT Australia Senior MemberAccount Moderator Scan your PC for 'tnsnames.ora' and I think you will find that you have three copies. Search this forum for 'tnsnames' and 'ifile' or 'tns_admin'. I recommend the use of 'tns_admin'. David Report message to a moderator Re: Forms6i ORA-12203 [message #304851 is a reply to message #304681] Thu, 06 March 2008 23:26 didiera
Sqlnet.log Location
Messages: 134Registered: August 2007 Location: Mauritius Senior Member Thanks David I have actually been through my hard drive and compared all the tnsnames.ora files I've got. 1] I ultracompared all with the one for Toad and ensured they are identical (Toad is using the one under oracle_home...\..\NETWORK\ADMIN) 2] I have even checked the registry key tns_admin and it actually points to the version under oracle_home...\..\NETWORK\ADMIN directory. The problem remains the same and maybe you should know that server-side the SIDs have changed from 3 character to 2 character naming and my troubles started from there...I have updated all tnsnames files accordingly with the right name-value pairs for SERVICE_NAME part. I am still checking your suggestions on the forum posts but have not yet found a suitable workaround. Report message to a moderator Re: Forms6i ORA-12203 [message #304863 is a reply to message #304851] Fri, 07 March 2008 00:08 djmartin Messages: 10180Registered: March 2005 Location: Canberra ACT Australia Senior MemberAccount Moderator You say:I have actually been through my hard drive and compared all the tnsnames.ora files I've got. And how many did you find? David Report message to a moderator Re: Forms6i ORA-12203 [message #304873 is a reply to message #304681] Fri, 07 March 2008 00:19 didiera Messages: 134Registered: August 2007 Location: Mauritius Senior Member under c:\oracle\dev2000\NET80 (Forms installat
12203 & TNS 12560 - Any ideas... please help!!! If this is your first visit, be sure to check tns-03505 failed to resolve name out the FAQ by clicking the link above. You may have
Ora-12170: Tns:connect Timeout Occurred
to register before you can post: click the register link above to proceed. To start viewing messages, tns-12541: tns:no listener select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: TNS 12203 & TNS 12560 - Any ideas... http://www.orafaq.com/forum/t/98493/ please help!!! Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-03-2002,11:46 AM #1 Shyamis View Profile View Forum Posts Visit Homepage Member Join Date Mar 2002 Posts 142 Hi Gang, here is a copy of the error message http://www.dbasupport.com/forums/showthread.php?28981-TNS-12203-amp-TNS-12560-Any-ideas-please-help!!! in my SQLNET.LOG file. My application was working perfectly when I left on a vacation, I come back and there is a connection problem and this is the error message I get! Nobody has touched my server (or so they claim...) in the mean time. What could be the possible reason for this error and what should I check. I've already checked the Listener process, the tnsnames.ora file, the service and connections through SQL*Plus & Toad. All of the above seems fine. I've also checked the permissions for the Oracle_home and all subdirectories. The Oracle sid has no special characters. I can't think of any valid reason. Somebody please help! Also in my TNSNAMES.ORA the PROTOCOL is TCP and what I see in the log file is PROTOCOL=BEQ. Can somebody please throw some light on this!!! This is on Windows NT Server 4.0 (Terminal Server Edition) & Oracle 8.0.6.0.0 Fatal NI connect error 12203, connecting to: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESC RIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program Files\Jouve\AirGTI Task Manager Suite\Air
understanding and resolving network problems through the use of log and trace files. These files keep track of the interaction between network components as errors occur. Evaluating this information will help http://docs.oracle.com/cd/B10501_01/network.920/a96580/troubles.htm you to diagnose and troubleshoot even the most complex network problems. This chapter describes common network errors and outlines procedures for resolving them. It also describes methods for logging and tracing error information to diagnose and troubleshoot more complex network problems. This chapter contains these topics: Diagnosing Oracle Net Services Resolving the Most Common Error Messages for Oracle Net Services Troubleshooting Tips from fatal ni the Field for Oracle Net Services Troubleshooting Network Problems Using Log and Trace Files Logging Error Information for Oracle Net Services Oracle Net Services Tracing Error Information Contacting Oracle Support Services Diagnosing Oracle 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 fatal ni connect underlying fault, noticeable or not, is reported by Oracle Net Services with an error number or message that is not always indicative of the actual problem. This section helps you determine which parts of Oracle Net 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 Oracle Net? 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 Oracle Net Services on the server involves the following tasks: Task 1: Verify the Database Is Running Task