RE: Using Unix debuggers to attach to Oracle processes

Yes, I found the following functions via nm: ksudss
ksdhng
ksudps

In mdb and dbx, I get unknown symbols which tells me that I still have to work on the syntax. With adb, I kill the shadow process (ora-7445, SIGKILL on the function/symbol), but no trace file that I can find.

It would be really cool if Oracle included its own debugger, external to the database. Or if you could run oradebug without connecting to the instance (attaching, but not connecting via sqlplus).

I'll ask our sysadmins about gdb - I was hoping to use at least one of the three we already have, but I will do whatever it takes. =) Thanks, Tanel,

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel Põder Sent: Monday, May 08, 2006 12:06 PM
To: Schultz, Charles; egorst_at_gmail.com
Cc: oracle-l
Subject: 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


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