similar to: OCIError (ORA-01017: invalid username/password; login denied

Hi I am a new to ROR and learning this framework from various tutorials. I have my new application and had the rails generate scaffold get going but after this when I first ran the rake db:migrate I got this ERROR! ORA-12514: TNS:listener d oes not currently know of service requested in connect descriptor (OCIError) I''m using database which is on a server and have used the tnsnames.ora

Hi all, when I execute the command "rake db:schema:dump" i get this error in the db/schema.rb file. ____________________________________________________ # Could not dump table "region" because of following ActiveRecord::StatementInvalid # OCIError: ORA-00918: column ambiguously defined: SELECT lower(i.index_name) as index_name, i.uniqueness, lowe r(c.column_name) as

I am having a problem getting Redmine to run with Oracle (11.2) backend. I get this error (below) because Oracle table names are limited to 30 characters. Does anyone around here know of a fix or workaround? I''m wondering if I can simple change the table name, or if that will break the application. When doing a db migrate to an Oracle db this creates the error below. I''m so

Hello all, I''m in my 5th month on Ruby on Rails and still learning. I have an application that works fine in sqlite3 and then the boss says he wants it migrated to Oracle. Now, I know very little about Oracle, enough to get into trouble. When I did the migration everything went haywire. Well, I''ve refactored several problems and now I have another. I have two models with a

Hello, I have a problem connecting to the development Oracle database but not to production, despite using the same credentials and connecting to the same database. The database is a legacy app that needs a new enhanced front end, so I''m not designing a new database just interacting with the existing one. Here is my database.yml: development: adapter: oracle_enhanced user: user

All of a sudden, on three different systems, the "server_ip_address/sid_name" syntax in database.yml has stopped working for me. I can''t even do a OCI8.new(blah blah blah) statement from an IRB shell. I get "ORA-12541: TNS:no listener", or some variant, depending on how I phrase it. On systems where I have a real deal client installed, and OCI can find the tnsnames

Hi, I'm setting up a 2-node Oracle 9i RAC on OCFS2. But I have some problems with understanding how the shared Oracle_Home is being used. For instance there is the *$ORACLE_HOME/oracm/admin/cmcfg.ora* file. The $ORACLE_HOME is on the SAN so the 2 nodes have access to this file. How will the settings then be done per node? Is there a guide/tutorial/howto for installing Oracle 9i RAC on

I am trying to use Rails and an Oracle 7 database. I have the following error message: (eval):3:in `__send__'': ORA-12663: Services required by client not available on the server (OCIError) from (eval):3:in `describe'' and the line oracle_adapter,rb:361: (owner, table_name) = @connection.describe(table_name) Do I need this describe line? Can I replace with something else just

Has anyone encountered this error or know how to correct it? I couldn''t find any Rails-specific info about this on google. Here are the circumstances: /usr/local/bin/ruby --version ruby 1.8.4 (2005-12-24) [i686-linux] /usr/local/bin/rails --version Rails 1.1.6 ## Create mcd app rails mcd -d oracle cd mcd ## Create oracle tablespace & user sqlplus ''/ as

i''m working on ubuntu 11.04; i need to create some rails application with oracle database on local computer. i installed: ruby 1.9.2, rails 3.1, oracle 10g XE, rubu-oci8 2.0.6, gem ''activerecord-oracle_enhanced-adapter'', create database user named ''orak'' with password ''orakpass'' through 127.0.0.1:8080/apex, i maked new application

Hi all, Windows XP Oracle 10g client OCI8 0.1.16 Ruby 1.8.5 Rails 1.1.6 I''m hitting weird behavior with the Oracle adapter and a find_by_sql call on a multi-table join. The SQL looks like this: SELECT DISTINCT e1.ip_address, loc.street, loc.city, loc.state FROM schema.net_element ne, schema.equipment e1, schema.equipment e2, schema.building b, schema.cust_loc cl, schema.location

Hi, when I configure my app to use the oracle_enhanced adapter it throws the following exception: java.sql.SQLException: ORA-01882 : Timezone region not found How can I solve this? Thanks, Rafael Roque -- Posted via http://www.ruby-forum.com/.

I''m trying to get ActiveRecord working with an Oracle DB over the instant client. On a 32bit machine, I can require ''oci8'': Linux xxx.xxx.xxx.xxx 2.6.9-78.0.17.ELsmp #1 SMP Thu Mar 5 04:52:17 EST 2009 i686 i686 i386 GNU/Linux irb(main):001:0> require ''oci8'' => true However, on a 64bit machine: Linux xxx.xxx.xxx.xxx 2.6.18-128.1.6.el5 #1 SMP Tue

> 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:

Hi, Can any one help me? I''m using Ubuntu and trying to connect to an oracle database using oracle_enhanced adapter connection, but keeps getting following error: /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/dependencies. rb:275:in `load_missing_constant'': uninitialized constant ActiveRecord::Connecti onAdapters::OracleEnhancedAdapter (NameError)

Hi, I have some problems with rails and the oracle_enhanced adapter. My rails application is working but not my rake task. It doesn''t find the oracle_enhanced adapter. Please install the oracle_enhanced adapter: `gem install activerecord-oracle_enhanced-adapter` (no such file to load -- active_record/connection_adapters/oracle_enhanced_adapter) But the gem is installed as the rails

The attached is from my ISP (times are GMT -0800). This outage will impact: a) The mailing lists and mailing list archives. b) search of the Shorewall web site and list archives. I will be out of town when this outage occurs so I will have my fingers crossed that things will come back up ok. -Tom -- Tom Eastep \ Shorewall - iptables made easy Shoreline, \ http://shorewall.sf.net

I''ve opened up development of Shorewall 4.1. While I had previously announced that Shorewall 4.1 would focus on IPv6, I have since learned that the netfilter team are developing ''xtables'', a unified IP0v4/IPv6 utility. It seems silly to spend the effort to add Shorewall support for IPv6 only to then have to turn around and convert it to use xtables. So I''ve

Hello. Tired of searching and finding nothing useful. Moving application to laptop for trip. Installed: - Ruby (1.8.6, patchlevel 111) - Rails (2.2.2) - Oracle adapter (1.0.0.9250) - ruby-oci8 (2.0.1) - Oracle 10g Express Edition database.yml: development: adapter: oracle etc... When I start Mongrel (ruby script/server) I get the error above. I''ve looked everywhere I can think of.

Hi, I need to get the environment variable ORACLE_SID from the OS. I know this can be done with the following: $blah = env("PATH") However, the ORACLE_SID variable is only set under the oracle user account. So I would need a way to login as the oracle account first to retrieve the ORACLE_SID variable. Is there anyway to get the environment variable from a user''s account