Oracle XE on Ubuntu Intrepid Ibex - Part II

Last night I tried to install Oracle XE on my new Ubuntu Intrepid Ibex installation (Machine 3), but it failed due to lack of swap memory. Thankfully, cdman was reading and offered up this page in the Ubuntu documentation.

I followed the instructions there, only adding 1024 instead of 512 Mb. Reboot. Rerun the package installer (still not command line...) and voila!

From oraclenerd

Following those instructions, opened up a terminal:

chet@ubuntu:/etc$ sudo init.d/oracle-xe configure

Oracle Database 10g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 10g Express 
Edition.  The following questions will determine whether the database should 
be starting upon system boot, the ports it will use, and the passwords that 
will be used for database accounts.  Press  to accept the defaults. 
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:8080

Specify a port that will be used for the database listener [1521]:1521

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of 
different passwords for each database account.  This can be done after 
initial configuration:
Confirm the password:

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:n

Starting Oracle Net Listener...Done
Configuring Database...Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:8080/apex"

That took about 10 minutes because it's an old underpowered machine, but I'm not worried about that now.

Open up SQL*Plus (via GUI...like I said, I'll get there) and login as sys:

SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges

Wait, I'm not logged in as root. OK, try again:

SQL> conn sys/testing as sysdba
Connected.

Nice. Once I can figure out how to launch SQL*Plus (cdman, no hints!) from the command line I should be able to use the "conn / as sysdba" syntax by using sudo. So I'm in.

SQL> SELECT * FROM DUAL;

DUM
---
X

SQL> CREATE USER cjustice IDENTIFIED BY testing
  2    DEFAULT TABLESPACE users
  3    QUOTA UNLIMITED ON users;

User created.

SQL> GRANT DBA TO cjustice;

Grant succeeded.

SQL> conn cjustice/testing
Connected.
SQL> CREATE TABLE t
  2  AS 
  3  SELECT 'BOLLOCKS' t, rownum id
  4  FROM dual
  5    CONNECT BY LEVEL <= 1000;

Table created.

A couple of quick tasks and all seems to be well.

Let's check out the website:

From oraclenerd

WTF?

Probably something in the etc/hosts file that I need to update. I'll leave that for Part III.