1 2 Previous Next 19 Replies Latest reply: Feb 5, 2013 3:50 AM by Osama_Mustafa Go to original post RSS
      • 15. Re: Problems with DB -->Re: alter database mount exclusive - what does it mean?
        Osama_Mustafa
        TNS-12637: Packet receive failed Cause: A process was unable to receive a packet from another process. Possible causes are:
        1. The other process was terminated.
        2. The machine on which the other process is running went down.
        3. Some other communications error occurred.
        Action: If the cause is not obvious, contact Oracle Customer Support.
        • 16. Re: Problems with DB -->Re: alter database mount exclusive - what does it mean?
          kogotok1
          I have found for example the following errors errors reported in the same time in alert.log and in listener.log

          1.
          ALERT.LOG

          ***********************************************************************
          Fatal NI connect error 12547, connecting to:
          (LOCAL=NO)
          VERSION INFORMATION:
               TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
               Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
               Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
          Time: 04-FEB-2013 17:45:59
          Tracing not turned on.
          Tns error struct:
          ns main err code: 12547
          TNS-12547: TNS:lost contact
          ns secondary err code: 12560
          nt main err code: 0
          nt secondary err code: 0
          nt OS err code: 0
          opiodr aborting process unknown ospid (4196) as a result of ORA-609
          Mon Feb 04 17:48:05 2013

          AND CORRESPONDING PLACE IN LISTENER.LOG
          ----------------------------------------------------------------------
          04-FEB-2013 17:45:59 * service_update * xxx * 0
          04-FEB-2013 17:45:59 * (CONNECT_DATA=(SERVICE_NAME=XXX)(CID=(PROGRAM=C:\xxx\bin\minimalcop.exe)(HOST=CNVRGTEST02)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.93.99)(PORT=51733)) * establish * XXX * 0
          04-FEB-2013 17:45:59 * service_update * xxx * 0
          04-FEB-2013 17:45:59 * (CONNECT_DATA=(SERVICE_NAME=XXX)(CID=(PROGRAM=C:\xxx\bin\minimalcop.exe)(HOST=CNVRGTEST03)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.93.254)(PORT=64606)) * establish * XXX * 0
          04-FEB-2013 17:45:59 * service_update * xxx * 0
          04-FEB-2013 17:45:59 * 12502
          TNS-12502: TNS:listener received no CONNECT_DATA from client
          04-FEB-2013 17:45:59 * service_update * xxx * 0
          04-FEB-2013 17:45:59 * (CONNECT_DATA=(SERVICE_NAME=XXX)(CID=(PROGRAM=C:\xxx\bin\minimalcop.exe)(HOST=CNVRGTEST04)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.91.193)(PORT=64317)) * establish * XXX * 0
          04-FEB-2013 17:45:59 * service_update * xxx * 0
          04-FEB-2013 17:45:59 * 12502
          TNS-12502: TNS:listener received no CONNECT_DATA from client

          2.
          ALERT.LOG
          ***********************************************************************
          Fatal NI connect error 12547, connecting to:
          (LOCAL=NO)
          VERSION INFORMATION:
               TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
               Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
               Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
          Time: 04-FEB-2013 18:01:02
          Tracing not turned on.
          Tns error struct:
          ns main err code: 12547
          TNS-12547: TNS:lost contact
          ns secondary err code: 12560
          nt main err code: 0
          nt secondary err code: 0
          nt OS err code: 0
          opiodr aborting process unknown ospid (1336) as a result of ORA-609
          Mon Feb 04 18:02:33 2013

          AND CORRESPONDING PLACE IN LISTENER.LOG
          ----------------------------------------------------------------------
          04-FEB-2013 18:01:02 * (CONNECT_DATA=(SERVICE_NAME=XXX)(CID=(PROGRAM=C:\xxx\bin\minimalcop.exe)(HOST=CNVRGTEST04)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.91.193)(PORT=55481)) * establish * XXX * 12560
          TNS-12560: TNS:protocol adapter error
          TNS-00530: Protocol adapter error
          64-bit Windows Error: 54: Unknown error
          TNS-12518: TNS:listener could not hand off client connection
          TNS-12571: TNS:packet writer failure
          TNS-12560: TNS:protocol adapter error
          TNS-00530: Protocol adapter error
          64-bit Windows Error: 54: Unknown error

          What do you think - is it the same reason for both problems or not?
          • 17. Re: Problems with DB -->Re: alter database mount exclusive - what does it mean?
            Osama_Mustafa
            Did you check MOS note that i posted , please check it and understand the cause
            • 18. Re: Problems with DB -->Re: alter database mount exclusive - what does it mean?
              kogotok1
              Thank you.
              I have read it, and I don't think it is my case
              Note written about EM agent nscd (the advice is - to stop this agent) - but I have no this process started on my server. Also - Note is about Linux, but I have MS Windows server.
              Why do you think it is my case? May be I am wrong ... How I can define this - I looket into TaskManager and can not find anything like "nscd" - may be I should search for another name?

              Additional question: how I can define the client, which is the reason for TNS-12502 error in listener.log?

              Edited by: kogotok1 on Feb 5, 2013 12:42 PM

              Edited by: kogotok1 on Feb 5, 2013 12:44 PM
              • 19. Re: Problems with DB -->Re: alter database mount exclusive - what does it mean?
                Osama_Mustafa
                You need to check MOS Document to see what is your case :
                Troubleshooting ORA-12537 / TNS-12537 TNS:Connection Closed [ID 555609.1]
                11g: ORA-609 TNS-12537 and TNS-12547 or TNS-12170 in 11g Alert.log [ID 1116960.1]
                1 2 Previous Next