내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
2024
10.12
14:00
10.12
14:00
OS 환경 : Oracle Linux 8.4 (64bit)
DB 환경 : Oracle Database 19.3.0.0
방법 : Oracle Linux 8.4에 Oracle 19c 설치 가이드
본문에서는 Oracle Linux 8.4에 Oracle 19c 를 설치하는 방법을 설명함
OS 설치는 아래 게시물 참조
Oracle linux 8.4 설치 가이드(https://positivemh.tistory.com/761)
hostname : ora19
DB 설치파일
LINUX.X64_193000_db_home.zip
오라클 설치 전 사전 설정
/etc/hosts 설정
|
1
2
3
4
|
vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.137.19 ora19--추가
|
/etc/hostname 확인
|
1
2
|
# vi /etc/hostname
ora19
|
preinstall rpm 설치
공식홈페이지에서 preinstall rpm 다운로드 후 서버에 업로드
또는 curl로 서버에 직접 다운로드
|
1
|
# curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
|
preinstall 패키지 설치
perinstall 패키지 설치 시 os 커널 파라미터가 설정되고, oracle 유저와 oinstall, dba 등 설치에 필요한 권한 유저가 생성되고, 필요한 패키지가 설치됨
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
# dnf -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
Last metadata expiration check: 5:31:35 ago on Thu 15 Aug 2024 01:36:25 AM KST.
Dependencies resolved.
==============================================================================================================================================================================================================
Package Architecture Version Repository Size
==============================================================================================================================================================================================================
Installing:
oracle-database-preinstall-19c x86_64 1.0-2.el8 @commandline 31 k
Installing dependencies:
ksh x86_64 20120801-267.0.1.el8 ol8_appstream 923 k
libaio-devel x86_64 0.3.112-1.el8 ol8_baseos_latest 19 k
libnsl x86_64 2.28-151.0.1.el8 ol8_baseos_latest 102 k
lm_sensors-libs x86_64 3.4.0-23.20180522git70f7e08.el8 ol8_baseos_latest 59 k
sysstat x86_64 11.7.3-13.0.1.el8_10 ol8_appstream 426 k
Transaction Summary
==============================================================================================================================================================================================================
Install 6 Packages
Total size: 1.5 M
Total download size: 1.5 M
Installed size: 5.0 M
Downloading Packages:
(1/5): libaio-devel-0.3.112-1.el8.x86_64.rpm 23 kB/s | 19 kB 00:00
(2/5): lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm 55 kB/s | 59 kB 00:01
(3/5): libnsl-2.28-151.0.1.el8.x86_64.rpm 80 kB/s | 102 kB 00:01
(4/5): sysstat-11.7.3-13.0.1.el8_10.x86_64.rpm 584 kB/s | 426 kB 00:00
(5/5): ksh-20120801-267.0.1.el8.x86_64.rpm 843 kB/s | 923 kB 00:01
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 789 kB/s | 1.5 MB 00:01
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : ksh-20120801-267.0.1.el8.x86_64 1/6
Running scriptlet: ksh-20120801-267.0.1.el8.x86_64 1/6
Installing : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 2/6
Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 2/6
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored
Installing : sysstat-11.7.3-13.0.1.el8_10.x86_64 3/6
Running scriptlet: sysstat-11.7.3-13.0.1.el8_10.x86_64 3/6
Installing : libnsl-2.28-151.0.1.el8.x86_64 4/6
Installing : libaio-devel-0.3.112-1.el8.x86_64 5/6
Running scriptlet: oracle-database-preinstall-19c-1.0-2.el8.x86_64 6/6
Installing : oracle-database-preinstall-19c-1.0-2.el8.x86_64 6/6
Running scriptlet: oracle-database-preinstall-19c-1.0-2.el8.x86_64 6/6
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored
Verifying : libaio-devel-0.3.112-1.el8.x86_64 1/6
Verifying : libnsl-2.28-151.0.1.el8.x86_64 2/6
Verifying : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 3/6
Verifying : ksh-20120801-267.0.1.el8.x86_64 4/6
Verifying : sysstat-11.7.3-13.0.1.el8_10.x86_64 5/6
Verifying : oracle-database-preinstall-19c-1.0-2.el8.x86_64 6/6
Installed:
ksh-20120801-267.0.1.el8.x86_64 libaio-devel-0.3.112-1.el8.x86_64 libnsl-2.28-151.0.1.el8.x86_64 lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 oracle-database-preinstall-19c-1.0-2.el8.x86_64
sysstat-11.7.3-13.0.1.el8_10.x86_64
Complete!
|
자동 설정 후 수동설정 파일 확인필요
/etc/sysctl.conf 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
# vi /etc/sysctl.conf
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 4294967296
kernel.shmmax = 4294967296
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
|
*kernel.shmall, kernel.shmmax 은 서버에 물리 메모리의 절반으로 설정 필요(byte 단위)
현재 서버의 물리 메모리를 8gb로 잡았기 때문에 절반인 4gb를 byte로 변경해 적용함(4*1024*1024*1024)
잘 입력되었는지 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
# /sbin/sysctl -p
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 4294967296
kernel.shmmax = 4294967296
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
|
아래 파일 내용 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
# cat /etc/security/limits.d/oracle-database-preinstall-19c.conf
# oracle-database-preinstall-19c setting for nofile soft limit is 1024
oracle soft nofile 1024
# oracle-database-preinstall-19c setting for nofile hard limit is 65536
oracle hard nofile 65536
# oracle-database-preinstall-19c setting for nproc soft limit is 16384
# refer orabug15971421 for more info.
oracle soft nproc 16384
# oracle-database-preinstall-19c setting for nproc hard limit is 16384
oracle hard nproc 16384
# oracle-database-preinstall-19c setting for stack soft limit is 10240KB
oracle soft stack 10240
# oracle-database-preinstall-19c setting for stack hard limit is 32768KB
oracle hard stack 32768
# oracle-database-preinstall-19c setting for memlock hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90 % of RAM
oracle hard memlock 134217728
# oracle-database-preinstall-19c setting for memlock soft limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM
oracle soft memlock 134217728
# oracle-database-preinstall-19c setting for data soft limit is 'unlimited'
oracle soft data unlimited
# oracle-database-preinstall-19c setting for data hard limit is 'unlimited'
oracle hard data unlimited
|
패스워드 설정
|
1
|
# passwd oracle
|
selinux permissive 설정
|
1
2
|
# vi /etc/selinux/config
SELINUX=permissive
|
방화벽 해제
|
1
2
|
# systemctl stop firewalld
# systemctl disable firewalld
|
설치 경로 생성
|
1
2
3
4
|
# mkdir -p /app/oracle/product/19c/
# mkdir -p /app/media
# chown -R oracle:dba /app
# chmod -R 775 /app
|
서버에 Oracle Database 설치 미디어 업로드 후 권한 부여
|
1
2
3
|
# ls -al /app/media
-rw-r--r--. 1 root root 3059705302 8월 14 01:54 LINUX.X64_193000_db_home.zip
# chown oracle:dba LINUX.X64_193000_db_home.zip
|
오라클 계정 접속 후 .bash_profile 에 아래 내용 추가
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
# su - oracle
$ vi .bash_profile
export ORACLE_HOSTNAME=ora19
export ORACLE_UNQNAME=oracle19
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19c
export ORA_INVENTORY=/app/oraInventory
export ORACLE_SID=oracle19
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export DISPLAY=192.168.137.1:0.0
stty erase ^H
alias ss="sqlplus / as sysdba"
alias bdump="cd $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace"
alias alert='vi $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace/alert_$ORACLE_SID.log'
alias alertf='tail -300f $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace/alert_$ORACLE_SID.log'
alias listen="vi $ORACLE_BASE/diag/tnslsnr/ora19/listener/trace/listener.log"
alias listenf="tail -300f $ORACLE_BASE/diag/tnslsnr/ora19/listener/trace/listener.log"
|
적용
|
1
|
$ . ./.bash_profile
|
오라클 설치파일 압축해제
|
1
2
|
$ cd $ORACLE_HOME
$ unzip /app/media/LINUX.X64_193000_db_home.zip
|
Oracle Software 설치
오라클 설치
|
1
2
|
$ export CV_ASSUME_DISTID=OEL7.6
$ ./runInstaller
|
*CV_ASSUME_DISTID 설정을 하지 않고 runInstaller 을 실행하면 아래 에러가 발생함
[INS-08101] Unexpected error while executing the action at state: 'supportedOSCheck' ( https://positivemh.tistory.com/486 )
Set Up Software Only 선택
Single instance database installation 선택
Enterprise Edition 선택
Oracle base 경로 설정
oraInventory 경로 선택
그룹 권한 선택
./runinstaller 실행후 자동으로 root 스크립트 실행을 위한 root 패스워드 입력(root.sh 등)
사전 요구사항 체크중
Install 선택
설치 중
root 스크립트를 돌리기 전 확인차 물어보는 메세지 Yes 선택
db 소프트웨어(엔진) 설치 완료 Close 선택
리스너 설정
netca 진행
|
1
|
$ netca
|
Listener configuration 선택
Add 선택
리스너 이름 설정
프로토콜 설정
Use the standard port number of 1521 선택
No 선택
리스너 설정 완료
Finish 선택
DB 생성
DB 생성
|
1
|
$ dbca
|
dbca oui 로딩중
Create a database 선택
Advanced configuration 선택
Custom Database 선택
oracle SID 입력
Use following for the database storage attributes 선택
Next 선택
리스너 선택
모두 체크 해제
Memory 에서 ASMM 선택, SGA 사이즈는 1300MB, PGA는 700MB 선택
Choose from the list of character sets 는 KO16MSWIN949 선택
Connection mode 는 Dedicated server mode 선택
Sample schemas 는 선택 안함
EM 체크 해제
sys 계정 패스워드 설정
Create database 선택
Finish 선택
db instance 생성중
db 인스턴스 생성 완료
db 설치 후 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 15 08:43:28 2024
Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> select instance_name, version, status from v$instance; INSTANCE_NAME VERSION STATUS ---------------- ----------------- ------------ oracle19 19.0.0.0.0 OPEN |
참조 :
https://positivemh.tistory.com/761
https://positivemh.tistory.com/548
https://positivemh.tistory.com/551
https://positivemh.tistory.com/522
https://positivemh.tistory.com/521
https://positivemh.tistory.com/550
'ORACLE > Install' 카테고리의 다른 글
| Oracle Linux 8.4에 Oracle 19c Silent 모드 설치 가이드 (0) | 2024.09.06 |
|---|---|
| Oracle 19c Single DB RU(Release Update) 패치 가이드 (2) | 2024.08.17 |
| Oracle Linux 8.4에 Oracle 23ai Exa 버전(정식23ai 버전X) 설치 가이드 (0) | 2024.08.09 |
| Oracle Linux 4.8에 Oracle 10g R2 설치 가이드 (0) | 2024.08.02 |
| Oracle Linux 8.4에 Oracle 23ai Free RPM 설치 및 삭제 가이드 (0) | 2024.05.03 |