FYI, I installed ruby-oci8-1.0.0-rc1 and the problem disappeared.
( Also note for completeness that I am on RHEL ES 3 Taroon Update 7 , i686 and Oracle 10.2.0.1.0 Enterprise ) -Scopulorum On Mar 21, 9:53 am, "scopulorum" <[EMAIL PROTECTED]> wrote: > Sorry, I forgot to include the trace. > > -Scopulorum > > rake db:migrate --trace > (in XXX/XXX/mcd) > ** Invoke db:migrate (first_time) > ** Invoke environment (first_time) > ** Execute environment > ** Execute db:migrate > ** Invoke db:schema:dump (first_time) > ** Invoke environment > ** Execute db:schema:dump > rake aborted! > OCIError: ORA-03106: fatal two-task communication protocol error: > select lower(table_name) from user_tables > /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5618/lib/ > active_record/connection_adapters/abstract_adapter.rb:122:in `log' > /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5618/lib/ > active_record/connection_adapters/oracle_adapter.rb:222:in `execute' > /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5618/lib/ > active_record/connection_adapters/oracle_adapter.rb:480:in `select' > /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5618/lib/ > active_record/connection_adapters/abstract/database_statements.rb:7:in > `select_all' > /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5618/lib/ > active_record/connection_adapters/oracle_adapter.rb:285:in `tables' > /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5618/lib/ > active_record/schema_dumper.rb:54:in `tables' > /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5618/lib/ > active_record/schema_dumper.rb:23:in `dump' > /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5618/lib/ > active_record/schema_dumper.rb:17:in `dump' > /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6.5618/lib/tasks/ > databases.rake:24 > /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6.5618/lib/tasks/ > databases.rake:23 > /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in > `execute' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in > `execute' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:357:in > `invoke' > /usr/local/lib/ruby/1.8/thread.rb:135:in `synchronize' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:350:in > `invoke' > /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6.5618/lib/tasks/ > databases.rake:5 > /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in > `execute' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in > `execute' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:357:in > `invoke' > /usr/local/lib/ruby/1.8/thread.rb:135:in `synchronize' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:350:in > `invoke' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in `run' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in `run' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.1/bin/rake:7 > /usr/local/bin/rake:18 > > On Mar 21, 9:47 am, "scopulorum" <[EMAIL PROTECTED]> wrote: > > > 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 sysdba' > > create tablespace mcd datafile '/oracle/oradata/d102/mcd_0.dbf' SIZE > > 500M; > > create user mcd identified by XXX default tablespace mcd ; > > grant select_catalog_role, connect, resource, XXX, create session to > > mcd; > > > ## Start server app > > ruby script/server -d -p3000http://splinter:3000/ > > > ## Configure App ( Correct oracle db spec ) > > vi config/database.yml > > development: > > adapter: oracle > > database: d102 > > username: mcd > > password: XXX > > > ## Test config ( db connection ) > > rake db:migrate > > (OK) > > > ## Create Model & assosciated tables > > ruby script/generate model structure > > > ## Configure/Correct the migration file ( 1st in sequence creates > > tables) > > vi db/migrate/001_create_structures.rb > > ... > > def self.up > > create_table :structures do |t| > > t.column :amw, :float > > t.column :gvk_id, :string > > t.column :parent_id, :float > > t.column :ism_parent_id, :float > > t.column :ref_id, :float > > t.column :mechanism_id, :float > > t.column :ism, :text > > t.column :norm_ism, :text > > t.column :coords, :text > > t.column :cflag, :float > > t.column :vis, :text > > t.column :val, :text > > t.column :symbol, :text > > t.column :bst, :text > > t.column :mw, :float > > t.column :formula, :string > > t.column :internal_ref, :text > > t.column :comments, :text > > end > > ... > > > ## Create tables > > rake db:migrate > > ... fails ... > > rake aborted! > > OCIError: ORA-03106: fatal two-task communication protocol error: > > select lower(table_name) from user_tables > > ... > > # Try roll-back to version 0 > > rake db:migrate VERSION=0 > > ... fails ... > > rake aborted! > > OCIError: ORA-03106: fatal two-task communication protocol error: > > select lower(table_name) from user_tables > > ... > > # Roll-forward? > > rake db:migrate VERSION=1 > > ... > > rake aborted! > > OCIError: ORA-03106: fatal two-task communication protocol error: > > select lower(table_name) from user_tables > > > # Note that all is fine in native sqlplus > > sqlplus 'mcd/XXX' > > SQL> select lower(table_name) from user_tables; > > > LOWER(TABLE_NAME) > > ------------------------------ > > structures > > schema_info > > > SQL> desc structures > > Name Null? Type > > ----------------------------------------- -------- > > ---------------------------- > > ID NOT NULL NUMBER(38) > > AMW NUMBER > > GVK_ID VARCHAR2(255) > > PARENT_ID NUMBER > > ISM_PARENT_ID NUMBER > > REF_ID NUMBER > > MECHANISM_ID NUMBER > > ISM CLOB > > NORM_ISM CLOB > > COORDS CLOB > > CFLAG NUMBER > > VIS CLOB > > VAL CLOB > > SYMBOL CLOB > > BST CLOB > > MW NUMBER > > FORMULA VARCHAR2(255) > > INTERNAL_REF CLOB > > COMMENTS CLOB > > > SQL> desc schema_info > > Name Null? Type > > ----------------------------------------- -------- > > ---------------------------- > > VERSION NUMBER(38) > > > SQL> select version from schema_info; > > > VERSION > > ---------- > > 1 > > > Thanks in advance for any suggestions you may have to offer. > > > Scopulorum --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---
