linux系统给oracle数据库增加新的实例(1).pdf
版权申诉
13 浏览量
2023-03-11
23:37:47
上传
评论
收藏 38KB PDF 举报
linux系统给系统给oracle数据库增加新的实例数据库增加新的实例
eg: 新建实例名orcl
1、新增实例的⽬录
su - oracle
cd $ORACLE_BASE/admin
mkdir orcl
cd orcl
mkdir dbdump
mkdir adump
mkdir pfile
cd $ORACLE_BASE/oradate
mkdir orcl
2、新增实例的启动⽂件
cd $ORACLE_HOME/dbs
cp initorcl.ora initorcl.ora #复制⼀个原有的ora⽂件
vim initorcl.ora #修改为响应信息 ORACLE_BASE要改为绝对路径 不然会报错
3、创建密码⽂件
orapwd file=$ORACLE_BASE/product/10.2.0/db_1/dbs/orapwmydb password=turboblog entries=5 force=y
4、建库 、建数据字典
将下⾯的sql⽂件放到linux系统中
chmod 777 createdb.sql
CREATE DATABASE exchange
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/u01/app/oracle/oradata/exchange/system01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited extent
management local
sysaux datafile '/u01/app/oracle/oradata/exchange/sysaux01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited
default temporary tablespace TEMP tempfile '/u01/app/oracle/oradata/exchange/temp01.dbf' size 20m reuse autoextend on next 640k
maxsize unlimited
undo tablespace UNDOTBS1 datafile '/u01/app/oracle/oradata/exchange/undo01.dbf' size 20m reuse autoextend on next 5M maxsize
unlimited
logfile
GROUP 1 ('/u01/app/oracle/oradata/exchange/redo1.dbf') size 10m,
GROUP 2 ('/u01/app/oracle/oradata/exchange/redo2.dbf') size 10m,
GROUP 3 ('/u01/app/oracle/oradata/exchange/redo3.dbf') size 10m
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16;
资源评论
