CREATE DATABASE ORCL
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
LOGFILE GROUP 1 ('/u1/ORCL/redo01.log') SIZE 100M,
GROUP 2 ('/u1/ORCL/redo02.log') SIZE 100M,
GROUP 3 ('/u1/ORCL/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u1/ORCL/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u1/ORCL/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u1/ORCL/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u1/ORCL/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u1/ORCL/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
@/oracle/app/product/10.2.0/rdbms/admin/catalog.sql
@/oracle/app/product/10.2.0/rdbms/admin/catproc.sql
run trong system
@/oracle/app/product/10.2.0/sqlplus/admin/pupbld.sql
SQL>@?/rdbms/admin/utltkprf.sql
SQL>@?/rdbms/admin/utlxplan.sql
SQL>@?/rdbms/admin/utlpwdmg.sql
SQL>@?/rdbms/admin/utlbstat.sql
SQL>@?/rdbms/admin/utlestat.sql
SQL>@?/rdbms/admin/owminst.plb
SQL>@?/javavm/install/initjvm.sql
SQL>@?/xdk/admin/initxml.sql
SQL>@?/rdbms/admin/utldtree.sql
SQL>@?/rdbms/admin/catblock.sql
SQL>@?/rdbms/admin/caths.sql
SQL>@?/xdk/admin/xmlja.sql
SQL>@?/rdbms/admin/catjava.sql
SQL>@?/rdbms/admin/catexf.sql
@$ORACLE_HOME/rdbms/admin/catexf.sql
@G:\app\fiscal.dba\product\11.2.0\dbhome_1\RDBMS\ADMIN\exfeapvs.plb