Re: Problem connecting to 10g DB server after standing up on network

> Problem connecting to 10g DB server after standing up on network

Have a seat.

> We have since hardened the machine.

And apparently you did a good job of that.

> I am not able to connect to the database remotely (sqlplus, golden, toad, etc.).
> The error I receive is a ORA-12564: TNS:connection refused

Thanks for including the error message and including the OS and database server software version.

1. What error messagge does a tnsping return?
2. If you connect to the box via an ssh client, can you use sqlplus to connect bequeath (without going through the listener)? most likely you can as the firewall policy that was implemented via "hardening" will not likely affect bequeathed connections.
3. If you configure a loopback entry in the tnsnames.ora file (127.0.0.1) - does that support a connection? (most likely, yes).

For a remote connection, requesting a dedicated server session - a random unprivileged port is used - above 1024, below 65535. If the host-based firewall ruleset is such that those ports are not open for connections - then a dedicated server session will not be created and one or more error messages will be returned.

If you temporarily disable the host-based firewall - do you get a connection?

I am unfamiliar with Solaris.

-bdbafh Received on Thu Mar 09 2006 - 14:55:28 CST