OraFAQ Forum: Server Administration » automatic restart of teh instance

Home » RDBMS Server » Server Administration » automatic restart of teh instance (Oracle 18)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

automatic restart of teh instance [message #675636]

Thu, 11 April 2019 01:21

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

Attachment: oracle.png
(Size: 19.01KB, Downloaded 2449 times)

Report message to a moderator

Re: automatic restart of teh instance [message #675644 is a reply to message #675636]

Thu, 11 April 2019 03:19

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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?

Report message to a moderator

Re: automatic restart of teh instance [message #675667 is a reply to message #675644]

Thu, 11 April 2019 06:21

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

Report message to a moderator

Re: automatic restart of teh instance [message #675671 is a reply to message #675667]

Thu, 11 April 2019 07:36

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator