Shulou(Shulou.com)06/01 Report--

The Oracle BBED (Oracle Block Browser and Editor) tool is a block-level viewing and modification tool provided within Oracle. With the help of this tool, we can easily view the storage details of Oracle blocks at the block level, and better understand the technical details of Oracle Internal structure.

1. Environmental introduction

First of all, it should be stated that BBED is a non-Oracle recommended tool, which is only provided for internal recovery processing, and does not provide any information or related technical support externally. Therefore, if we plan to use this tool, especially in a production environment, it is our last choice. Be sure to use it when there is a backup to restore, otherwise using BBED rashly will easily lead to database startup failure or more serious problems.

Of the versions provided by BBED, there is only Linux/Unix, and there is no corresponding version on Windows. The environment in which indexing uses BBED is usually command-line. And BBED does not provide a compiled ready-made version inside Oracle, so we need to manually compile the link operation.

This article records the methods of compiling BBED on Oracle 10g and 11g respectively, and serves as a memo.

2. Compile BBED under Oracle 10g

This method is suitable for Oracle 10g and previous visible versions.

First, look at the relevant environment variables in the system and navigate to the library file directory of BBED.

[oracle@oracle10g ~] $env | grep ORACLE

ORACLE_SID=wilson

ORACLE_BASE=/u01

ORACLE_HOME=/u01/oracle

The object object file corresponding to BBED is usually in $ORACLE_HOME/rdbms/lib.

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

[oracle@oracle10g lib] $pwd

/ u01/oracle/rdbms/lib

After that, use the make command of the Linux system to compile and connect to generate the executor bbed.

[oracle@oracle10g lib] $make-f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed

Linking BBED utility (bbed)

Rm-f / u01/oracle/rdbms/lib/bbed

Gcc-o / u01/oracle/rdbms/lib/bbed-L/u01/oracle/rdbms/lib/-L/u01/oracle/lib/-L/u01/oracle/lib/stubs/-L/usr/lib-lirc/u01/oracle/lib/s0main.o / u01/oracle/rdbms/lib/ssbbded.o / u01/oracle/rdbms/lib/sbbdpt.o `cat / u01/oracle/lib/ ldSecrets`-lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10 / u01/oracle/rdbms/lib / defopt.o-ldbtools10-lclntsh`cat / u01/oracle/lib/ ldyogs`-lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10-lnro10 `cat / u01/oracle/lib/ ldyogs`-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 `lnls10 / cat ldfants`-cat-u01/oracle/lib/-lnsslb10-lnsslb10 -lnro10 `cat / u01/oracle/lib/ ldSecrets`-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 / lnls10-lcore10 sysliblist`-u01/oracle/lib/ -rpath,/u01/oracle/lib-lm`cat / u01/oracle/lib/ sysliblist`-ldl-lm-L/u01/oracle/lib

You can view the generated executable file bbed.

[oracle@oracle10g lib] $ls-l bbed

-rwxr-xr-x1 oracle oinstall 540313 Jun 16 09:15 bbed

Bbed is usually copied to the directory $ORACLE_HOME/bin directory, because it is added to the PATH environment variable and can be accessed from all parts of the system. After that, it is to build commonly used parameter files and the like.

[oracle@oracle10g lib] $cp bbed $ORACLE_HOME/bin

[oracle@oracle10g bin] $ls-l bbed

-rwxr-xr-x1 oracle oinstall 540313 Jun 16 09:20 bbed

[oracle@oracle10g bin] $cat par.txt

Blocksize=8192

Listfile=filelist.txt

Mode=edit

Try to start BBED.

[oracle@oracle10g bin] $bbed

Password:

BBED: Release 2.0.0.0.0-Limited Production on Thu Jun 16 09:23:18 2011

Copyright (c) 1982, 2005, Oracle.All rights reserved.

*! For Oracle Internal Use only!! *

BBED >

Installation successful!

3. The use of BBED under Oracle11g

Oracle10g and previous versions can be used using the above method. But in Oracle11g, some extra processing is needed. The root cause is that when compiling BBED under 11g, a missing error in the library obj file will be reported.

The solution is also very simple, that is, copy out the corresponding obj file under Oracle10g and place it under 11g.

From $ORACLE_HOME/rdbms/lib of oracle10g, copy ssbbded.o, sbbdpt.o

Copy bbedus.msb in $ORACLE_HOME/rdbms/msg

Under 11g:

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

[oracle@bspdev lib] $pwd

/ u01/app/oracle/rdbms/lib

[oracle@bspdev lib] $

The compilation process is similar:

[oracle@bspdev lib] $make-f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed

Linking BBED utility (bbed)

Rm-f / u01/app/oracle/rdbms/lib/bbed

Gcc-o/u01/app/oracle/ rdbms/lib/bbed-M32-L/u01/app/oracle/rdbms/lib/-L/u01/app/oracle/lib/-L/u01/app/oracle/lib/stubs/-L/u01/app/oracle/lib/-lirc-lipgo/u01/app/oracle/lib/s0main.o / u01/app/oracle/rdbms/lib/ssbbded.o / u01/app/oracle/rdbms/lib/sbbdpt.o `cat / u01/app/oracle / lib/ ldSecrets`-lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-ldbtools11-lclntsh`cat / u01/app/oracle/lib/ ldyogs`-lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-lnro11 `cat / u01/app/oracle/lib/ ldSecrets`-lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-lnnz11-lzt11-lztkg11-lclient11-lnnetd11-lvsn11-lcommon11-lgeneric11-lmm-lsnls11-lnls11-lcore11-lsnls11-lnls11-lcore11-lsnls11-lnls11- lxml11-lcore11-lcore11-lunls11-lsnls11-`lsnls11 / lunls11 ldfants` -lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-lnro11 `cat / u01/app/oracle/lib/ ldyogs`-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-lcore11-lunls11-lnls11`cat / lsnls11 sysliblist` -rpath,/u01/app/oracle/lib-lm`cat / u01/app/oracle/lib/ sysliblist`-ldl-lm-L/u01/app/oracle/lib

Compile successfully, and then copy it to the specified $ORACLE_HOME/bin directory and use it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.