similar to: Determining which tables are available (oracle)

Displaying 20 results from an estimated 30000 matches similar to: "Determining which tables are available (oracle)"

2011 Sep 02
3
problems with oracle xe server connection
i''m working on ubuntu 11.04; i need to create some rails application with oracle database on local computer. i installed: ruby 1.9.2, rails 3.1, oracle 10g XE, rubu-oci8 2.0.6, gem ''activerecord-oracle_enhanced-adapter'', create database user named ''orak'' with password ''orakpass'' through 127.0.0.1:8080/apex, i maked new application
2010 Feb 06
0
I can only halfway connect to oracle
Gurus... If I set up my project to use SQLite (so it can come up) and attempt to connect to oracle via: oracle_connect = $application_properties[$connect_string] oracle_conn = OCI8.new(oracle_id, oracle_password, oracle_connect) where oracle_connect equals ''//bobs.big.boy.gov:1521/D09'' (with or w/o the introductory //) my rails app connect to the oracle database just fine. If
2010 Dec 15
3
ORA-12514: TNS:listener d oes not currently know of service requested in connect descriptor (OCIEr
Hi I am a new to ROR and learning this framework from various tutorials. I have my new application and had the rails generate scaffold get going but after this when I first ran the rake db:migrate I got this ERROR! ORA-12514: TNS:listener d oes not currently know of service requested in connect descriptor (OCIError) I''m using database which is on a server and have used the tnsnames.ora
2010 Apr 27
3
"ORA-12154: TNS:..." error after successful oracle connection
Hi, After a few days of struggling, I was able to run this command successfully. ruby -r oci8 -e "OCI8.new(''xxx_dba'', ''xxx'', ''//xxxx:1521/ xxxxx.xxx.org'').exec(''SELECT 1 from dual'') {|r| puts r.join}" I got "1.0" as output and I got my prompt back. So, I went back to the RoR app that I am working on,
2005 Jul 27
7
Oracle OCI8, or "am I going crazy?"
All of a sudden, on three different systems, the "server_ip_address/sid_name" syntax in database.yml has stopped working for me. I can''t even do a OCI8.new(blah blah blah) statement from an IRB shell. I get "ORA-12541: TNS:no listener", or some variant, depending on how I phrase it. On systems where I have a real deal client installed, and OCI can find the tnsnames
2006 Jul 28
0
cannot read a table in Oracle when scaffold''ing
I installed Ruby, Rails (using gems install rails -v 1.0.0 --remote), the OCI driver for windows to access Oracle (C:\> ruby ruby-oci8-0.1.13-mswin.rb). I create a an application in rails (C:\> rails tabella) I have a table called tabella in Oracle in the RAILSDB database. I modify my database.yml to read: development: adapter: oci username: ruby password: ruby host: RAILSDB I
2006 Jan 10
5
Oracle 10g Express - generate scaffold gives error
Hello, I have Oracle XE installed. I have a table USERS. When I try to generate a scaffold it gives me this error. I tried also with Mysql and it worked. E:\radrails\projects\MPS>ruby script\generate scaffold user exists app/controllers/ exists app/helpers/ create app/views/user exists test/functional/ dependency model exists app/models/ exists
2005 Apr 25
0
Oracle connection problem: rails ok!
Thanks Dan That fixed it. > Date: Sun, 24 Apr 2005 22:32:34 -0700 > From: Dan Peterson <dpiddy-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > Subject: Re: [Rails] Oracle connection problem: ruby ok, rails not ok. > To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > Message-ID: <56d3286d0504242232471fe782-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org> >
2008 Jun 11
6
how to create new database to oracle ?
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
2009 Sep 11
0
oracle_enhanced problem connection
Hello, I have a problem connecting to the development Oracle database but not to production, despite using the same credentials and connecting to the same database. The database is a legacy app that needs a new enhanced front end, so I''m not designing a new database just interacting with the existing one. Here is my database.yml: development: adapter: oracle_enhanced user: user
2012 Jun 08
1
Announce: puppetlabs_spec_helper 0.1.0 Available
puppetlabs_spec_helper is a Rubygem to make writing and running module spec tests using rspec-puppet easier. It includes a set of common rake tasks and a spec_helper that correctly initializes puppet and rspec-puppet for testing. The code is available on github at http://github.com/puppetlabs/puppetlabs_spec_helper. Patches are welcome. To convert a module with existing spec tests to use the
2009 Mar 05
0
Insert using Rake Task
Hi, Anyone can help me, I run my source code using rake task. It seems no error was trace, but when I look the table it doesn''t insert.I select the data here MysqlDB.Tablename and update/insert here SQLserverDB.TableName. # Start Here # rake mysqldata_select:sqldata_update def clean_html(html) new_html = strip_tags(html) # remove html tags new_html = decode_entities(new_html) #
2013 Feb 01
0
rake db:migrate failing against oracle
Hello All -- I am using jruby 1.6.7.2 with rails 3.2.11 to create a brown bag for several other developers. I cannot get the migration to work to save my life... In my database yaml file I have the following: --- development: adapter: jdbc driver: oracle.jdbc.driver.OracleDriver url: jdbc:oracle:thin:@localhost:1521:xe username: brownbag password: brownbag pool: 500 --- When I run:
2011 Apr 20
6
rake db:create fails
Hello folks, I´m here trying to find the way to solve my problem. When i try to run rake db:create or rake db:create:all the process stops and the databases are not created. I change the directives, putting --trace before the rake db:create and the steps are C:\appws\cookbook>rake db:create --trace (in C:/appws/cookbook) ** Invoke db:create (first_time) ** Invoke db:load_config (first_time)
2005 Mar 21
3
Oracle Adapter on Mac OS X?
I had previously gotten Maik Schmidt''s patch for Oracle working, but now am trying the official Oracle adapter with the latest Rails. I''ve been trying to get the OCI8 connector to install under OS X, but get the following error. Has anyone gotten it working? ---- [waterdog:~/Desktop/ruby-oci8-0.1.9] stmpjmpr% ruby setup.rb config ---> lib ---> lib/DBD ---> lib/DBD/OCI8
2011 Apr 26
1
problem populating table using rake db:fixtures:load
I''m running Rails 3 and I''m trying to populate a table using rake db:fixtures:load, and I''m getting a "Could not find" file error. The table is called stores, and I''ve confirmed that it exists, and the data is in stores.yml in my test/fixtures directory. The command I''m running is rake db:fixtures:load FIXTURES=stores. The error message
2009 Apr 14
1
Oracle oci8 => OCIError: OCI Library Initialization Error
I''m trying to get ActiveRecord working with an Oracle DB over the instant client. On a 32bit machine, I can require ''oci8'': Linux xxx.xxx.xxx.xxx 2.6.9-78.0.17.ELsmp #1 SMP Thu Mar 5 04:52:17 EST 2009 i686 i686 i386 GNU/Linux irb(main):001:0> require ''oci8'' => true However, on a 64bit machine: Linux xxx.xxx.xxx.xxx 2.6.18-128.1.6.el5 #1 SMP Tue
2009 May 05
3
Oracle-JRuby error
I am trying to migrate from RoR/MYSql to JRoR/Oracle. I am using Active Record JDBC to talk to the database. The Migration process to create and populate the database tables has been painful. My latest issue is the method new_date is undefined in the JDBC adapter. I have the following gems installed: *** LOCAL GEMS *** actionmailer (2.2.2) actionpack (2.2.2) activerecord (2.2.2)
2008 Feb 22
2
Connecting to Oracle from Rails 2.0.2
Long afternoon, but finally got it. Hope this spares you some pain: Installation instructions mainly based on: http://ruby.about.com/od/enterprise/ss/ruby_oracle.htm Install Oracle Instant Client: mkdir C:\oracle cd c:\oracle Get the following files from here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html and unzip them into the c:\oracle\ unzip
2008 Sep 15
0
Instant Client: Connecting Oracle and Mac
Hi, I am having a terrible time installing Instant Client to connect my Mac and an Oracle db. I am using the following instructions: http://www.foliosus.com/2007/11/19/connecting-ruby-on-rails-to-oracle-on-an-intel-mac-in-leopard-mac-osx-105/?css=Banksia All goes seemingly well until the Compile the ruby-oci8 library section. ruby setup.rb config returns the following error message: