> 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
on 2012-12-20 12:23
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
Log in with Google account | Log in with Yahoo account
No account? Register here.