Monday, February 28, 2011

Prepare Database Environment

The best way to get this done is to refer installation guide.

Install Oracle Enterprise Linux
Install Oracle Database
Some useful blog:
Oracle Validated RPM
Installing Oracle Database 11g on Linux
Installing Oracle Database 11g Release 1 on Enterprise Linux 5 (32- and 64-bit)
Create Oracle Database Tablespaces
CREATE BIGFILE TABLESPACE FSMS_DATA DATAFILE 'fsms_data.dat' size 10G AUTOEXTEND ON NEXT 1G MAXSIZE 100G;
CREATE BIGFILE TABLESPACE FSMS_IDEX DATAFILE 'fsms_idex.dat' size 10G AUTOEXTEND ON NEXT 1G MAXSIZE 100G;
Create database user and grant required privileges
Create user "fsms" and grant required privileges (ex. create table,create view) and access to tablespace FSMS_DATA,FSMS_IDEX

No comments: