Oracle 11g Manual Database Creation

Oracle 11g Manual Database Creation (Linux 32/64 & Solaris 32/64 bit)

step by step procedure:
——————————————
create all directory structure for your db according to your init file:

### Startup database with init file
startup nomount pfile=’$ORACLE_HOME/dbs/initsvtvmx.ora’;

### Run create database statement
CREATE DATABASE svtvmx
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE ‘/u01/oracle/oradata/svtvmx/system01.dbf’ SIZE 1G REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE ‘/u01/oracle/oradata/svtvmx/sysaux01.dbf’ SIZE 500M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE ‘/u01/oracle/oradata/svtvmx/temp01.dbf’ SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE “UNDOTBS1” DATAFILE ‘/u01/oracle/oradata/svtvmx/undotbs01.dbf’ SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET UTF8
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 (‘/u01/oracle/oradata/svtvmx/redo01.log’) SIZE 20M,
GROUP 2 (‘/u01/oracle/oradata/svtvmx/redo02.log’) SIZE 20M,
GROUP 3 (‘/u01/oracle/oradata/svtvmx/redo03.log’) SIZE 20M
USER SYS IDENTIFIED BY svtvmx USER SYSTEM IDENTIFIED BY svtvmx

### Create default tablespace
CREATE TABLESPACE “USERS” LOGGING DATAFILE ‘/u01/oracle/oradata/svtvmx/users01.dbf’ SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

ALTER DATABASE DEFAULT TABLESPACE “USERS”

### install catalogs…
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catblock.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
@$ORACLE_HOME/rdbms/admin/catoctk.sql
@$ORACLE_HOME/rdbms/admin/owminst.plb
@$ORACLE_HOME/sqlplus/admin/pupbld.sql

connect “SYSTEM”/”&&systemPassword”

set echo on

@$ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql
@$ORACLE_HOME/javavm/install/initjvm.sql
@$ORACLE_HOME/xdk/admin/initxml.sql
@$ORACLE_HOME/xdk/admin/xmlja.sql
@$ORACLE_HOME/rdbms/admin/catjava.sql
@$ORACLE_HOME/rdbms/admin/catexf.sql
@$ORACLE_HOME/ctx/admin/catctx no1knows SYSAUX TEMP NOLOCK
@$ORACLE_HOME/ctx/admin/defaults/dr0defin.sql ‘AMERICAN’
@$ORACLE_HOME/rdbms/admin/catqm.sql no1knows SYSAUX TEMP
@$ORACLE_HOME/rdbms/admin/catxdbj.sql
@$ORACLE_HOME/rdbms/admin/catrul.sql
@$ORACLE_HOME/ord/admin/ordinst.sql SYSAUX SYSAUX
@$ORACLE_HOME/ord/im/admin/iminst.sql
@$ORACLE_HOME/olap/admin/olap.sql SYSAUX TEMP
@$ORACLE_HOME/md/admin/mdinst.sql
@$ORACLE_HOME/ultrasearch/admin/wk0install.sql SYS no1knows SYSAUX TEMP “” PORTAL false
@$ORACLE_HOME/sysman/admin/emdrep/sql/emreposcre $ORACLE_HOME SYSMAN SYSMAN TEMP ON
@$ORACLE_HOME/apex/catapx.sql change_on_install SYSAUX SYSAUX TEMP /i/ NONE
@$ORACLE_HOME/rdbms/admin/cat_owb.sql SYSAUX TEMP
@$ORACLE_HOME/ultrasearch/admin/wk0config.sql change_on_install (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=svtvmx.db.com)(PORT=2533))(CONNECT_DATA=(SERVER=DEDICATED)
(SERVICE_NAME=svtvmx))) false ” “

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply