Building Oracle Database from scratch

Building Oracle Database from scratch

Choose a custom database creation, do not allow DBCA to create the database, only generate the scripts. Edit the init.ora file.

The following init.ora was used for smhslive. 

  

###########################################

# Archive

###########################################

log_archive_format=ARC%S_%R.%T

 

###########################################

# Cache and I/O

###########################################

db_block_size=8192

 

###########################################

# Database Identification

###########################################

db_domain=""

db_name="smhslive"

 

###########################################

# File Configuration

###########################################

control_files=("D:\oradata\smhslive\control01.ctl", "E:\FRA\smhslive\control02.ctl")

db_recovery_file_dest="E:\FRA"

db_recovery_file_dest_size=10737418240

 

###########################################

# Miscellaneous

###########################################

diagnostic_dest=c:\ora11g

 

###########################################

# NLS

###########################################

nls_language="ENGLISH"

nls_territory="UNITED KINGDOM"

 

###########################################

# SGA Memory

###########################################

sga_max_size=12G

sga_target=12G

 

###########################################

# Security and Auditing

###########################################

audit_file_dest="c:\ora11g\admin\smhslive\adump"

remote_login_passwordfile=EXCLUSIVE

 

 

###########################################

# Sort, Hash Joins, Bitmap Indexes

###########################################

pga_aggregate_target=4G

 

###########################################

# System Managed Undo and Rollback Segments

###########################################

undo_tablespace=UNDOTBS1

#  Added by SKD

sessions=665

smtp_out_server='xxx'

processes=900

open_cursors=1000

session_cached_cursors=1000

compatible=10.2.0.5

optimizer_features_enable=’10.2.0.5’

db_block_checking=FULL

db_block_checksum=FULL

recyclebin=OFF

cursor_sharing=FORCE

control_management_pack_access='NONE'

aq_tm_processes=1

job_queue_processes=100

resource_limit=TRUE

sec_case_sensitive_logon=FALSE

java_pool_size=128M

audit_trail='NONE'

_query_on_physical=false

_client_enable_auto_unregister=true

_shared_pool_reserved_min_alloc= 4000

db_create_file_dest='e:\oradata'

Prevent junk from being installed

The only components to install: base Oracle, Java, XML, Oracle Workspace Manager and Oracle Text (which is free and needed by SMHS):

CATALOG

CATJAVA

CATPROC

CONTEXT

JAVAVM

OWM

XDB

XML

Edit the database creation scripts according to the following instructions.

CreateDB.sql

Append this to turn on ARCHIVELOG mode from the moment of database creation:

ARCHIVELOG;

postDBCreation.sql

Append the following at the end of the script:

alter database force logging;

alter database flashback on;

exec DBMS_AUTO_TASK_ADMIN.DISABLE('AUTO SPACE ADVISOR',NULL,NULL);

exec DBMS_AUTO_TASK_ADMIN.DISABLE('SQL TUNING ADVISOR',NULL,NULL);

commit;

create restore point db_created;

JServer.sql

Disable catexf.sql:

-- @c:\ora11g\product\11.2.0\dbhome_1\rdbms\admin\catexf.sql;

xdb_protocol.sql

Disable catrul.sql

-- @c:\ora11g\product\11.2.0\dbhome_1\rdbms\admin\catrul.sql;

smhslive.sql

Comment out the ACCEPT commands and add the following password definitions:

DEF sysPassword = 

DEF systemPassword = 

DEF dbsnmpPassword = 

In the host command for orapwd add the sys password

password=xxx