> 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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
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.
