|
|
| Re: ORA-12203: TNS:unable to connect to destination.... [message #242731 is a reply to message #242729] |
Mon, 04 June 2007 22:48   |
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.....
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
Hello all,
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. 
