Remote Access ORACLE database

From: Raymond Wong <raymond.wong_at_hk.origin-it.com>
Date: 2000/07/29
Message-ID: <8lsar9$pff1@imsp212.netvigator.com>#1/1

Dear all,

I got a problem and hope that you guys would kindly help.

I have installed ORACLE 8i on my NT workstation (hostname = ntwkstat). I set up the TNSNAME.ORA so that the Global DB Name is oracle.ntwkstat. Then I started the database using DBA Studio and then started the listener (lsnrctl start).

Then I installed Developer 2000 on the same machine. Since the ORACLE_HOME is different, I copied the session "oracle.ntwkstat = ...." to the TNSNAMES.ORA in developer 2000. I used SQL*Plus to test it and it runs fine.

However, when I installed ORACLE 8i Client on my notebook and copied the same session of TNSNAMES.ORA to the Client's TNSNAMES.ORA, it didn't work. SQL*Plus just report ORA-12535 TNS: operation timed out.

What's the problem?? Received on Sat Jul 29 2000 - 00:00:00 CDT