Forum: Ruby on Rails Oracle listner with port forwarding issue

Posted by RVince (Guest)
on 2012-12-20 12:23
(Received via mailing list)
> bundle exec rails s
=> Booting WEBrick
=> Rails 3.1.5 application starting in development on 
http://0.0.0.0:3000
=> Call with -d to detach
=> Ctrl-C to shutdown server
Warning: NLS_LANG is not set. fallback to US-ASCII.
[2012-12-19 12:17:10] INFO  WEBrick 1.3.1
[2012-12-19 12:17:10] INFO  ruby 1.9.3 (2012-10-12) [x86_64-linux]
[2012-12-19 12:17:10] INFO  WEBrick::HTTPServer#start: pid=13819 
port=3000

Then I go to hit localhost:3000, and in the server console I get :

Started GET "/" for 127.0.0.1 at 2012-12-19 12:17:22 -0800

OCIError (ORA-12541: TNS:no listener):

In researching this error, it is a result of a misconfigured oracle
listener (I am using port forwarding on port 1522).  In database.yml I 
have
localhost:1522. I am also invoking:

ssh -C -q -f -N -l root -L 1522:74.121.71.3:1521 
<http://74.121.70.3:1521>
eesdev.somebody.net <http://eesdev.missiondata.net>

Finally, my $ORACLE_HOME points to the right spot, and PATH=$PATH:/bin

So everything is set up to hit the oracle server through port 1522.

This ORA-12541, the misconfigured oracle listener (I assume on my local,
which has already been started) in 
$ORACLE_HOME/network/admin/tnsnames.ora
appears as:

# tnsnames.ora Network Configuration File:
/opt/app/oracle/product/11/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

Any idea what I should append to this so as to get the listener to work
properly with the port forwarding here? TIA, RVince
Please log in before posting. Registration is free and takes only a minute.
Existing account (Switch to SSL-encrypted connection)
NEW: Do you have a Google/GoogleMail or Yahoo account? No registration required!
Log in with Google account | Log in with Yahoo account
No account? Register here.