Suspending a newly forked oracle process

Suppose we want to investigate/debug the initial phases of an oracle process creation such as the authentication step (Oracle getting anyone’s password) , how to processed ? We will have to attach to the process just after it’s creation ! Here is a systemtap script that may help !

TEST ENV : Oracle 12.1.0.2.6/UEK4/OEL 6/systemtap 3.1

I just modified the script used in my blog post systemtap : A mini oracle db firewall to suspend the oracle process just after is has been forked (using the SIGSTOP signal the idea come from  Mauro Pagano blog post  Manually holding an enqueue with SystemTap).

Capture

Now attach to the oracle process using GDB/intel pin  for example and hit Ctr+C to resume execution.

DOWNLOAD : new_proc_sus.stp

That’s it 😀

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s