Oracle 10g database free download
- ORACLE 10G DATABASE FREE DOWNLOAD INSTALL
- ORACLE 10G DATABASE FREE DOWNLOAD FULL
- ORACLE 10G DATABASE FREE DOWNLOAD PASSWORD
SQL> ALTER USER app_test DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp SQL> GRANT CONNECT, RESOURCE TO app_test IDENTIFIED BY app_test_password SQL> ALTER USER app_development DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp SQL> GRANT CONNECT, RESOURCE TO app_development IDENTIFIED BY app_development_password For reference I'm using ruby-oci8 2.0.4 and oracle_enhanced 1.3.1Ĭreate the development and test databases in Oracle using SQL*Plus $ sqlplus SYS/password AS SYSDBA Put these in your Gemfile and lock down to whatever version works.
ORACLE 10G DATABASE FREE DOWNLOAD INSTALL
Gem install activerecord-oracle_enhanced-adapter
To connect active record to oracle you'll need the oracle-enhanced driver. Then edit nls_lang.sh $ sudo vi /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.shĪnd try to source. If you see an error like this: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.shĪnd then source your. Set the Oracle Database XE Server Environment VariablesĪdd the following to $HOME/.bashrc # Oracle server environment To access the Database Home Page go to "" Starting Oracle Database 10g Express Edition Instance.Done This can be done afterĭo you want Oracle Database 10g Express Edition to be started on boot (y/n) :y Oracle recommends the use ofĭifferent passwords for each database account.
ORACLE 10G DATABASE FREE DOWNLOAD PASSWORD
Password will be used for SYS and SYSTEM. Specify a password to be used for database accounts. Specify a port that will be used for the database listener : Specify the HTTP port that will be used for Oracle Application Express :8080 The following questions will determine whether the database shouldīe starting upon system boot, the ports it will use, and the passwords that This will configure on-boot properties of Oracle Database 10g ExpressĮdition. Oracle Database 10g Express Edition Configuration $ sudo apt-get install -y libaioįollow the "Installing Oracle Database XE Server" setup instructions,Ĭhoosing the defaults. Install the Linux Async IO library, called either libaio or libaio1 depending on the Ubuntu version. See for the easiest way to add extra swap. Swap space, do you have enough? Oracle 10g requires 1Gb of swap, check how much you have before doing the install. NOTE: You may have to register to download the package.
ORACLE 10G DATABASE FREE DOWNLOAD FULL
Oracle 10g Express Edition (XE) is a simplified version of Oracle 10g designed to get you up and running with development, without wasting your time installing the full server edition. Tested using the following versions, others may work as well:
Notes on Setting up Oracle 10g XE with RailsĬapturing my notes about setting up an Oracle 10g XE / Rails environment for development work.