Solaris 11 Oracle DB 11g R2(11.2.0.3) Single on ASM 설치

● Solaris 11 Oracle DB 11g R2(11.2.0.3) Single on ASM 설치
Grid, ASM, DB 설치

1) 설치 준비
설치 파일 준비

2) 환경변수 설정
[grid]
export EDITOR=vi
export HOST='solaris'
export USER='grid'
export PS1='['`hostname`':$PWD]$ '
export ORACLE_SID=+ASM
export LANG=C
export ORACLE_BASE=/grid/app/grid
export ORACLE_HOME=/grid/app/11.2.0/grid
#export NLS_LANG=AMERICAN_AMERICA.UTF8
#export NLS_LANG=American_America.ko16ksc5601
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$PATH:.:$ORACLE_HOME/bin:/usr/bin:/sbin:/usr/ccs/bin:/usr/bin/X11
export PATH=$PATH:$ORACLE_HOME/bin:/oracle/dba:$ORA_CRS_HOME/bin:$ORACLE_HOME/OPatch

[oracle]
export EDITOR=vi
export HOST='solaris'
export USER='oracle'
export PS1='['`hostname`':$PWD]$ '
export ORACLE_SID=orcl1
#export ORACLE_SID=orcl2
export LANG=C
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2
export ORACLE_CRS_HOME=/grid/app/11.2.0/grid
#export NLS_LANG=AMERICAN_AMERICA.UTF8
#export NLS_LANG=American_America.ko16ksc5601
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$PATH:.:$ORACLE_HOME/bin:/usr/bin:/sbin:/usr/ccs/bin:/usr/bin/X11
export PATH=$PATH:$ORACLE_HOME/bin:/oracle/dba:$ORA_CRS_HOME/bin:$ORACLE_HOME/OPatch

3) Grid Infrastructure 설치
./runInstaller
Skip software updates 선택

4) Select installation option
Install grid infrastructure software only 선택

5) 언어 설정
KOREAN 추가

6) sys암호 설정
oracle 입력

7) 계정 별 권한 선택
dba 확인

8)  홈 설정
ORACLE_BASE=/grid/app/grid
Software Location= /grid/app/11.2.0/grid (grid user home directory)

9) 인벤토리 설정
/grid/oraInventory

10) 설정 확인

11) 설치
스크립트 등 설치

12) 종료

13) Grid 설치 확인
[solaris:/grid]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
               OFFLINE OFFLINE      solaris                              
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        OFFLINE OFFLINE                                                  
ora.diskmon
      1        OFFLINE OFFLINE                                                  
ora.evmd
      1        ONLINE  ONLINE       solaris

14) ASMCA를 이용한 DISK Group 생성
[solaris:/grid]$ asmca
DATA_orcl1, DATA_orcl2, RECO_orcl1, RECO_orcl2 생성

15) ASM 확인
[solaris:/oracle]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA_orcl1.dg
               ONLINE  ONLINE       solaris                              
ora.DATA_orcl2.dg
               ONLINE  ONLINE       solaris                              
ora.RECO_orcl1.dg
               ONLINE  ONLINE       solaris                              
ora.RECO_orcl2.dg
               ONLINE  ONLINE       solaris                              
ora.asm
               ONLINE  ONLINE       solaris           Started            
ora.ons
               OFFLINE OFFLINE      solaris                              
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       solaris                              
ora.diskmon
      1        OFFLINE OFFLINE                                                  
ora.evmd
      1        ONLINE  ONLINE       solaris
16) DB 엔진 설치
./runInstaller

17) Software updates
Skip software updates 선택

18) Installation option
Install database software only 선택

19) 언어 설정
KOREAN 추가

20) Select Database Edition
Standard Edition One 선택

21) 홈 경로 설정
ORACLE_BASE=/oracle/app/oracle
Software Location=/oracle/app/oracle/product/11.2 (oracle user home directory)

22) 권한 설정
dba

23) 설정 확인

24) 설치
스크립트 등 실행
설치 완료

25) DB 설치 (SID 별로 2번 진행)
dbca 실행

26) Operations
Create a Database 선택

27) Database templates
General Purpose or Transaction Processing 선택

28) SID 설정
orcl1, orcl2

29) sys 암호 설정
oracle 입력

30) Database File Locations
Storage Type: Automatic Storage management 선택
DATA 그룹 선택
DATA_orcl1, DATA_orcl2

31) Database Content
Sample schemas 체크 해제

32) Recovery Configuration
FRA 활성화 및 RECO_orcl1, RECO_orcl2 선택
Archive log 활성화

33) Initialization Parameters
SGA = 15G
Process = 1000
Character Set = UTF8, KO16KSC5601

34) 설정 확인 & redo log 사이즈 변경
100M, 1 Member 4 Group 구성

35) Creation Options
Create database 선택
Finish

36) 리스너 구성
Netca를 이용하여 구성
2개의 인스턴스에 전용 리스너 구성(운영DB 리스너구성 참고)

37) 최종 구성 확인
[solaris:/oracle]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA_orcl1.dg
               ONLINE  ONLINE       solaris                              
ora.DATA_orcl2.dg
               ONLINE  ONLINE       solaris                              
ora.LISTENER.lsnr
               ONLINE  ONLINE       solaris                              
ora.LISTENER_orcl2.lsnr
               ONLINE  ONLINE       solaris                              
ora.RECO_orcl1.dg
               ONLINE  ONLINE       solaris                              
ora.RECO_orcl2.dg
               ONLINE  ONLINE       solaris                              
ora.asm
               ONLINE  ONLINE       solaris           Started            
ora.ons
               OFFLINE OFFLINE      solaris                              
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       solaris                              
ora.diskmon
      1        OFFLINE OFFLINE                                                  
ora.evmd
      1        ONLINE  ONLINE       solaris                              
ora.ozskdorcl1.db
      1        ONLINE  ONLINE       solaris           Open               
ora.ozskdorcl2.db
      1        ONLINE  ONLINE       solaris           Open
     
38) 완료