Installing Oracle Express on 64 bit Ubuntu

http://littlebrain.org/2008/05/12/how-to-install-oracle-xe-in-ubuntu-64-bit/

http://forums.oracle.com/forums/thread.jspa?threadID=848385&tstart=45

This is nothing to worry about – update-rc.d: warning: /etc/init.d/oracle-xe missing LSB style header

After it’s been installed, configure it:

sudo /etc/init.d/oracle-xe configure

Configure stuff, I used all defaults I believe.

Next in order to run sqlplus to do anything you need to source the config file:

source /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh

Which in turn gave me this error:

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found

Which is entirely related to what shell that it is trying to run on. In the file definition you’ll find #! /bin/sh and if you change this to #! /bin/bash it will run properly. Fixed!

Now doing a – ‘which sqlplus’ should return a path to sqlplus like this:

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus

SQLPLUS /NOLOG

CONNECT username/password

All of this so I can ‘Enable Remote HTTP Connection with SQL Command Line’

EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

Now I have to reconfigure port forwarding on my router at home in order to remotely access the Oracle Admin Website and router.

To access the Oracle Admin Site remote I should be able to go to:

http://host:port/apex

Where host = my domain name or IP and port = the default 8080 port I setup

I need to port forward 8080 requests to the server but I can’t remotely change my router yet.

I currently have it forwarding port 80 to the server but in order to change the router remotely I’m supposed to access myip:80

So one of those two needs to change.

Change HTTP or FTP port via SQLPLUS

SQL> begin

2    dbms_xdb.sethttpport(’80’);

3    dbms_xdb.setftpport(‘2100’);

4  end;

5  /

CONNECT username/password
All of this so I can ‘Enable Remote HTTP Connection with SQL Command Line’ EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);Now I have to reconfigure port forwarding on my router at home in order to remotely access the Oracle Admin Website and router.To access the Oracle Admin Site remote I should be able to go to:http://host:port/apexWhere host = my domain name or IP and port = the default 8080 port I setupI need to port forward 8080 requests to the server but I can’t remotely change my router yet.I currently have it forwarding port 80 to the server but in order to change the router remotely I’m supposed to access myip:80So one of those two needs to change.
Change HTTP or FTP port via SQLPLUS
SQL> begin 2    dbms_xdb.sethttpport(’80’); 3    dbms_xdb.setftpport(‘2100′); 4  end; 5  /

So one of those two needs to change.

Change HTTP or FTP port via SQLPLUS

SQL> begin

2    dbms_xdb.sethttpport(’80’);

3    dbms_xdb.setftpport(‘2100’);

4  end;

5  /