ORACLE 手动建库
来源:互联网 发布:网络歌手名单 编辑:程序博客网 时间:2024/06/11 14:35
1.切换环境变量
export ORACLE_SID=liu
2.创建pfile
$ORACLE_HOME/dbs/init.ora
用 cat init.ora | grep -v ^# > initliu.ora
db_name=liu
db_files = 80 # SMALL
db_file_multiblock_read_count = 8 # SMALL
#db_block_buffers = 100 # SMALL
#shared_pool_size = 3500000 # SMALL
log_checkpoint_interval = 10000 processes = 50 # SMALL parallel_max_servers = 5 # SMALL #log_buffer = 32768 # SMALL max_dump_file_size = 10240 # limit trace file size to 5 Meg each global_names = TRUE control_files = ('/u02/app/oracle/oradata/liu/control01.ctl','/u02/app/oracle/oradata/liu/contro l02.ctl','/u02/app/oracle/oradata/liu/control03.ctl') sga_target=300m background_dump_dest=/u02/app/oracle/admin/liu/bdump core_dump_dest=/u02/app/oracle/admin/liu/cdump
user_dump_dest=/u02/app/oracle/admin/liu/udump undo_management=auto undo_tablespace=tbs1 3.创建必要的相关目录 bdump cdump udump mkdir -p /u02/app/oracle/admin/bdump mkdir -p /u02/app/oracle/admin/cdump mkdir -p /u02/app/oracle/admin/udump 以nomount方式启动数据库 4.建库脚本 vi db.sql ################################################################## create database liu
user sys identified by oracle user system identified by oracle maxinstances 2 maxlogfiles 20 maxloghistory 20 maxdatafiles 2048 datafile '/u02/app/oracle/oradata/liu/system01.dbf' size 300m autoextend on next 30m maxsize unlimited sysaux datafile '/u02/app/oracle/oradata/liu/sysaux01.dbf' size 300m autoextend on next 30m maxsize unlimited undo tablespace tbs1 datafile '/u02/app/oracle/oradata/liu/undo01.dbf' size 50m autoextend on next 10m maxsize unlimited default temporary tablespace temp tempfile '/u02/app/oracle/oradata/liu/temp01.dbf' size 100m default tablespace data datafile '/u02/app/oracle/oradata/liu/data01.dbf' size 100m
logfile group 1 ('/u02/app/oracle/oradata/liu/redo01.rdo') size 20m, group 2 ('/u02/app/oracle/oradata/liu/redo02.rdo') size 20m, group 3 ('/u02/app/oracle/oradata/liu/redo03.rdo') size 20m; 5.运行脚本 @?/rdbms/admin/catalog @?/rdbms/admin/catproc conn system/oracle @?/sqlplus/admin/pupbld
- ORACLE 手动建库
- oracle手动建库脚本
- oracle 手动建库 --test
- oracle 之 手动建库
- ORACLE 10G 手动建库
- Oracle 9i 手动建库
- oracle 11g 手动建库
- 图解Oracle 12c 手动建库
- Oracle 11G 手动建库练习
- oracle install manually(手动建库)
- Oracle 11g R2 手动建库(create database manually)
- Oracle 11g R2 手动建库(create database manually)
- Oracle 11g R2 手动建库(create database manually)
- oracle 11gR2静默安装and手动建库
- oracle06_手动建库
- ASM 手动建库
- 手动建库
- 手动建库
- lsnr报错解决
- 动态链接库与静态链接库
- 发展、成就、薪水
- Azure(一):简介
- 在工程研究中心的第一天
- ORACLE 手动建库
- C/S 与 B/S 的区别
- c语言基本算法程序百例之十—数值转换
- 可用手势切换播放节目的android视频播放器
- 在vb.net 中判断input的press button是Cancel还是OK
- sql2005 清除日志
- 耦合度与设计模式
- 头一次
- Java正则表达式详解(转)