ANBOB™

Oracle has the BBED utility (block browser and editor) is is all releases of Oracle, from Oracle7 to Oracle10g,In Oracle 11g, BBED becomes unavailable but if you search in the ins_rdbms.mk makefile (located in $ORACLE_HOME/rdbms/lib directory), you will see that the entry is still there. Designed for internal use only,If you want to use it with an Oracle 11g database, you will have to get some files from an old Oracle 10g installation and build the binary in your Oracle 11g home.

There is a nice document (PDF) about the BBED tool, titled Disassembling the Oracle Data Block which can be found here: PDF

— in oracle 10g

[oracle@testdb ~]$ mkdir bbed

[oracle@testdb ~]$ cd $ORACLE_HOME/rdbms
[oracle@testdb rdbms]$ cd lib

[oracle@testdb lib]$ cp ssbbded.o ~/bbed/
[oracle@testdb lib]$ cp sbbdpt.o ~/bbed/ 
[oracle@testdb lib]$ cd ../mesg
[oracle@testdb mesg]$ cp bbedus.msb ~/bbed/
[oracle@testdb mesg]$ cp bbedus.msg ~/bbed/
[oracle@testdb mesg]$ cd 
[oracle@testdb ~]$ ls

[oracle@testdb ~]$ tar zcvf bbed_src.tgz bbed/

[oracle@dbserver58 ~]$ tar zxvf bbed_src.tgz 
[oracle@dbserver58 ~]$ cd bbed
[oracle@dbserver58 bbed]$ ls
bbedus.msb  bbedus.msg  sbbdpt.o  ssbbded.o

[oracle@dbserver58 bbed]$ cp bbedus.ms* $ORACLE_HOME/rdbms/mesg/
[oracle@dbserver58 bbed]$ cp s* $ORACLE_HOME/rdbms/lib/


[oracle@dbserver58 ~]$ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed 

[oracle@dbserver58 ~]$ which bbed
/oracle/product/11.2.0/db_1/bin/bbed

[oracle@dbserver58 ~]$ bbed
Password: 

BBED: Release 2.0.0.0.0 - Limited Production on Fri Feb 21 10:34:01 2014

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

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

BBED> 

TIP:
When you start BBED it will ask you for a password. This password is: blockedit

NOTE:
Do not use BBED on a production database unless one knows what one is doing. Do not use BBED on any database that one cannot afford to lose. Take a backup of any database on which this tool is going to be used.

— update 2016-6-4 —
build BBED in 12c release 2 same as 11g.

[oracle@anbob bbed]$ bbed
Password: bbededit
BBED: Release 2.0.0.0.0 – Limited Production on Fri Jun 24 17:19:41 2016
Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************

BBED> ls
BBED-00200: invalid keyword (ls)
BBED> quit

[oracle@anbob bbed]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.0.0 Beta on Fri Jun 24 17:24:11 2016
Copyright (c) 1982, 2015, Oracle. All rights reserved.

打赏

微信扫一扫，打赏作者吧～