This is all 32 bit, no 64 bit software will be covered here.<\/p>\n
To get Oracle 10g in 2013 requires a support account of course. Only 11g is available now. Basically I needed Oracle 10 because its still quite heavily used in global business circles. My security testing software <\/a>may run into Oracle 10 (in fact, already has several times).<\/p>\n After some considerable problems with library linking related failures with Oracle 10g and Ubuntu 12 (12.04.2), I decided to just save time by backdating and using more compatible libraries. The install with Ubuntu 10.04.4 Lucid Lynx. The install with this older version (this is only for dev work, trust me i wouldn’t dream of using this in production) went like a dream.<\/p>\n Note that many install guides insist on installing Oracle’s Java or some other JVM. I found that this was not necessary.<\/p>\n and then libstdc++5 will be required. I found it here eventually…<\/p>\n http:\/\/old-releases.ubuntu.com\/ubuntu\/pool\/universe\/g\/gcc-3.3\/libstdc++5_3.3.6-17ubuntu1_i386.deb<\/p>\n and then …<\/p>\n This process installs the library in the right place (at least where the installer for Oracle looks).<\/p>\n In \/etc\/sysctl.conf …<\/p>\n Reload to take effect…<\/p>\n root@vm-ubuntu-11:~# \/sbin\/sysctl -p<\/p>\n vi \/etc\/security\/limits.conf<\/p>\n Add the following …<\/p>\n (Ubuntu isn’t a supported distro for Oracle DB and some subtle changes are needed) I went with more typical Oracle style directories here for some reason, but you can choose what’s best for you, as long as the ownership is set correctly (watch this space)…<\/p>\n Add the following …<\/p>\n Add this … The zip file from Oracle – you will have unzipped it, it can be anywhere on the system, lets say \/opt. Then what’s needed? Start up an X environment (su to Oracle and startx), open a Terminal and… Do not select the “create starter database” here and selection of Enterprise Edition worked for me, with the Installation Type option.<\/p>\n The installer will ask you run 2 scripts as root. Its is wise to follow this advisory.<\/p>\n The install proceeded fast. I only had one error related to the RDBMS compliation (“Error in invoking target ‘all_no_orcl ihsodbc’ of makefile ‘\/u01\/oracle\/product\/10.2.0\/db_1\/rdbms\/lib\/ins_rdbms.mk'”), but this was because I had not installed the libstdc++5<\/p>\n So what you have now is a database engine but with no database to serve, and no Listener to process client connections to said database.<\/p>\n Again. within the Oracle owned X environment…<\/p>\n and default options will work here, just to get a database working. netca is in $ORACLE_HOME\/bin and therefore in the shell $PATH. Easy.<\/p>\n First up you need to find the GID for the oinstall group you created earlier…<\/p>\n In my case it was 1001. <\/p>\n As root (UID=0) hose this into the \/proc hugetlb_shm_group thus…<\/p>\n Again, as oracle user, do this…<\/p>\n …and again, default options will work in most cases here.<\/p>\n The database name should match the ORACLE_SID environment variable you specified earlier.<\/p>\n The install script created a oratab file under \/etc. The last part of the stanza (the “Y”) implies “yes” please start this SID on system start. This is your choice of course.<\/p>\n dbstart is a shell script under $ORACLE_HOME\/bin. One line needs to be changed here in most cases…this is a basic substitution of your $ORACLE_HOME in place of the “\/ade\/vikrkuma_new\/oracle” in the line after the comment “Set this to bring up Oracle Net Listener”: “ORACLE_HOME_LISTNER=\/ade\/vikrkuma_new\/oracle”<\/p>\n # Set this to bring up Oracle Net Listener<\/p>\n if [ ! $ORACLE_HOME_LISTNER ] ; then And that should be sufficient to just get a database up and running.<\/p>\n To shutdown the database<\/strong>, Oracle provides $ORACLE_HOME\/bin\/dbshut and this won’t require any editing.<\/p>\n Personally I like to be able to control the Oracle database service with service binary as in: The script here to go under \/etc\/init.d was the same as my script for Oracle Database 11g…<\/p>\n ORA_HOME=\"\/u01\/oracle\/product\/10.2.0\/db_1\"<\/p>\n ORA_OWNR=\"oracle\"<\/p>\n # if the executables do not exist -- display error<\/p>\n if [ ! -f $ORA_HOME\/bin\/dbstart -o ! -d $ORA_HOME ] # depending on parameter -- startup, shutdown, restart case \"$1\" in #Optional : for Enterprise Manager software only touch \/var\/lock\/oracle #Optional : for Enterprise Manager software only su - $ORA_OWNR -c \"$ORA_HOME\/bin\/lsnrctl stop\" Most likely the only change required will be the ORA_HOME setting which obviously is your $ORACLE_HOME.<\/p>\n So after all this, how do we know our database is up and running? sqlplus \/ as sysdba<\/p>\n This should drop you into the antiquated text based app and look something like…<\/p>\n SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jun 21 07:57:43 2013<\/p>\n Copyright (c) 1982, 2005, Oracle. All rights reserved.<\/p>\n Connected to: SQL> This post is based to some extent the following two posts: Some parts of these posts didn’t work for me (I had lots of linking errors), but nonetheless thanks go out to the authors of those blogs.<\/p>\n","protected":false},"excerpt":{"rendered":" This is all 32 bit, no 64 bit software will be covered here. To get Oracle 10g in 2013 requires a support account of course. Only 11g is available now. Basically I needed Oracle 10 because its still quite heavily … Continue reading Java<\/h2>\n
Other Libraries<\/h2>\n
dpkg -i\u00a0libstdc++5_3.3.6-17ubuntu1_i386.deb<\/code><\/p>\nUsers and Groups<\/h2>\n
sudo group add oinstall
\nsudo group add dba
\nsudo group add nobody
\nsudo user add -m oracle -g oinstall -G dba
\nsudo passwd oracle<\/code><\/p>\nKernel Parameters<\/h2>\n
kernel.shmall = 2097152
\nkernel.shmmax = 2147483648
\nkernel.shmmni = 4096
\nkernel.sem = 250 32000 100 128
\nfs.file-max = 65536
\nnet.ipv4.ip_local_port_range = 1024 65000<\/code><\/p>\nkernel.shmall = 2097152
\nkernel.shmmax = 2147483648
\nkernel.shmmni = 4096
\nkernel.sem = 250 32000 100 128
\nfs.file-max = 65536
\nnet.ipv4.ip_local_port_range = 1024 65000<\/code><\/p>\nChange Limits<\/h2>\n
* soft nproc 2047
\n* hard nproc 16384
\n* soft nofile 1024
\n* hard nofile 65536<\/code><\/p>\nChange The System In A Suse Kinda Way<\/h2>\n
\n
\nsudo ln -s \/usr\/bin\/awk \/bin\/awk
\nsudo ln -s \/usr\/bin\/rpm \/bin\/rpm
\nsudoln -s \/lib\/libgcc_s.so.1 \/lib\/libgcc_s.so
\nsudo ln -s \/usr\/bin\/basename \/bin\/basename<\/code><\/p>\nOracle Base Directory<\/h2>\n
sudo mkdir -p \/u01\/oracle
\nsudo chown -R oracle:oinstall \/u01
\nsudo chmod -R 770 \/u01<\/code><\/p>\nUpdate default profile<\/h2>\n
vi \/etc\/profile<\/code><\/p>\nexport ORACLE_BASE=\/u01\/oracle
\nexport ORACLE_HOME=\/u01\/oracle\/product\/10.2.0\/db_1
\nexport ORACLE_SID=orcl10
\nexport PATH=$PATH:$ORACLE_HOME\/bin<\/code><\/p>\nConvince Oracle that Ubuntu is Redhat<\/h2>\n
sudo vi \/etc\/redhat-release<\/code><\/p>\n
\n“Red Hat Enterprise Linux AS release 3 (Taroon)”<\/p>\nRun The Installer<\/h2>\n
\nSo after unzipping you will see a \/opt\/database directory.<\/p>\nchown -R oracle:install \/opt\/database<\/code><\/p>\n
\n
\n\/opt\/database\/runInstaller<\/code><\/p>\nInstaller Options<\/h2>\n
Create a Listener<\/h2>\n
netca<\/code><\/p>\nCreate A Database<\/h2>\n
cat \/etc\/group | grep oinstall<\/code><\/p>\necho \"dbca<\/code><\/p>\nDatabase Service Control<\/h2>\n
\nIt may look something similar to…
\n
\nroot@ubuntu:~# cat \/etc\/oratab
\n....[comments]
\norcl10:\/u01\/oracle\/product\/10.2.0\/db_1:Y
\n<\/code><\/p>\nORACLE_HOME_LISTNER=\/ade\/vikrkuma_new\/oracle<\/p>\n
\necho \"ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener\"
\nelse
\nLOG=$ORACLE_HOME_LISTNER\/listener.log
\n<\/code><\/p>\n“service” Control Under Linux<\/h2>\n
\nservice oracle start<\/code>
\nand
\nservice oracle stop<\/code><\/p>\nroot@ubuntu:~# cat \/etc\/init.d\/oracle
\n#!\/bin\/bash
\n#
\n# Run-level Startup script for the Oracle Instance and Listener
\n#
\n### BEGIN INIT INFO
\n# Provides: Oracle
\n# Required-Start: $remote_fs $syslog
\n# Required-Stop: $remote_fs $syslog
\n# Default-Start: 2 3 4 5
\n# Default-Stop: 0 1 6
\n# Short-Description: Startup\/Shutdown Oracle listener and instance
\n### END INIT INFO<\/p>\n
\nthen
\n echo \"Oracle startup: cannot start\"
\n exit 1
\nfi<\/p>\n
\n# of the instance and listener or usage display<\/p>\n
\n start)
\n # Oracle listener and instance startup
\n echo -n \"Starting Oracle: \"
\n su - $ORA_OWNR -c \"$ORA_HOME\/bin\/dbstart $ORA_HOME\"
\n su - $ORA_OWNR -c \"$ORA_HOME\/bin\/lsnrctl start\"<\/p>\n
\n su - $ORA_OWNR -c \"$ORA_HOME\/bin\/emctl start dbconsole\"<\/p>\n
\n echo \"OK\"
\n ;;
\n stop)
\n # Oracle listener and instance shutdown
\n echo -n \"Shutdown Oracle: \"<\/p>\n
\n su - $ORA_OWNR -c \"$ORA_HOME\/bin\/emctl stop dbconsole\"<\/p>\n
\n su - $ORA_OWNR -c \"$ORA_HOME\/bin\/dbshut $ORA_HOME\"
\n rm -f \/var\/lock\/oracle
\n echo \"OK\"
\n ;;
\n reload|restart)
\n $0 stop
\n $0 start
\n ;;
\n *)
\n echo \"Usage: $0 start|stop|restart|reload\"
\n exit 1
\nesac
\nexit 0<\/code><\/p>\nQuick Test<\/h2>\n
\nTry a local test…as Oracle user…<\/p>\noracle@ubuntu:~$ sqlplus \/ as sysdba<\/p>\n
\nOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
\nWith the Partitioning, OLAP and Data Mining options<\/p>\n
\n<\/code><\/p>\nCredits<\/h2>\n
\nhttp:\/\/www.excession.org.uk\/blog\/installing-oracle-on-ubuntu-karmic-64-bit.html<\/a>
\nand
\nhttp:\/\/sqlandplsql.com\/2011\/12\/02\/installing-oracle-11g-on-ubuntu\/<\/a><\/p>\n