Use BBED for Oracle 11g Compilation

Use BBED for Oracle 11g Compilation

Environment: RHEL 6.4 + Oracle 11.2.0.4

• 1. Copy the missing file
• 2. Compile BBED
• 3. BBED Test
• Reference

1. Copy the missing file

Several related files are missing in 11g, but we can actually copy the related files from 10g to the corresponding directory of 11g:

$ORACLE_HOME/rdbms/lib/sbbdpt.o$ORACLE_HOME/rdbms/lib/ssbbded.o$ORACLE_HOME/rdbms/mesg/bbedus.msb$ORACLE_HOME/rdbms/mesg/bbedus.msg

2. Compile BBED

make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed

The successful compilation result is as follows:

[oracle@JY-DB01 dbhome_1]$ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbedLinking BBED utility (bbed)rm -f /u02/app/oracle/product/11.2.0/dbhome_1/bin/bbedgcc -o /u02/app/oracle/product/11.2.0/dbhome_1/bin/bbed -m64 -z noexecstack -L/u02/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ -L/u02/app/oracle/product/11.2.0/dbhome_1/lib/ -L/u02/app/oracle/product/11.2.0/dbhome_1/lib/stubs/  /u02/app/oracle/product/11.2.0/dbhome_1/lib/s0main.o /u02/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ssbbded.o /u02/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/sbbdpt.o `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -ldbtools11 -lclntsh  `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lclient11 -lnnetd11  -lvsn11 -lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11  -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/ldflags`    -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 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11   `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -Wl,-rpath,/u02/app/oracle/product/11.2.0/dbhome_1/lib -lm    `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -ldl -lm   -L/u02/app/oracle/product/11.2.0/dbhome_1/lib

3. BBED Test

-- 3.1 bbed command test available [oracle @ JY-DB01 dbhome_1] $ bbedPassword: -- the default password is blockeditBBED: Release 2.0.0.0.0-Limited Production on Mon Jan 18 15:13:09 2016 Copyright (c) 1982,201 1, oracle and/or its affiliates. all rights reserved. *************!!! For Oracle Internal Use only !!! * ************** BBED> help allSET DBA [dba | file #, block #] set filename 'filename' set file file # set block [+/-] block # set offset [[+/-] byte offset | symbol | * symbol] set blocksize bytesSET LIST [FILE] 'filename' set width character_countSET COUNT bytes_to_displaySET IBASE [HEX | OCT | DEC] set obase [HEX | OCT | DEC] set mode [BROWSE | EDIT] set spool [Y | N] SHOW [<SET parameter> | ALL] INFOMAP [/v] [DBA | FILENAME | FILE | BLOCK] DUMP [/v] [DBA | FILENAME | FILE | BLOCK | OFFSET | COUNT] PRINT [/x | d | u | o | c] [DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | * symbol] EXAMINE [/Nuf] [DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | * symbol] </Nuf>: n-a number which specifies a repeat count. u-a letter which specifies a unit size: B-b1, ub1 (byte) h-b2, ub2 (half-word) w-b4, ub4 (word) r-Oracle table/index rowf-a letter which specifies a display format: x-hexadecimal d-decimal u-unsigned decimal o-octal c-character (native) n-Oracle number t-Oracle date I-Oracle rowidFIND [/x | d | u | o | c] numeric/character string [TOP | CURR] COPY [DBA | FILE | FILENAME | BLOCK] TO [DBA | FILE | FILENAME | BLOCK] MODIFY [/x | d | u | o | c] numeric/character string [DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | * symbol] ASSIGN [/x | d | u | o] <target spec >=< source spec> <target spec>: [DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | * symbol] <source spec>: [value | <target spec options>] SUM [DBA | FILE | FILENAME | BLOCK] [APPLY] PUSH [DBA | FILE | FILENAME | BLOCK | OFFSET] POP [ALL] REVERT [DBA | FILE | FILENAME | BLOCK] UNDOHELP [<bbed command> | ALL] VERIFY [DBA | FILE | FILENAME | BLOCK] upt [DBA | FILE | FILENAME | BLOCK] BBED> -- 3.2 bbed command parameter [oracle @ JY-DB01 tmp] $ bbed help = yPASSWORD-Required parameterFILENAME-Database file nameBLOCKSIZE-Database block sizeLISTFILE-List file nameMODE-[browse/edit] SPOOL-Spool logfile [no/yes] Your file-BBED command file nameLOGFILE-BBED log file namePARFILE-Parameter file nameBIFILE-BBED before-image file nameREVERT-Rollback changes from BIFILE [no/yes] SILENT- hide banner [no/yes] HELP-Show all valid parameters [no/yes]

In addition, generally, bbed is used to write the configuration parameters in the parameter configuration file, and then directly call the configuration file, for example:

-- Edit/tmp/bbed. par parameter configuration file blocksize = 8192 listfile =/tmp/listfile.txt mode = edit -- edit/tmp/listfile.txt File 5/u02/oradata/jingyu/dbs_d_jingyu01.dbf 314572806/u02/oradata/jingyu/ dbs_ I _jingyu01.dbf 31457280 -- call bbedcd/tmpbbed parfile = bbed. par