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 -p3000 http://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 -~----------~----~----~----~------~----~------~--~---
