This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Feb 5, 2013 1: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 Oracle ACE
    Currently Being Moderated
    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?
    346402 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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?
    346402 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points