Scripts for Database Creation of 10g on SuSE 9.0

OCPdba.Net


The following scripts can be used to create a base database:

init.ora Database Creation init.ora
ILMG1.sh Shell script to run scripts
ILMG1.sql Shell script to run scripts
ILMG1-mod.sql This is the sql script without database options
 
ILMG1-mod.sql sub scripts:

CreateDB.sql Start the database instance and issue CREATE DATABASE command
CreateDBFiles.sql Create supporting database datafiles and tablespaces
CreateDBCatalog.sql Create data dictionary
postDBCreation.sql Create spfile, Close and Restart database
 
Database Options scripts - Run as you require these options:

JServer.sql JServer
context.sql Context
cwmlite.sql CWMLITE
emRepository.sql emRepository
interMedia.sql interMedia
odm.sql odm
odmmetadata.sql odmmetadata
ordinst.sql ordinst
spatial.sql spatial
ultraSearch.sql ultraSearch
ultraSearchCfg.sql ultraSearchCfg
xdb_protocol.sql xdb_protocol
 

OCPdba.Net