connect error 12203
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: ora-12203 unable to connect to destination 1 I have Identical tnsnames.ora files defined for Toad and oracle forms builder
How To Resolve Ora-12203 Error2 I can connect and query in Toad any of the SIDs defined. 3 When I tnsping any given ora-12203 forms 6i SID , it's ok (e.g tnsping WM) 4 When I tnsping80 the same SIDs from forms/bin dir (e.g tnsping80 WM), it fails. See screen dump attached. please Help regards, Didier Attachment: screenDump.JPG ora-12203 tns unable to connect to destination oracle 8i (Size: 61.36KB, Downloaded 423 times) Report message to a moderator Re: Forms6i ORA-12203 [message #304813 is a reply to 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'
Ora-12203 Forms 6i Windows 7or '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 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
Problem(Abstract) The following error occurs when trying to connect to an Oracle database: DMS-E-GENERAL, A general exception has occurred during operation adi rollup patch 'attach database' ORA-12203 TNS unable to connect to destination OR DMS-E-GENERAL , error while trying to retrieve text for error ora 12203 a general exception has occurred during operation 'attach database' ORA-12203 error while trying to retrieve text for error
Ora-12203 Oracle 11gORA-12203 ORA-12545 - TNS name lookup failure Fatal OSN connect error 12203 Resolving the problem This message indicates that the client is not able to find the desired database. This http://www.orafaq.com/forum/t/98493/ error often is reported because the destination node is not available or because of unrelated network problems.1. Make sure that NetTest or SQLPlus is able to make a connection successfully.2. Ensure that the correct connect string is being used - check this in the TNSNAMES.ora file. Look at the TNSNAMES.ORA file to see that the ADDRESS parameters in the connect descriptor http://www.ibm.com/support/docview.wss?uid=swg21348889 for the service name are correct.3. Confirm that a ping from the DOS prompt has the correct IP address. If the tnsping does not find the host then there is a problem with the TNSNAMES.ORA file E.G: wrong location or incorrect name in the connection. Please contact your Oracle DBA.In the Orawin95\bin there is an EXE called TNSPING.EXE to us this at the DOS prompt type.tnsping
12203 & TNS 12560 - Any ideas... please help!!! If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to http://www.dbasupport.com/forums/showthread.php?28981-TNS-12203-amp-TNS-12560-Any-ideas-please-help!!! register before you can post: click the register link above to proceed. To start viewing messages, 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... please help!!! Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to unable 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 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 unable to connect 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 188.8.131.52.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\Airgtitm.exe)(HOST=JOUVE2)(USER=WilsonPl)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 184.108.40.206.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 220.127.116.11.0 - Production Time: 12-AUG-02 11:43:05 Tracing not turned on. Tns error struct: nr err code: 12203 TNS-12203: TNS:unable to connect to destination ns main err code: 12560 TNS-12560: TNS:protocol adapter error ns secondary err code: 0 nt main err code: 530 TNS-00530: Protocol adapter error nt secondary err code: 0 nt O