SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-25-2008, 02:57 AM
| ||||
| ||||
 Problem connecting to 10g DB server after standing up on network I installed a 10g R2 database on a standalone Solaris 9 box. We have since hardened the machine, and have put it up on the network. Since putting it up, 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 I have checked my tnsnames, listener.ora, and other config files -- nothing appears to be awry. Could this issue be connected to the fact that the box did not have a FQDN when I installed. If so, is there a way that I can remedy the issue now, or would it require a re-install? Your help is appreciated.... //NC      |
|
02-25-2008, 02:57 AM
| ||||
| ||||
| 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 |
Linear Mode
