3 Replies Latest reply on Aug 20, 2003 1:08 AM by 314612

    connection becomes slow


      we have a database oracle enterprise edition,
      installed on AIX 4.3.3.
      after working well for several months, connection becomes vevy slow, it takes about 2~3 minutes to connect to the server. but when I issue sqlplus from the server , it responsess very fast.

      there errors appear in the listener.log for several times:
      TNS-12560: TNS:protocol adapter error
      TNS-00530: Protocol adapter error
      IBM/AIX RISC System/6000 Error: 72: Software caused connection abort

      TNS-12547: TNS:lost contact
      TNS-12560: TNS:protocol adapter error
      TNS-00517: Lost contact
      IBM/AIX RISC System/6000 Error: 32: Broken pipe

      someone who had ever experienced, any advice would be appreciated!