916040 wrote:Seem like a sound approach.
Ultimately, I'm trying to connect JBoss to the database, but for now I'd just like to try a simpler setup.
I'm using Instant Client on Windows 7 with Oracle 11.2 running on a RedHat 5 virtual machine. When I connect with the following...Did you verify basic network connectivity first?
it hangs, eventually timing out.
strauss wrote:Even if port 1521 is open, that may not be enough.
I can connect with Putty from Windows. And I have this entry in /etc/sysconfig/iptables:
-A RH-Firewall-1-INPUT -m state state NEW -m tcp -p tcp dport 1521 -j ACCEPT
Is that enough to get that port open?
I restarted iptables, and now I'm getting a different error. Should I make a new thread for it, or can I leave it in here? This is the error.Mysterious.
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Laurenz Albe wrote:Not very mysterious, if you had read my post.
Edited by: orafad on Feb 23, 2012 2:02 PM
C:\>sqlplus blah@localhost/test SQL*Plus: Release 184.108.40.206.0 Production on Thu Feb 23 13:56:44 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA Enter user-name: C:\>sqlplus blah@'localhost/test' SQL*Plus: Release 220.127.116.11.0 Production on Thu Feb 23 13:56:59 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter password: