1. OS (설치 기준은 12.2.0.1)
Linux x86-64 operating system requirements | The following Linux x86-64 kernels are supported: Oracle Linux 7 with the Unbreakable Enterprise Kernel 3: 3.8.13-35.3.1.el7uek.x86_64 or later |
| Minimum local disk storage space for Oracle software | For Linux x86-64: |
Packages for Oracle Linux 7 | The following packages (or later versions) must be installed: binutils-2.23.52.0.1-12.el7 (x86_64) |
2. asm 디스크 설정 변경
Verifying the Disk I/O Scheduler on Linux
For best performance for Oracle ASM, Oracle recommends that you use the Deadline I/O Scheduler.
Disk I/O schedulers reorder, delay, or merge requests for disk I/O to achieve better throughput and lower latency. Linux has multiple disk I/O schedulers available, including Deadline, Noop, Anticipatory, and Completely Fair Queuing (CFQ).
On each cluster node, enter the following command to verify that the Deadline disk I/O scheduler is configured for use:
# cat /sys/block/${ASM_DISK}/queue/scheduler
noop [deadline] cfq
In this example, the default disk I/O scheduler is Deadline and ASM_DISK is the Oracle Automatic Storage Management (Oracle ASM) disk device.
If the default disk I/O scheduler is not Deadline, then set it using a rules file:
Using a text editor, create a UDEV rules file for the Oracle ASM devices:
# vi /etc/udev/rules.d/60-oracle-schedulers.rules
Add the following line to the rules file and save it:
ACTION=="add|change", KERNEL=="sd[a-z]", ATTR{queue/rotational}=="0", ATTR{queue/scheduler}="deadline"On clustered systems, copy the rules file to all other nodes on the cluster. For example:
$ scp 60-oracle-schedulers.rules root@node2:/etc/udev/rules.d/60-oracle-schedulers.rules
Load the rules file and restart the UDEV service. For example:
Oracle Linux and Red Hat Enterprise Linux
# udevadm control --reload-rules
SUSE Linux Enterprise Server
# /etc/init.d boot.udev restart
Verify that the disk I/O scheduler is set as Deadline.
3. group/user 생성
/usr/sbin/groupadd -g 54321 oinstall
groupadd dba
groupadd oper
groupadd backupdba
groupadd dgdba
groupadd kmdba
groupadd asmdba
groupadd racdba
groupadd asmoper
groupadd asmadmin
grid 설치 : grid
( uid=54331(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),
54327(asmdba),54328(asmoper),54329(asmadmin),54330(racdba) )
oracle, db 설치 : oracle
( uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba), 54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54327(asmdba),54330(racdba) )
useradd -g oinstall -G dba -M oragrid
useradd -g oinstall -G dba -M -d /oracle oracle
4. kernel parameter (/etc/sysctl.conf)
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 3221225472
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 8388608
net.core.wmem_default = 4194304
net.core.wmem_max = 8388608
vm.swappiness = 5
5. security limit 설정 (/etc/security/limits.conf)
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft stack 32768
oracle soft memlock kernel.shmmax와 동일하게
oracle hard memlock kernel.shmmax와 동일하게
6. hugepage disable (/etc/rc.local)
if test -f /sys/kernel/mm/transparent_hugepage/enabled; then echo never > /sys/kernel/mm/transparent_hugepage/enabled fi if test -f /sys/kernel/mm/transparent_hugepage/defrag; then echo never > /sys/kernel/mm/transparent_hugepage/defrag fi
7. 설치전 check
1) 설치시
./orachk -profile preinstall
2) upgrade시
./orachk -u -o pre
3) rac 체크
- CRS 관련 체크
/ORACLE/crs/12.2.0.1/runcluvfy.sh stage -pre crsinst -n dev01,dev02 -verbose -fixup
8. cvu (rac 설치시) check
https://docs.oracle.com/database/122/CWADD/cluster-verification-utility-reference.htm#CWADD91030
cd /u01/app/oracle/product/12.2.0/grid
runcluvfy.sh stage -pre hacfg9. asm disk setup
/etc/init.d/oracleasm createdisk DATAVOL58 /dev/mapper/ICALc-oradb-100G-008-n3par04
/etc/init.d/oracleasm createdisk DATAVOL59 /dev/mapper/ICALc-oradb-100G-009-n3par04
/etc/init.d/oracleasm createdisk DATAVOL60 /dev/mapper/ICALc-oradb-100G-010-n3par04
ALTER DISKGROUP DATAVOL ADD DISK
'ORCL:DATAVOL58',
'ORCL:DATAVOL59',
'ORCL:DATAVOL60'
REBALANCE POWER 11;
10. install
1) response file
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=dba
INVENTORY_LOCATION=/oracle/oraInventory
ORACLE_HOME=/oracle/app/product/12.2.0
ORACLE_BASE=/oracle/app
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
2) 설치
- sw 설치
./runInstaller -silent -showProgress -waitForCompletion -responseFile db_install.rsp
- db 설치
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbName cdb1 \
-sid cdb1 \
-automaticMemoryManagement false \
-characterSet AL32UTF8 \
-databaseConfigType SINGLE \
-databaseType MULTIPURPOSE \
-storageType FS \
-datafileDestination "/oracle/app/oradata/" \
-enableArchive true \
-archiveLogDest "/oracle/app/archive" \
-redoLogFileSize 300 \
-emConfiguration NONE \
-sysPassword "test00" \
-systemPassword "test00" \
-sampleSchema false \
-totalMemory 3000 \
-useWalletForDBCredentials true \
-dbCredentialsWalletLocation "/oracle/app/product/12.2.0/db_1/network/admin" \
-dbCredentialsWalletPassword oracle00 \
-createAsContainerDatabase true \
-numberOfPDBs 1 \
-pdbName pdb1 \
-pdbAdminPassword "test00" \
-useLocalUndoForPDBs true
- graphics 설치
export DISPLAY=:0.0
xhost +
su - oracle
export DISPLAY=:0.0
'RDB > Oracle' 카테고리의 다른 글
| oracle asm 18c (0) | 2019.02.20 |
|---|---|
| oracle 18c autotask enable or disable (0) | 2019.02.11 |
| oracle audit (0) | 2018.12.13 |
| oracle database roadmap (0) | 2018.11.16 |
| oracle 18c 기능 (0) | 2018.11.15 |