Call: +44 (0)1904 557620 Call

Pete Finnigan's Oracle Security Weblog

This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.

[Previous entry: "Encrypting JDBC thin connections with SQL*Net"] [Next entry: "XML DB Beta program for Oracle 10g release 2"]

Stefan talks about finding the cluster interconnect IP address

I was browsing - (broken link) orablogs last night and saw Stefan Roesch's post entitled "Determining the IP address of the cluster interconnect in 9i". Although my main interest is of course Oracle security I also enjoy looking into hidden, undocumented and internal details so this post perked my interest as it talks about the use of the undocumented kernel debugger oradebug.

Stefan informs us that its not possible to determine the interconnect IP Address from a database view in 9i RAC. He instead shows us how to use the oradebug command to find the IP Address. This is done with the oradebug ipc command and the tool writes a trace file containing the info needed. Stefan goes on to show us a complete example with how to find and read the trace file. Finding a trace file created by oradebug is done with the oradebug tracefile_name command.

I have links to two great papers about the oradebug on my oracle internals page