Oracle listner with port forwarding issue

bundle exec rails s
=> Booting WEBrick
=> Rails 3.1.5 application starting in development on
=> 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

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

Started GET “/” for 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
localhost:1522. I am also invoking:

ssh -C -q -f -N -l root -L 1522:

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
appears as:

tnsnames.ora Network Configuration File:


Generated by Oracle configuration tools.

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

Any idea what I should append to this so as to get the listener to work
properly with the port forwarding here? TIA, RVince

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs