OraFAQ Forum: Forms » Forms6i ORA-12203

Home » Developer & Programmer » Forms » Forms6i ORA-12203

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Forms6i ORA-12203 [message #304681]

Thu, 06 March 2008 02:08

didiera
Messages: 134
Registered: 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
forms builder
2 I can connect and query in Toad any of the SIDs defined.
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 (e.g tnsping80 WM), it fails.
See screen dump attached.

please Help

regards,
Didier

Attachment: screenDump.JPG
(Size: 61.36KB, Downloaded 1109 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: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account 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
Messages: 134
Registered: 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: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account 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: 134
Registered: August 2007
Location: Mauritius

Senior Member

under c:\oracle\dev2000\NET80 (Forms installation)

i've got 1 under ADMIN and 1 under TNSAPI and 1 under ADMIN\SAMPLE

under c:\oracle\ora10g\product\10.2.0\db_1

i've got 1 under NETWORK\ADMIN, 1 under NETWORK\ADMIN\SAMPLE,

under win32/SQLNET/8_0_6_0_0-1181195/install/NET80/CLIENT

1 in the above folder and 1 under ../NET23/CLIENT

well I have not checked all actually because I now that the only ones concerning me are those under oracle installation (c:\oracle\ora10g\product\10.2.0\db_1) and forms (c:\oracle\dev2000\NET80)

Report message to a moderator

Re: Forms6i ORA-12203 [message #304879 is a reply to message #304873]

Fri, 07 March 2008 00:57

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Wrong. Give me a number.

David

Report message to a moderator

Re: Forms6i ORA-12203 [message #304884 is a reply to message #304681]

Fri, 07 March 2008 01:03

didiera
Messages: 134
Registered: August 2007
Location: Mauritius

Senior Member

If this might help you, below is an excerpt of my sqlnet for forms6i - it logs the network error when im trying to connect to SID EP

***********************************************************************
Fatal NI connect error 12203, connecting to:
 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.33.18)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=EP)(CID=(PROGRAM=C:\oracle\dev2000\BIN\ifbld60.EXE)(HOST=DIDS)(USER=Didier?AUGUSTIN))))

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 8.0.6.0.0 - Production
  Time: 07-MAR-08 10:46:44
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination
    ns main err code: 12538
    TNS-12538: TNS:no such protocol adapter
    ns secondary err code: 12560
    nt main err code: 508
    TNS-00508: No such protocol adapter
    nt secondary err code: 0
    nt OS err code: 0


***********************************************************************

- note, I have replaced the contents of tnsnames.ora for forms with the ifile tag pointing it to the one under my oracle installation

[Updated on: Fri, 07 March 2008 01:12]

Report message to a moderator

Re: Forms6i ORA-12203 [message #305078 is a reply to message #304884]

Sat, 08 March 2008 03:55

didiera
Messages: 134
Registered: August 2007
Location: Mauritius

Senior Member

David,

don't bother anymore with this. My last resort was to reinstall Forms and Reports. Now everything's back to normal and my first move was to make an image of my machine afterwards.
I just would like to say that this is a pitfall of Forms and Reports. They are really sensitive and sometimes they just go crazy for no apparent reason.

cheers anyway and...

have a beer, it's the week-end dude! Cool

Report message to a moderator

Previous Topic:	get_file_name problem
Next Topic:	Help Needed Regarding Calling a Crystal Report 8.5 with the parameter from developer 6i form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 22:02:55 CST 2025