Oracle 8i 的BBED在windows 平台下的$ORACLE_HOME/bin下可以找到,9i中似乎未随软件发布,故在windows没有这个工具,
在linux上面有,9i/10g 版本需要编译。11g + 的版本没有提供,需要从10g中把bbed 复制过去。
在9i/10g中连接生成bbed:
cd $ORACLE_HOME/rdbms/lib
make-f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed
OracleDatabase 11g+ 中缺省的未提供BBED库文件,但是可以用10g的文件编译出来,需要先从10g中复制如下文件到相应目录,然后再执行上述连接命令。
复制文件:
[dave@www.cndba.cn ~]$ cd /u01/ora_10g_bbed/
[dave@www.cndba.cn ora_10g_bbed]$ ls
bbedus.msb bbedus.msg sbbdpt.o ssbbded.o
[dave@www.cndba.cn ora_10g_bbed]$ cp ssb* $ORACLE_HOME/rdbms/lib
[dave@www.cndba.cn ora_10g_bbed]$ cp sbb* $ORACLE_HOME/rdbms/lib
[dave@www.cndba.cn ora_10g_bbed]$ cp bbed* $ORACLE_HOME/rdbms/mesg
编译
[dave@www.cndba.cn ora_10g_bbed]$ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed
--注意这里有2个$ORACLE_HOME/bin/bbed
Linking BBED utility (bbed)
rm -f /u01/app/oracle/product/19.3.0/dbhome_1/bin/bbed
/u01/app/oracle/product/19.3.0/dbhome_1/bin/orald -o /u01/app/oracle/product/19.3.0/dbhome_1/bin/bbed -m64 -z noexecstack -Wl,--disable-new-dtags -L/u01/app/oracle/product/19.3.0/dbhome_1/rdbms/lib/ -L/u01/app/oracle/product/19.3.0/dbhome_1/lib/ -L/u01/app/oracle/product/19.3.0/dbhome_1/lib/stubs/ /u01/app/oracle/product/19.3.0/dbhome_1/lib/s0main.o /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/lib/ssbbded.o /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/lib/sbbdpt.o `cat /u01/app/oracle/product/19.3.0/dbhome_1/lib/ldflags` -lncrypt19 -lnsgr19 -lnzjs19 -ln19 -lnl19 -lngsmshd19 -ldbtools19 -lclntsh -lclntshcore `cat /u01/app/oracle/product/19.3.0/dbhome_1/lib/ldflags` -lncrypt19 -lnsgr19 -lnzjs19 -ln19 -lnl19 -lngsmshd19 -lnro19 `cat /u01/app/oracle/product/19.3.0/dbhome_1/lib/ldflags` -lncrypt19 -lnsgr19 -lnzjs19 -ln19 -lnl19 -lngsmshd19 -lnnz19 -lzt19 -lztkg19 -lztkg19 -lclient19 -lnnetd19 -lcommon19 -lgeneric19 -lmm -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lxml19 -lcore19 -lunls19 -lsnls19 -lnls19 -lcore19 -lnls19 `cat /u01/app/oracle/product/19.3.0/dbhome_1/lib/ldflags` -lncrypt19 -lnsgr19 -lnzjs19 -ln19 -lnl19 -lngsmshd19 -lnro19 `cat /u01/app/oracle/product/19.3.0/dbhome_1/lib/ldflags` -lncrypt19 -lnsgr19 -lnzjs19 -ln19 -lnl19 -lngsmshd19 -lclient19 -lnnetd19 -lcommon19 -lgeneric19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lxml19 -lcore19 -lunls19 -lsnls19 -lnls19 -lcore19 -lnls19 -lclient19 -lnnetd19 -lcommon19 -lgeneric19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lxml19 -lcore19 -lunls19 -lsnls19 -lnls19 -lcore19 -lnls19 `cat /u01/app/oracle/product/19.3.0/dbhome_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/19.3.0/dbhome_1/lib -lm `cat /u01/app/oracle/product/19.3.0/dbhome_1/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/19.3.0/dbhome_1/lib
[dave@www.cndba.cn ora_10g_bbed]$
[dave@www.cndba.cn ora_10g_bbed]$ which bbed
/u01/app/oracle/product/19.3.0/dbhome_1/bin/bbed
[dave@www.cndba.cn ora_10g_bbed]$
[dave@www.cndba.cn ora_10g_bbed]$ bbed
Password:
BBED: Release 2.0.0.0.0 - Limited Production on Mon Nov 22 13:35:21 2021
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED>
版权声明:本文为博主原创文章,未经博主允许不得转载。