RE: Oracle... one DB connects, one does not...

Don't think so... remember that both of the databases (one working and one not working) are on the same machine, though they are using a different port. What is also odd is that if the database is left up overnight, then it starts working.... if it's shutdown overnight it doesn't start working. We killed all the jobs (thinking it was the job scheduler) and that did not make a difference. We killed all CRON jobs, still nothing. No remote jobs are scheduled.

It's the darndest thing I've ever seen. Still a few more things to test here and there though.

RF

-----Original Message-----
From: Mladen Gogala [mailto:gogala_at_sbcglobal.net] Sent: Wednesday, July 19, 2006 6:32 PM
To: robertgfreeman_at_yahoo.com
Cc: oracle-l_at_freelists.org
Subject: Re: Oracle... one DB connects, one does not...

On 07/19/2006 01:08:22 PM, Robert Freeman wrote:
> All,
>
> I have a rather stange problem. I have a database on
> LINUX that we created. We then exported data from a
> VMS database and imported it to the Linux database. I
> can connect just fine in SQL*Plus... but our JDBC
> application is freezing up when trying to issue a
> query.
>
> What is *really* odd is:
>
> 1. After about 12 hours of inactivity, it starts
> working ok again. So something is getting reset. We
> have been trying to figure out what it might be, but
> we have yet to be able to do so.
>
> 2. We created another database, on the same box, with
> the same configuration, and imported the data again
> from the same dump file and we don't have the same
> problem.
>
> Any ideas???

Rob, it looks like some stupid SELinux or IP_Tables trick. Is something blocking you and enforcing some kind of idiotic security policy? Turn that off.

--
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l