oracle11g手工建库需要注意的点

1. 密码文件需要建在执行的目录，如果file不指定路径的话，将会创建在当前目录

[oracle@centos6 dbs]$ orapwdfile=/u01/app/oracle/product/11.2/dbs/orapwmynewdb

2. 从oracle的示例参数文件创建自己的参数文件，注意替换oracle_base为真实的路径，否则startup nomount时会报错。

db_name='MYNEWDB'

memory_target=512m

processes = 150

audit_file_dest='/u01/app/oracle/admin/mynewdb/adump'

audit_trail ='db'

db_block_size=8192

db_domain=''

db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'

db_recovery_file_dest_size=2G

diagnostic_dest='/u01/app/oracle'

dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'

open_cursors=300

remote_login_passwordfile='EXCLUSIVE'

undo_tablespace='UNDOTBS1'

CONTROL_FILES =(/u01/app/oracle/oradata/mynewdb/control01.ctl,

                /u01/app/oracle/oradata/mynewdb/control02.ctl,

                /u01/app/oracle/oradata/mynewdb/control03.ctl)

另外，需要根据参数文件中指定的路径创建相关的路径。

3.执行建库脚本的时候要注意建库脚本中的内容设置与参数文件一致，比如表空间名称，否则建库将会报错

CREATE DATABASE mynewdb

  USER SYS IDENTIFIED BY sys_password

  USER SYSTEM IDENTIFIED BY system_password

  LOGFILE GROUP 1('/u01/app/oracle/oradata/mynewdb/redo01a.log','/u01/app/oracle/oradata/mynewdb/redo01b.log')SIZE 100M BLOCKSIZE 512,

          GROUP 2('/u01/app/oracle/oradata/mynewdb/redo02a.log','/u01/app/oracle/oradata/mynewdb/redo02b.log')SIZE 100M BLOCKSIZE 512,

          GROUP 3('/u01/app/oracle/oradata/mynewdb/redo03a.log','/u01/app/oracle/oradata/mynewdb/redo03b.log')SIZE 100M BLOCKSIZE 512

  MAXLOGFILES 5

  MAXLOGMEMBERS 5

  MAXLOGHISTORY 1

  MAXDATAFILES 100

  CHARACTER SET US7ASCII

  NATIONAL CHARACTER SET AL16UTF16

  EXTENT MANAGEMENT LOCAL

  DATAFILE '/u01/app/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE

  SYSAUX DATAFILE '/u01/app/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325MREUSE

  DEFAULT TABLESPACE users

     DATAFILE '/u01/app/oracle/oradata/mynewdb/users01.dbf'

     SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

  DEFAULT TEMPORARY TABLESPACE tempts1

     TEMPFILE '/u01/app/oracle/oradata/mynewdb/temp01.dbf'

     SIZE 20M REUSE

  UNDO TABLESPACE undotbs1

     DATAFILE '/u01/app/oracle/oradata/mynewdb/undotbs01.dbf'

     SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

4.官方文档中的第三个脚本需要使用system执行，如果不执行这个脚本，创建新用户后将不能根据指定密码正常连接
@?/sqlplus/admin/pupbld.sql