Oracle DB: 11.2.0.1.0 on Linux x86
I've just installed a database patch, which seems to have gone well. A pre-requisite for this was shutting down the database.
Following install, I restarted the database but now cannot connect to it unless I'm connecting internally.
When I attempt to connect normally, I get this:
sqlplus ray@bvclone
SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 9 16:04:12 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12537: TNS:connection closed
I've looked at a number of threads on this, none of which seem to help.
Both tnsnames.ora and listener.ora are looking at the same port (1521)
The only clue I have is that tnsping gives different results when run as different users:
As oracle on Linux:
tnsping bvclone
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = atlas)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = bvclone)))
OK (0 msec)
As myself on Linux:
tnsping bvclone
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 09-NOV-2011 16:09:51
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=nn.nnn.nn.nnn)(PORT=1521)))
TNS-12535: TNS:operation timed out
I can see that the service name is missing, which suggests I'm missing something blindingly obvious here....any thoughts on what this could be would be much appreciated.
Thanks,
Ray
Edited by: 896276 on 09-Nov-2011 08:22
Edited by: 896276 on 09-Nov-2011 08:22