oracle11g 編譯BBED工具

jasperjohn發表於2012-07-03

oracle10g BBED:
cd $ORACLE_HOME/rdbms/lib
通過以下命令將bbed生成到$ORACLE_HOME/bin目錄
[oracle@db2 lib]$ make -f ins_rdbms.mk  BBED=$ORACLE_HOME/bin/bbed  $ORACLE_HOME/bin/bbed
10gdg1-> bbed
Password:  blockedit(defaultpasswd)


oracle11g 下編譯BBED

BBED is not available in 11g but you can still link it after getting the following files from any previous version like 10gR2.

Copy $ORA10g_HOME/rdbms/lib/ssbbded.o to $ORA11g_HOME/rdbms/lib
Copy $ORA10g_HOME/rdbms/lib/sbbdpt.o to $ORA11g_HOME/rdbms/lib

Message files (list may differ):
Copy $ORA10g_HOME/rdbms/mesg/bbedus.msb to $ORA11g_HOME/rdbms/mesg
Copy $ORA10g_HOME/rdbms/mesg/bbedus.msg to $ORA11g_HOME/rdbms/mesg


cd $ORACLE_HOME/rdbms/lib
通過以下命令將bbed生成到$ORACLE_HOME/bin目錄
make -f ins_rdbms.mk  BBED=$ORACLE_HOME/bin/bbed  $ORACLE_HOME/bin/bbed

$ORA11g_HOME/bin/bbed
password: blockedit


一般使用bbed,都是將一些配置資訊寫入到一個引數文字里,在呼叫bbed時,指定該引數檔案。如:
       $bbedparfile=bbed.par
相關的引數可以通過help 檢視:
[oracle@db2 admin]$ bbed help=y
PASSWORD - Required parameter
FILENAME - Database file name
BLOCKSIZE - Database block size
LISTFILE - List file name
MODE - [browse/edit]
SPOOL - Spool to logfile [no/yes]
CMDFILE - BBED command file name
LOGFILE - BBED log file name
PARFILE - Parameter file name
BIFILE - BBED before-image file name
REVERT - Rollback changes from BIFILE[no/yes]
SILENT - Hide banner [no/yes]
HELP - Show all valid parameters [no/yes]      

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14661773/viewspace-734441/,如需轉載,請註明出處,否則將追究法律責任。

相關文章