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)
http://localhost:8080/apex/
or
http://127.0.0.1:8080/apex/

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.
@test
or
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 (help.ubuntu.com)
Orafusion.com Resources