내맘대로긍정이 알려주는
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) 1997, 2020, 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) 1982, 2020, 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
'ORACLE > Install' 카테고리의 다른 글
Oracle 11g R2 Single PSU 패치 가이드 (0) | 2021.03.20 |
---|---|
Oracle Linux 6.8에 Oracle 11g R2 ADG 설치 가이드 (2) | 2020.12.12 |
Windows 10에 Oracle 12c R1 클라이언트 설치 가이드 (3) | 2020.08.07 |
Oracle Linux 7.6에 Oracle 12c R1 설치 가이드 (0) | 2020.07.15 |
Oracle Linux 7.4에 Oracle 11g R2 RAC 삭제 가이드 (0) | 2020.07.10 |