11g下編譯使用BBED

首先在11g環境下， 試圖登入bbed，但是系統報告找不到檔案
[oracle@testdb ~]$ cd $ORACLE_HOME/lib
[oracle@testdb lib]$ ./bbed
-bash: ./bbed: No such file or directory
試圖使用make命令來編譯 依舊報錯，缺少兩個檔案
[oracle@testdb lib]$ cd ../rdbms/lib
[oracle@testdb lib]$ make -f ins_rdbms.mk /data/oracle/product/11.2.0/db1/rdbms/lib/bbed

Linking BBED utility (bbed)
rm -f /data/oracle/product/11.2.0/db1/rdbms/lib/bbed
gcc -o /data/oracle/product/11.2.0/db1/rdbms/lib/bbed -m64 -L/data/oracle/product/11.2.0/db1/rdbms/lib/ -L/data/oracle/product/11.2.0/db1/lib/ -L/data/oracle/product/11.2.0/db1/lib/stubs/  /data/oracle/product/11.2.0/db1/lib/s0main.o /data/oracle/product/11.2.0/db1/rdbms/lib/ssbbded.o /data/oracle/product/11.2.0/db1/rdbms/lib/sbbdpt.o `cat /data/oracle/product/11.2.0/db1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -ldbtools11 -lclntsh  `cat /data/oracle/product/11.2.0/db1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /data/oracle/product/11.2.0/db1/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 /data/oracle/product/11.2.0/db1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /data/oracle/product/11.2.0/db1/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 /data/oracle/product/11.2.0/db1/lib/sysliblist` -Wl,-rpath,/data/oracle/product/11.2.0/db1/lib -lm    `cat /data/oracle/product/11.2.0/db1/lib/sysliblist` -ldl -lm   -L/data/oracle/product/11.2.0/db1/lib
gcc: /data/oracle/product/11.2.0/db1/rdbms/lib/ssbbded.o: No such file or directory
gcc: /data/oracle/product/11.2.0/db1/rdbms/lib/sbbdpt.o: No such file or directory
make: *** [/data/oracle/product/11.2.0/db1/rdbms/lib/bbed] Error 1

從一個10g環境中copy過來
[oracle@testdb2 ~]$ cd /data/oracle/product/10.2/db1/rdbms/lib
You have new mail in /var/spool/mail/oracle
[oracle@testdb2 lib]$ ls ssbbded.o
ssbbded.o
[oracle@testdb2 lib]$ ls sbbdpt.o
sbbdpt.o

轉到11g，這次編譯透過但是還是報錯
[oracle@testdb lib]$ make -f ins_rdbms.mk /data/oracle/product/11.2.0/db1/rdbms/lib/bbed

Linking BBED utility (bbed)
rm -f /data/oracle/product/11.2.0/db1/rdbms/lib/bbed
gcc -o /data/oracle/product/11.2.0/db1/rdbms/lib/bbed -m64 -L/data/oracle/product/11.2.0/db1/rdbms/lib/ -L/data/oracle/product/11.2.0/db1/lib/ -L/data/oracle/product/11.2.0/db1/lib/stubs/  /data/oracle/product/11.2.0/db1/lib/s0main.o /data/oracle/product/11.2.0/db1/rdbms/lib/ssbbded.o /data/oracle/product/11.2.0/db1/rdbms/lib/sbbdpt.o `cat /data/oracle/product/11.2.0/db1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -ldbtools11 -lclntsh  `cat /data/oracle/product/11.2.0/db1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /data/oracle/product/11.2.0/db1/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 /data/oracle/product/11.2.0/db1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /data/oracle/product/11.2.0/db1/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 /data/oracle/product/11.2.0/db1/lib/sysliblist` -Wl,-rpath,/data/oracle/product/11.2.0/db1/lib -lm    `cat /data/oracle/product/11.2.0/db1/lib/sysliblist` -ldl -lm   -L/data/oracle/product/11.2.0/db1/lib
[oracle@testdb lib]$ ll beed
ls: beed: No such file or directory
[oracle@testdb lib]$ ll bbed
-rwxr-xr-x 1 oracle oinstall 266374 Jan 12 13:42 bbed
[oracle@testdb lib]$ ./bbed
Message 112 not found; No message file for product=RDBMS, facility=BBED
BBED-00113: file not found

繼續從10g下面copy東西
[oracle@testdb2 lib]$ scp /data/oracle/product/10.2/db1/rdbms/mesg/bbedus.msb 127.0.0.9:/data/oracle/product/11.2.0/db1/rdbms/mesg
oracle@192.168.110.238's password:
bbedus.msb     

轉到11g下，這次倒是可以登入了,密碼blockedit,但是還需定義登入引數檔案

[oracle@testdb lib]$ ./bbed
Password:

BBED: Release 2.0.0.0.0 - Limited Production on Wed Jan 12 13:46:32 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

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

BBED> set file 3 block 128
BBED-00312: no LISTFILE specified

定義BBED用到的檔案資訊
[oracle@testdb lib]$ vi filelist.txt
3 /data/oracle/oradata/justin.dbf 104857603 /data/oracle/oradata/justin.dbf 104857603 /data/oracle/oradata/renkun01.dbf 10485760

引數資訊
[oracle@testdb lib]$ vi par.txt
blocksize=8192
listfile=filelist.txt
mode=edit

[oracle@testdb lib]$ ./bbed parfile=par.txt
Password:

BBED: Release 2.0.0.0.0 - Limited Production on Wed Jan 12 14:11:07 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

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

BBED> set file 3 block 135
        FILE#           3
        BLOCK#          135

總算可以用了