|
List Home > Databases > Oracle > [ Post New Problem ]
Welcome back !
| TrackingID : | 4799 |
| Posted : | Friday, July 22nd, 2005 11:08:14 PM |
| By : | juicyapple |
| unable connect to destination | Configuration: |
i run oracle form at Windows ME and try to connect to Oracle Database 9i on Windows XP but it prompts ORA-12203: unable connect to destination.
I have configure tnsname.ora at the client machine (windows ME) like below
mms_sys =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 10.1.1.13)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = oracle)
)
)
the server host is 10.1.1.13, and SID=oracle.
But why connection still fail? Can anyone help?
| Operating System : microsoft windows XP
|
Related Problems :
Comments :
Re: unable connect to destination by Anonymous Ghost on July 22nd, 2005 11:10:27 PM
I think the Firewall in Windows XP is blocking the incoming connection. |
Re: unable connect to destination by juicyapple on July 22nd, 2005 11:21:29 PM
firewall is turn off and i connect client on windows XP, it works well.. |
Re: unable connect to destination by juicyapple on July 22nd, 2005 11:35:03 PM
i know that oracle database can't be installed in Windows XP home edition and windows ME, then how if install oracle form on windows ME and connect to database on XP? |
Re: unable connect to destination by Anonymous Ghost on July 23rd, 2005 05:56:13 AM
See according to your other post, it seems that your Windows XP oracle is running on port 1062 and IP 10.1.1.183.
Try to connect to this IP and port number, that should be fine. |
Re: unable connect to destination by juicyapple on July 24th, 2005 06:44:52 AM
client machine running on windows XP on port 1062 and IP 10.1.1.183, when connection establish successfully to the server on port 1521 and IP 10.1.1.13, i can see the info inside listener.txt on server which is
(CONNECT_DATA=(SID=oracle)(CID=(PROGRAM=C:\\\\oracle\\\\oradev\\\\bin\\\\ifrun60.EXE)(HOST=CCSERVER1)(USER=NN))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.183)(PORT=1062)) * establish * oracle * 0
however, if connection request from client on Windows ME, message ORA-12203: unable to connect to destination prompt out.
What mistake i have made? What others configuration i have to do beside the tnsname? |
Re: unable connect to destination by juicyapple on July 24th, 2005 07:59:37 PM
i reinstalled oracle form developer and connect to server database, it works! However, it fails to load all the forms except the main form...
:< |
Related Problems :
List Home > Databases > Oracle > [ Post New Problem ] |
|
