共计 6994 个字符，预计需要花费 18 分钟才能阅读完成。
Windows WSL 登陆后显示如下:
| Welcome to Ubuntu 20.04.4 LTS (GNU/Linux 4.4.0-19041-Microsoft x86_64) | |
| * Documentation: https://help.ubuntu.com | |
| * Management: https://landscape.canonical.com | |
| * Support: https://ubuntu.com/advantage | |
| System information as of Tue Aug 22 14:12:16 CST 2023 | |
| System load: 0.52 | |
| Usage of /home: unknown | |
| Memory usage: 75% | |
| Swap usage: 2% | |
| Processes: 12 | |
| Users logged in: 0 |
登陆 WSL 零碎上，从 Oracle 下载几个压缩包
| ~# wget https://download.oracle.com/otn_software/linux/instantclient/2111000/instantclient-sqlplus-linux.x64-21.11.0.0.0dbru.zip | |
| --2023-08-22 10:26:32-- https://download.oracle.com/otn_software/linux/instantclient/2111000/instantclient-sqlplus-linux.x64-21.11.0.0.0dbru.zip | |
| Resolving download.oracle.com (download.oracle.com)... 23.203.124.79 | |
| Connecting to download.oracle.com (download.oracle.com)|23.203.124.79|:443... connected. | |
| HTTP request sent, awaiting response... 200 OK | |
| Length: 936855 (915K) [application/zip] | |
| Saving to:‘instantclient-sqlplus-linux.x64-21.11.0.0.0dbru.zip’instantclient-sqlplus-linux.x 100%[==============================================>] 914.90K 172KB/s in 5.3s | |
| 2023-08-22 10:26:38 (172 KB/s) -‘instantclient-sqlplus-linux.x64-21.11.0.0.0dbru.zip’saved [936855/936855] | |
| ~# wget https://download.oracle.com/otn_software/linux/instantclient/2111000/instantclient-basic-linux.x64-21.11.0.0.0dbru.zip | |
| --2023-08-22 10:27:18-- https://download.oracle.com/otn_software/linux/instantclient/2111000/instantclient-basic-linux.x64-21.11.0.0.0dbru.zip | |
| Resolving download.oracle.com (download.oracle.com)... 23.203.124.79 | |
| Connecting to download.oracle.com (download.oracle.com)|23.203.124.79|:443... connected. | |
| HTTP request sent, awaiting response... 200 OK | |
| Length: 78744025 (75M) [application/zip] | |
| Saving to:‘instantclient-basic-linux.x64-21.11.0.0.0dbru.zip’instantclient-basic-linux.x64 100%[==============================================>] 75.10M 1.75MB/s in 59s | |
| 2023-08-22 10:28:19 (1.27 MB/s) -‘instantclient-basic-linux.x64-21.11.0.0.0dbru.zip’saved [78744025/78744025] | |
| ~# wget https://download.oracle.com/otn_software/linux/instantclient/2111000/instantclient-jdbc-linux.x64-21.11.0.0.0dbru.zip | |
| --2023-08-22 10:40:23-- https://download.oracle.com/otn_software/linux/instantclient/2111000/instantclient-jdbc-linux.x64-21.11.0.0.0dbru.zip | |
| Resolving download.oracle.com (download.oracle.com)... 23.203.124.79 | |
| Connecting to download.oracle.com (download.oracle.com)|23.203.124.79|:443... connected. | |
| HTTP request sent, awaiting response... 200 OK | |
| Length: 1579011 (1.5M) [application/zip] | |
| Saving to:‘instantclient-jdbc-linux.x64-21.11.0.0.0dbru.zip’instantclient-jdbc-linux.x64- 100%[==============================================>] 1.51M 301KB/s in 5.1s | |
| 2023-08-22 10:40:29 (301 KB/s) -‘instantclient-jdbc-linux.x64-21.11.0.0.0dbru.zip’saved [1579011/1579011] | |
| ~# wget https://download.oracle.com/otn_software/linux/instantclient/2111000/instantclient-sdk-linux.x64-21.11.0.0.0dbru.zip | |
| --2023-08-22 10:28:39-- https://download.oracle.com/otn_software/linux/instantclient/2111000/instantclient-sdk-linux.x64-21.11.0.0.0dbru.zip | |
| Resolving download.oracle.com (download.oracle.com)... 104.76.200.85 | |
| Connecting to download.oracle.com (download.oracle.com)|104.76.200.85|:443... connected. | |
| HTTP request sent, awaiting response... 200 OK | |
| Length: 1001766 (978K) [application/zip] | |
| Saving to:‘instantclient-sdk-linux.x64-21.11.0.0.0dbru.zip’instantclient-sdk-linux.x64-2 100%[==============================================>] 978.29K 479KB/s in 2.0s | |
| 2023-08-22 10:28:42 (479 KB/s) -‘instantclient-sdk-linux.x64-21.11.0.0.0dbru.zip’saved [1001766/1001766] |
别离解压四个压缩包:
| root@jinju:~# mkdir instantclient | |
| root@jinju:~# mv instantclient-* instantclient | |
| # unzip instantclient-basic-linux.x64-21.11.0.0.0dbru.zip | |
| # unzip instantclient-sqlplus-linux.x64-21.11.0.0.0dbru.zip | |
| # unzip instantclient-sdk-linux.x64-21.11.0.0.0dbru.zip | |
| # unzip instantclient-jdbc-linux.x64-21.11.0.0.0dbru.zip |
而后全副进入～/instantclient/instantclient_21_11 里了
| root@jinju:~/instantclient# cd instantclient_21_11/ | |
| root@jinju:~/instantclient/instantclient_21_11# ls | |
| BASIC_LICENSE genezi libclntsh.so.21.1 libocci.so libocci_gcc53.so.21.1 orai18n.jar | |
| BASIC_README glogin.sql libclntshcore.so libocci.so.10.1 libociei.so sdk | |
| JDBC_LICENSE libclntsh.so DESKTOP-35UHREQ- libclntshcore.so.12.1 libocci.so.11.1 libocijdbc21.so sqlplus | |
| JDBC_README libclntsh.so.10.1 libclntshcore.so.18.1 libocci.so.12.1 liboramysql.so ucp.jar | |
| SDK_LICENSE libclntsh.so.11.1 libclntshcore.so.19.1 libocci.so.18.1 libsqlplus.so uidrvci | |
| SDK_README libclntsh.so.12.1 libclntshcore.so.20.1 libocci.so.19.1 libsqlplusic.so xstreams.jar | |
| SQLPLUS_LICENSE libclntsh.so.18.1 libclntshcore.so.21.1 libocci.so.20.1 network | |
| SQLPLUS_README libclntsh.so.19.1 libheteroxa21.so libocci.so.21.1 ojdbc8.jar | |
| adrci libclntsh.so.20.1 libnnz21.so libocci_gcc53.so orai18n-mapping.jar |
标准一下搁置的门路，放到下面解压的门路也是能够的
| root@jinju:~/instantclient# mkdir -p /u01/app/oracle/product/19.0.0/client_1 | |
| root@jinju:~/instantclient# cp -rf ～/instantclient/instantclient_21_11/* /u01/app/oracle/product/19.0.0/client_1/ |
/etc/profile 增加门路
| root@jinju:~/instantclient/instantclient_21_11# more /etc/profile。。。export ORACLE_HOME=/u01/app/oracle/product/19.0.0/client_1 | |
| export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH | |
| export TNS_ADMIN=$ORACLE_HOME/network/admin | |
| export PATH=$PATH:$ORACLE_HOME:$ORACLE_HOME/lib:$ORACLE_HOME/sdk/include |
装置个 JDK
root@jinju:~/instantclient/instantclient_21_11/sdk# apt install openjdk-17*
测试下 SQL*Plus，能够用连贯串拜访 Oracle
| root@jinju:~# sqlplus test/test@192.168.3.107:1521/PDB1 | |
| SQL*Plus: Release 21.0.0.0.0 - Production on Tue Aug 22 11:16:16 2023 | |
| Version 21.11.0.0.0 | |
| Copyright (c) 1982, 2022, 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> show user; | |
| USER is "TEST" | |
| SQL> exit | |
| Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production | |
| Version 19.3.0.0.0 |
增加 tnsnames.ora 配置，简化连贯串拜访
| root@jinju:~# cd $ORACLE_HOME/network/admin | |
| root@jinju:/u01/app/oracle/product/19.0.0/client_1/network/admin# touch tnsnames.ora | |
| root@jinju:/u01/app/oracle/product/19.0.0/client_1/network/admin# more tnsnames.ora | |
| # tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/tnsnames.ora | |
| # Generated by Oracle configuration tools. | |
| 107ORCL = | |
| (DESCRIPTION = | |
| (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.107)(PORT = 1521)) | |
| (CONNECT_DATA = | |
| (SERVER = DEDICATED) | |
| (SERVICE_NAME = orcl) | |
| ) | |
| ) | |
| 107PDB1 = | |
| (DESCRIPTION = | |
| (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.107)(PORT = 1521)) | |
| (CONNECT_DATA = | |
| (SERVER = DEDICATED) | |
| (SERVICE_NAME = pdb1) | |
| ) | |
| ) |
持续测试
| root@jinju:/u01/app/oracle/product/19.0.0/client_1/network/admin# sqlplus test/test@107PDB1 | |
| SQL*Plus: Release 21.0.0.0.0 - Production on Tue Aug 22 11:29:21 2023 | |
| Version 21.11.0.0.0 | |
| Copyright (c) 1982, 2022, Oracle. All rights reserved. | |
| Last Successful login time: Tue Aug 22 2023 11:29:16 +08:00 | |
| Connected to: | |
| Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production | |
| Version 19.3.0.0.0 | |
| SQL> show user; | |
| USER is "TEST" | |
| SQL> show con_name; | |
| CON_NAME | |
| ------------------------------ | |
| PDB1 |
Ok, 应用失常
正文完
