ocm创建数据库

步骤
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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/66233/viewspace-690393/