Wednesday, December 19, 2012
> 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 eesdev.somebody.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)
)
)
--
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@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment