Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Using Unix debuggers to attach to Oracle processes

Using Unix debuggers to attach to Oracle processes

From: Schultz, Charles <sac_at_uillinois.edu>
Date: Thu, 4 May 2006 08:39:05 -0500
Message-ID: <565F609E6D736D439837F1A1A797F34171D4AC@ADMINMAIL1.ui.uillinois.edu>


Anyone familiar with using adb or mdb to attach to Unix (Solaris) processes? I am working with Oracle Support, but the guy behind the curtain (the developer) is in England, and it is hard to communicate quickly since our shifts do not overlap for long.

This is what I have so far - I bomb on #5 with an "unknown symbol":

1. adb -P'> ' $ORACLE_HOME/bin/oracle 
2. Wait for the "> " prompt 
3. Determine the OS pid of the shadow ("oracle$ORACLE_SID") process. The
steps below assume that the pid is 123456. 4. Attach to the process by typing "0t123456:A" at the "> " prompt 5. Set a breakpoint in qmxtgrGetBindVal() by typing "qmxtgrGetBindVal:b" at the "> " prompt.
6. Allow the process to continue execution by typing ":c" at the "> " prompt.
7. Repeat steps 1-6 for all of the shared_server processes(p00x)and QC process executing the "adb" command under different windows.

charles schultz
oracle dba
aits - adsd
university of illinois

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 04 2006 - 08:39:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US