How to Collect and Read Logs for an Oracle Connection

[HenrietteH]

How-To

Collect and Read Logs for an Oracle Connection

Environment

• Alteryx Designer
  • All version
• Oracle Connection
• Wireshark

Procedure

Step 1: Collecting logs using Wireshark

1. Take note of the Oracle Server's IP Address - either use nslookup or have the customer ask their IT. 
2. Create a test workflow in Alteryx. Try to make the workflow as simple as possible with as little data as possible being read in.
3. Open Wireshark and make sure you select the right interface to capture traffic. 
4. Start capturing traffic in Wireshark.
5. Run the Alteryx workflow. 
6. Upon Workflow completion, stop capturing traffic in Wireshark. 

Step 2: Reading the logs

1. Filter for the server's IP address using the following syntax: ip.addr == 10.10.10.10
2. The first three lines should be [SYN], [SYN,ACK] and [ACK] between the local machine and the server.
3. The next line should be the request to connect.

4. Right-click on the line and select Follow > TCP Stream. This will show the traffic between the local machine and the server related to this connection. 
5. For a successful connection, you should see:

a. The initial request
b. Authentication
c. The version
d. The query
e. Metadata query(ies)
f. The data being transferred
g. At the very end, the server should send a message "ORA-01403: no data found". This tells us that the end of file has been reached.

1. Examples of errors you might see: 
   1. Table not found
      The connection authenticates but an error is thrown right after the query is sent:
      
   2. Invalid username or password
      An error is thrown during authentication: