bbed工具安装

1、上传bbedus.msb bbedus.msg sbbdpt.o ssbbded.o四个文件到数据库服务器

[oracle@edgzrip1-PROD1 bbed_10g_src_x32]$ ll
total 36
-rw-r--r-- 1 oracle oinstall 8704 Oct 20 2013 bbedus.msb
-rw-r--r-- 1 oracle oinstall 10270 Oct 20 2013 bbedus.msg
-rw-r--r-- 1 oracle oinstall 3043 Oct 20 2013 sbbdpt.o
-rw-r--r-- 1 oracle oinstall 2721 Oct 20 2013 ssbbded.o

2、将以上四个文件复制到相应目录

[oracle@edgzrip1-PROD1 bbed_10g_src_x32]$ cp ssbbded.o $ORACLE_HOME/rdbms/lib
[oracle@edgzrip1-PROD1 bbed_10g_src_x32]$ cp sbbdpt.o $ORACLE_HOME/rdbms/lib
[oracle@edgzrip1-PROD1 bbed_10g_src_x32]$ cp bbedus.msb $ORACLE_HOME/rdbms/mesg
[oracle@edgzrip1-PROD1 bbed_10g_src_x32]$ cp bbedus.msg $ORACLE_HOME/rdbms/mesg

3、编译安装
[oracle@edgzrip1-PROD1 bbed_10g_src_x32]$ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed

Linking BBED utility (bbed)
rm -f /u01/app/oracle/product/11.2.0/dbhome_1/bin/bbed
/usr/bin/gcc -m32 -o /u01/app/oracle/product/11.2.0/dbhome_1/bin/bbed -m32 -L/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ -L/u01/app/oracle/product/11.2.0/dbhome_1/lib/ -L/u01/app/oracle/product/11.2.0/dbhome_1/lib/stubs/ -L/u01/app/oracle/product/11.2.0/dbhome_1/lib/ -lirc -lipgo /u01/app/oracle/product/11.2.0/dbhome_1/lib/s0main.o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ssbbded.o /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/sbbdpt.o `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -ldbtools11 -lclntsh `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lztkg11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/11.2.0/dbhome_1/lib -lm `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/11.2.0/dbhome_1/lib

4、扩展

bbed的密码为blockedit，为方便使用，我们还可以进行以下步骤。

vi par.txt

blocksize=8192
listfile=filelist.txt
mode=edit

列出文件：

SQL> select file#||chr(9)||name||chr(9)||bytes from v$datafile;

FILE#||CHR(9)||NAME||CHR(9)||BYTES
--------------------------------------------------------------------------------
1 /u01/app/oracle/oradata/ORCL/system01.dbf 786432000
2 /u01/app/oracle/oradata/ORCL/sysaux01.dbf 545259520
3 /u01/app/oracle/oradata/ORCL/undotbs01.dbf 319815680
4 /u01/app/oracle/oradata/ORCL/users01.dbf 5242880
5 /u01/app/oracle/oradata/ORCL/test01.dbf 524288000

编辑filelist.txt文件：

1 /u01/app/oracle/oradata/ORCL/system01.dbf 786432000
2 /u01/app/oracle/oradata/ORCL/sysaux01.dbf 545259520
3 /u01/app/oracle/oradata/ORCL/undotbs01.dbf 319815680
4 /u01/app/oracle/oradata/ORCL/users01.dbf 5242880
5 /u01/app/oracle/oradata/ORCL/test01.dbf 524288000

设置bbed命令工具别名：

vi .bash_profile

alias bbed='bbed parfile=par.txt password=blockedit'

这样就可以输入bbed直接登录，而不需要再输入密码，列出数据文件。

[oracle@edgzrip1-PROD1 bbed_10g_src_x32]$ bbed

BBED: Release 2.0.0.0.0 - Limited Production on Sat Nov 7 01:57:29 2020

************* !!! For Oracle Internal Use only !!! ***************

BBED> info
File# Name Size(blks)
----- ---- ----------
1 /u01/app/oracle/oradata/ORCL/system01.dbf 96000
2 /u01/app/oracle/oradata/ORCL/sysaux01.dbf 66560
3 /u01/app/oracle/oradata/ORCL/undotbs01.dbf 39040
4 /u01/app/oracle/oradata/ORCL/users01.dbf 640
5 /u01/app/oracle/oradata/ORCL/test01.dbf 64000