手工创建数据库oracle11g r2

设置环境变量.bash_profile
然后创建初始口令文件
orapwd FILE=/u01/app/oracle/product/11.2.0/db_1/dbs/orapman PASSWORD=wy ENTRIES=5
在/u01/app/oracle/product/11.2.0/db_1/dbs目录下创建 initman.ora文件




创建文件夹 mkdir -p /export/home/mandata/man
          mkdir -p /u01/app/oracle/flash_recovery_area
           mkdir -p /u01/app/oracle/admin/man/adump
          
分配权限给oracle用户 
          chown -R oracle:dba /export/home/mandata
          chown -R oracle:dba /export/home/mandata/man
          chown -R oracle:dba /u01/app/oracle/flash_recovery_area
          chown -R oracle:dba /u01/app/oracle/admin/man/adump
 


登录sqlplus 创建SPFILE文件


Create SPFILE='/u01/app/oracle/product/11.2.0/db_1/dbs/SPFILEman.ora'
from PFILE='/u01/app/oracle/product/11.2.0/db_1/dbs/initman.ora' 




执行建库sql
CREATE DATABASE "man"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/export/home/mandata/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/export/home/mandata/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/export/home/mandata/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/export/home/mandata/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/export/home/mandata/redo01.dbf') SIZE 51200K,
GROUP 2 ('/export/home/mandata/redo02.dbf') SIZE 51200K,
GROUP 3 ('/export/home/mandata/redo03.dbf') SIZE 51200K
USER SYS IDENTIFIED BY "wy" USER SYSTEM IDENTIFIED BY "wy";


运行sql脚本创建数据字典和相关的包
catalog.sql:用于创建数据字典
catproc.sql:用于创建PL/SQL所需要的函数,过程，包等
@/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/catalog.sql
@/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/catproc.sql