Oracle listner with port forwarding issue

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

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