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:migraterake 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 -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
"database" in database.yml should be set to "hostname/sid" 2008/6/11 Pokkai Dokkai <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>:> > > 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 > -- > Posted via http://www.ruby-forum.com/. > > > >-- Cheers, Jesse --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Jesse Hu wrote:> "database" in database.yml should be set to "hostname/sid" > > 2008/6/11 Pokkai Dokkai <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>: > Cheers, > Jessei a new to oracle with rails can you tell how to create new SID in oracle-xe. thankx -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Mon, Jul 7, 2008 at 3:00 PM, Pokkai Dokkai <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> Jesse Hu wrote: >> "database" in database.yml should be set to "hostname/sid" >> 2008/6/11 Pokkai Dokkai <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>: >> 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. -- http://lindsaar.net/ Rails, RSpec and Life blog.... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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 -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
please visit http://www.oracle.com/technology/index.html or buy an oracle database book :) 2008/7/7 Pokkai Dokkai <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>:> > 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 > -- > Posted via http://www.ruby-forum.com/. > > > >-- Cheers, Jesse --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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 Dokkai <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>:> > 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 > -- > Posted via http://www.ruby-forum.com/. > > > >-- Cheers, Jesse --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---