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 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).


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: Logo

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

Facebook photo

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

Connecting to %s