It never ceases to amaze me how difficult some responders on message boards make it to use certain tools. Requests for information are usually denied with something similar to “If you have to ask that, you shouldn’t be _fill_in_the_blank_”.
How pompous, especially as a response to someone trying to learn, often on their own time.
At any rate, there is a point to this post. If you have come here searching for the bbed password, it is…
BLOCKEDIT
…and below is how I got it…
dell11gr1:oracle:apptest1:/u01/app/oracle/product/10.2.0/rdbms/lib>make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed
Linking BBED utility (bbed)
rm -f /u01/app/oracle/product/10.2.0/rdbms/lib/bbed
gcc -o /u01/app/oracle/product/10.2.0/rdbms/lib/bbed -L/u01/app/oracle/product/10.2.0/rdbms/lib/ -L/u01/app/oracle/product/10.2.0/lib/ -L/u01/app/oracle/product/10.2.0/lib/stubs/ -L/usr/lib -lirc /u01/app/oracle/product/10.2.0/lib/s0main.o /u01/app/oracle/product/10.2.0/rdbms/lib/ssbbded.o /u01/app/oracle/product/10.2.0/rdbms/lib/sbbdpt.o `cat /u01/app/oracle/product/10.2.0/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 /u01/app/oracle/product/10.2.0/rdbms/lib/defopt.o -ldbtools10 -lclntsh `cat /u01/app/oracle/product/10.2.0/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /u01/app/oracle/product/10.2.0/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lmm -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /u01/app/oracle/product/10.2.0/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /u01/app/oracle/product/10.2.0/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /u01/app/oracle/product/10.2.0/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/10.2.0/lib -lm `cat /u01/app/oracle/product/10.2.0/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/10.2.0/lib
dell11gr1:oracle:apptest1:/u01/app/oracle/product/10.2.0/rdbms/lib>strings -a bbed > l.txt
dell11gr1:oracle:apptest1:/u01/app/oracle/product/10.2.0/rdbms/lib>bbed -h
LRM-00101: unknown parameter name 'h'
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]
BBED-00105: LRM error 101 occurred during command line parsing
dell11gr1:oracle:apptest1:/u01/app/oracle/product/10.2.0/rdbms/lib>while read line; do
> echo $line | grep -q " "
> if [ $? -ne 0 ]; then
> bbed PASSWORD="$line" > /dev/null
> if [ $? -eq 0 ]; then
> echo "PASSWORD = $line"
> break
> fi
> fi
> done < l.txt
PASSWORD = BLOCKEDIT
dell11gr1:oracle:apptest1:/u01/app/oracle/product/10.2.0/rdbms/lib>bbed
Password:
BBED: Release 2.0.0.0.0 - Limited Production on Mon Jan 31 23:25:31 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED>
Having said all of what is above, use the tool at your own risk!! Usage outside of Oracle support is, well…not supported 🙂
However, it is an excellent learning tool on a test database to which you have access.