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.zipResolving download.oracle.com (download.oracle.com)... 23.203.124.79Connecting to download.oracle.com (download.oracle.com)|23.203.124.79|:443... connected.HTTP request sent, awaiting response... 200 OKLength: 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.zipResolving download.oracle.com (download.oracle.com)... 23.203.124.79Connecting to download.oracle.com (download.oracle.com)|23.203.124.79|:443... connected.HTTP request sent, awaiting response... 200 OKLength: 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.zipResolving download.oracle.com (download.oracle.com)... 23.203.124.79Connecting to download.oracle.com (download.oracle.com)|23.203.124.79|:443... connected.HTTP request sent, awaiting response... 200 OKLength: 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.zipResolving download.oracle.com (download.oracle.com)... 104.76.200.85Connecting to download.oracle.com (download.oracle.com)|104.76.200.85|:443... connected.HTTP request sent, awaiting response... 200 OKLength: 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 instantclientroot@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# lsBASIC_LICENSE genezi libclntsh.so.21.1 libocci.so libocci_gcc53.so.21.1 orai18n.jarBASIC_README glogin.sql libclntshcore.so libocci.so.10.1 libociei.so sdkJDBC_LICENSE libclntsh.so DESKTOP-35UHREQ- libclntshcore.so.12.1 libocci.so.11.1 libocijdbc21.so sqlplusJDBC_README libclntsh.so.10.1 libclntshcore.so.18.1 libocci.so.12.1 liboramysql.so ucp.jarSDK_LICENSE libclntsh.so.11.1 libclntshcore.so.19.1 libocci.so.18.1 libsqlplus.so uidrvciSDK_README libclntsh.so.12.1 libclntshcore.so.20.1 libocci.so.19.1 libsqlplusic.so xstreams.jarSQLPLUS_LICENSE libclntsh.so.18.1 libclntshcore.so.21.1 libocci.so.20.1 networkSQLPLUS_README libclntsh.so.19.1 libheteroxa21.so libocci.so.21.1 ojdbc8.jaradrci 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_1root@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_1export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATHexport TNS_ADMIN=$ORACLE_HOME/network/adminexport 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 2023Version 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 - ProductionVersion 19.3.0.0.0 SQL> show user;USER is "TEST"SQL> exitDisconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.3.0.0.0
增加tnsnames.ora 配置，简化连贯串拜访
root@jinju:~# cd $ORACLE_HOME/network/adminroot@jinju:/u01/app/oracle/product/19.0.0/client_1/network/admin# touch tnsnames.oraroot@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 2023Version 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 - ProductionVersion 19.3.0.0.0 SQL> show user;USER is "TEST"SQL> show con_name; CON_NAME------------------------------PDB1
Ok,应用失常