# How to create new database to oracle? **URL:** \ **Category:** Rails\ **Created:** [June 11, 2008, 4:54pm UTC](https://www.ruby-forum.com/t/how-to-create-new-database-to-oracle/140179 "2008-06-11T16:54:57Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [June 11, 2008, 4:54pm UTC](https://www.ruby-forum.com/t/how-to-create-new-database-to-oracle/140179/1 "2008-06-11T16:54:57Z")
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 ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [July 7, 2008, 7:00am UTC](https://www.ruby-forum.com/t/how-to-create-new-database-to-oracle/140179/2 "2008-07-07T07:00:25Z")
Jesse Hu wrote: > “database” in database.yml should be set to “hostname/sid” > > 2008/6/11 Pokkai D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > Cheers, > Jesse > i a new to oracle with rails > can you tell how to create new SID in oracle-xe. thankx ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [July 7, 2008, 7:21am UTC](https://www.ruby-forum.com/t/how-to-create-new-database-to-oracle/140179/3 "2008-07-07T07:21:36Z")
On Mon, Jul 7, 2008 at 3:00 PM, Pokkai D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Jesse Hu wrote: > > > “database” in database.yml should be set to “hostname/sid” > > 2008/6/11 Pokkai D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > > 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. – > **[Mikel Lindsaar](https://lindsaar.net/)** > > Internet Home for Mikel Lindsaar Rails, RSpec and Life blog… ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [July 7, 2008, 12:35pm UTC](https://www.ruby-forum.com/t/how-to-create-new-database-to-oracle/140179/4 "2008-07-07T12:35:54Z")
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/](http://lindsaar.net/) > Rails, RSpec and Life blog… so how to create new database ? thanks ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [June 16, 2008, 4:49am UTC](https://www.ruby-forum.com/t/how-to-create-new-database-to-oracle/140179/5 "2008-06-16T04:49:07Z")
“database” in database.yml should be set to “hostname/sid” 2008/6/11 Pokkai D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > 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/](http://www.ruby-forum.com/). > > > – Cheers, Jesse ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [July 16, 2008, 3:44pm UTC](https://www.ruby-forum.com/t/how-to-create-new-database-to-oracle/140179/6 "2008-07-16T15:44:13Z")
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. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > > database: 127.0.0.1/XE > > so how to create new database ? > > ## thanks > > Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/). > > > – Cheers, Jesse ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [July 16, 2008, 3:41pm UTC](https://www.ruby-forum.com/t/how-to-create-new-database-to-oracle/140179/7 "2008-07-16T15:41:51Z")
please visit [Technical Resources | Oracle](http://www.oracle.com/technology/index.html) or buy an oracle database book 🙂 2008/7/7 Pokkai D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > > database: 127.0.0.1/XE > > so how to create new database ? > > ## thanks > > Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/). > > > – Cheers, Jesse