Este exemplo abaixo é para criação de uma instância em Oracle 10G e um banco de dados novo:
REM ::: Comandos em linha de execução pelo DOS
REM ===================================================================REM ::: Define o nome da instância
SET ORACLE_SID=BLOGSERVER
SET ORACLE_BASE=D:\oracle
SET ORACLE_HOME=D:\oracle\product\10.2.0\db_1
REM ::: Define o local para armazenamento do banco de dados e arquivos dos Oracle
REM ===================================================================
MD D:\oracle\product\ORADATA\BLOGSERVER
MD D:\oracle\product\10.2.0\admin\BLOGSERVER
MD D:\oracle\product\10.2.0\admin\BLOGSERVER\adump
MD D:\oracle\product\10.2.0\admin\BLOGSERVER\bdump
MD D:\oracle\product\10.2.0\admin\BLOGSERVER\cdump
MD D:\oracle\product\10.2.0\admin\BLOGSERVER\udump
MD D:\ORACLE\PRODUCT\10.2.0\ORADATA\BLOGSERVER\
REM ::: Criar o arquivo através do notepad o arquivo initBLOGSERVER.ora
REM ===================================================================
# init em ORACLE_HOME\product\10.2.0\db_1\database\initBLOGSERVER.ora
BLOGSERVER.__db_cache_size=578813952
BLOGSERVER.__java_pool_size=4194304
BLOGSERVER.__large_pool_size=4194304
BLOGSERVER.__shared_pool_size=335544320
BLOGSERVER.__streams_pool_size=4194304
*.audit_file_dest='D:\oracle\product\10.2.0/admin/BLOGSERVER/adump'
*.audit_trail='DB'
*.background_dump_dest='D:\oracle\product\10.2.0/admin/BLOGSERVER/bdump'
*.compatible='10.2.0.5.0'
*.control_files='D:\oracle\product\10.2.0/oradata/BLOGSERVER/\control01.ctl','D:\oracle\product\10.2.0/oradata/BLOGSERVER/\control02.ctl'
*.core_dump_dest='D:\oracle\product\10.2.0/admin/BLOGSERVER/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='DBBLOG'
*.db_recovery_file_dest='D:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name=''DBBLOG''
*.dispatchers='(PROTOCOL=TCP) (SERVICE=BLOGSERVERXDB)'
*.job_queue_processes=10
*.nls_language='BRAZILIAN PORTUGUESE'
*.nls_territory='BRAZIL'
*.open_cursors=1000
*.pga_aggregate_target=311427072
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=4G
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:\oracle\product\10.2.0/admin/BLOGSERVER/udump'
REM ::: Este comando criará o serviço no Windows e subirá a instância
REM ===================================================================
ORADIM -NEW -SID BLOGSERVER -SYSPWD pwd -STARTMODE AUTO -PFILE D:\oracle\product\10.2.0\db_1\database\initBLOGSERVER.ora
REM ::: Caso necessário, pode remover a instância através do comando abaixo
REM ===================================================================
REM ORADIM -DELETE -SID BLOGSERVER
REM ::: Após criada a instância, já será possível acessar viar SQLPLUS
REM ===================================================================
sqlplus/nolog
conn / as sysdba
startup nomount
REM ::: Assim que acessar em modo nomount, criaremos o banco de dados
REM ===================================================================
CREATE DATABASE DBBLOG
user sys identified by manager
user system identified by manager
controlfile reuse
logfile group 1 ('D:\oracle\product\ORADATA\BLOGSERVER\redo01.log') size 128m,
group 2 ('D:\oracle\product\ORADATA\BLOGSERVER\redo02.log') size 128m,
group 3 ('D:\oracle\product\ORADATA\BLOGSERVER\redo03.log') size 128m,
group 4 ('D:\oracle\product\ORADATA\BLOGSERVER\redo04.log') size 128m,
group 5 ('D:\oracle\product\ORADATA\BLOGSERVER\redo05.log') size 128m
maxinstances 8
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 100
character set WE8MSWIN1252
national character set AL16UTF16
set time_zone = 'Brazil/East'
datafile 'D:\oracle\product\ORADATA\BLOGSERVER\system01.dbf' size 300m reuse
autoextend on next 128m maxsize 4g
extent management local
SYSAUX datafile 'D:\oracle\product\ORADATA\BLOGSERVER\sysaux01.dbf' size 200m reuse
autoextend on next 128m maxsize 4g
default tablespace USERS
datafile 'D:\oracle\product\ORADATA\BLOGSERVER\users01.dbf' size 200m reuse
autoextend on next 128M maxsize 4g
extent management local
default temporary tablespace TEMP
tempfile 'D:\oracle\product\ORADATA\BLOGSERVER\temp01.dbf' size 1G reuse
autoextend on next 128m maxsize unlimited
undo tablespace UNDOTBS1
datafile 'D:\oracle\product\ORADATA\BLOGSERVER\undotbs01.dbf' size 200m reuse
autoextend on next 128m maxsize unlimited;
REM ::: Após criado o banco de dados, aplicaremos os pacotes de funções
REM ===================================================================
@D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\catalog.sql;
@D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\catblock.sql;
@D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\catproc.sql;
@D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\catoctk.sql;
@D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\owminst.plb;
@D:\oracle\product\10.2.0\db_1\sqlplus\admin\pupbld.sql;
@D:\oracle\product\10.2.0\db_1\sqlplus\admin\help\hlpbld.sql helpus.sql;
@D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\plustrace.sql;