Handing create database 总结:
1、bash_profile
2、make directory
3、password file
4、spfile
5、controlfile
1、vi ./.bash_profile
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=/u01/oracle/product/10.2.0/db_1
export ORACLE_SID=PROD
export PATH=$ORACLE_HOME/bin:/bin:/usr/sbin:$PATH
export EDITOR=vi
2、mkdir directory
【mkdir adump mkdir bdump mkdir cdump mkdir udump】
--可简写为一条 mkdir {a,b,c,d}dump
mkdir oradata/prod -r
mkdir /prod/disk{1,2}
---模拟多块磁盘,datafile放在disk1里,logfile写5 group,每组2个member,分别放在disk1,和disk2里,controlfile分别放在/prod,/disk1,/disk2里
3、orapw file=$ORACLE_HOME/dbs/orapwPROD
password=change_on_install entries=5
--注意密码文件命名,如果ORACLE_SID为大写,密码就需大写,eg:ORACLE_SID=PROD,则密码命名为orapw PROD
4.cat init.ora|grep -v ^$|grep -v ^# > initprod.ora
sga_max_size=300M
sga_target=300M
db_name=prod
audit_file_dest=/u01/app/oracle/admin/prod/adump
background_dump_dest=/u01/app/oracle/admin/prod/bdump
core_dump_dest=/u01/app/oracle/admin/prod/cdump
user_dump_dest=/u01/app/oracle/admin/prod/udump
undo_management=AUTO
control_files=( , , )--多路复用三份
----删掉buffer的参数,先在pfile里面把参数都编辑好,如果不记得,eg:background_dump_dest,就创建为spfile,再show parameter dump,用spfile修改~~
创建spfile,最麻烦,如果initprod.ora参数写的不对,就可能重复一下过程~一般都是路径不对或者字儿敲错了~细心~
SQL>startup nomount pfile=''
SQL>create spfile from pfile;
SQL>Startup force;
SQL>Startup nomount;
5.create controlfile
Document>administrator guard---creating an oracle database --issue create database statement
直接从官当中拷贝命令,用gedit编辑,replace工具替换,一定小心,改的主要几个地方:db_name,密码,字符集,重点是路径(数据文件,日志文件),还有删掉default tablespace tbs,
用gedit编辑之后,后空格问题,再放到脚本create.sql里反而不好,不如之际copy到SQL*PLUS里,然后再用vi编辑器编辑,运行即可~
做完记得冷备~
有时间,把/etc/hosts里的ip配一下~
====================================
Trubleshooting
1.ORA-00444,ORA-07446错误解决
SQL> startup nomount pfile='$ORACLE_HOME/dbs/initprod.ora';
ORA-00444: background process "MMAN" failed while starting
ORA-07446: sdnfy: bad value '' for parameter .
background_dump_dest='/u01/app/oracle/admin/prod/bdump'
位置写错了
SQL> startup nomount pfile='$ORACLE_HOME/dbs/initprod.ora';
ORA-00444: background process "MMAN" failed while starting
ORA-07446: sdnfy: bad value '' for parameter .
SQL> !oerr ora 00444
00444, 00000, "background process \"%s\" failed while starting"
// *Cause: Usually due to a bad (or non-existent) background process image.
// *Action: Get a good background process image.
SQL> ! oerr ora 07446
07446, 00000, "sdnfy: bad value '%s' for parameter %s."
// *Cause: The directory specified as the value for the stated parameter could
// not be used.
// *Action: Make sure the directory you have specified is a valid
// directory/file specification.
2.ORA-01100 错误解决
rm -rf /etc/oratab
rm -rf /etc/oracle/
rm -rf $ORACLE_HOME/
rm oraInventory目录
把控制文件,创建文件,配置文件删掉
shutdown immediate
startup nomount
@/u01/app/oracle/create.sql
3. linux技巧
3.1 替换所有的
:%s/ / /g
eg: :%s/mynewdb/ocmdb1/g
4.细心,报错就肯定有问题
eg: alter system job_queue_processes=5 scope=spfile;
set 掉了,报错了
遇到错 :oerr ora 错误编号
5.catalog 和catproc两个脚本不要运行,否则有作弊的嫌疑
待续······
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22815499/viewspace-741131/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22815499/viewspace-741131/