내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 8.4 (64bit)
DB 환경 : Oracle Database 19.3.0.0
방법 : Oracle Linux 8.4에 Oracle 19c Client Silent 모드 설치 가이드
오라클 19c 클라이언트를 silent 모드로 설치하는 방법을 설명함
rpm 등 필수 패키지 자동 설정
1 2 | # 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 # dnf -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm |
오라클 유저 패스워드 설정
|
1
|
# passwd oracle
|
오라클 클라이언트용 폴더 생성
|
1
2
3
|
# mkdir -p /app/oracle
# chown -R oracle:oinstall /app
# chmod -R 755 /app
|
오라클 oraInst.loc 파일 생성
|
1
2
3
|
# vi /etc/oraInst.loc
inventory_loc=/app/oraInventory
inst_group=oinstall
|
오라클 oraInst.loc 파일 권한 부여
|
1
2
|
# chown oracle:oinstall /etc/oraInst.loc
# chmod 664 /etc/oraInst.loc
|
클라이언트 파일 업로드
클라이언트 파일 권한 부여
|
1
|
# chown oracle:oinstall unzip LINUX.X64_193000_client.zip
|
클라이언트 파일 unzip
|
1
2
|
# su - oracle
$ unzip LINUX.X64_193000_client.zip
|
response 파일 백업
|
1
2
|
$ cd /app/oracle/client/response/
$ cp client_install.rsp client_install.rspbak
|
response 파일 수정
installType은 Admin 등 본인이 선택가능(본문에서는 Custom으로 설치)
|
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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
|
$ vi client_install.rsp
요약
oracle.install.responseFileVersion=/oracle/install/rspfmt_clientinstall_response_schema_v19.0.0
UNIX_GROUP_NAME=dba
INVENTORY_LOCATION=/app/oraInventory
ORACLE_HOME=/app/oracle/product/19c
ORACLE_BASE=/app/oracle
oracle.install.client.installType=Custom
oracle.install.client.customComponents="oracle.network.client:19.0.0.0.0","oracle.sqlplus:19.0.0.0.0","oracle.rdbms.util:19.0.0.0.0","oracle.odbc:19.0.0.0.0"
전체
###############################################################################
## Copyright(c) Oracle Corporation 1998,2019. All rights reserved. ##
## ##
## Specify values for the variables listed below to customize ##
## your installation. ##
## ##
## Each variable is associated with a comment. The comment ##
## can help to populate the variables with the appropriate ##
## values. ##
## ##
###############################################################################
#-------------------------------------------------------------------------------
# Do not change the following system generated value.
#-------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_clientinstall_response_schema_v19.0.0
#-------------------------------------------------------------------------------
# Unix group to be set for the inventory directory.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
#-------------------------------------------------------------------------------
# Inventory location.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/app/oraInventory
#-------------------------------------------------------------------------------
# Complete path of the Oracle Home
#-------------------------------------------------------------------------------
ORACLE_HOME=/app/oracle/product/19c
#-------------------------------------------------------------------------------
# Complete path of the Oracle Base.
#-------------------------------------------------------------------------------
ORACLE_BASE=/app/oracle
#------------------------------------------------------------------------------
#Name : INSTALL_TYPE
#Datatype : String
#Description: Installation type of the component.
#
# The following choices are available. The value should contain
# only one of these choices.
# - Administrator
# - Runtime
# - InstantClient
# - Custom
#
#Example : INSTALL_TYPE = Administrator
#------------------------------------------------------------------------------
oracle.install.client.installType=Custom
#-------------------------------------------------------------------------------
# Name : oracle.install.client.customComponents
# Datatype : StringList
#
# This property is considered only if INSTALL_TYPE is set to "Custom"
#
# Description: List of Client Components you would like to install
#
# The following choices are available. You may specify any
# combination of these choices. The components you choose should
# be specified in the form "internal-component-name:version"
# Below is a list of components you may specify to install.
#
# oracle.sqlj:19.0.0.0.0 -- "Oracle SQLJ"
# oracle.rdbms.util:19.0.0.0.0 -- "Oracle Database Utilities"
# oracle.javavm.client:19.0.0.0.0 -- "Oracle Java Client"
# oracle.sqlplus:19.0.0.0.0 -- "SQL*Plus"
# oracle.dbjava.jdbc:19.0.0.0.0 -- "Oracle JDBC/THIN Interfaces"
# oracle.ldap.client:19.0.0.0.0 -- "Oracle Internet Directory Client"
# oracle.rdbms.oci:19.0.0.0.0 -- "Oracle Call Interface (OCI)"
# oracle.precomp:19.0.0.0.0 -- "Oracle Programmer"
# oracle.xdk:19.0.0.0.0 -- "Oracle XML Development Kit"
# oracle.network.aso:19.0.0.0.0 -- "Oracle Advanced Security"
# oracle.oraolap.mgmt:19.0.0.0.0 -- "OLAP Analytic Workspace Manager and Worksheet"
# oracle.network.client:19.0.0.0.0 -- "Oracle Net"
# oracle.network.cman:19.0.0.0.0 -- "Oracle Connection Manager"
# oracle.network.listener:19.0.0.0.0 -- "Oracle Net Listener"
# oracle.ordim.client:19.0.0.0.0 -- "Oracle Multimedia Client Option"
# oracle.odbc:19.0.0.0.0 -- "Oracle ODBC Driver"
# oracle.has.client:19.0.0.0.0 -- "Oracle Clusterware High Availability API"
# oracle.dbdev:19.0.0.0.0 -- "Oracle SQL Developer"
# oracle.rdbms.scheduler:19.0.0.0.0 -- "Oracle Scheduler Agent"
#
# Example : oracle.install.client.customComponents="oracle.precomp:19.0.0.0.0","oracle.oraolap.mgmt:19.0.0.0.0","oracle.rdbms.scheduler:19.0.0.0.0"
#-------------------------------------------------------------------------------
oracle.install.client.customComponents="oracle.network.client:19.0.0.0.0","oracle.sqlplus:19.0.0.0.0","oracle.rdbms.util:19.0.0.0.0","oracle.odbc:19.0.0.0.0"
#-------------------------------------------------------------------------------
# Host name to be used for by the Oracle Scheduler Agent.
# This needs to be entered in case oracle.rdbms.scheduler is selected in the
# list of custom components during custom install
#
# Example : oracle.install.client.schedulerAgentHostName = acme.domain.com
#------------------------------------------------------------------------------
oracle.install.client.schedulerAgentHostName=
#------------------------------------------------------------------------------
# Port number to be used for by the Oracle Scheduler Agent.
# This needs to be entered in case oracle.rdbms.scheduler is selected in the
# list of custom components during custom install
#
# Example: oracle.install.client.schedulerAgentPortNumber = 1500
#------------------------------------------------------------------------------
oracle.install.client.schedulerAgentPortNumber=
|
INS-08101 에러 방지를 위해 설정( 참조 https://positivemh.tistory.com/486 )
|
1
|
$ export CV_ASSUME_DISTID=RHEL7.6
|
클라이언트 설치전 사전 검증
|
1
2
3
4
5
6
|
$ ./runInstaller -silent -executePrereqs -responseFile /app/oracle/client/response/client_install.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 415 MB. Actual 41209 MB Passed
Checking swap space: must be greater than 150 MB. Actual 7899 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2023-11-28_12-48-34AM. Please wait ...
|
클라이언트 설치
|
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
64
65
66
|
$ ./runInstaller -waitforcompletion -showProgress -silent -responseFile /app/oracle/client/response/client_install.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 415 MB. Actual 40380 MB Passed
Checking swap space: must be greater than 150 MB. Actual 7899 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2023-11-28_12-53-59AM. Please wait ...[WARNING] [INS-32016] The selected Oracle home contains directories or files.
ACTION: To start with an empty Oracle home, either remove its contents or choose another location.
The response file for this session can be found at:
/app/oracle/product/19c/install/response/client_2023-11-28_12-53-59AM.rsp
You can find the log of this install session at:
/app/oraInventory/logs/installActions2023-11-28_12-53-59AM.log
Prepare in progress.
.................................................. 6% Done.
Prepare successful.
Copy files in progress.
.................................................. 12% Done.
.................................................. 17% Done.
.................................................. 22% Done.
.................................................. 27% Done.
.................................................. 32% Done.
.................................................. 37% Done.
.................................................. 42% Done.
.................................................. 47% Done.
.................................................. 52% Done.
.................................................. 57% Done.
Copy files successful.
Link binaries in progress.
Link binaries successful.
Setup files in progress.
........................................
Setup files successful.
Setup Inventory in progress.
Setup Inventory successful.
..........
Finish Setup in progress.
.................................................. 62% Done.
Finish Setup successful.
The installation of Oracle Client 19c was successful.
Please check '/app/oraInventory/logs/silentInstall2023-11-28_12-53-59AM.log' for more details.
Setup Oracle Base in progress.
Setup Oracle Base successful.
.................................................. 69% Done.
Prepare for configuration steps in progress.
Prepare for configuration steps successful.
.................................................. 85% Done.
Oracle Client Configuration in progress.
Successfully Setup Software.
.................................................. 100% Done.
Oracle Client Configuration successful.
|
테스트
sqlplus 실행
|
1
2
3
4
5
6
7
8
|
$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 28 01:09:35 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Enter user-name:
|
명령어가 정상적으로 수행됨 정상
tnsping 실행
|
1
2
3
4
5
6
7
|
$ tnsping
TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 28-NOV-2023 01:09:54
Copyright (c) 1997, 2019, Oracle. All rights reserved.
TNS-03502: Insufficient arguments. Usage: tnsping <address> [<count>]
|
명령어가 정상적으로 수행됨 정상
참조 :
https://docs.oracle.com/en/database/oracle/oracle-database/19/lacli/lot.html#List-of-Tables
https://positivemh.tistory.com/762
Oracle Linux 8.4에 Oracle 19c RAC 설치 가이드_Part 1
OS환경 : Oracle Linux 8.4 (64bit) DB 환경 : Oracle Database 19.12.0.0 방법 : Oracle Linux 8.4에 Oracle 19c RAC 설치 가이드_Part 1 OS 설치는 아래 게시물 참조 Oracle Linux 8.4 설치 가이드(https://positivemh.tistory.com/761) hostnam
positivemh.tistory.com
https://dataforum.io/pages/viewpage.action?pageId=2621969
'ORACLE > Install' 카테고리의 다른 글
| Oracle 23ai Free non-container 설치 시도(실패) (0) | 2024.04.28 |
|---|---|
| Oracle Linux 8.4에 Oracle 23c Free RPM 설치 및 삭제 가이드 (0) | 2024.04.25 |
| Windows 11에 Oracle 21c XE 설치 가이드 (0) | 2023.11.21 |
| Oracle Linux 8.4에 Oracle 19c RAC to RAC ADG 설치 가이드_Part 4 (0) | 2022.04.11 |
| Oracle Linux 8.4에 Oracle 19c RAC to RAC ADG 설치 가이드_Part 3 (3) | 2022.04.06 |