背景
windows 的wsl 安装了archlinux. 在archlinux下需要sqlplus连接数据库.
用ARU安装. 需要预先在archlinux安装开发包.
(sudo pacman -S base-devel)
从github clone 安装的脚本, 进入这个目录,makepkg下载并编译, makepkg -si 安装.
依赖包 libaio, oracle-instantclient-basic
完整命令
sudo pacman -S libaio
git clone https://aur.archlinux.org/oracle-instantclient-basic.git
cd *basic
makepkg
makepkg -si
git clone https://aur.archlinux.org/oracle-instantclient-sqlplus.git
cd oracle-instantclient-sqlplus/
makepkg
makepkg -si
which sqlplus
安装记录
[nome@arch tmp]$ git clone
https://aur.archlinux.org/oracle-instantclient-sqlplus.git [nome@arch
tmp]$ cd oracle-instantclient-sqlplus/ [nome@arch
oracle-instantclient-sqlplus]$ ls LICENSE PKGBUILD [nome@arch
oracle-instantclient-sqlplus]$ makepkg
==> Making package: oracle-instantclient-sqlplus 21.13.0.0.0-1 (Fri 24 May 2024 05:18:12 PM AEST)
==> Checking runtime dependencies…
==> Missing dependencies: -> oracle-instantclient-basic=21.13.0.0.0
==> Checking buildtime dependencies…
==> ERROR: Could not resolve all dependencies. [nome@arch oracle-instantclient-sqlplus]$ sudo makepkg [sudo] password for nome:
==> ERROR: Running makepkg as root is not allowed as it can cause permanent, catastrophic damage to your system. [nome@arch
oracle-instantclient-sqlplus]$ makepkg
==> Making package: oracle-instantclient-sqlplus 21.13.0.0.0-1 (Fri 24 May 2024 05:18:25 PM AEST)
==> Checking runtime dependencies…
==> Missing dependencies: -> oracle-instantclient-basic=21.13.0.0.0
==> Checking buildtime dependencies…
==> ERROR: Could not resolve all dependencies. [nome@arch tmp]$ git clone https://aur.archlinux.org/oracle-instantclient-basic.git
[nome@arch tmp]$ cd *basic [nome@arch oracle-instantclient-basic]$ ls
LICENSE oracle.sh PKGBUILD [nome@arch oracle-instantclient-basic]$
makepkg
==> Making package: oracle-instantclient-basic 21.13.0.0.0-1 (Fri 24 May 2024 05:22:01 PM AEST)
==> Checking runtime dependencies…
==> Missing dependencies: -> libaio
==> Checking buildtime dependencies…
==> ERROR: Could not resolve all dependencies. [nome@arch oracle-instantclient-basic]$ sudo pacman -S libaio resolving
dependencies… looking for conflicting packages…Packages (1) libaio-0.3.113-3
Total Download Size: 0.02 MiB Total Installed Size: 0.04 MiB
:: Proceed with installation? [Y/n] y :: Retrieving packages…
libaio-0.3.113-3-x86_64 23.6 KiB 113
KiB/s 00:00 [###############################################]
100%(1/1) checking keys in keyring
[###############################################] 100% (1/1) checking
package integrity
[###############################################] 100% (1/1) loading
package files
[###############################################] 100% (1/1) checking
for file conflicts
[###############################################] 100% :: Processing
package changes… (1/1) installing libaio
[###############################################] 100% :: Running
post-transaction hooks… (1/1) Arming ConditionNeedsUpdate…
[nome@arch oracle-instantclient-basic]$ makepkg
==> Making package: oracle-instantclient-basic 21.13.0.0.0-1 (Fri 24 May 2024 05:22:25 PM AEST)
==> Checking runtime dependencies…
==> Checking buildtime dependencies…
==> Retrieving sources… -> Found LICENSE -> Found oracle.sh -> Downloading instantclient-basic-linux.x64-21.13.0.0.0dbru.zip… %
Total % Received % Xferd Average Speed Time Time Time
Current
Dload Upload Total Spent Left Speed 100 79.8M 100 79.8M 0 0 4584k 0 0:00:17 0:00:17
–:–:-- 6524k
==> Validating source files with md5sums…
LICENSE … Passed
oracle.sh … Passed
instantclient-basic-linux.x64-21.13.0.0.0dbru.zip … Passed
==> Validating source files with sha256sums…
LICENSE … Passed
oracle.sh … Passed
instantclient-basic-linux.x64-21.13.0.0.0dbru.zip … Passed
==> Extracting sources… -> Extracting instantclient-basic-linux.x64-21.13.0.0.0dbru.zip with bsdtar
==> Entering fakeroot environment…
==> Starting package()…
==> Tidying install… -> Removing libtool files… -> Purging unwanted files… -> Removing static library files… -> Copying
source files needed for debug symbols… -> Compressing man and info
pages…
==> Checking for packaging issues…
==> Creating package “oracle-instantclient-basic”… -> Generating .PKGINFO file… -> Generating .BUILDINFO file… -> Generating
.MTREE file… -> Compressing package…==> Leaving fakeroot environment.
==> Finished making: oracle-instantclient-basic 21.13.0.0.0-1 (Fri 24 May 2024 05:23:32 PM AEST) [nome@arch oracle-instantclient-basic]$
makepkg -si
==> WARNING: A package has already been built, installing existing package…
==> Installing package oracle-instantclient-basic with pacman -U… loading packages… resolving dependencies… looking for conflicting
packages…Packages (1) oracle-instantclient-basic-21.13.0.0.0-1
Total Installed Size: 245.07 MiB
:: Proceed with installation? [Y/n] y (1/1) checking keys in keyring
[###############################################] 100% (1/1) checking
package integrity
[###############################################] 100% (1/1) loading
package files
[###############################################] 100% (1/1) checking
for file conflicts
[###############################################] 100% :: Processing
package changes… (1/1) installing oracle-instantclient-basic
[###############################################] 100% :: Running
post-transaction hooks… (1/1) Arming ConditionNeedsUpdate…
[nome@arch tmp]$ cd *plus [nome@arch oracle-instantclient-sqlplus]$ ls
LICENSE PKGBUILD [nome@arch oracle-instantclient-sqlplus]$ makepkg
-si
==> Making package: oracle-instantclient-sqlplus 21.13.0.0.0-1 (Fri 24 May 2024 05:29:17 PM AEST)
==> Checking runtime dependencies…
==> Checking buildtime dependencies…
==> Retrieving sources… -> Downloading instantclient-sqlplus-linux.x64-21.13.0.0.0dbru.zip… % Total %
Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed 100 914k 100 914k 0 0 498k 0 0:00:01 0:00:01
–:–:-- 498k
==> Validating source files with md5sums…
instantclient-sqlplus-linux.x64-21.13.0.0.0dbru.zip … Passed
==> Validating source files with sha256sums…
instantclient-sqlplus-linux.x64-21.13.0.0.0dbru.zip … Passed
==> Extracting sources… -> Extracting instantclient-sqlplus-linux.x64-21.13.0.0.0dbru.zip with bsdtar
==> Entering fakeroot environment…
==> Starting package()…
==> Tidying install… -> Removing libtool files… -> Purging unwanted files… -> Removing static library files… -> Copying
source files needed for debug symbols… -> Compressing man and info
pages…
==> Checking for packaging issues…
==> Creating package “oracle-instantclient-sqlplus”… -> Generating .PKGINFO file… -> Generating .BUILDINFO file… -> Generating
.MTREE file… -> Compressing package…
==> Leaving fakeroot environment.
==> Finished making: oracle-instantclient-sqlplus 21.13.0.0.0-1 (Fri 24 May 2024 05:29:21 PM AEST)
==> Installing package oracle-instantclient-sqlplus with pacman -U… loading packages… resolving dependencies… looking for conflicting
packages…Packages (1) oracle-instantclient-sqlplus-21.13.0.0.0-1
Total Installed Size: 3.19 MiB
:: Proceed with installation? [Y/n] y (1/1) checking keys in keyring
[###############################################] 100% (1/1) checking
package integrity
[###############################################] 100% (1/1) loading
package files
[###############################################] 100% (1/1) checking
for file conflicts
[###############################################] 100% :: Processing
package changes… (1/1) installing oracle-instantclient-sqlplus
[###############################################] 100% :: Running
post-transaction hooks… (1/1) Arming ConditionNeedsUpdate…
[nome@arch oracle-instantclient-sqlplus]$ ls
instantclient-sqlplus-linux.x64-21.13.0.0.0dbru.zip
oracle-instantclient-sqlplus-21.13.0.0.0-1-x86_64.pkg.tar.zst
PKGBUILD LICENSE pkg
src [nome@arch oracle-instantclient-sqlplus]$ which sqlplus
/usr/sbin/sqlplus [nome@arch oracle-instantclient-sqlplus]$ sqlplus
nome/nome@192.168.56.91:1521/ctpSQL*Plus: Release 21.0.0.0.0 - Production on Fri May 24 17:30:46 2024
Version 21.13.0.0.0Copyright © 1982, 2022, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release
11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options