Wednesday, January 21, 2009

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.

4 comments:

cdman83 said...

I'm happy that it worked :-)

Here are two additional tips:

- the text says that you should access 127.0.0.1:8080, but the screenshot shows you actually accessing 127.0.0.1 (you are missing the port)

- when taking screenshots you may want to put a couple of seconds delay in to make sure that the capture window isn't visible in the image

Best regards.

oraclenerd said...

I feel like a n00b!

Sure enough, fire up the database and add the 8080 port and I'm in.

Gratzi!

NIL said...

Hi,

I have already connected....

but I have another issue,, can you help me how can I add the UTL_FILE as parameter in Oracle XE?

Regards,

oraclenerd said...

NIL,

I'm not sure I follow. UTL_FILE is a package, not a parameter. Unless you are talking about UTL_FILE_DIR which specifies a location that Oracle can read and write to.

chet