> 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