Re: Using Unix debuggers to attach to Oracle processes

GDB should be available for Solaris as well if nothing else works.

Did you try to search for the required function name with nm or objdump?

Tanel.

• Original Message ----- From: "Schultz, Charles" <sac_at_uillinois.edu> To: <egorst_at_gmail.com>; "Tanel Põder" <tanel.poder.003_at_mail.ee> Cc: "oracle-l" <oracle-l_at_freelists.org> Sent: Monday, May 08, 2006 9:39 PM Subject: RE: Using Unix debuggers to attach to Oracle processes

Egor, you mentioned:

"There might be a catch here. Such program will not work without some values (like address of fixed table). These values may change after db startup and are obtained using ordinary SQL (via sqlplus, for example). So if we want to use program that directly read data from SGA of hanged database, we need to preliminary read some values sometimes before database hangs (for example, immediately after startup)."

That is helpful to know. I am still stuck on the debugger, and my sysadmins are not up to date with the latest debuggers we have, which are (Solaris 8): dbx 6.2 (/opterp/ban7/SUNWspro/bin/dbx)
/bin/adb (unknown version)
/bin/mdb (unknown version)

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