how to create new database to oracle ?

rubyonrails-talk
1

i have rails-2.1.0

my database.yml development:   adapter: oracle   database: pe   username: or   password: or

rake db:create rake db:version --->Current version: 0 rake db:migrate

rake aborted! ORA-12154: TNS:could not resolve the connect identifier specified (See full trace by running task with --trace)

is above idea is possible, then how ?

and i thing i should give service name into some *.ora files.... i don't know how to give and what file it is ..

can any one help me

2

“database” in database.yml should be set to “hostname/sid”

3

Jesse Hu wrote:

"database" in database.yml should be set to "hostname/sid"

Cheers, Jesse

i a new to oracle with rails can you tell how to create new SID in oracle-xe.

thankx

4

In XE your SID will be 'XE'

So your database.yml will look something like:

development:   adapter:oracle   database: 127.0.0.1/XE   username: rails   password: yourpassword

Obviously replace 127.0.0.1 with the IP address / hostname of your oracle server.

5

Mikel Lindsaar wrote:

In XE your SID will be 'XE'

So your database.yml will look something like:

development:   adapter:oracle   database: 127.0.0.1/XE   username: rails   password: yourpassword

Obviously replace 127.0.0.1 with the IP address / hostname of your oracle server.

-- http://lindsaar.net/ Rails, RSpec and Life blog....

so how to create new database ?

thanks

6

please visit http://www.oracle.com/technology/index.html or buy an oracle database book :slight_smile:

7

Sorry I misunderstood you.

" rake db:create" doesn’t work with Oracle. you need to create a database or create an user in an existing database.