What am I doing wrong with remote oracle database connections?
901652Dec 2 2011 — edited Dec 2 2011I'm a newbie to Oracle Database so keep that in mind.
I just installed Oracle Database 11.2.0.1.0 on a Linux system; I know it's running as I can log in and query the database.
Also, I'm pretty sure the listener is working, because I can see that it's listening on TCP port 1521 (0.0.0.0:1521).
I'm trying to connect to it from a Windows machine. I've installed the Oracle Database Client software version 11.2.0.2.0. I'm assuming I installed it correctly because it lets me use the command line tools. I am assuming the slight version difference shouldn't be an issue for simple tasks.
From Windows, when I run "sqlplus [username]/[password]@[hostname.of.database.server]/DB11G", I get the following:
--------------------------------
SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 2 11:16:00 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred
--------------------------------
From Windows, when I run "tnsping [hostname.of.database.server]", I get the following:
--------------------------------
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-DEC-2011 11:18:06
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage 3512 not found; No message file for product=NETWORK, facility=TNSMessage 3513 not found; No message file for product=NETWORK, facility=TNSTNS-12535: Message 12535 not found; No message file for product=NETWORK, facility=TNS
--------------------------------
This doesn't seem right.
If I try to run tnsping on an invalid hostname, I get:
--------------------------------
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-DEC-2011 11:19:06
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-03505: Message 3505 not found; No message file for product=NETWORK, facility=TNS
--------------------------------
Which is slightly different, but still doesn't look right.
Am I doing this right? Can I use sqlplus on a database-client-only Windows machine to connect to a Linux database server? I just am assuming this should work. If I need to set ORACLE_HOME (et al.), I'm not sure what to set it to. I used default directories when I installed the client, C:\app\.
P.S. When I run "tnsping localhost" on the Linux system, it gives an "OK".
Edited by: notfed on Dec 2, 2011 8:35 AM