Oracle11gR2手工建库

一、创建密码文件及初始化参数文件

创建密码文件

[oracle@oral bin]$ ./orapwd file=orapwdoral password=oracleentries=30

创建初始化参数文件

复制参数文件

[oracle@oral dbs]$ cp init.ora initoral.ora

修改参数文件

[oracle@oral dbs]$ vi initoral.ora

db_name='oral'

memory_target=1G

processes = 150

audit_file_dest='/u01/app/oracle/admin/oral/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/oral/ora_control1,/u01/app/oracle/oradata/oral/ora_control2)

compatible ='11.2.0'

二、创建数据库需要的相关目录

[oracle@oral oracle]$ mkdir -p admin/oral/adump

[oracle@oral oracle]$ mkdir -p flash_recovery_area

[oracle@oral oracle]$ mkdir -p oradata/oral

三、手工建库

创建数据库脚本create_db.sql

[oracle@oral ~]$ vi create_db.sql

CREATE DATABASE oral

 USERSYS IDENTIFIED BY sys

 USERSYSTEM IDENTIFIED BY system

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

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

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

 MAXLOGFILES 5

 MAXLOGMEMBERS 5

 MAXLOGHISTORY 1

 MAXDATAFILES 100

 CHARACTER SET AL32UTF8

 NATIONAL CHARACTER SET AL16UTF16

 EXTENT MANAGEMENT LOCAL

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

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

 DEFAULT TABLESPACE users

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

     SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

 DEFAULT TEMPORARY TABLESPACE tempts1

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

     SIZE 20M REUSE

 UNDOTABLESPACE undotbs1

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

     SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

 启动数据库到nomount状态

[oracle@oral bin]$ ./sqlplus / as sysdba

SQL> startup nomount

查看日志

[oracle@oral oracle]$ cd /u01/app/oracle/diag/rdbms/oral/oral/trace/

[oracle@oral trace]$ tail -100falert_oral.log

执行创建数据库脚本

SQL> @/home/oracle/create_db.sql 

Database created.

执行catalog.sql和catproc.sql脚本

catalog.sql是用来创建数据库的内部字典表

catproc.sql是用来创建数据库的内建的存储过程

 

SQL>@?/rdbms/admin/catalog.sql

SQL> @?/rdbms/admin/catproc.sql

检查一下数据库实例状态

SQL> select statusfrom v$instance; 

数据库手工建库完毕！

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24626757/viewspace-2121286/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24626757/viewspace-2121286/