Re: TNS Protocol Adapter Error (Oracle 9i) - Urgent

saurabhgarg2k_at_gmail.com wrote:
> Can it be something related to firewall settings, as the server has
> just been hardened two days back, or if can be any port blocking or
> something

Yes, quite likely if that is the case.

To test use telnet. Open a command shell and telnet to the Oracle server IP address on port 1521, e.g.
C:\> telnet 196.168.0.100 1521

If you do not get a connection, it means that the server on that port is not reachable from that local machine.

--
Billy