This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Feb 5, 2013 1:50 AM by Osama_Mustafa RSS

Errors in alert log and listener log and "alter database mount exclusive"

346402 Newbie
Currently Being Moderated
Hello!
I need a help.
Database 11R2 works under MS Windows Server.
Whwn I start it using Services, according alert log it is started by command "alter database mount exclusive".
Next - alter database open.
After this, it seams that program, which should put data into database, can not work with it, because I see errors in alert log: ora-12537, 12560, 12535, 12570, 12547.
What does itmean and what to do?

This is extract from alert_log
...
ORACLE_BASE from environment = C:\Oracle
Mon Feb 04 14:54:53 2013
alter database mount exclusive
Successful mount of redo thread 1, with mount id 1458539517
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Thread 1 opened at log sequence 3105
Current log# 3 seq# 3105 mem# 0: C:\ORACLE\ORADATA\xxx\REDO03.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is AL32UTF8
No Resource Manager plan active
Mon Feb 04 14:55:04 2013
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Mon Feb 04 14:55:06 2013
QMNC started with pid=20, OS id=2860
Completed: alter database open
Mon Feb 04 14:55:11 2013
Starting background process CJQ0
Mon Feb 04 14:55:11 2013
CJQ0 started with pid=25, OS id=2000
Mon Feb 04 14:55:11 2013
db_recovery_file_dest_size of 4977 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Feb 04 15:00:29 2013
Starting background process SMCO
Mon Feb 04 15:00:29 2013
SMCO started with pid=32, OS id=3212

Edited by: kogotok1 on Feb 4, 2013 4:54 PM
  • 1. Re: alter database mount exclusive - what does it mean?
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    alter database mount exclusive
    EXCLUSIVE : allow only the current instance to function.

    Check this thread Please
    starting up in shared and exclusive mode

    also Post alert log as you see it.
  • 2. Re: alter database mount exclusive - what does it mean?
    Niket Kumar Pro
    Currently Being Moderated
    check also your listener service.

    cmd>lsnrctl status
  • 3. Re: alter database mount exclusive - what does it mean?
    346402 Newbie
    Currently Being Moderated
    Thank you - I had put extract from alert log in my message.
    Main question from me: can it be "exclusive" the reason for errors like this (from alert log)

    Fatal NI connect error 12570, 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 14:02:26
    Tracing not turned on.
    Tns error struct:
    ns main err code: 12570

    TNS-12570: TNS:packet reader failure
    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 (3956) as a result of ORA-609
    Mon Feb 04 14:03:06 2013


    ***********************************************************************

    Fatal NI connect error 12537, 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 14:03:06
    Tracing not turned on.
    Tns error struct:
    ns main err code: 12537

    TNS-12537: TNS:connection closed
    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 (3088) as a result of ORA-609
    Mon Feb 04 14:07:08 2013
  • 4. Re: alter database mount exclusive - what does it mean?
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    I recommend you to check MOS note
    Lsnrctl Status is Failing and Alert.log Shows TNS-12537 and ORA-609 [ID 950135.1]
  • 5. Re: alter database mount exclusive - what does it mean?
    JohnWatson Guru
    Currently Being Moderated
    I do not see any problem.
    The exclusive mount is bacause the database is not clustered.
    Those "Fatal NI connect" messages are not errors (you can suppress them if you want by disabling ADR logging) they are normal for an 11g instance.
    --
    John Watson
    http://skillbuilders.com
  • 6. Re: alter database mount exclusive - what does it mean?
    346402 Newbie
    Currently Being Moderated
    Thank you.
    But in the same time - when I see in alert log those error messages ora -12560, 12537,12535,12570 and so on - clients programs, whiie try to connect, hang up.
    For sql plus takes 20 minutes to connect.

    lsnrctl status gives the following

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-FEB-2013 16:01
    :46

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx-BD.mosxxx
    .elektra.net)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
    ction
    Start Date 01-FEB-2013 10:22:48
    Uptime 3 days 5 hr. 39 min. 54 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File C:\Oracle\listener.ora
    Listener Log File c:\oracle\diag\tnslsnr\xxx-BD\listener\alert\l
    og.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx-BD.mosxxx.elektra.net)
    (PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "XXX" has 2 instance(s).
    Instance "XXX", status UNKNOWN, has 1 handler(s) for this service...
    Instance "xxx", status READY, has 1 handler(s) for this service...
    Service "XXXDB" has 1 instance(s).
    Instance "xxx", status READY, has 1 handler(s) for this service...
    The command completed successfully

    To tell the truth I am confuse - I thought I have only 1 service "XXXDB" and 1 instance - "xxx".
    May be I have wrong entries in tnslsnr.ora?
  • 7. Re: alter database mount exclusive - what does it mean?
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    But in the same time - when I see in alert log those error messages ora -12560, 12537,12535,12570 and so on - clients programs, whiie try to connect, hang up.
    For sql plus takes 20 minutes to connect.
    Are you using JDBC ? which type of application you have , are you enable the audit ?
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "XXX" has 2 instance(s).
    Instance "XXX", status UNKNOWN, has 1 handler(s) for this service...
    Instance "xxx", status READY, has 1 handler(s) for this service...
    Service "XXXDB" has 1 instance(s).
    Instance "xxx", status READY, has 1 handler(s) for this service...
    The command completed successfully
    You instance is xxx
    Instance "xxx", status READY, has 1 handler(s) for this service...
  • 8. Re: alter database mount exclusive - what does it mean?
    346402 Newbie
    Currently Being Moderated
    I think application uses OCI
    As far as I know audit disabled

    So - lsnrctl is Ok?
    What can be the reason for application and sql plus hang up?
  • 9. Re: alter database mount exclusive - what does it mean?
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    is the JDBC OCI Driver Crash ?
  • 10. Re: alter database mount exclusive - what does it mean?
    346402 Newbie
    Currently Being Moderated
    I don't know. Where I can see this?
  • 11. Re: alter database mount exclusive - what does it mean?
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    kogotok1 wrote:
    I don't know. Where I can see this?
    I think The below note related to your issue
    Troubleshooting JDBC OCI Driver Crash/Hangs on the Microsoft Windows Platform [ID 604097.1]
  • 12. Re: alter database mount exclusive - what does it mean?
    346402 Newbie
    Currently Being Moderated
    Thank you - I found this note - but I am completely don't sure that my driver crushes: obviously, SQLPLUS hangs up for 20 minutes, but after this connects to database. Why do you think this is JDBC driver?
  • 13. Re: alter database mount exclusive - what does it mean?
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    kogotok1 wrote:
    Thank you - I found this note - but I am completely don't sure that my driver crushes: obviously, SQLPLUS hangs up for 20 minutes, but after this connects to database. Why do you think this is JDBC driver?
    I don't know your setup but before applying any MOS notes you need to make sure its working your case read it carefully
  • 14. Problems with DB -->Re: alter database mount exclusive - what does it mean?
    346402 Newbie
    Currently Being Moderated
    Could you give me a piece of advice, please?

    I just found the corresponding places in alert.log and in tnslsnr.log.

    When in alert log: -----------------

    Fatal NI connect error 12637, 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:40:00*
    Tracing not turned on.
    Tns error struct:
    ns main err code: 12637

    TNS-12637: Packet receive failed
    ns secondary err code: 12532
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
    opiodr aborting process unknown ospid (4304) as a result of ORA-609

    In lsnr log -------------------------

    *04-FEB-2013 17:40:00* * 12502
    TNS-12502: TNS:listener received no CONNECT_DATA from client
    04-FEB-2013 17:40:00 * service_update * xxx * 0
    04-FEB-2013 17:40:00 * 12502
    TNS-12502: TNS:listener received no CONNECT_DATA from client
    04-FEB-2013 17:40:00 * 12502
    TNS-12502: TNS:listener received no CONNECT_DATA from client
    04-FEB-2013 17:40:00 * 12502
    TNS-12502: TNS:listener received no CONNECT_DATA from client
    04-FEB-2013 17:40:00 * 12502
    TNS-12502: TNS:listener received no CONNECT_DATA from client
    04-FEB-2013 17:40:00 * 12502
    TNS-12502: TNS:listener received no CONNECT_DATA from client

    Do you know something about this?
    Does it looks like JDBC crash?

    Edited by: kogotok1 on Feb 4, 2013 4:55 PM

    Edited by: kogotok1 on Feb 4, 2013 4:58 PM
1 2 Previous Next

Legend

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