What is Oracle BBED Tool? How to make it Available in Oracle 11g?

advertisements

_____________________________________________________________________________________________________________________

BBED: Block Browser and Edit Tool

It is an Oracle tool to check the internal structure of the Oracle blocks. You have to use this tool very carefully as it can damage the Oracle blocks as well as the Oracle database too. This tool allows editing the blocks of the datafiles and it overrides the oracle access.

Generally you have to use this tool with the support of Metalink SR support.

How to make it Available in Oracle 11g?

Normally, it is not available with Oracle 11g. You have to copy the respective files from the Oracle 10g Home and like it with Oracle 11g.

The files need to be copied from Oracle 10g to Oracle 11g:

1.  $ORACLE_HOME/rdbms/lib/ssbbded.o

2.  $ORACLE_HOME/rdbms/lib/sbbdpt.o

3.  $ORACLE_HOME/rdbms/mesg/bbedus.msb

4.  $ORACLE_HOME/rdbms/mesg/bbedus.msg

Set the ORACLE_HOME variables for the Oracle 11g and link these files to Oracle Home.

make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk

BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed

Start the BBED utility and default password would be blockedit

$ORACLE_HOME/bin/bbed

$ORACLE_HOME/bin/bbed

Password:

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from Santiago de cuba viewed 'ORA-00059: maximum number of DB_FILES exceeded - F' 1 hr 5 mins ago

A visitor from Hyderabad viewed 'Troubleshoot Fix ORA-16018 ORA-16019 ORA-02097 Ora' 1 hr 36 mins ago

A visitor from Brokopondo viewed 'Data Pump impdp expdp : SQLFILE option to extract ' 1 hr 41 mins ago

A visitor from Singapore viewed 'ORA-01548: active rollback segment, Find out Oracl' 2 hrs 23 mins ago

A visitor from Kuala lumpur viewed 'Oracle 12c 18c 19c: How to find out the Listener.l' 2 hrs 52 mins ago

Real-time | Get Script | More Info