> 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 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/fUrDPhkK2rQJ. For more options, visit https://groups.google.com/groups/opt_out.
