Running Oracle Databases on Linux
[ Home ] [ UK Price Comparison Sites ] [ UK Broadband Internet Access ] [ Mobile Phones ] [ Shopping ] [ UK Job Sites ] [ Other Topics ]
 

How to run Oracle on Linux

Oracle is a great database. You can run it at home on your PC for free for development purposes, but once your site on the internet (you are creating websites aren't you?) you'll have to pay Oracle a brown envelope stuffed full of money.

• List of guides to installing Oracle

  openacs.org/doc/openacs-4/oracle.html- Open ACS's guide to installing Oracle 8.1.7, derived from documentation at Ars Digita, who used Oracle extensively.

  oraworld.com/tips.htm - List of Oracle install guides

  linuxdoc.org/HOWTO/Oracle-8-HOWTO.html

   

• Oracle documentation

  Tahiti.oracle.com

   

• Oracle/Linux Presentations

  See dbatoolbox.com or

  dbspecialists.com/4dbas/present.html

  • Installing and Configuring Oracle on the Linux Platform

    dbspecialists.com/4dbas/presos/oracle816linux.html

     

  • Configuring Oracle on Linux For Peak Performance

    dbspecialists.com/4dbas/presos/LinuxWorldTutorialHK.html

     

  • Installing and Configuring Oracle on the Linux Platform

    dbspecialists.com/4dbas/presos/inst_ora_on_linux.html

   

• Tips for Using Oracle

  Selected tips from philip.greenspun.com/wtr/oracle-tips.html (includes optimising tips)

  • Hire the best dba that you can.

    Fire your dba if he or she can't make your Oracle installation pass the following acceptance tests:

    • philip.greenspun.com/wtr/oracle/acceptance-sql.txt  (to be run as the user that the Web server runs as)
    • philip.greenspun.com/wtr/oracle/system-test-sql.txt (to be run as a user with DBA privileges)

     

  • Dating and Oracle

    A good general rule with Oracle is that every parameter in the default Oracle installation is wrong. Date format is no exception. Here's what you should have for starters in your $ORACLE_HOME/dbs/initora8.ora:

    # Use ANSI date format by default!

    nls_date_format = "YYYY-MM-DD"

Now you have robust database, you may want to see try my page on e-commerce.