Criar um banco de dados sem o DBCA

Segue script de criação de um banco de dados Oracle 10g sem interface gráfica, considerando que neste ponto, vc já criou o init, ajustou variáveis de ambiente, criou o serviço(apenas para windows) e iniciou a instance em nomount.


--no sqlplus com sysdba
CREATE DATABASE man01
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/u02/oradata/man01/redo01.log') SIZE 1000M,
GROUP 2 ('/u02/oradata/man01/redo02.log') SIZE 1000M,
GROUP 3 ('/u02/oradata/man01/redo03.log') SIZE 1000M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u02/oradata/man01/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u02/oradata/man01/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE '/u02/oradata/man01/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u02/oradata/man01/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE 10g;

CONNECT SYS/password AS SYSDBA
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql

EXIT

##############Criar ts adicionais
-- create a user tablespace to be assigned as the default tablespace for users
CREATE TABLESPACE users LOGGING
DATAFILE '/u02/oradata/man01/users01.dbf'
SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE 5g
EXTENT MANAGEMENT LOCAL;

##############instalar jvm
@$ORACLE_HOME/javavm/install/initjvm.sql

##############instalar XDB
catqm.sql
#Create the tables and views needed to run XML DB
For example:

catqm.sql change_on_install XDB TEMP
Reconnect to SYS again and run the following:

catxdbj.sql #Load xdb java library
Ex:
@$ORACLE_HOME/rdbms/admin/catqm.sql xdb users temp
@$ORACLE_HOME/rdbms/admin/catxdbj.sql

###################com user system
@?/sqlplus/admin/pupbld.sql