Oracle Installation and Database Creation

Oracle Editions

 

  • Oracle Lite Edition: Build, manage, deploy web apps for mobile devices
  • Express Edition: This is the FREE version of Oracle
  • Standard Edition One: 5 users minimum, 2 processors and webapp tools
  • Standard Edition: Single or clustered servers, upto 4 processors, support RAC (Real Application Clusters - meaning that you can have more that one oracle database instance tapping into a database)
  • Enterprise Edition: Standard Edition plus Data Guard (i.e in case you have one db going down, another one can pick up where u left off.), Data Mining Features, Data Warehousing, Online Analytic Processing, Fine Grained auditing, Flashback, Rolling upgrades (install upgrade patches without restarting the db), parallel operations (i.e you can do intensive queries with more than one process at the same time) etc.

 

more info at http://oracle.com

 

Installation Prerequisite

Check prerequisite information at http://tahiti.oracle.com

Linux

  • At least 1024MB RAM. You can - grep MemTotal /proc/meminfo
  • Swap space depends on RAM - grep SwapTotal /proc/meminfo
  • 400MB disk space in /tmp - df -k
  • 1.5 - 3.5GB disk space
  • At least 1.2GB disk space for Database
  • Make sure you have the right processor type

 

Windows

  • 256MB RAM, 512MB recommended
  • Virtual memory - Double the RAM
  • Disk space: 2.04GB + space for your data
  • 550 MHz processor minimum
  • 256 Video Adapter

 

How to do quiet install (method 2)

Windows:

  • on the command line switch to oracle home directory. similar to c:\database
  • Type setup -record -destinationFile c:\database\basic.rsp

Note: c:\database\basic.rsp can be put in any location. When you type the above command, it brings up the OUI. Enter the necessary info and click next until you get to the summary page where you have to click install. Click "Cancel instead". After you've done this, Enter in the command prompt dir *.rsp to see the new files that have been created.
- Type the command: setup -silent -responseFile c:\database\basic.rsp

 

method 3 (By Scratch)

Windows

  • Type oradim -new -sid <sid name>

This creates an Oracle service

  • Create an initialization file that has parameters for your database E.g
# inittest.ora
DB_NAME=test
INSTANCE_NAME=test.johnson
CONTROL_FILES = ("C:\oracle\product\10.2.0\oradata\control01.ctl", "c:\oracle\product\10.2.0\oradata\control02.ctl", "product\10.2.0\oradata\control03.ctl")
BACKGROUND_DUMP_DEST = c:\oracle\product\10.2.0\admin\bdump
USER_DUMP_DEST = C:\oracle\product\10.2.0\admin\udump
DB_FILES = 1000
UNDO_MANAGEMENT = auto
UNDO_TABLESPACE = undo
SHARED_POOL_SIZE = 75m

  • To run this script, you login to sqlplus as the OS user. To do this: Type> sqlplus / as sysdba
  • SQL> startup nomount pfile='c:\oracle\product\10.2.0\db_1\database\inittest.ora'
  • SQL> select status from v$instance; // This command creates oracle instance and not the database.
  • Create the database. Type in a file the following

-- create.sql
CREATE DATABASE test
MAXLOGFILES 32
MAXDATAFILES 500
DATAFILE 'c:\oracle\product\10.2.0\oradata\test\system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE 'c:\oracle\product\10.2.0\oradata\test\sysaux.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDO" DATAFILE 'c:\oracle\product\10.2.0\oradata\test\undo01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
CHARACTER SET WE8MSWIN1252
logfile 'c:\oracle\product\10.2.0\oradata\test\redo01.log' size 100M reuse, c:\oracle\product\10.2.0\oradata\test\redo02.log' size 100M reuse, c:\oracle\product\10.2.0\oradata\test\redo03.log' size 100M reuse

Note: Make sure you launch sqlplus where the create script is sitting. That way, you don't have to specify the directory where it is. We can just do @create.

  • SQL> select status from v$instance;

Post new comment

The content of this field is kept private and will not be shown publicly.