[Spacewalk-list] lots of tracebacks with 1.3 server

[Jan Pazdziora]

On Thu, Mar 10, 2011 at 10:13:51AM -0500, jason at monsterjam.org wrote:
> I keep getting this a lot and im not sure why.. 

[...]

> SQLConnectError: (12170, 'ORA-12170: TNS:Connect timeout occurred\n', '//slaughterhouse.mydomain.com:1521/spwalk.mydomain.com', 

12170, 00000, "TNS:Connect timeout occurred"
// *Cause:  The server shut down because connection establishment or
// communication with a client failed to complete within the allotted time
// interval. This may be a result of network or system delays; or this may
// indicate that a malicious client is trying to cause a Denial of Service
// attack on the server.
// *Action: If the error occurred because of a slow network or system,
// reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT,
// SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values.
// If a malicious client is suspected, use the address in sqlnet.log to
// identify the source and restrict access. Note that logged addresses may
// not be reliable as they can be forged (e.g. in TCP/IP).

Generally, your Oracle database does not seem to be available.

Did this work in the past? Is this fresh installation or upgrade?
Does tnsping work?

You might want to ask your DBA to help you troubleshoot this -- maybe
the database server is just down for maintenance?

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat