一步一步学习oracle手工建库（beta版）

          ① 配置listener.ora

             参考文档b14213（Net service reference）
             141页 静态注册的那个example
             第139页 第一段

             案例：

think =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS=(PROTOCOL = tcp)(HOST= 192.168.227.128)(PORT= 1521)     )    )  )SID_LIST_think =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = orcl.oracle.com)      (SID_NAME = orcl)      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)))

              注意事项：括号和空格要注意增补！

          ② 配置tnsnames.ora

             参考文档b14213 123页example
             案例：

orcl =  (DESCRIPTION =    (ADDRESS=(PROTOCOL= tcp)(HOST= 192.168.227.128)(PORT= 1521))    (CONNECT_DATA=(SERVICE_NAME= orcl.oracle.com)) )

          ③ 配置createdb.sql脚本

             参考b14231 第77页
             案例：

CREATE DATABASE orcl USER SYS IDENTIFIED BY oracle USER SYSTEM IDENTIFIED BY oracle LOGFILE GROUP 1 ('/u01/app/oracle/oradata/orcl/redo01.log') SIZE 100M,        GROUP 2 ('/u01/app/oracle/oradata/orcl/redo02.log') SIZE 100M,        GROUP 3 ('/u01/app/oracle/oradata/orcl/redo03.log') SIZE 100MMAXLOGFILES 5MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 100MAXINSTANCES 1CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16DATAFILE '/u01/app/oracle/oradata/orcl/system01.dbf' SIZE 600M REUSEEXTENT MANAGEMENT LOCALSYSAUX DATAFILE '/u01/app/oracle/oradata/orcl/sysaux01.dbf' SIZE 450M REUSEDEFAULT TABLESPACE usersDATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf' size 50M REUSE DEFAULT TEMPORARY TABLESPACE tempTEMPFILE '/u01/app/oracle/oradata/orcl/temp01.dbf'SIZE 20M REUSEUNDO TABLESPACE undotbsDATAFILE '/u01/app/oracle/oradata/orcl/undotbs01.dbf'SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

          ④ 创建目录

[oracle@localhost admin]$ pwd/u01/app/oracle/admin[oracle@localhost admin]$ mkdir -p orcl/{a,b,c,u,dp}dump[oracle@localhost flash_recovery_area]$ pwd/u01/app/oracle/flash_recovery_area[oracle@localhost admin]$ mkdir ORCL[oracle@localhost dbs]$ pwd/u01/app/oracle/product/10.2.0/db_1/dbs[oracle@localhost dbs]$ ls                    alert_orcl.log  hc_orcl.dat  hc_think.dat  initdw.ora  init.ora  snapcf_orcl.f

          ⑤ 创建密码文件

[oracle@localhost dbs]$ orapwd file=orapworcl password=oracle entries=5 

          ⑥ 配置pfile

[oracle@localhost dbs]$ cp -p init.ora  initorcl.ora[oracle@localhost dbs]$ grep -v '^#' initorcl.ora  | grep -v '^$' > initorcl.ora.test [oracle@localhost dbs]$ mv initorcl.ora.test  initorcl.ora

             案例：

db_name= orcldb_domain= oracle.comdb_files = 100db_file_multiblock_read_count = 128 processes = 1000 parallel_max_servers = 40open_cursors= 400 global_names = false control_files = '/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl','/u01/app/oracle/oradata/orcl/control03.ctl'sga_target = 900msga_max_size = 900mpga_aggregate_target= 450Mdb_recovery_file_dest = '/u01/app/oracle/flash_recovery_area'db_recovery_file_dest_size = 2Gundo_tablespace= undotbsundo_management= autoundo_retention = 900log_archive_dest_10='location=use_db_recovery_file_dest' 

          ⑦ 

     sqlplus /nolog     conn / as sysdba     create spfile from pfile；     startup     @createdb.sql

          ⑧ 运行4个包

     @?/rdbms/admin/catalog.sql     @?/rdbms/admin/catproc.sql     @?/rdbms/admin/dbmspool.sql     connect system/oracle     @?/sqlplus/admin/pupbld.sql

    小结：

           mysql一条create database xx就可以创建一个数据库，但oracle则不行。以上步骤只是个测试版，后续还会把更完善的步骤、和创建过程中相关错误呈上。