local connection is ok but times out in client
junjie_2Sep 16 2008 — edited Sep 23 2008Haroo there!
I setup a Oracle 9i server as a dummy database in my work pc (see specs below) where I do programming in .NET. I've been using it for several months now and never had a problem connecting to it through isqlplus or our programs run in my pc.
Lately, I tried to setup a client pc that will connect to my dummy database. I installed the OraClient, setup the service name of our real database and successfully connected to it.
Then I add my dummy database in the service names but the test connection failed. I finished the setup ignoring the error.
dummy database name: burabod
my pc name: kurasmag
Troubleshooting:
- ping kurasmag from the client works
- tnsping both database works (both from the server and from the client)
- port 1521 TCP is an exception in kurasmag's windows firewall.
Please help.
Thanks.
Junjie
-----
Additional info:
These are the oracle services that is present in my PC at work. I manually turned them on because it cost a lot of time at windows startup.
!http://images.haroopotter.multiply.com/image/4/photos/4/600x600/1/burabod.jpg?et=ejx0RkZyLonaxyo3Paf5Dg&nmid=115873170!
------------
Windows XP Prof SP3
Intel P4 2GHz 1Gb RAM
NVidia GeForce4 MX4000
Edited by: junjie2 on Sep 17, 2008 12:54 PM