I followed the instructions there, only adding 1024 instead of 512 Mb. Reboot. Rerun the package installer (still not command line...) and voila!
Following those instructions, opened up a terminal:
chet@ubuntu:/etc$ sudo init.d/oracle-xe configureThat took about 10 minutes because it's an old underpowered machine, but I'm not worried about that now.
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
Specify a port that will be used for the database listener :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
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
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"
Open up SQL*Plus (via GUI...like I said, I'll get there) and login as sys:
SQL> conn / as sysdbaWait, I'm not logged in as root. OK, try again:
ORA-01031: insufficient privileges
SQL> conn sys/testing as sysdbaNice. 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;A couple of quick tasks and all seems to be well.
SQL> CREATE USER cjustice IDENTIFIED BY testing
2 DEFAULT TABLESPACE users
3 QUOTA UNLIMITED ON users;
SQL> GRANT DBA TO cjustice;
SQL> conn cjustice/testing
SQL> CREATE TABLE t
3 SELECT 'BOLLOCKS' t, rownum id
4 FROM dual
5 CONNECT BY LEVEL <= 1000;
Let's check out the website:
Probably something in the etc/hosts file that I need to update. I'll leave that for Part III.