Oracle11g 手动建库

环境说明–数据库版本：11.0.2.4

设置环境变量

[oracle@vastdata1 ~]$ set ORACLE_SID=PROD

构造参数文件

[oracle@vastdata1 dbs]$ cat init.ora|grep -v ^$|grep -v ^# >initPROD.ora

修改参数文件

[oracle@vastdata1 dbs]$ vi initPROD.oradb_name='PROD'memory_target=1Gprocesses = 150audit_file_dest='/u01/app/oracle/admin/prod/adump'audit_trail ='db'db_block_size=8192db_domain=''db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'db_recovery_file_dest_size=2Gdiagnostic_dest='/u01/app/oracle'dispatchers='(PROTOCOL=TCP) (SERVICE=PRODLXDB)'open_cursors=300remote_login_passwordfile='EXCLUSIVE'undo_tablespace='UNDOTBS1'control_files = (/u01/app/oracle/oradata/PROD/control01.ctl,/u01/app/oracle/oradata/PROD/control02.ctl)compatible ='11.2.0'

根据参数文件创建相应的目录

[oracle@vastdata1 ~]$ mkdir -p /u01/app/oracle/admin/prod/adump[oracle@vastdata1 ~]$ mkdir -p /u01/app/oracle/flash_recovery_area[oracle@vastdata1 ~]$ mkdir -p /u01/app/oracle/oradata/PROD

编辑建库脚本

[oracle@vastdata1 ~]$ cat create_db.sqlCREATE DATABASE PROD   USER SYS IDENTIFIED BY oracle   USER SYSTEM IDENTIFIED BY oracle   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD/redo01a.log','/u01/app/oracle/oradata/PROD/redo01b.log') SIZE 100M BLOCKSIZE 512,           GROUP 2 ('/u01/app/oracle/oradata/PROD/redo02a.log','/u01/app/oracle/oradata/PROD/redo02b.log') SIZE 100M BLOCKSIZE 512,           GROUP 3 ('/u01/app/oracle/oradata/PROD/redo03a.log','/u01/app/oracle/oradata/PROD/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/PROD/system01.dbf' SIZE 325M REUSE   SYSAUX DATAFILE '/u01/app/oracle/oradata/PROD/sysaux01.dbf' SIZE 325M REUSE   DEFAULT TABLESPACE users      DATAFILE '/u01/app/oracle/oradata/PROD/users01.dbf'      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED   DEFAULT TEMPORARY TABLESPACE tempts1      TEMPFILE '/u01/app/oracle/oradata/PROD/temp01.dbf'      SIZE 20M REUSE   UNDO TABLESPACE undotbs1      DATAFILE '/u01/app/oracle/oradata/PROD/undotbs01.dbf'      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

将数据库启动到nomount状态

SQL> startup nomount

运行创建脚本

SQL> @/home/oracle/create_db.sql

查看数据库状态

SQL> select status from v$instance;

创建数据字典视图

SQL> @?/rdbms/admin/catalog.sqlSQL> @?/rdbms/admin/catproc.sqlSQL> @?/sqlplus/admin/pupbld.sql