oracle手动添加一个数据库,oracle手动添加数据库

文件带有TEST的行是加载原来的实例库一下四行得删除，及pga_aggregate_target = 94371840

background_dump_dest

= /oracle/app/admin/TEST/bdump

user_dump_dest

= /oracle/app/admin/TEST/udump

core_dump_dest

= /oracle/app/admin/TEST/cdump

audit_file_dest

= /oracle/app/admin/TEST/adump

将control_files和db_name 这行的TEST改成新的实例库名字

(3)建立密码文件

orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=123456 force=y

(4)建立所需的目录

[oracle@sq ~]$ mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/adump

[oracle@sq ~]$ mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/bdump

[oracle@sq ~]$ mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/pfile

[oracle@sq ~]$ mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/cdump

[oracle@sq ~]$ mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/dpdump

[oracle@sq ~]$ mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/udump

此时还应创建新的数据库目录

[oracle@sq2 dbs]$ mkdir -p /oracle/app/oradata/NIMEIA/

(5)建立spfile

SQL> startup nomount

SQL> create spfile from pfile;

(6)建立新实例的数据库

vi /home/oracle/createDB.sql内容：

create database NIMEIA

logfile group 1 ('$ORACLE_BASE/oradata/NIMEIA/redo01.log') size 100m,

group 2 ('$ORACLE_BASE/oradata/NIMEIA/redo02.log') size 100m,

group 3 ('$ORACLE_BASE/oradata/NIMEIA/redo03.log') size 100m

maxlogfiles 10

maxlogmembers 5

maxloghistory 5

maxdatafiles 100

maxinstances 1

character set zhs16gbk

national character set al16utf16

datafile '$ORACLE_BASE/oradata/NIMEIA/system01.dbf' size 350m reuse autoextend on next 1m maxsize unlimited extent management local

sysaux datafile '$ORACLE_BASE/oradata/sysaux01.dbf' size 350m reuse autoextend on next 1m maxsize unlimited

default temporary tablespace temp01 tempfile '$ORACLE_BASE/oradata/NIMEIA/temp01.dbf' size 50m reuse autoextend on next 1m maxsize 500m

undo tablespace undotbs1 datafile '$ORACLE_BASE/oradata/NIMEIA/undotbs01.dbf' size 500m reuse autoextend on next 1m maxsize unlimited;

(7)开始建库SQL> @/home/oracle/createDB.sql

此时的数据库字典都不能使用。

(8)建立数据库字典视图@/$ORACLE_HOME/rdbms/admin/catalog.sql

(9)建立存储过程包@/$ORACLE_HOME/rdbms/admin/catproc.sql

成功后显示

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Package body created.

No errors.

Package body created.

PL/SQL procedure successfully completed.