最简单的oracle手动建库

------------------------------------------------------

创建目录
------------------------------------------------------

mkdir -p /u01/app/oracle/oradata/oradb1/

mkdir -p /u01/app/oracle/admin/oradb1/adump

mkdir -p /u01/app/oracle/admin/oradb1/bdump

mkdir -p /u01/app/oracle/admin/oradb1/cdump

mkdir -p /u01/app/oracle/admin/oradb1/udump

------------------------------------------------------
手动编辑初始化参数initoradb1.ora
------------------------------------------------------
db_name=oradb1
db_block_size=8192
sga_target=256m
pga_aggregate_target=50m
control_files='/u01/app/oracle/oradata/oradb1/control01.ctl','/u01/app/oracle/oradata/oradb1/control02.ctl','/u01/app/oracle/oradata/oradb1/control03.ctl'
background_dump_dest='/u01/app/oracle/admin/oradb1/bdump'
core_dump_dest='/u01/app/oracle/admin/oradb1/cdump'
user_dump_dest='/u01/app/oracle/admin/oradb1/udump'
undo_management=auto
undo_tablespace=undotbs1
------------------------------------------------------
创建数据库
------------------------------------------------------
export ORACLE_SID=oradb1

sqlplus / as sysdba

startup nomount

CREATE DATABASE oradb1
USER SYS IDENTIFIED BY password
USER SYSTEM IDENTIFIED BY password
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/oradb1/redo01.log') SIZE 100M,
GROUP 2 ('/u01/app/oracle/oradata/oradb1/redo02.log') SIZE 100M,
GROUP 3 ('/u01/app/oracle/oradata/oradb1/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET utf8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/app/oracle/oradata/oradb1/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/oradb1/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TEMPORARY TABLESPACE temp01
TEMPFILE '/u01/app/oracle/oradata/oradb1/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/u01/app/oracle/oradata/oradb1/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

调用脚本

@/u01/app/oracle/product/db_1/rdbms/admin/catalog.sql
@/u01app/oracle/product/db_1/rdbms/admin/catproc.sql

创建spfile

create spfile from pfile;

调用脚本

conn system/password
@/u01/app/oracle/product/db_1/sqlplus/admin/pupbld.sql

创建表空间和用户

conn / as sysdba
create tablespace users datafile '/u01/app/oracle/oradata/oradb1/data01.dbf' size 512m autoextend off;
create user magy identified by magy default tablespace users temporary tablespace temp;
grant connect,resource to magy;
grant unlimited tablespace to magy;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23382569/viewspace-747145/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23382569/viewspace-747145/