How to create new database to oracle?

Rails
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

Jesse Hu wrote:

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

2008/6/11 Pokkai D. [email protected]:
Cheers,
Jesse
i a new to oracle with rails
can you tell how to create new SID in oracle-xe.

thankx

3

On Mon, Jul 7, 2008 at 3:00 PM, Pokkai D.
[email protected] wrote:

Jesse Hu wrote:

“database” in database.yml should be set to “hostname/sid”
2008/6/11 Pokkai D. [email protected]:
Cheers,
Jesse
i a new to oracle with rails
can you tell how to create new SID in oracle-xe.

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.

–

Rails, RSpec and Life blog…

4

Mikel L. 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

5

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

2008/6/11 Pokkai D. [email protected]:

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

Posted via http://www.ruby-forum.com/.

–
Cheers,
Jesse

6

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.

2008/7/7 Pokkai D. [email protected]:

database: 127.0.0.1/XE
so how to create new database ?

thanks

Posted via http://www.ruby-forum.com/.

–
Cheers,
Jesse

7

please visit Technical Resources | Oracle or buy an
oracle
database book :slight_smile:

2008/7/7 Pokkai D. [email protected]:

database: 127.0.0.1/XE
so how to create new database ?

thanks

Posted via http://www.ruby-forum.com/.

–
Cheers,
Jesse