unix下Oracle創(chuàng)建實(shí)例的方法
下面為您介紹的Oracle創(chuàng)建實(shí)例的方法是在unix下Oracle創(chuàng)建實(shí)例的方法，如果您對Oracle創(chuàng)建實(shí)例方面感興趣的話，不妨一看。
#unix系統(tǒng)存儲：邏輯卷組--》邏輯卷---》文件系統(tǒng)---》文件夾---》文件
#查看邏輯卷
vgdisplay
#一般有三個(gè)邏輯卷組
#/dev/vg00（系統(tǒng)邏輯卷） /dev/vgitapp（應(yīng)用邏輯卷） /dev/vgitdb（數(shù)據(jù)存儲邏輯卷）
#創(chuàng)建邏輯卷 hp-ux
lvcreate -L 120000 -n lv_itsmdb01 /dev/vgitdb
# 120000 單位是：m
#創(chuàng)建文件系統(tǒng)
newfs -F vxfs /dev/vgitdb/rlv_itsmdb01
#路徑根據(jù)oracel安裝目錄進(jìn)行相應(yīng)修改
創(chuàng)建目錄/oracle/app/oracle/oradata執(zhí)行組和用戶為dba和oracle
#mount文件系統(tǒng)
#路徑根據(jù)oracel安裝目錄進(jìn)行相應(yīng)修改
mount -F vxfs /dev/vgitdb/lv_itsmdb01 /oracle/app/oracle/oradata
#oracle帳戶登錄系統(tǒng)
#建文件夾
- mkdir /oracle/admin/itsm3/cdump /oracle/admin/itsm3/udump /oracle/admin/itsm3/logs /oracle/admin/itsm3/bdump
- /oracle/admin/itsm3/pfile
- /oracle/oradata/itsm3/archive
- sqlplus /nolog
- conn SYS/admin as SYSDBA
- set echo off
- spool $ORACLE_BASE/admin/itsm3/logs/Createitsm3.log
#如沒有Createitsm3.log，自己創(chuàng)建這個(gè)文件
startup nomount pfile=$ORACLE_HOME/dbs/inititsm3.ora
#自己創(chuàng)建inititsm3.ora（內(nèi)容從其他的實(shí)例下尋找，之后修改），執(zhí)行此命令后若報(bào)錯(cuò)，一般都是文件夾沒有，或者創(chuàng)建未知不對，自行查找對應(yīng)
- CREATE DATABASE itsm3
- LOGFILE
- GROUP 1 ('/oracle/oradata/itsm3/redo01.log') SIZE 102400K,
- GROUP 2 ('/oracle/oradata/itsm3/redo02.log') SIZE 102400K,
- GROUP 3 ('/oracle/oradata/itsm3/redo03.log') SIZE 102400K
- MAXLOGHISTORY 1
- MAXLOGFILES 5
- MAXLOGMEMBERS 3
- ARCHIVELOG
- DATAFILE '/oracle/oradata/itsm3/system01.dbf' SIZE 250M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
- DEFAULT TEMPORARY TABLESPACE temp
- Tempfile '/oracle/oradata/itsm3/temp01.dbf' size 40M autoextend on next 5120k MAXSIZE UNLIMITED
- undo tablespace undotbs
- datafile '/oracle/oradata/itsm3/undotbs01.dbf' size 100M autoextend on next 5120k MAXSIZE UNLIMITED
- MAXINSTANCES 1
- MAXDATAFILES 1024
- CHARACTER SET UTF8
- NATIONAL CHARACTER SET UTF8;
- alter tablespace system default storage
- (initial 64K minextents 1
- maxextents unlimited pctincrease 50);
- alter tablespace system minimum extent 64k;
- create temporary tablespace tempitims
- Tempfile '$ORADATA_DICT/$ORACLE_SID/tempitims.dbf' size 100M
- autoextend on next 5120k MAXSIZE 200M
- extent management local;
- CREATE TABLESPACE users
- LOGGING
- DATAFILE '$ORADATA_DICT/$ORACLE_SID/user01.DBF'
- SIZE 10M AUTOEXTEND ON NEXT 5M MAXSIZE 30M
- BLOCKSIZE 4096 EXTENT MANAGEMENT LOCAL UNIFORM size 204800
- SEGMENT SPACE MANAGEMENT AUTO;
- spool off
- spool $ORACLE_BASE/admin/$ORACLE_SID/logs/Createcatalog.log
- @$ORACLE_HOME/rdbms/admin/catalog.sql
- spool off
- spool $ORACLE_BASE/admin/$ORACLE_SID/logs/Createcatproc.log
- @$ORACLE_HOME/rdbms/admin/catproc.sql
- spool off
- spool $ORACLE_BASE/admin/$ORACLE_SID/logs/Createcatexp7.log
- @$ORACLE_HOME/rdbms/admin/catexp7.sql
- spool off
- spool $ORACLE_BASE/admin/$ORACLE_SID/logs/Createcatrep.log
- @$ORACLE_HOME/rdbms/admin/catrep.sql
- spool off
- spool $ORACLE_BASE/admin/$ORACLE_SID/logs/Createcaths.log
- @$ORACLE_HOME/rdbms/admin/caths.sql
- spool off
- connect system/manager
- spool $ORACLE_BASE/admin/$ORACLE_SID/logs/Createpupbld.log
- @$ORACLE_HOME/sqlplus/admin/pupbld.sql
- spool off
- exit
- --Create Tablespace spActiveAlm
- CREATE TABLESPACE itsmtablespaces
- LOGGING
- DATAFILE '/oracle/itsm3data/itsm3/itsmtablespaces.DBF'
#目錄要進(jìn)行修改
- SIZE 50M AUTOEXTEND ON NEXT 10M MAXSIZE 10000M
- BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL UNIFORM size 409600
- SEGMENT SPACE MANAGEMENT AUTO;
- --create user itims
- conn sys/admin as sysdba
- set echo on
- spool $ORACLE_BASE/admin/$ORACLE_SID（也可以是itsm3）/logs/createUsers.log
- CREATE USER itsm
- IDENTIFIED BY itsm1234
- DEFAULT TABLESPACE USERS
- TEMPORARY TABLESPACE TEMPITIMS;
- grant dba to itsm;
- spool off
- exit;
#$ORACLE_SID 是環(huán)境變量，通過設(shè)置.profile 得到，可以寫成絕對路徑 如：/oracle/../.. 點(diǎn)對應(yīng)你自己建的目錄
【編輯推薦】
