Home » RDBMS Server » Server Administration » OracleServiceTMTDB service terminated unexpectedly (Oracle Release 11.2.0.1.0, Windows Server 2008 R2 Standard [Version 6.1.7601])
OracleServiceTMTDB service terminated unexpectedly [message #668148] Thu, 08 February 2018 14:06 Go to next message
barnhard
Messages: 3
Registered: February 2018
Location: Cabin John, MD
Junior Member

Windows Server 2008 R2 Standard [Version 6.1.7601] running Oracle Release 11.2.0.1.0, throws the following Windows system log error message on a daily basis requiring a system reboot to recover.

Error 2/8/2018 7:09:53 AM Service Control Manager 7034 None
Log Name: System
Source: Service Control Manager
Date: 2/8/2018 7:09:53 AM
Event ID: 7034
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: MOA-DB1
Description:
The OracleServiceTMTDB service terminated unexpectedly. It has done this 1 time(s).

There is no visible entry in the alert_tmtdb.log prior to the noted error event. The abridged alert_tmtdb.log is attached as Abridged-alert-tmtdb-log-2018.txt.

The server is a Dell system with a single Xeon CPU E5620 @2.40 GHz and installed Memory of 16.0 GB which was instanced proximate to 2/14/2012.

The Windows Server Application Log included the following entry of note:
Information 2/7/2018 9:51:51 AM Oracle.tmtdb 34 None
Log Name: Application
Source: Oracle.tmtdb
Date: 2/7/2018 9:51:51 AM
Event ID: 34
Task Category: None
Level: Information
Keywords: Classic
User: N/A
Computer: MOA-DB1
Description:
Audit trail: LENGTH: "226" SESSIONID:[8] "38305592" ENTRYID:[1] "1" USERID:[3] "DEV" ACTION:[3] "102" RETURNCODE:[1] "0" LOGOFF$PREAD:[1] "0" LOGOFF$LREAD:[5] "78378" LOGOFF$LWRITE:[2] "20" LOGOFF$DEAD:[1] "0" DBID:[10] "2292594092" SESSIONCPU:[3] "166".

A Google search located references to a prior issue with Oracle TMTDB VSS Writer Service. The server in question has the service set to Manual and it is stopped. The same article also referenced a resource depletion issue. The server in question has 16 GB of main memory and a spot check of performance showed 4 GB of memory explicitly allocated to Oracle and approximately 12 GB available during normal operations. No time correlated sample has been obtained yet.

What is the recommended approach to resolving this problem?
Re: OracleServiceTMTDB service terminated unexpectedly [message #668149 is a reply to message #668148] Thu, 08 February 2018 14:44 Go to previous messageGo to next message
BlackSwan
Messages: 26275
Registered: January 2009
Location: SoCal
Senior Member
Thu Feb 08 02:00:00 2018
Clearing Resource Manager plan via parameter
Thu Feb 08 08:29:48 2018
Starting ORACLE instance (normal)

IMO, Oracle is the victim; not the culprit.
Root cause & fix are external to Oracle at OS or hardware level.
I surmise that this system is configured to restart Oracle database after system bootup. Is this correct?

>Error 2/8/2018 7:09:53 AM Service Control Manager 7034 None
The error above is logged more than 1 hour before Oracle reports it is restarting
Re: OracleServiceTMTDB service terminated unexpectedly [message #668150 is a reply to message #668149] Thu, 08 February 2018 15:14 Go to previous messageGo to next message
barnhard
Messages: 3
Registered: February 2018
Location: Cabin John, MD
Junior Member

Thank you very much for your prompt response. You are likely right that it is OS and/or hardware related but I do not want my possible ignorance to be the cause of unnecessary consternation or expense.
Yes, the system restarts Oracle on reboot. Only one reboot per day seems to be required. However, typically the reboot is required at least 30 minutes after end users successfully start exercising the system for the day. I would normally expect that a fault which occurs over 6 hours earlier that was the proximate cause of failure would not allow any successful access prior to the reboot of the server and restart of Oracle.

[Updated on: Thu, 08 February 2018 15:18]

Report message to a moderator

Re: OracleServiceTMTDB service terminated unexpectedly [message #668151 is a reply to message #668150] Thu, 08 February 2018 15:23 Go to previous messageGo to next message
BlackSwan
Messages: 26275
Registered: January 2009
Location: SoCal
Senior Member
Oracle log shows NO activity between 02:00 & 08:29:48

IMO, Windows had some catastrophic failure closer to 08:29 than 02:00.

Root cause & fix are at OS or hardware level.
If you wish to continue to waste your time looking into Oracle for problem & resolution; you are certainly free to do so.

It appears that both hardware & OS are 10+ years old & are past due to be upgraded.
IMO, the system hardware is flakey & needs to be replaced or it needs Windows patch to stop it from malfunctioning.
Re: OracleServiceTMTDB service terminated unexpectedly [message #668152 is a reply to message #668149] Thu, 08 February 2018 15:27 Go to previous messageGo to next message
Michel Cadot
Messages: 65969
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Thu Feb 08 02:00:00 2018
Clearing Resource Manager plan via parameter
Thu Feb 08 08:29:48 2018
Starting ORACLE instance (normal)
This pattern appears several times in the file, search for previous same error in Windows system log.
Also search for trace files at about the time the service shuts down.

But I agree with BlackSwan, Oracle does not stop the service, in any case I know, so problem seems external to Oracle.

I also advise you to set registry parameters:
ORA_<SID>_SHUTDOWN -> TRUE
ORA_<SID>_SHUTDOWN_TIMEOUT -> say 90 seconds
ORA_<SID>_SHUTDOWNTYPE -> -> immediate
See https://docs.oracle.com/cd/E11882_01/win.112/e10845/admin.htm#CDCHAAHB
Or using ORADIM, see https://docs.oracle.com/cd/E11882_01/win.112/e10845/admin.htm#NTQRF215

Re: OracleServiceTMTDB service terminated unexpectedly [message #668161 is a reply to message #668152] Fri, 09 February 2018 11:14 Go to previous messageGo to next message
barnhard
Messages: 3
Registered: February 2018
Location: Cabin John, MD
Junior Member

Thanks to Michel Cadot and BlackSwan for your replies. After a line-by-line review of the Windows logs over an extended time frame, I found a portable drive that appears to be failing that was part of a database backup sequence. It has been removed from the system and we are monitoring to see if the hard drive controller errors return. If they do the existing equipment will be retired as soon as possible.
Re: OracleServiceTMTDB service terminated unexpectedly [message #668162 is a reply to message #668161] Fri, 09 February 2018 11:22 Go to previous messageGo to next message
Michel Cadot
Messages: 65969
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks for the feedback.

Re: OracleServiceTMTDB service terminated unexpectedly [message #668195 is a reply to message #668162] Mon, 12 February 2018 05:28 Go to previous messageGo to next message
vishaljamdagni
Messages: 2
Registered: February 2018
Junior Member
The problem does seem to be somewhere at the hardware or the operating system to me as well...
I could be wrong though so, pardon me if I got it wrong.
Cheers.
Re: OracleServiceTMTDB service terminated unexpectedly [message #668196 is a reply to message #668195] Mon, 12 February 2018 05:41 Go to previous message
Michel Cadot
Messages: 65969
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is what OP said:

Quote:
I found a portable drive that appears to be failing that was part of a database backup sequence. It has been removed from the system...
Previous Topic: Is it required that the gid and uid at the destination server be the same as the source in nfs confi
Next Topic: ORA-1652: unable to extend temp segment by 32 in tablespace TEMP
Goto Forum:
  


Current Time: Fri Nov 16 12:54:54 CST 2018