# Windows:下載並雙擊執行
https://rubyforge.org/projects/ruby-oci8/
# → ruby-oci8-mswin/*.rb
# Linux:gem 安裝(需先裝 Oracle Instant Client SDK)
gem install ruby-oci8
development:
adapter: oci
host: MY_TNS_ALIAS # tnsnames.ora 裡的別名
username: system
password: manager
# 無 database 欄位;Oracle 用 TNS 別名決定連線目標
# 或直接用 Easy Connect 字串
production:
adapter: oci
host: 192.168.0.50/ORCL # host/service_name
username: app_user
password: secret
CREATE TABLE items (
id NUMBER(10) PRIMARY KEY,
title VARCHAR2(200) NOT NULL,
created_at DATE DEFAULT SYSDATE
);
CREATE SEQUENCE items_seq INCREMENT BY 1 START WITH 1 NOCACHE;
-- 觸發器自動填 id (Rails 1.x 需要,2.x+ 內建支援)
CREATE OR REPLACE TRIGGER items_bir
BEFORE INSERT ON items
FOR EACH ROW
BEGIN
SELECT items_seq.NEXTVAL INTO :NEW.id FROM DUAL;
END;
/
rails myapp
cd myapp
ruby script/generate scaffold Item Admin
ruby script/server
# 瀏覽器開 https://localhost:3000/admin/item
| 現象 | 原因 | 解法 |
|---|---|---|
| `OCIError: ORA-12154` | TNS 別名解析失敗 | 確認 `tnsnames.ora` 在 `TNS_ADMIN` 路徑、別名拼寫正確 |
| `ActiveRecord::StatementInvalid: ORA-02289` | Sequence 不存在 | 建立 `{table}_seq` Sequence |
| 主鍵不自動賦值 | 欄位名非 `id` 或未建 Trigger | 改名為 `id`、建 Trigger 或升級 Rails 2.3+ |
| 中文亂碼 | `NLS_LANG` 未設或不匹配 | `export NLS_LANG=AMERICAN_AMERICA.AL32UTF8` (Linux) / 註冊表設定 (Windows) |
Rails + Oracle 三步驟:**裝 oci8 → 寫 database.yml (adapter: oci, host: TNS別名) → 建表遵循複數命名 + id PK + {table}_seq Sequence**。搞定這三點,Scaffold 即可跑起來,享受 Rails 開發效率與 Oracle 企業級穩定的雙重紅利。