linux系统给oracle数据库增加新的实例

eg:  新建实例名orcl

1、新增实例的目录

su - oracle

cd $ORACLE_BASE/admin

mkdir orcl

cd orcl

mkdir dbdump 

mkdir  adump

mkdir  pfile

cd $ORACLE_BASE/oradate

2、新增实例的启动文件

cd $ORACLE_HOME/dbs

cp initorcl.ora initorcl.ora  #复制一个原有的ora文件

vim initorcl.ora  #修改为响应信息  ORACLE_BASE要改为绝对路径 不然会报错

3、创建密码文件

orapwd file=$ORACLE_BASE/product/10.2.0/db_1/dbs/orapwmydb password=turboblog entries=5 force=y

4、建库 、建数据字典

将下面的sql文件放到linux系统中

chmod 777 createdb.sql

CREATE DATABASE exchange

MAXINSTANCES 8

MAXLOGHISTORY 1

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

DATAFILE '/u01/app/oracle/oradata/exchange/system01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited extent management local

sysaux datafile '/u01/app/oracle/oradata/exchange/sysaux01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited

default temporary tablespace TEMP tempfile '/u01/app/oracle/oradata/exchange/temp01.dbf' size 20m reuse autoextend on next 640k maxsize unlimited

undo tablespace UNDOTBS1 datafile '/u01/app/oracle/oradata/exchange/undo01.dbf' size 20m reuse autoextend on next 5M maxsize unlimited

logfile

GROUP 1 ('/u01/app/oracle/oradata/exchange/redo1.dbf') size 10m,

GROUP 2 ('/u01/app/oracle/oradata/exchange/redo2.dbf') size 10m,

GROUP 3 ('/u01/app/oracle/oradata/exchange/redo3.dbf') size 10m

CHARACTER SET ZHS16GBK

NATIONAL CHARACTER SET AL16UTF16;

export ORACLE_SID=orcl

sqlplus / as sysdba

SQL> startup  nomount;

SQL>@路径+createdb.sql

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

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

SQL> @?/sqlplus/admin/pupbld.sql;

SQL>startup force;

SQL>exit;

5、建监听

cd  $ORACLE_BASE/product/10.2.0/db_1/network/admin

vim listener.ora

增加节点：

(SID_DESC =

      (GLOBAL_DBNAME = orcl)

      (ORACLE_HOME = /oracle/app/product/10.2.0/db)

      (SID_NAME = orcl)

    )

重启监听