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