Ubuntu and oracle setup and usage

===== Orcale open 8080 port to wetwork
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
http://192.168.0.99:8080/apex

Some useful Bash scripts for Oracle management:
http://www.akadia.com/services/ora_linux_install_10g.html

Run sqlplus on another server:
sqlplus det2/det2@'(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.102)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = xe)))'

Arrow keys on sqlplus!!!!!!!!!!!!!!! -> use gqlplus
http://gqlplus.sourceforge.net/
Download and copy binary file from folder Linux to $ORACLE_HOME/bin
or
http://sysdba.wordpress.com/2006/10/08/how-to-use-rlwrap-to-get-a-command-history-in-sqlplus/
sudo apt-get install rlwrap
alias sqlp='rlwrap sqlplus'

Extend amount of connectoins to DB:
http://naveenkanth.blogspot.com/2008/07/ora-12519-ora-12505.html
ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE
select name,value from v$parameter where name in('sessions','processes');