Database Administration (MOSC)

MOSC Banner

ORA-03135 trying to connect to one database

edited Dec 20, 2009 2:51PM in Database Administration (MOSC) 2 commentsAnswered
Hi,

I have about 20 databases on my server.

When I want to connect to the databasse AXWAYI, I receive the following error :

[oracle@devdmzsrs ~]$ sqlplus system/xxx@AXWAYI

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Dec 18 09:30:54 2009

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

ERROR:
ORA-03135: connection lost contact 

The connections to the others databases work.

I have no firewall and no sqlnet.ora file. There is no error in the alert.log.

When I try to connect as sysdba, the sqlplus command hangs.

So, I killed my sysdba connection with kill -9. But the connection didn't kill and I received the message "coonected" and the SQL prompt appeared. So, I restarted the database. Now it's OK.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center