ORACLE 手动建库

1. 安装ORACLE 软件。
2。 指定ORACLE SID
[oracle@rman ~]$ export ORACLE_SID=db1
[oracle@rman ~]$ echo $ORACLE_SID
db1

3.制定参数文件
[oracle@rman dbs]$ strings spfiletest.ora > initdb1.ora
修改参数文件：
替换命令：%s/test/db1/g
               %s/*\.//g

4. 创建参数文件所需的目录。
[oracle@rman dbs]$ mkdir -p ~/admin/db1/adump
[oracle@rman dbs]$ mkdir -p ~/oradata/db1
[oracle@rman dbs]$ mkdir -p ~/flash_recovery_area/db1

5. 创建SPFILE文件
SQL> create spfile from pfile;

File created.

6. 启动到NOMOUNT状态。
SQL> startup nomount;
ORACLE instance started.

Total System Global Area  631914496 bytes
Fixed Size                  1338364 bytes
Variable Size             301990916 bytes
Database Buffers          322961408 bytes
Redo Buffers                5623808 bytes

7. 执行创建数据库语句。
SQL> CREATE DATABASE db1
   USER SYS IDENTIFIED BY sys_password
   USER SYSTEM IDENTIFIED BY system_password
   LOGFILE GROUP 1 ('/home/oracle/oradata/db1/redo01a.log','/home/oracle/oradata/db1/redo01b.log') SIZE 100M BLOCKSIZE 512,
           GROUP 2 ('/home/oracle/oradata/db1/redo02a.log','/home/oracle/oradata/db1/redo02b.log') SIZE 100M BLOCKSIZE 512,
           GROUP 3 ('/home/oracle/oradata/db1/redo03a.log','/home/oracle/oradata/db1/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 '/home/oracle/oradata/db1/system01.dbf' SIZE 325M REUSE
   SYSAUX DATAFILE '/home/oracle/oradata/db1/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TABLESPACE users
      DATAFILE '/home/oracle/oradata/db1/users01.dbf'
      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/home/oracle/oradata/db1/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs
      DATAFILE '/home/oracle/oradata/db1/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

Database created.

 

8. 执行以下脚本建立数据字典等性息。
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/sqlplus/admin/pupbld.sql

重启数据库即可。

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

转载于:http://blog.itpub.net/22740983/viewspace-745144/