Oracle VM and Rails: OCIError: ORA-12537: TNS:connection closed -


i have rails app, using oracle database.

i used run using oracle virtualbox , oracle developer day kit on old machine. pack provided oracle included oracle database 11g have new laptop, need reinstall everything, went well, oracle pack 'otn dev day' uses oracle database 12g.

and after setting exact same way, run error while testing connection via oci8:

1.9.3-p327 :001 > require 'oci8'  => false 1.9.3-p327 :002 > c= oci8.new('me', 'mypassword', '//localhost:1521/orcl') ocierror: ora-12537: tns:connection closed         oci8.c:267:in oci8lib_191.bundle         (irb):2:in `new'         (irb):2         /users/stephanethomas/.rvm/gems/ruby-1.9.3-p327/gems/railties-3.2.14/lib/rails/commands/console.rb:47:in `start'         /users/stephanethomas/.rvm/gems/ruby-1.9.3-p327/gems/railties-3.2.14/lib/rails/commands/console.rb:8:in `start'         /users/stephanethomas/.rvm/gems/ruby-1.9.3-p327/gems/railties-3.2.14/lib/rails/commands.rb:41:in `<top (required)>'         script/rails:6:in `require'         script/rails:6:in `<main>'

in vm, if check listener i've got working fine: 

lsnrctl linux: version 12.1.0.1.0 - production on 09-mar-2014 20:26:17  copyright (c) 1991, 2013, oracle.  rights reserved.  connecting (description=(address=(protocol=tcp)(host=localhost)(port=1521))) status of listener ------------------------ alias                     listener version                   tnslsnr linux: version 12.1.0.1.0 - production start date                09-mar-2014 19:56:48 uptime                    0 days 0 hr. 29 min. 28 sec trace level               off security                  on: local os authentication snmp                      off listener parameter file   /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora listener log file         /u01/app/oracle/product/12.1.0/dbhome_1/log/diag/tnslsnr/localhost/listener/alert/log.xml listening endpoints summary...   (description=(address=(protocol=tcp)(host=0.0.0.0)(port=80))(protocol_stack=(presentation=http)(session=raw)))   (description=(address=(protocol=tcp)(host=0.0.0.0)(port=21))(protocol_stack=(presentation=ftp)(session=raw)))   (description=(address=(protocol=tcp)(host=localhost)(port=1521)))   (description=(address=(protocol=ipc)(key=extproc1521))) services summary... service "orcl" has 1 instance(s).   instance "orcl", status ready, has 1 handler(s) service... service "orclxdb" has 1 instance(s).   instance "orcl", status ready, has 1 handler(s) service... service "pdb1" has 1 instance(s).   instance "orcl", status ready, has 1 handler(s) service... command completed

is there significant changes between 12 , 11? or did miss while installing?

thanks in advance!

generally ora-12537 should stack of error messages. previous error messages more important, looks ruby suppresses them (not good).

did disable firewall on machine?

otherwise post listener.ora, sqlnet.ora , protocol.ora files.


Comments

Post a Comment

Popular posts from this blog

Android layout hidden on keyboard show -

i have strange problem layout. when tap on edittext , keyboard shown edittext stay on bottom , when tap on to hide keyboard , keyboard hides , edittext go should when want input text. when tap again, keyboard shown , edittext goes down behind keyboard... <relativelayout android:layout_width="match_parent" android:layout_height="match_parent" > <scrollview android:layout_width="match_parent" android:layout_height="fill_parent" android:above="@+id/rl_commands"> <textview android:layout_width="match_parent" android:layout_height="wrap_content"/> </scrollview> <relativelayout android:layout_width="match_parent android:layout_height="24dp" android:id="@+id/rl_commands" android:alignparentbottom="true">
Read more

google app engine - 403 Forbidden POST - Flask WTForms -

i have flask application running on google app engine. trying submit form built using wtform , keep getting following error. 403 forbidden: don't have permission access requested resource. either read-protected or not readable server. location.html (part of code) <form method=post action="/home/location"> .... <button type="submit" class="btn btn-primary" value="submit"> directions </button> </form> main.py @app.route('/home/location', methods=['post', 'get']) def location(): form = cfcdirections.direction(request.form) print(request.method) if request.method == 'post' , form.validate(): print("after if") directions = cfcdirections() street_no = directions.no street = directions.street suburb = directions.suburb postcode = directions.postcode
Read more

c - Why would PK11_GenerateRandom() return an error -8023? -

i looking through internet trying find source of pk11_generaterandom() function see why function fail. have program uses function when moved new flavor of linux, fails after forking ( fork() ) since not believe there problem nss, suspect doing incorrectly disregarded in older versions of linux new 1 there issue. the openssl package same on 'good' , 'bad' server: openssl 0.9.8e-fips-rhel5 01 jul nss rpm differs though. 'good' has nss-3.12.2.0-2.el5 and bas has version nss-3.15.3-4.el5_10 the 'good' server uses quite obsolete linux: linux 2.6.18-128.el5 #1 smp wed jan 21 08:45:05 est 2009 x86_64 x86_64 x86_64 gnu/linux enterprise linux enterprise linux server release 5.3 (carthage) red hat enterprise linux server release 5.3 (tikanga) the 'bad' server newer: linux bad 2.6.18-371.4.1.el5 #1 smp wed jan 29 11:05:49 pst 2014 x86_64 x86_64 x86_64 gnu/linux oracle linux server release 5.10 red hat enterprise linux server release
Read more