Home » RDBMS Server » Server Administration » Not able to connect to DB in Redhat Linux - intermittent wired problem
Not able to connect to DB in Redhat Linux - intermittent wired problem [message #60178] Tue, 20 January 2004 20:22 Go to next message
Kumar
Messages: 115
Registered: December 1998
Senior Member
Hi,

I need some help from you if possible please help me. There is a wired problem in the Linux based Oracle server.

OS: Redhat Linux 8
Database: Oracle Enterprise server 9.2

There is an intermittent wired problem.

After some time (it happen twice last Saturday and Yesterday), either from application or from SQL Plus we are not able to connect it from outside. But we are able to connect to the oracle server on Linux server.

We checked the Listener status on the server and it was UP and running.

We can ping the server from outside.

We are not able to do an FTP from inside the server or from Outside to the Linux server.

During this time the http protocol is working we can upload any file to the other sites.

We tried to shutdown the oracle server and even we tried to restart the OS itself and not able to resole this issue.

If we create a new Listener and starts the server and all blocking thing were released and now working.

Currently we are monitoring the server at ALIF’s premises if it going to happen for the third time or not.

Thanks a lot
Regards

Kumar
Re: Not able to connect to DB in Redhat Linux - intermittent wired problem [message #60181 is a reply to message #60178] Wed, 21 January 2004 02:30 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
as per your posting,
the database cannot be reached from outside
but cann be reached from the local host.
did u use a tnsconnectstring to connect in the local host?
like
$sqlplus scott/tiger@localHost

and
are u having any sqlnet tracing enabled?
Previous Topic: Problem in connecting while Creating a Database
Next Topic: trust relationship
Goto Forum:
  


Current Time: Fri Sep 20 10:29:05 CDT 2024