步骤
1.确定SID
2.创建相关目录
3.创建并且编辑初始化文件
4.生成密码文件
5.生成spfile
6.创建数据库
7.运行catalog.sql catproc.sql
1.设置SID
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/10.2.0
2. 创建相关目录
cd /oracle
mkdir -p app/orcl/adump
mkdir -p app/orcl/bdump
mkdir -p app/orcl/cdump
mkdir -p app/orcl/udump
mkdir -p oradata
3.创建口令文件
$cd $ORACLE_HOME/dbs
$orapwd file=orapworcl password=orcl
-----------考题中会给你说创建的密码文件
4.. 创建初始化文件
cd $ORACLE_HOME/dbs
cat init.ora|grep -v ^#|grep -v ^$ >aa.sql
db_name=DEFAULT
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 = (ora_control1, ora_control2)
修改为
[oracle@node1 ~]$ more a.sql
db_block_size = 8192
db_files = 1000
pga_aggregate_target = 30M #DEMO
sga_max_size=500m
sga_target=500m
undo_tablespace=undotbs1
undo_management=auto
optimizer_mode = all_rows
db_file_multiblock_read_count = 16
db_name = orcl -考题中需要的数据库名
control_files = (/oracle/oradata/control01.ctl) -----考题中需要的目录,名称
sql>create spfile from pfile='/home/oracle/a.sql';
SQL> show parameter db_create
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string /oracle/oradata
db_create_online_log_dest_1 string /oracle/oradata
sql>alter system set db_create_file_dest='/oracle/oradata' scope=spfile;
sql>alter system set db_create_online_log_dest_1='/oracle/oradata' scope=spfile;
SQL> show parameter dump
NAME TYPE VALUE
------------------------------------ ----------- -----------------------------
background_core_dump string partial
background_dump_dest string /oracle/admin/orcl/bdump
core_dump_dest string /oracle/admin/orcl/cdump
max_dump_file_size string UNLIMITED
shadow_core_dump string partial
user_dump_dest string /oracle/admin/orcl/cdump
sql>alter system set background_dump_dest='/oracle/admin/orcl/bdump' scope=spfile;
sql>alter system set core_dump_dest='/oracle/admin/orcl/cdump' scope=spfile;
sql>alter system set user_dump_dest='/oracle/admin/orcl/udump' scope=spfile;
sql>shutdown immediate
sql>startup
5.创建数据库
从administrator guide 中搞出相关的脚本,编辑,然后创建
6.执行包
sql>@?/rdbms/admin/catalog.sql
sql>@?/rdbms/admin/catproc.sql
7.备份数据库
可以做冷备份
cp -r orcl orclbak
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/66233/viewspace-690393/,如需转载,请注明出处,否则将追究法律责任。