[20240811]bbed使用问题.txt

[20240811]bbed使用问题.txt --//我使用的bbed以前在11g下编译,我将相应文件打包放在一起,但是我在21c下解压,放在/home/oracle/bbed目录,执行时遇到问题: --//参考链接：[20210311]如何建立bbed安装包.txt =>https://blog.itpub.net/267265/viewspace-2762464/ $ cd bbed $ ls -l total 63376 -rwxr-xr-x. 1 oracle oinstall   255300 2021-03-10 17:19:53 bbed -rw-r--r--. 1 oracle oinstall       75 2021-03-11 09:24:38 bbed.par -rw-r--r--. 1 oracle oinstall     8704 2021-03-11 09:24:22 bbedus.msb -rwxr-xr-x. 1 oracle oinstall    10299 2021-03-11 09:24:22 bbedus.msg -rw-r--r--. 1 oracle oinstall       27 2021-03-11 08:55:01 cmd.par -rw-r--r--. 1 oracle oinstall     1352 2021-03-11 09:00:23 filelist.txt -rwxr-xr-x. 1 oracle oinstall   144776 2021-03-10 17:22:18 ld-linux-x86-64.so.2 -rwxr-xr-x. 1 oracle oinstall     3768 2021-03-10 17:22:12 libaio.so.1 -rwxr-xr-x. 1 oracle oinstall 53793394 2021-03-10 17:20:37 libclntsh.so.11.1 -rwxr-xr-x. 1 oracle oinstall  1726320 2021-03-10 17:22:06 libc.so.6 -rwxr-xr-x. 1 oracle oinstall    23360 2021-03-10 17:21:00 libdl.so.2 -rwxr-xr-x. 1 oracle oinstall   614992 2021-03-10 17:21:13 libm.so.6 -rwxr-xr-x. 1 oracle oinstall  7996693 2021-03-10 17:20:46 libnnz11.so -rwxr-xr-x. 1 oracle oinstall   114352 2021-03-10 17:22:00 libnsl.so.1 -rwxr-xr-x. 1 oracle oinstall   149968 2021-03-10 17:21:23 libpthread.so.0 -rw-r--r--. 1 oracle oinstall        0 2024-08-11 09:32:26 log.bbd -rw-r--r--. 1 oracle oinstall     4608 2021-03-11 09:26:20 lrmus.msb -rw-r--r--. 1 oracle oinstall     4433 2021-03-11 09:26:20 lrmus.msg $ strace -e open ./bbed open("/u01/app/oracle/product/11.2.0.4/dbhome_1/lib/tls/x86_64/libclntsh.so.11.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/u01/app/oracle/product/11.2.0.4/dbhome_1/lib/tls/libclntsh.so.11.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/u01/app/oracle/product/11.2.0.4/dbhome_1/lib/x86_64/libclntsh.so.11.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/u01/app/oracle/product/11.2.0.4/dbhome_1/lib/libclntsh.so.11.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/u01/app/oracle/product/21.0.0/dbhome_1/lib/tls/x86_64/libclntsh.so.11.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/u01/app/oracle/product/21.0.0/dbhome_1/lib/tls/libclntsh.so.11.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/u01/app/oracle/product/21.0.0/dbhome_1/lib/x86_64/libclntsh.so.11.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/u01/app/oracle/product/21.0.0/dbhome_1/lib/libclntsh.so.11.1", O_RDONLY|O_CLOEXEC) = 3 --//找到!!oracle 21c下居然还有libclntsh.so.11.1这个文件,实际上这里面的11对应版本号11. open("/u01/app/oracle/product/21.0.0/dbhome_1/lib/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) --//没有找到.以下为了观察方便做了一些分割 open("/lib/tls/x86_64/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/lib/tls/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/lib/x86_64/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/lib/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/usr/lib/tls/x86_64/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/usr/lib/tls/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/usr/lib/x86_64/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/usr/lib/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3 open("/lib64/tls/x86_64/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/lib64/tls/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/lib64/x86_64/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/lib64/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/usr/lib64/tls/x86_64/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/usr/lib64/tls/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/usr/lib64/x86_64/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/usr/lib64/libnnz11.so", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) ./bbed: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory +++ exited with 127 +++ --//做了4组探查, 目录分别是 /lib, /usr/lib,/lib64 ,/usr/lib64/. --//你可以发现文件libnnz11.so在本地目录是存在的,只不过没有找对应的目录.只要加入检索路径就ok了. # cat /etc/ld.so.conf.d/bbed.conf /home/oracle/bbed # ldconfig --//退出oracle会话重新登录。 $ strace -e open ./bbed open("/u01/app/oracle/product/11.2.0.4/dbhome_1/lib/tls/x86_64/libclntsh.so.11.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/u01/app/oracle/product/11.2.0.4/dbhome_1/lib/tls/libclntsh.so.11.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/u01/app/oracle/product/11.2.0.4/dbhome_1/lib/x86_64/libclntsh.so.11.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/u01/app/oracle/product/11.2.0.4/dbhome_1/lib/libclntsh.so.11.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) open("/u01/app/oracle/product/21.0.0/dbhome_1/lib/tls/x86_64/libclntsh.so.11.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) ... open("/home/oracle/bbed/libnnz11.so", O_RDONLY|O_CLOEXEC) = 3 ... open("/u01/app/oracle/product/21.0.0/dbhome_1/nls/data/lx20001.nlb", O_RDONLY) = 3 open("/u01/app/oracle/product/21.0.0/dbhome_1/rdbms/mesg/bbedus.msb", O_RDONLY) = -1 ENOENT (No such file or directory) open("/u01/app/oracle/product/21.0.0/dbhome_1/rdbms/mesg/bbedus.msb", O_RDONLY) = -1 ENOENT (No such file or directory) open("/u01/app/oracle/product/21.0.0/dbhome_1/oracore/mesg/lrmus.msb", O_RDONLY) = 3 open("log.bbd", O_WRONLY|O_APPEND)      = 4 Message 112 not found; No message file for product=RDBMS, facility=BBED --- SIGSEGV {si_signo=SIGSEGV, si_code=SEGV_ACCERR, si_addr=0x7ffc673a5780} --- +++ killed by SIGSEGV (core dumped) +++ Segmentation fault (core dumped) --//可以发现bbedus.*文件，不会找本地的bbed目录。改变PATH环境变量也不行 --//$ export PATH=$PATH:/home/oracle/bbed/。 $ cp bbedus.ms* /u01/app/oracle/product/21.0.0/dbhome_1/rdbms/mesg/ $  ./bbed Password: BBED: Release 2.0.0.0.0 - Limited Production on Sun Aug 11 09:45:25 2024 Copyright (c) 1982, 2021, Oracle and/or its affiliates.  All rights reserved. ************* !!! For Oracle Internal Use only !!! *************** --//测试OK. --//补充测试: $ ldd bbed         linux-vdso.so.1 =>  (0x00007fffb41e2000)         libclntsh.so.11.1 => /u01/app/oracle/product/21.0.0/dbhome_1/lib/libclntsh.so.11.1 (0x00007f98a283b000)         libnnz11.so => /home/oracle/bbed/libnnz11.so (0x00007f98a2445000)         libdl.so.2 => /lib64/libdl.so.2 (0x00007f98a2241000)         libm.so.6 => /lib64/libm.so.6 (0x00007f98a1f3f000)         libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f98a1d22000)         libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f98a1b09000)         libc.so.6 => /lib64/libc.so.6 (0x00007f98a1748000)         libnnz21.so => /u01/app/oracle/product/21.0.0/dbhome_1/lib/libnnz21.so (0x00007f98a0f99000)         librt.so.1 => /lib64/librt.so.1 (0x00007f98a0d91000)         libaio.so.1 => /home/oracle/bbed/libaio.so.1 (0x00007f98a0b90000)         libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f98a0975000)         /lib64/ld-linux-x86-64.so.2 (0x00007f98a6be6000)         libclntshcore.so.21.1 => /u01/app/oracle/product/21.0.0/dbhome_1/lib/libclntshcore.so.21.1 (0x00007f98a03c5000) # mv /etc/ld.so.conf.d/bbed.conf /tmp/ # ldconfig --//退出oracle用户再登录执行: $ ldd bbed         linux-vdso.so.1 =>  (0x00007fff2cffb000)         libclntsh.so.11.1 => /u01/app/oracle/product/21.0.0/dbhome_1/lib/libclntsh.so.11.1 (0x00007f43dadc2000)         libnnz11.so => not found         ~~~~~~~~~~~~~~~~~~~~~~~~~         libdl.so.2 => /lib64/libdl.so.2 (0x00007f43dab95000)         libm.so.6 => /lib64/libm.so.6 (0x00007f43da893000)         libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f43da676000)         libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f43da45d000)         libc.so.6 => /lib64/libc.so.6 (0x00007f43da09c000)         libnnz21.so => /u01/app/oracle/product/21.0.0/dbhome_1/lib/libnnz21.so (0x00007f43d98ed000)         librt.so.1 => /lib64/librt.so.1 (0x00007f43d96e5000)         libaio.so.1 => /lib64/libaio.so.1 (0x00007f43d94e3000)         libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f43d92c8000)         /lib64/ld-linux-x86-64.so.2 (0x00007f43df16d000)         libclntshcore.so.21.1 => /u01/app/oracle/product/21.0.0/dbhome_1/lib/libclntshcore.so.21.1 (0x00007f43d8d18000) --//实际上就是一个文件libnnz11.so没有发现. $ ls -l  libnnz11.so /u01/app/oracle/product/21.0.0/dbhome_1/lib/libnnz* -rwxr-xr-x. 1 oracle oinstall  7996693 2021-03-10 17:20:46 libnnz11.so -rw-r--r--. 1 oracle oinstall  2216754 2021-07-07 08:15:14 /u01/app/oracle/product/21.0.0/dbhome_1/lib/libnnz21.a -rw-r--r--. 1 oracle oinstall  7118328 2021-07-07 08:15:44 /u01/app/oracle/product/21.0.0/dbhome_1/lib/libnnz21.so -rw-r--r--. 1 oracle oinstall 22732192 2021-07-07 08:16:20 /u01/app/oracle/product/21.0.0/dbhome_1/lib/libnnzst.a --//估计后面的数字代表oracle版本号,11表示11g,21表示21c的版本. $ cp  libnnz11.so /u01/app/oracle/product/21.0.0/dbhome_1/lib/ --//这样bbed一样可以正常使用.感觉linux也许出于安全考虑不会查找本地库文件. --//补充说明,开始我是修改LD_LIBRARY_PATH环境变量,执行许多命令会报错,不知道为什么.不死心做了上面的尝试. $ echo $LD_LIBRARY_PATH /u01/app/oracle/product/21.0.0/dbhome_1/lib:/lib:/usr/lib --//建议还是从10g拷贝对应文件ssbbded.o,sbbdpt.o,重新编译bbed,23c还是支持bbed的编译,当然我没有测试. --//参考: [20121004]11G下编译bbed.txt=> https://blog.itpub.net/267265/viewspace-745588/ gcc: /u01/app/oracle11g/product/11.2.0/db_1/rdbms/lib/ssbbded.o: No such file or directory gcc: /u01/app/oracle11g/product/11.2.0/db_1/rdbms/lib/sbbdpt.o: No such file or directory $ grep bbed ${ORACLE_HOME}/rdbms/lib/ins_rdbms.mk         $(SILENT)$(ECHO) "Linking BBED utility (bbed)" --//make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed --//有时间再做一次编译看看。目前暂时先拷贝libnnz11.so到相应目录.