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)

    )

重新開機監聽