Oracle Exadata TEST Single Database Installation : Install Database S/W & TEST Database

5. Install Database S/W & TEST Database

   

1) ASM Disk 구성

-Grid, Oracle 계정 Path 지정(.bash_profile)

[Grid] export PATH export ORACLE_BASE=/home/grid/app export ORACLE_HOME=/home/grid/11.2.0/grid export PATH=$PATH:$ORACLE_HOME/bin export ORACLE_SID=+ASM1

[Oracle] export PATH export ORACLE_BASE=/home/oracle/app export ORACLE_HOME=/home/oracle/11.2.0/db export PATH=$PATH:$ORACLE_HOME/bin export ORACLE_SID=EXAORCL1 export ORACLE_UNQNAME=EXAORCL

   

①ASMCA

[grid@exadb1 ~]$ ls 11.2.0 app oradiag_grid setup [grid@exadb1 ~]$ [grid@exadb1 ~]$ asmca

   

-oradata01로 구성된 모든 Disk를 선택해서 External로 구성을 진행하였다.

-Cell Disk를 2개이상으로 구성할 경우에 High, Normal로도 구성이 가능하다.

   

[ASM 추가 내역 확인] [grid@exadb1 bin]$ ./crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE exadb1 ora.MGMT.dg ONLINE ONLINE exadb1 ora.ORADATA01.dg ONLINE ONLINE exadb1 ora.asm ONLINE ONLINE exadb1 Started ora.gsd OFFLINE OFFLINE exadb1 ora.net1.network ONLINE ONLINE exadb1 ora.ons ONLINE ONLINE exadb1 ora.registry.acfs ONLINE ONLINE exadb1 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE exadb1 ora.cvu 1 ONLINE ONLINE exadb1 ora.exadb1.vip 1 ONLINE ONLINE exadb1 ora.oc4j 1 ONLINE ONLINE exadb1 ora.scan1.vip 1 ONLINE ONLINE exadb1 [grid@exadb1 bin]$

   

2) Install DB S/W

①DB 설치 파일 이관 및 unzip

   

②DB S/W Only 설치 진행

install readme.html response rpm runInstaller sshsetup stage welcome.html [oracle@exadb1 database]$ [oracle@exadb1 database]$ ./runInstaller Starting Oracle Universal Installer...

   

   

-Install database software only 선택

   

   

-SSH Connectivity 설치 (Oracle)

   

   

-위 해당 에러는 무시하고 진행

   

   

[root@exadb1 ~]# /home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh Performing root user operation for Oracle 11g     The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /home/oracle/app/oracle/product/11.2.0/dbhome_1     Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite.     Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Finished product-specific root actions. [root@exadb1 ~]#

   

   

   

3) Create TEST DB

① DB 생성

[oracle@exadb1 ~]$ [oracle@exadb1 ~]$ dbca

   

   

-Oracle Real Application Clusters (RAC) database 선택

   

   

-SID 지정

   

   

-ASM DISK 선택 후에 해당 DISK GROUP 선택

   

   

-DB가 구성되는데 시간이 조금 오래 걸릴 수 있으니 기다리면 된다.(alert log를 확인)

4) Oracle Exadata 상태확인

   

① Oracle Exadata 구성 상태 확인

[grid@exadb1 ~]$ crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE exadb1 ora.MGMT.dg ONLINE ONLINE exadb1 ora.ORADATA1.dg ONLINE ONLINE exadb1 ora.asm ONLINE ONLINE exadb1 Started ora.gsd OFFLINE OFFLINE exadb1 ora.net1.network ONLINE ONLINE exadb1 ora.ons ONLINE ONLINE exadb1 ora.registry.acfs ONLINE ONLINE exadb1 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE exadb1 ora.cvu 1 ONLINE ONLINE exadb1 ora.exadb1.vip 1 ONLINE ONLINE exadb1 ora.exaorcl.db 1 ONLINE ONLINE exadb1 Open ora.oc4j 1 ONLINE ONLINE exadb1 ora.scan1.vip 1 ONLINE ONLINE exadb1

SQL> SELECT NAME, ALLOCATION_UNIT_SIZE AU, STATE, TYPE, TOTAL_MB, COMPATIBILITY FROM V$ASM_DISKGROUP;     NAME AU STATE TYPE TOTAL_MB ------------------------------ ---------- ----------- ------ ---------- COMPATIBILITY ------------------------------------------------------------ MGMT 4194304 MOUNTED EXTERN 896 11.2.0.4.0     ORADATA1 4194304 CONNECTED EXTERN 4480 11.2.0.4.0         SQL> SELECT LIBRARY, TOTAL_MB, NAME, FAILGROUP, LABEL FROM V$ASM_DISK ORDER BY FAILGROUP, NAME;     LIBRARY TOTAL_MB ---------------------------------------------------------------- ---------- NAME FAILGROUP ------------------------------ ------------------------------ LABEL ------------------------------- CELL 448 DATA_CD_DISK01_STOCELL1 DATA_CD_DISK01_STOCELL1 DATA_CD_DISK01_STOCELL1     CELL 448 DATA_CD_DISK02_STOCELL1 DATA_CD_DISK02_STOCELL1 DATA_CD_DISK02_STOCELL1     LIBRARY TOTAL_MB ---------------------------------------------------------------- ---------- NAME FAILGROUP ------------------------------ ------------------------------ LABEL -------------------------------     CELL 448 DATA_CD_DISK03_STOCELL1 DATA_CD_DISK03_STOCELL1 DATA_CD_DISK03_STOCELL1     CELL 448 DATA_CD_DISK04_STOCELL1 DATA_CD_DISK04_STOCELL1     LIBRARY TOTAL_MB ---------------------------------------------------------------- ---------- NAME FAILGROUP ------------------------------ ------------------------------ LABEL ------------------------------- DATA_CD_DISK04_STOCELL1     CELL 448 DATA_CD_DISK05_STOCELL1 DATA_CD_DISK05_STOCELL1 DATA_CD_DISK05_STOCELL1     CELL 448     LIBRARY TOTAL_MB ---------------------------------------------------------------- ---------- NAME FAILGROUP ------------------------------ ------------------------------ LABEL ------------------------------- DATA_CD_DISK06_STOCELL1 DATA_CD_DISK06_STOCELL1 DATA_CD_DISK06_STOCELL1     CELL 448 DATA_CD_DISK07_STOCELL1 DATA_CD_DISK07_STOCELL1 DATA_CD_DISK07_STOCELL1         LIBRARY TOTAL_MB ---------------------------------------------------------------- ---------- NAME FAILGROUP ------------------------------ ------------------------------ LABEL ------------------------------- CELL 448 DATA_CD_DISK08_STOCELL1 DATA_CD_DISK08_STOCELL1 DATA_CD_DISK08_STOCELL1     CELL 448 DATA_CD_DISK09_STOCELL1 DATA_CD_DISK09_STOCELL1 DATA_CD_DISK09_STOCELL1     LIBRARY TOTAL_MB ---------------------------------------------------------------- ---------- NAME FAILGROUP ------------------------------ ------------------------------ LABEL -------------------------------     CELL 448 DATA_CD_DISK10_STOCELL1 DATA_CD_DISK10_STOCELL1 DATA_CD_DISK10_STOCELL1     CELL 448 DATA_CD_DISK11_STOCELL1 DATA_CD_DISK11_STOCELL1     LIBRARY TOTAL_MB ---------------------------------------------------------------- ---------- NAME FAILGROUP ------------------------------ ------------------------------ LABEL ------------------------------- DATA_CD_DISK11_STOCELL1     CELL 448 DATA_CD_DISK12_STOCELL1 DATA_CD_DISK12_STOCELL1 DATA_CD_DISK12_STOCELL1         12 rows selected.     SQL> SELECT NAME, DATABASE_ROLE, PLATFORM_NAME FROM V$DATABASE;     NAME DATABASE_ROLE --------- ---------------- PLATFORM_NAME -------------------------------------------------------------------------------- EXAORCL PRIMARY Linux x86 64-bit         SQL> SELECT INSTANCE_NAME, HOST_NAME, VERSION, DATABASE_STATUS, INSTANCE_ROLE FROM V$INSTANCE;     INSTANCE_NAME ---------------- HOST_NAME ---------------------------------------------------------------- VERSION DATABASE_STATUS INSTANCE_ROLE ----------------- ----------------- ------------------ EXAORCL1 exadb1 11.2.0.4.0 ACTIVE PRIMARY_INSTANCE

[root@exadb1 bin]# ./ocrcheck Status of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space (kbytes) : 2932 Available space (kbytes) : 259188 ID : 411888517 Device/File Name : +MGMT Device/File integrity check succeeded     Device/File not configured     Device/File not configured     Device/File not configured     Device/File not configured     Cluster registry integrity check succeeded     [root@exadb1 bin]# ./crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 8890e5fc853e4fa5bfa8c39090e6cf6d (o/192.168.56.102/DATA_CD_DISK01_stocell1) [MGMT] Located 1 voting disk(s).     [oracle@exadb1 ~]$ free total used free shared buffers cached Mem: 2685952 2425212 260740 0 17192 796020 -/+ buffers/cache: 1612000 1073952 Swap: 4095992 112112 3983880

   

②Oracle Exadata Smart Scan TEST

alter session set cell_offload_processing=false;     select /*+ GATHER_PLAN_STATISTICS WITH_SMART_SCAN */sum(sal) from scott.emp where deptno='20';       SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(NULL,NULL, 'allstats last -rows +predicate'));     SQL_ID d8gtt1g1rufkx, child number 1 ------------------------------------- select /*+ GATHER_PLAN_STATISTICS WITH_SMART_SCAN */sum(sal) from scott.emp where deptno='20'   Plan hash value: 2083865914       Predicate Information (identified by operation id): ---------------------------------------------------   2 - filter("DEPTNO"=20)   Note ----- - dynamic sampling used for this statement (level=2)

alter session set cell_offload_processing=true;     select /*+ GATHER_PLAN_STATISTICS WITH_SMART_SCAN */sum(sal) from scott.emp where deptno='20';       SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(NULL,NULL, 'allstats last -rows +predicate'));     SQL_ID d8gtt1g1rufkx, child number 0 ------------------------------------- select /*+ GATHER_PLAN_STATISTICS WITH_SMART_SCAN */sum(sal) from scott.emp where deptno='20'   Plan hash value: 2083865914     Predicate Information (identified by operation id): ---------------------------------------------------   2 - storage("DEPTNO"=20) filter("DEPTNO"=20)   Note ----- - dynamic sampling used for this statement (level=2)

   

   

[참고 문서 및 사이트]

• http://www.oracle.com/index.html
• http://oracletechdba.blogspot.in/2014/08/exadata-simulator-vm.html
• https://dbaesp.wordpress.com/2013/12/11/exadata-virtual-test-environment-for-oce-prep-storage-cell-node/
• http://uhesse.com/2011/01/19/exadata-part-i-smart-scan/
• http://www.oracle.com/technetwork/oem/exa-mgmt/em12c-exadata-discovery-cookbook-1662643.pdf
• http://digital.kyobobook.co.kr/digital/ebook/ebookDetail.ink?barcode=480140001714P
• http://pat98.tistory.com/category
• Exadata의 Base Document (MOS ID 888828.1]