Home » RDBMS Server » Server Administration » automatic restart of teh instance (Oracle 18)
automatic restart of teh instance [message #675636] Thu, 11 April 2019 01:21 Go to next message
m.haase
Messages: 4
Registered: April 2019
Junior Member
Good Morning,

we have the problem, that every night the instace will be automatically restart..

Here the logs from Windows:

Audit trail: LENGTH: '301' ACTION :[26] 'SELECT CDB FROM V$DATABASE' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[19] 'NT-AUTORITÄT\SYSTEM' CLIENT TERMINAL:[7] 'MNORA18' STATUS:[1] '0' DBID:[10] '4125061835' SESSIONID:[10] '4294967295' USERHOST:[14] 'MN\MNORA18' CLIENT ADDRESS:[0] '' ACTION NUMBER:[1] '3' .

Audit trail: LENGTH: '303' ACTION :[27] 'ALTER DATABASE CLOSE NORMAL' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[19] 'NT-AUTORITÄT\SYSTEM' CLIENT TERMINAL:[7] 'MNORA18' STATUS:[1] '0' DBID:[10] '4125061835' SESSIONID:[10] '4294967295' USERHOST:[14] 'MN\MNORA18' CLIENT ADDRESS:[0] '' ACTION NUMBER:[2] '35' .

Audit trail: LENGTH: '288' ACTION :[23] 'ALTER DATABASE DISMOUNT' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[19] 'NT-AUTORITÄT\SYSTEM' CLIENT TERMINAL:[7] 'MNORA18' STATUS:[1] '0' DBID:[0] '' SESSIONID:[10] '4294967295' USERHOST:[14] 'MN\MNORA18' CLIENT ADDRESS:[0] '' ACTION NUMBER:[2] '35' .

Audit trail: LENGTH: '284' ACTION :[18] 'SHUTDOWN IMMEDIATE' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[19] 'NT-AUTORITÄT\SYSTEM' CLIENT TERMINAL:[7] 'MNORA18' STATUS:[1] '0' DBID:[0] '' SESSIONID:[10] '4294967295' USERHOST:[14] 'MN\MNORA18' CLIENT ADDRESS:[0] '' ACTION NUMBER:[3] '139' .

Shutdown normal performed on instance mnora18.

All process in instance mnora18 stopped

/foru/forum/fa/14080/0/
  • Attachment: oracle.png
    (Size: 19.01KB, Downloaded 1933 times)
Re: automatic restart of teh instance [message #675644 is a reply to message #675636] Thu, 11 April 2019 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It seems you have a Windows scheduled task (not an Oracle one) that shut down your instance.
Is the server also restarted at this time?

Re: automatic restart of teh instance [message #675667 is a reply to message #675644] Thu, 11 April 2019 06:21 Go to previous messageGo to next message
m.haase
Messages: 4
Registered: April 2019
Junior Member
Hello,

no. The server is not restarting at this time. i have made a standard installation and i have not create any task for a restart or something.

Best regards
marco
Re: automatic restart of teh instance [message #675671 is a reply to message #675667] Thu, 11 April 2019 07:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The last posted record states:
ACTION :[18] 'SHUTDOWN IMMEDIATE'
CLIENT USER:[19] 'NT-AUTORITÄT\SYSTEM'

So this is not a human being that does that but the system itself.
Check your Windows scheduled task.

Re: automatic restart of teh instance [message #675676 is a reply to message #675667] Thu, 11 April 2019 08:52 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
What version of Windows?
Re: automatic restart of teh instance [message #675678 is a reply to message #675676] Thu, 11 April 2019 09:21 Go to previous messageGo to next message
m.haase
Messages: 4
Registered: April 2019
Junior Member
The Server is a Windows Server 2012 R2 Datacenter

Do you have a idea where i can search for a service ?
Re: automatic restart of teh instance [message #675680 is a reply to message #675678] Thu, 11 April 2019 10:44 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Open a run dialog box and type services.msc.

Re: automatic restart of teh instance [message #675684 is a reply to message #675678] Fri, 12 April 2019 01:12 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
m.haase wrote on Thu, 11 April 2019 15:21
The Server is a Windows Server 2012 R2 Datacenter

Do you have a idea where i can search for a service ?
Open a command box, and run

sc query
Re: automatic restart of teh instance [message #675689 is a reply to message #675684] Fri, 12 April 2019 04:47 Go to previous messageGo to next message
m.haase
Messages: 4
Registered: April 2019
Junior Member
Hello,

where i can search for a task is clear Smile
But have everyone a idea which shedule Task will shutdown the instance ?
Re: automatic restart of teh instance [message #675691 is a reply to message #675689] Fri, 12 April 2019 06:02 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
No - since it's not a standard oracle thing.
Re: automatic restart of teh instance [message #675692 is a reply to message #675689] Fri, 12 April 2019 06:20 Go to previous message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
cookiemonster wrote on Fri, 12 April 2019 12:02
No - since it's not a standard oracle thing.
Or a standard Windows thing. Someone has created a task to do this.
Previous Topic: Need advice to Migrate 11g to 12c using datapump
Next Topic: large table
Goto Forum:
  


Current Time: Thu Mar 28 07:17:09 CDT 2024