Âîò çäåñü îïèñàíî: http://www.sql.ru/forum/actualthread.aspx?bid=3&tid=144624&pg=-1

Ñîâåðøåííî íåïîíÿòíî, êîãäà áûë ïðîñòî ñåðâåð (íå ADVANCED), âñ¸ ðàáîòàëî...

òå ïðîñòî åñëè âûïîëíèòü äàííûé ñêðèïò òî âñå íîðìàëüíî? â ëþáîì ñëó÷àå ñìîòðèòå alert.log è âèíäîâûå ñîáûòèÿ íà ñåðâåðå.

Âñ¸ î÷åíü ñòðàííî:

=======Âîò ïîø¸ë SHUTDOWN IMMEDIATE:

Wed Dec 08 23:00:00 2004
Restarting dead background process EMN0
EMN0 started with pid=11
Wed Dec 08 23:00:21 2004
Shutting down instance (immediate)
License high water mark = 70
Wed Dec 08 23:00:24 2004
ALTER DATABASE CLOSE NORMAL
Wed Dec 08 23:00:24 2004
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Dec 08 23:00:25 2004
Thread 1 closed at log sequence 16067
Wed Dec 08 23:00:25 2004
Completed: ALTER DATABASE CLOSE NORMAL
Wed Dec 08 23:00:25 2004
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
archiving is disabled
Wed Dec 08 23:00:26 2004
ARCH shutting down
ARC0: Archival stopped

========Âîò ñòàðò îïÿòü:

Starting up ORACLE RDBMS Version: 8.1.7.4.1.
System parameters with non-default values:
processes = 110
shared_pool_size = 536870912
large_pool_size = 0
java_pool_size = 67108864
control_files = E:\CONTROL.CTL, F:\CONTROL.CTL, G:\CONTROL.CTL
db_block_buffers = 49152
db_block_size = 8192
compatible = 8.1.7.4.1
log_archive_start = TRUE
log_archive_dest = C:\BACKUP\ARCHLOGS
log_archive_format = LEG1_%S.ARC
log_buffer = 67108864
log_checkpoint_interval = 0
log_checkpoint_timeout = 900
db_files = 1020
db_file_multiblock_read_count= 16
dml_locks = 1024
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 10
instance_name = LEG1
service_names = LEG1
open_links = 4
sort_area_size = 16777216
sort_area_retained_size = 1048576
db_name = LEG1
open_cursors = 300
os_authent_prefix =
text_enable = TRUE
utl_file_dir = C:\PARUS\sberbank
job_queue_processes = 1
parallel_max_servers = 5
background_dump_dest = C:\oracle\ora81\database\bdump
user_dump_dest = C:\oracle\ora81\database\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
Wed Dec 08 23:00:36 2004
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=9
Wed Dec 08 23:00:36 2004
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed Dec 08 23:00:36 2004
alter database mount
Wed Dec 08 23:00:37 2004
ARC0: Archival started
Wed Dec 08 23:00:41 2004
Successful mount of redo thread 1, with mount id 2395695577.
Wed Dec 08 23:00:41 2004
Database mounted in Exclusive Mode.
Completed: alter database mount
Wed Dec 08 23:00:41 2004
alter database archivelog
Completed: alter database archivelog
Wed Dec 08 23:00:41 2004
alter database open
Wed Dec 08 23:00:42 2004
Thread 1 opened at log sequence 16067
Current log# 3 seq# 16067 mem# 0: H:\LOG5.ORA
Current log# 3 seq# 16067 mem# 1: I:\LOG6.ORA
Successful open of redo thread 1.
Wed Dec 08 23:00:42 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Dec 08 23:01:26 2004
Completed: alter database open
Wed Dec 08 23:01:27 2004
Thread 1 advanced to log sequence 16068
Current log# 4 seq# 16068 mem# 0: H:\LOG7.ORA
Current log# 4 seq# 16068 mem# 1: I:\LOG8.ORA
Wed Dec 08 23:01:27 2004
ARC0: Beginning to archive log# 3 seq# 16067
ARC0: Completed archiving log# 3 seq# 16067

========= À âîò SHUTDOWN NORMAL:

Wed Dec 08 23:02:31 2004
Restarting dead background process EMN0
EMN0 started with pid=12
Wed Dec 08 23:02:31 2004
Shutting down instance (normal)
License high water mark = 3
Wed Dec 08 23:07:42 2004
SHUTDOWN: waiting for logins to complete.
Dump file C:\oracle\ora81\database\bdump\leg1ALRT.LOG

Íè÷åãî íå ïîíèìàþ........

äóìàþ âàøà ïðîáëåìà òàæå ÷òî è çäåñü http://www.sql.ru/forum/actualthread.aspx?tid=136850&hl=shutdown+normal
à åñòü ëè êàêîé ñìûñë èñïîëüçîâàòü shutdown normal à íå immediate?

Ðàçîáðàëñÿ áëèí!
Ïîñëå ïåðåóñòàíîâêè ñåðâåðà è îðàêëà ïîÿâèëèñü äâà ñåðâèñà OraDataGatherer è åù¸ êàêîé-òî OraAgent. Âîò ïîñëåäíèé è äàâàë íåó÷ò¸ííóþ ñåññèþ DMSNMP. ß åù¸ òîãäà ïîäóìàë "íà êîé ëÿä ýòè ñåðâèñû?" Íî ïåðåâîäèòü â ðó÷íîé çàïóñê íå ñòàë, ðåøèë ïîäîæäàòü. Âîò òå è ïîäîæäàë...

Âîîáùå, äëÿ íîðìàëüíîé ðàáîòû ÏÀÐÓÑà, íóæíû ëè ñåðâèñû, êðîìå Listenera è èíñòàíñà?

À ïî ïîâîäó íîðìàë èëè èììåäèýéò, ÿ ãäå-òî êîãäà-òî âû÷èòàë, ÷òî íóæíî äåëàòü ñíà÷àëà èììåäèýéò, ïîòîì ñòàðò ñâè÷ ëîã, à ïîòîì íîðìàë, òîãäà ìîë, âñ¸ ñáðàñûâàåòñÿ â àðõèâ ëîãè è, òèïà òàê íàä¸æíåé. Íå çíàþ, êàê îáúÿñíèòü, íåãðàìîòíûé ÿ

P/S/
È åù¸, â Event Viewer, ïî äåñÿòü ðàç íà äíþ ïèøåò òàêóþ õðåíü:

Event Type: Warning
Event Source: Oracle.leg1
Event Category: None
Event ID: 16
Date: 09.12.2004
Time: 11:06:46
User: N/A
Computer: GOBLIN
Description:
Instance leg1 has been terminated.

&Iacute;&aring; &ccedil;&iacute;&agrave;&aring;&ograve;&aring;, &divide;&ograve;&icirc; &yacute;&ograve;&icirc; &ograve;&agrave;&ecirc;&icirc;&aring;?<br><br>Сообщение отредактировано: Alexander, в: 2004/12/09 17:38

&Iacute;&agrave;&ntilde;&ecirc;&icirc;&euml;&uuml;&ecirc;&icirc; &yuml; &ccedil;&iacute;&agrave;&thorn; &auml;&euml;&yuml; &iacute;&icirc;&eth;&igrave;&agrave;&euml;&uuml;&iacute;&icirc;&eacute; &eth;&agrave;&aacute;&icirc;&ograve;&ucirc; &iacute;&aring; &ograve;&icirc;&euml;&uuml;&ecirc;&icirc; &Iuml;&agrave;&eth;&oacute;&ntilde;&agrave; , &iacute;&icirc; &egrave; &iuml;&eth;&icirc;&ntilde;&ograve;&icirc; &icirc;&eth;&agrave;&ecirc;&euml;&agrave; &auml;&icirc;&ntilde;&ograve;&agrave;&ograve;&icirc;&divide;&iacute;&icirc; &iacute;&agrave;&iuml;&egrave;&ntilde;&agrave;&iacute;&iacute;&ucirc;&otilde; &Acirc;&agrave;&igrave;&egrave; &auml;&acirc;&oacute;&otilde; &ntilde;&aring;&eth;&acirc;&egrave;&ntilde;&icirc;&acirc;. &Icirc;&ntilde;&ograve;&agrave;&euml;&uuml;&iacute;&ucirc;&aring; &ntilde;&aring;&eth;&acirc;&egrave;&ntilde;&ucirc; &acirc;&ntilde;&iuml;&icirc;&igrave;&icirc;&atilde;&agrave;&ograve;&aring;&euml;&uuml;&iacute;&ucirc;&aring; &egrave; &divide;&aring;&ntilde;&ograve;&iacute;&icirc; &atilde;&icirc;&acirc;&icirc;&eth;&yuml; &iacute;&aring; &ccedil;&iacute;&agrave;&thorn; &ccedil;&agrave;&divide;&aring;&igrave; &icirc;&iacute;&egrave; &iacute;&oacute;&aelig;&iacute;&ucirc; .
&Agrave; &iuml;&icirc;&acirc;&icirc;&auml;&oacute; &quot;&ntilde;&ograve;&agrave;&eth;&ograve; &ntilde;&acirc;&egrave;&ograve;&divide; &euml;&icirc;&atilde;&quot; &iacute;&aring; &iuml;&icirc;&iacute;&yuml;&ograve;&iacute;&icirc;. &Acirc;&ucirc; &aelig;&aring; &oacute;&aelig;&aring; &ccedil;&agrave;&atilde;&agrave;&ntilde;&egrave;&euml;&egrave; &aacute;&agrave;&ccedil;&oacute; &egrave; &iuml;&aring;&eth;&aring;&ecirc;&euml;&thorn;&divide;&aring;&iacute;&egrave;&yuml; &euml;&icirc;&atilde; &ocirc;&agrave;&eacute;&euml;&agrave; &iuml;&eth;&icirc;&egrave;&ccedil;&icirc;&oslash;&euml;&icirc; &agrave;&acirc;&ograve;&icirc;&igrave;&agrave;&ograve;&icirc;&igrave; &iuml;&eth;&egrave; &ntilde;&ograve;&agrave;&eth;&ograve;&aring;. &times;&aring;&ntilde;&ograve;&iacute;&icirc; &atilde;&icirc;&acirc;&icirc;&eth;&yuml; &ntilde; &agrave;&eth;&otilde;&egrave;&acirc; &euml;&icirc;&atilde;&agrave;&igrave;&egrave; &iacute;&aring; &ntilde;&ograve;&agrave;&euml;&ecirc;&egrave;&acirc;&agrave;&euml;&ntilde;&yuml; &iuml;&icirc;&ograve;&icirc;&igrave;&oacute; &igrave;&icirc;&aelig;&aring;&ograve; &Acirc;&ucirc; &egrave; &iuml;&eth;&agrave;&acirc;&ucirc;