Oracle Exadata TEST Single Database Installation : Install Database S/W & TEST Database
1. IT Story/DB 2015. 8. 21. 13:15
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]
'1. IT Story > DB' 카테고리의 다른 글
| Oracle RAC 11gR2 Management (0) | 2015.09.04 |
|---|---|
| Oracle RAC 11gR2 Failover 구성 (0) | 2015.09.04 |
| OCR, VOTE ASM Disk에서 RawDevice로 Disk 변경 TEST (0) | 2015.08.26 |
| ODA 기본 OS 상태(OVM환경)에서 Grid & DB Installation (0) | 2015.08.26 |
| Oracle Exadata TEST Single Database Installation : Install Grid Infrastructure (1) | 2015.08.21 |
| Oracle Exadata TEST Single Database Installation : Storage Cell disk (3) | 2015.08.21 |
| Oracle Exadata TEST Single Database Installation : OVM TEST Environment (2) | 2015.08.21 |
| Oracle Exadata TEST Single Database Installation : Overview (0) | 2015.08.20 |
운명을바꾸는자
IT와 함께 살아가는 삶
