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 /
