peace love linux logo

Oracle Database 10g Express Edition on Ubuntu Linux (Notes)

Tested on Ubuntu Linux 7.10 Gutsy Gibbon. (2008-12-02)

Installation: Configure the database.
sudo /etc/init.d/oracle-xe configure

Stop the database.
sudo /etc/init.d/oracle-xe stop

Start the database.
sudo /etc/init.d/oracle-xe start

Access the web-interface. (Login: system)

Login to the database shell. (The database has to be running!)
sqlplus system as sysdba

Execute a PL/SQL script (test.sql) in the database shell. (SQL> ...)
Be sure to change to the directory of the script before logging into the database.
start test.sql

Check the current date format. (e.g. if you have the error ORA-01843: not a valid month)
create table date_test as select sysdate dt from dual;
select dt from date_test;

Change the current date format. (example date format)
alter session set NLS_DATE_FORMAT='yyyy-mm-dd';

Related page

Oracle 10g Express Edition on Ubuntu ( Resources