手动建库

最新推荐文章于 2025-08-12 22:08:46 发布

原创最新推荐文章于 2025-08-12 22:08:46 发布 · 431 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #测试

ORACLE基础知识专栏收录该内容

4 篇文章

订阅专栏

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

重启数据库即可。