프린트 하기

내맘대로긍정이 알려주는

Oracle 23ai 신기능
무료 세미나 발표자료

다운로드 trending_flat

OS환경 : Oracle Linux 7.6 (64bit)


DB 환경 : Oracle Database 21.1.0.0


방법 : Oracle Linux 7.6에 Oracle 21c 클라이언트 설치 가이드

oracle 유저 .bash_profile 설정

1
2
3
4
5
6
7
export TMP=/tmp;
export TMPDIR=$TMP;
export ORACLE_BASE=/app/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/21c;
export PATH=/usr/sbin:$PATH:$ORACLE_HOME/bin:$PATH;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;



설정 저장

1
$ . ./.bash_profile



설치파일 업로드 및 unzip

1
2
3
4
$ cd /app/media/
$ ls -al LINUX.X64_210000_client.zip 
-rw-r--r-- 1 oracle dba 1068127159 Dec 12 00:21 
$ unzip LINUX.X64_210000_client.zip



클라이언트 폴더로 이동

1
2
3
4
5
6
7
8
9
10
$ ls -al
total 4031092
drwxr-xr-x. 3 oracle dba         91 Dec 12 00:23 .
drwxr-xr-x. 5 oracle dba         53 Dec 11 22:56 ..
drwxr-xr-x  5 oracle dba         90 Oct 31 22:32 client
-rw-r--r--  1 oracle dba 1068127159 Dec 12 00:21 LINUX.X64_210000_client.zip
 
$ cd client
$ ls
install  response  runInstaller  stage  welcome.html



./runInstaller 실행

1
$ ./runInstaller



Administrator 선택



Software location 지정



사전 요구사항 체크중



Swap 이슈는 Ignore



설치 사항 체크



설치중



설치완료



설치 후 폴더 확인

1
2
3
4
5
6
$ cd /app/oracle/product/21c/
$ ls 
assistants   crs        diagnostics  install        jdbc  ldap     odbc    oracore      oui    precomp  relnotes      slax          srvm      utl
bin          css        env.ora      instantclient  jdk   lib      olap    oraInst.loc  owm    QOpatch  root.sh       sqldeveloper  suptools  xdk
cfgtoollogs  cv         has          inventory      jlib  network  OPatch  ord          perl   racg     runInstaller  sqlj          ucp
clone        deinstall  hs           javavm         jpub  nls      opmn    oss          plsql  rdbms    sdk           sqlplus       usm



OPatch 툴로 버전 확인

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
$ export ORACLE_HOME=/app/oracle/product/21c
$ export PATH=/usr/sbin:/usr/local/bin:$PATH
$ export PATH=$ORACLE_HOME/bin:$PATH
$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
$ export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
 
$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.22
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /app/oracle/product/21c
Central Inventory : /app/oraInventory
   from           : /app/oracle/product/21c/oraInst.loc
OPatch version    : 12.2.0.1.22
OUI version       : 12.2.0.9.0
Log file location : /app/oracle/product/21c/cfgtoollogs/opatch/opatch2020-12-12_00-37-46AM_1.log
 
Lsinventory Output file location : /app/oracle/product/21c/cfgtoollogs/opatch/lsinv/lsinventory2020-12-12_00-37-46AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: oracle19
ARU platform id: 226
ARU platform description:: Linux x86-64
 
Installed Top-level Products (1): 
 
Oracle Client 21c                                                    21.0.0.0.0
There are 1 products installed in this Oracle Home.
 
 
There are no Interim patches installed in this Oracle Home.
 
 
--------------------------------------------------------------------------------
 
OPatch succeeded.



OPatch detail 정보

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
116
117
118
119
120
121
$ ./opatch lsinventory -detail
Oracle Interim Patch Installer version 12.2.0.1.22
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /app/oracle/product/21c
Central Inventory : /app/oraInventory
   from           : /app/oracle/product/21c/oraInst.loc
OPatch version    : 12.2.0.1.22
OUI version       : 12.2.0.9.0
Log file location : /app/oracle/product/21c/cfgtoollogs/opatch/opatch2020-12-12_01-09-28AM_1.log
 
Lsinventory Output file location : /app/oracle/product/21c/cfgtoollogs/opatch/lsinv/lsinventory2020-12-12_01-09-28AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: oracle19
ARU platform id: 226
ARU platform description:: Linux x86-64
 
Installed Top-level Products (1): 
 
Oracle Client 21c                                                    21.0.0.0.0
There are 1 products installed in this Oracle Home.
 
 
Installed Products (85): 
 
Assistant Common Files                                               21.0.0.0.0
Buildtools Common Files                                              21.0.0.0.0
Cluster Verification Utility Client Files                            21.0.0.0.0
Cluster Verification Utility Common Files                            21.0.0.0.0
Database SQL Scripts                                                 21.0.0.0.0
Deinstallation Tool                                                  21.0.0.0.0
Expat libraries                                                       2.0.1.0.5
HAS Common Files                                                     21.0.0.0.0
Installation Common Files                                            21.0.0.0.0
Installation Plugin Files                                            21.0.0.0.0
Installer SDK Component                                              12.2.0.9.0
Java Development Kit                                               1.8.0.271.00
LDAP Required Support Files                                          21.0.0.0.0
OLAP Analytic Workspace Manager and Worksheet                        21.0.0.0.0
Oracle Advanced Security                                             21.0.0.0.0
Oracle Bali Share                                                    12.2.1.0.0
Oracle Call Interface (OCI)                                          21.0.0.0.0
Oracle Client 21c                                                    21.0.0.0.0
Oracle Clusterware RDBMS Files                                       21.0.0.0.0
Oracle Core Required Support Files                                   21.0.0.0.0
Oracle Core Required Support Files for Core DB                       21.0.0.0.0
Oracle Database Deconfiguration                                      21.0.0.0.0
Oracle Database Utilities                                            21.0.0.0.0
Oracle DBCA Deconfiguration                                          21.0.0.0.0
Oracle Extended Windowing Toolkit                                    12.2.1.0.0
Oracle Globalization Support                                         21.0.0.0.0
Oracle Globalization Support                                         21.0.0.0.0
Oracle Globalization Support For Core                                21.0.0.0.0
Oracle Help for Java                                                 11.1.2.0.0
Oracle Help Share Library                                            11.1.2.0.0
Oracle Ice Browser                                                    6.1.3.2.0
Oracle Instant Client                                                21.0.0.0.0
Oracle Internet Directory Client                                     21.0.0.0.0
Oracle Java Client                                                   21.0.0.0.0
Oracle JDBC/OCI Instant Client                                       21.0.0.0.0
Oracle JDBC/THIN Interfaces                                          21.0.0.0.0
Oracle JFC Extended Windowing Toolkit                                11.1.1.1.0
Oracle LDAP administration                                           21.0.0.0.0
Oracle Locale Builder                                                21.0.0.0.0
Oracle Multimedia Client Option                                      21.0.0.0.0
Oracle Net                                                           21.0.0.0.0
Oracle Net Required Support Files                                    21.0.0.0.0
Oracle Netca Client                                                  21.0.0.0.0
Oracle Notification Service                                          21.0.0.0.0
Oracle Notification Service for Instant Client                       21.0.0.0.0
Oracle ODBC Driver                                                   21.0.0.0.0
Oracle ODBC Driverfor Instant Client                                 21.0.0.0.0
Oracle OLAP API                                                      21.0.0.0.0
Oracle One-Off Patch Installer                                      12.2.0.1.17
Oracle Programmer                                                    21.0.0.0.0
Oracle RAC Required Support Files-HAS                                21.0.0.0.0
Oracle Recovery Manager                                              21.0.0.0.0
Oracle Security Developer Tools                                      21.0.0.0.0
Oracle SQL Developer                                                 21.0.0.0.0
Oracle SQLJ                                                          21.0.0.0.0
Oracle Universal Connection Pool                                     21.0.0.0.0
Oracle Universal Installer                                           12.2.0.9.0
Oracle USM Deconfiguration                                           21.0.0.0.0
Oracle Wallet Manager                                                21.0.0.0.0
Oracle XML Development Kit                                           21.0.0.0.0
Oracle XML Query                                                     21.0.0.0.0
oracle.swd.commonlogging                                             13.3.0.0.0
oracle.swd.opatchautodb                                              12.2.0.1.5
oracle.swd.oui.core.min                                              12.2.0.9.0
Parser Generator Required Support Files                              21.0.0.0.0
Perl Interpreter                                                     5.32.0.0.0
Perl Modules                                                         5.32.0.0.0
PL/SQL                                                               21.0.0.0.0
PL/SQL Embedded Gateway                                              21.0.0.0.0
Platform Required Support Files                                      21.0.0.0.0
Precompiler Common Files                                             21.0.0.0.0
Precompiler Common Files for Core                                    21.0.0.0.0
Precompiler Required Support Files                                   21.0.0.0.0
Precompilers                                                         21.0.0.0.0
RDBMS Required Support Files                                         21.0.0.0.0
RDBMS Required Support Files for Instant Client                      21.0.0.0.0
Required Support Files                                               21.0.0.0.0
Secure Socket Layer                                                  21.0.0.0.0
SQL*Plus                                                             21.0.0.0.0
SQL*Plus Files for Instant Client                                    21.0.0.0.0
SQL*Plus Required Support Files                                      21.0.0.0.0
SQLJ Runtime                                                         21.0.0.0.0
SSL Required Support Files for InstantClient                         21.0.0.0.0
XDK Required Support Files                                           21.0.0.0.0
XML Parser for Java                                                  21.0.0.0.0
There are 85 products installed in this Oracle Home.
 
 
There are no Interim patches installed in this Oracle Home.
 
 
--------------------------------------------------------------------------------
 
OPatch succeeded.



tnsnames.ora 작성 후 19c db로 접속 시도

1
2
3
4
5
6
7
8
9
10
$ cd $ORACLE_HOME/network/admin
$ vi tnsnames.ora
ORCL19 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle19)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl19)
    )
  )



tnsping 시도

1
2
3
4
5
6
7
8
9
10
11
12
13
$ tnsping orcl19
 
TNS Ping Utility for Linux: Version 21.0.0.0.0 - Production on 12-DEC-2020 00:40:41
 
Copyright (c) 19972020, Oracle.  All rights reserved.
 
Used parameter files:
/app/oracle/product/21c/network/admin/sqlnet.ora
 
 
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle19)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl19)))
OK (0 msec)

정상



sqlplus 접속 시도

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
$ sqlplus system/oracle@orcl19
 
SQL*Plus: Release 21.0.0.0.0 - Production on Sat Dec 12 00:41:03 2020
Version 21.1.0.0.0
 
Copyright (c) 19822020, Oracle.  All rights reserved.
 
Last Successful login time: Fri Nov 27 2020 21:34:38 +09:00
 
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
 
SQL> select version from v$instance;
 
VERSION
-----------------
19.0.0.0.0

tnsping, sqlplus 모두 21.0.0.0 버전의 오라클 클라이언트를 정상적으로 사용함



참조 : https://docs.oracle.com/en/database/oracle/oracle-database/21/lacli/index.html

oracle database 21c client install