7 Replies Latest reply: Apr 28, 2013 7:56 AM by KR10822864 RSS

    Oracle Net

    1005860
      Hello,

      When is it appropriate to set tracing on Oracle Net?
        • 1. Re: Oracle Net
          sb92075
          1002857 wrote:
          Hello,

          When is it appropriate to set tracing on Oracle Net?
          always, never, you pick.
          • 2. Re: Oracle Net
            sybrand_b
            1 it is almost never required
            2 You can not trace selectively
            3 It generates a huge amount of trace files
            4 You need to know how to read these files
            5 They are very informative
            *6 It is very easy to forget to switch it off*

            -----------
            Sybrand Bakker
            Senior Oracle DBA
            • 3. Re: Oracle Net
              Justin_Mungal
              1002857 wrote:
              Hello,

              When is it appropriate to set tracing on Oracle Net?
              I've used it a couple times to troubleshoot intermittent connection issues between a client and server. I didn't even read the trace files, I sent them to Oracle Support.
              • 4. Re: Oracle Net
                EdStevens
                Justin Mungal wrote:
                1002857 wrote:
                Hello,

                When is it appropriate to set tracing on Oracle Net?
                I've used it a couple times to troubleshoot intermittent connection issues between a client and server. I didn't even read the trace files, I sent them to Oracle Support.
                It's a shame you "didn't even read the trace files". Even without being a network wizard or knowing how to really read the file, you'd be surprised what you can pick out just by going on a "fishing expedition." You should try it some time.
                • 5. Re: Oracle Net
                  Justin_Mungal
                  EdStevens wrote:
                  Justin Mungal wrote:
                  1002857 wrote:
                  Hello,

                  When is it appropriate to set tracing on Oracle Net?
                  I've used it a couple times to troubleshoot intermittent connection issues between a client and server. I didn't even read the trace files, I sent them to Oracle Support.
                  It's a shame you "didn't even read the trace files". Even without being a network wizard or knowing how to really read the file, you'd be surprised what you can pick out just by going on a "fishing expedition." You should try it some time.
                  I've read them before. I've also taken etherpeek/wireshark captures. You're right, they can be quite insightful.

                  I should have been a bit more clear, but in the particular case above I had opened an SR on behalf of a client, and it was Oracle Support that requested the trace. Mentioning that I didn't read them was pretty irrelevant and makes me come off as lazy; I'm not sure why I did that.
                  • 6. Re: Oracle Net
                    Aman....
                    1002857 wrote:
                    Hello,

                    When is it appropriate to set tracing on Oracle Net?
                    As always, any question related to oracle db would be having the answer started from "it depends" . So now, in answer for your question, tell us why you think you want to do it? Do you have any issue in the environment or it's just a thought in your mind?

                    Aman....
                    • 7. Re: Oracle Net
                      KR10822864
                      1002857 wrote:
                      Hello,

                      When is it appropriate to set tracing on Oracle Net?
                      refer below link:
                      http://docs.oracle.com/cd/B19306_01/network.102/b14212/troublestng.htm