4 Replies Latest reply: Aug 16, 2013 4:07 PM by 993467 RSS

    ORA-12537 TNS: Connection Closed

    993467

      HI All,

       

      On server when i am connecting using system/manager@orcl , i can connected successfully.

      I am facing ORA-12573 TNS: connection closed  issue.  When connect with client machine.

       

      Thanks & Regards

      Ravi Kumar

        • 1. Re: ORA-12537 TNS: Connection Closed
          Asif Muhammad

          Hi Ravi,

           

           

          Please try increasing the value of the processes parameter value in the init<SID> file in the dbs directory

           

          Note: If you are using a pfile, you will have to restart the database to change take effect. If you are using spfile, this can be achieved dynamically

           

           

          Also refer notes:

          Troubleshooting ORA-12537 / TNS-12537 TNS:Connection Closed (Doc ID 555609.1)

          'ORA-12537: TNS:connection closed' Errors Connecting To Oracle11g R1 on Linux via Oracle Net (Doc ID 733737.1)

           

           

          Thanks &

          Best Regards,

          • 2. Re: ORA-12537 TNS: Connection Closed
            Nicolas.Gasparotto

            ARM.Asif wrote:

             

            Hi Ravi,

             

             

            Please try increasing the value of the processes parameter value in the init<SID> file in the dbs directory

             

            Note: If you are using a pfile, you will have to restart the database to change take effect. If you are using spfile, this can be achieved dynamically

            Maybe a bit pedentic: changing dynamically or not a parameter has nothing to do with pfile/spfile

            Right, the first need a file modification (pfile), the latter a sql command line (spfile), but whatever is in use either pfile or spfile, you'll have to bounce the database to take effect for PROCESSES parameter change.

            SQL> alter system set processes=300 scope=both;

            alter system set processes=300 scope=both

                             *

            ERROR at line 1:

            ORA-02095: specified initialization parameter cannot be modified

             

            SQL> alter system set processes=300 scope=spfile;

             

            System altered.

             

            Nicolas.

             

            sorry for the non-formatted code, I'm not getting used this infamous editor capabilities

            Message was edited by: NicolasGasparotto

            • 3. Re: ORA-12537 TNS: Connection Closed
              nagulan.selvakumar

              Hi,

               

              What is your OS and DB version?

              Take a look at the note Doc ID 555609.1 (indicated earlier by ARM.Asif) as it stands to any platform.

               

              Thank you!!

              • 4. Re: ORA-12537 TNS: Connection Closed
                993467

                Hi All,

                Thank you for response...

                I increase the size of sga and issue has solved.............

                 

                Thanks again.

                 

                Regards

                Ravi Kumar