Home » Developer & Programmer » Forms » ORA-12203: TNS:unable to connect to destination....
icon12.gif  ORA-12203: TNS:unable to connect to destination.... [message #242729] Mon, 04 June 2007 22:09 Go to next message
shyam.2384
Messages: 16
Registered: March 2007
Location: BHILAI
Junior Member
Laughing Hello all,

Cool I have installed oracle 8i enterprice edition. It has successfully installed and working properly but when i installed developer 6i then try to connect the error occured ORA-12203.

Cool I have read so many topics abt this problem in this forum but cant get solution..
How to configure listner and tnsname..

Cool so please give me solution to configure the listner step by step

Cool I am using Oracle 8i, Developer 6i and Operating System is windows 2000 server....

Re: ORA-12203: TNS:unable to connect to destination.... [message #242731 is a reply to message #242729] Mon, 04 June 2007 22:48 Go to previous messageGo to next message
yahya_mukhtar
Messages: 12
Registered: June 2007
Location: pakistan
Junior Member
hi ..
the problem is the oracle developer connectivity. go to developer folder where u install the developer .
find the NET80 folder if find then go to that folder there is admin flder find the file tnsnames.ora open that file into notepad. there is lot of lines there .
copy that lines that i send u.

Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = SID1)
)
)
and paste it at the end of the file.
there is some change in these lines. first of all remove the world "Example1.world" and use the SID that u write when u install the oracle.
then go to lines 7 remove the "Production1" and write the ip of the computer where u install the oracle. then go to line 11 remove the "SID1" and then use the SID that u define when u install the oracle that is host string......

save this file and enjoy.....
Re: ORA-12203: TNS:unable to connect to destination.... [message #242740 is a reply to message #242729] Mon, 04 June 2007 23:22 Go to previous messageGo to next message
shyam.2384
Messages: 16
Registered: March 2007
Location: BHILAI
Junior Member
Thanks for ur reply.....

i have installed oracle and developer in single system is this code working properly...


[Updated on: Mon, 04 June 2007 23:30]

Report message to a moderator

Re: ORA-12203: TNS:unable to connect to destination.... [message #242742 is a reply to message #242740] Mon, 04 June 2007 23:26 Go to previous messageGo to next message
yahya_mukhtar
Messages: 12
Registered: June 2007
Location: pakistan
Junior Member
hi
Cool yes the i send working in single as well as in the server.
Re: ORA-12203: TNS:unable to connect to destination.... [message #242743 is a reply to message #242742] Mon, 04 June 2007 23:31 Go to previous messageGo to next message
shyam.2384
Messages: 16
Registered: March 2007
Location: BHILAI
Junior Member
ok .. Thank u very much

I'll try it..
Re: ORA-12203: TNS:unable to connect to destination.... [message #242824 is a reply to message #242743] Tue, 05 June 2007 04:16 Go to previous messageGo to next message
ganesh_jadhav0509
Messages: 63
Registered: May 2007
Location: Chester
Member

u can configure or create new by useing net8 configuration

or check ip config of the system
Re: ORA-12203: TNS:unable to connect to destination.... [message #242828 is a reply to message #242824] Tue, 05 June 2007 04:23 Go to previous message
yahya_mukhtar
Messages: 12
Registered: June 2007
Location: pakistan
Junior Member
hi

plz explain ur question....

if u have a computer that is standalone then u use the
pc name instead of ip.

Previous Topic: 2 session from forms
Next Topic: call_form() can't work.thanks!
Goto Forum:
  


Current Time: Sun Dec 04 10:46:42 CST 2016

Total time taken to generate the page: 0.04318 seconds