Re: Using Unix debuggers to attach to Oracle processes

Tanel Põder has an interesting presentation on this:

http://integrid.info/hotsos05/Advanced%20Research%20Techniques.pdf

HTH Stefan

On 5/4/06, Schultz, Charles <sac_at_uillinois.edu> wrote:
>
> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l