Не пойму что случилось, все работало нормально.
Запускаю систему, индикаторы зеленым цветом. Через секунд 10 work+disp отключаются.

trace рабочего процесса -

---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "700"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
B
B Sun Oct 14 17:56:31 2012
B create_con (con_name=R/3)
B Loading DB library 'C:\usr\sap\SPB\DVEBMGS02\exe\dboraslib.dll' ...
B Library 'C:\usr\sap\SPB\DVEBMGS02\exe\dboraslib.dll' loaded
B Version of 'C:\usr\sap\SPB\DVEBMGS02\exe\dboraslib.dll' is "700.08", patchlevel (0.144)
B New connection 0 created
M sysno 02
M sid SPB
M systemid 562 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 144
M intno 20050900
M make: multithreaded, Unicode, 64 bit, optimized
M pid 2112
M
M kernel runs with dp version 232000(ext=109000) (@(#) DPLIB-INT-VERSION-232000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2112) [dpxxdisp.c 1305]
I MtxInit: 30000 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M DpShMCreate: sizeof(wp_adm) 25168 (1480)
M DpShMCreate: sizeof(tm_adm) 5652128 (28120)
M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)
M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
M DpShMCreate: sizeof(comm_adm) 552080 (1088)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (104)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1864)
M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000010DF0050, size: 6348592)
M DpShMCreate: allocated sys_adm at 0000000010DF0050
M DpShMCreate: allocated wp_adm at 0000000010DF2150
M DpShMCreate: allocated tm_adm_list at 0000000010DF83A0
M DpShMCreate: allocated tm_adm at 0000000010DF8400
M DpShMCreate: allocated wp_ca_adm at 000000001135C2A0
M DpShMCreate: allocated appc_ca_adm at 0000000011362060
M DpShMCreate: allocated comm_adm at 0000000011363FA0
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 00000000113EAC30
M DpShMCreate: allocated gw_adm at 00000000113EACB0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 00000000113EACE0
M DpShMCreate: allocated wall_adm at 00000000113EACF0
M ThTaskStatus: rdisp/reset_online_during_debug 0
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation view
X <EsNT> Using memory model view.
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M
M Sun Oct 14 17:56:32 2012
M ThInit: running on host saprealspb
M
M Sun Oct 14 17:56:33 2012
M calling db_connect ...
C Prepending C:\usr\sap\SPB\DVEBMGS02\exe to Path.
C Oracle Client Version: '10.2.0.2.0'
C Client NLS settings: AMERICAN_AMERICA.UTF8
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@SPB on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 0000000014CE40C0 0000000014CEC2F0 0000000014D08B18
C Attaching to DB Server SPB (con_hdl=0,svchp=0000000014D089D8,srvhp=0000000014D0AE08)
C Starting user session (con_hdl=0,svchp=0000000014D089D8,srvhp=0000000014D0AE08,usrhp=0000000014CECB08)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
[dboci.c 4532]
C Detaching from DB Server (con_hdl=0,svchp=0000000014D089D8,srvhp=0000000014D0AE08)
C *** ERROR => CONNECT failed with sql error '1033'
[dbsloci.c 11044]
C Try to connect with default password
C Connecting as SAPSR3/<pwd>@SPB on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 0000000014CE40C0 0000000014CEC2F0 0000000014D08B18
C Attaching to DB Server SPB (con_hdl=0,svchp=0000000014D089D8,srvhp=0000000014D0AE08)
C
C Sun Oct 14 17:56:34 2012
C Starting user session (con_hdl=0,svchp=0000000014D089D8,srvhp=0000000014D0AE08,usrhp=0000000014CECB08)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
[dboci.c 4532]
C Detaching from DB Server (con_hdl=0,svchp=0000000014D089D8,srvhp=0000000014D0AE08)
C *** ERROR => CONNECT failed with sql error '1033'
[dbsloci.c 11044]
B ***LOG BV3=> severe db error 1033 ; work process is stopped [dbsh#2 @ 1199] [dbsh 1199 ]
B ***LOG BY2=> sql error 1033 performing CON [dblink#5 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#5 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1440]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10468]
M
M Info for wp 0
M
M stat = WP_RUN
M waiting_for = NO_WAITING
M reqtype = DP_RQ_DIAWP
M act_reqtype = NO_REQTYPE
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source =
M last_tid = 0
M last_mode = 0
M semaphore = 0
M act_cs_count = 0
M csTrack = 0
M csTrackRwExcl = 0
M csTrackRwShrd = 0
M mode_cleaned_counter = 0
M control_flag = 0
M int_checked_resource(RFC) = 0
M ext_checked_resource(RFC) = 0
M int_checked_resource(HTTP) = 0
M ext_checked_resource(HTTP) = 0
M report = > <
M action = 0
M tab_name = > <
M attachedVm = no VM
M
M *****************************************************************************
M *
M * LOCATION SAP-Server saprealspb_SPB_02 on host saprealspb (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Sun Oct 14 17:56:34 2012
M * RELEASE 700
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10688
M * COUNTER 1
M *
M *****************************************************************************
M
M PfStatDisconnect: disconnect statistics
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 724]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 261]
M Entering ThSetStatError
M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2112) [dpnttool.c 327]

Лог R3trans - d:

This is r3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SPB'"
r3trans finished (0012).

Не пойму в чем дело, к базе почему то не коннектится. Ноты посмотреть негде, домашняя система, поставил, изучаю.

смотри на стороне оракла, alertSID.log

лог -

Sun Oct 14 17:23:13 2012
ORA-600 signalled during: ALTER DATABASE MOUNT...
Sun Oct 14 17:25:33 2012
Starting ORACLE instance (normal)
Shutting down instance: further logons disabled
Sun Oct 14 17:30:33 2012
Stopping background process MMNL
Sun Oct 14 17:30:33 2012
Stopping background process CJQ0
Sun Oct 14 17:30:34 2012
Background process MMNL not dead after 10 seconds
Sun Oct 14 17:30:34 2012
Stopping background process MMON
Sun Oct 14 17:30:35 2012
Background process MMON not dead after 30 seconds
Sun Oct 14 17:30:35 2012
Shutting down instance (immediate)
License high water mark = 1
Sun Oct 14 17:30:35 2012
Stopping Job queue slave processes, flags = 7
Sun Oct 14 17:30:35 2012
Job queue slave processes stopped
Sun Oct 14 17:30:35 2012
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun Oct 14 17:31:04 2012
Starting ORACLE instance (normal)
Sun Oct 14 17:31:04 2012
Specified value of sga_max_size is too small, bumping to 675282944
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes = 80
sessions = 96
event = 10191 trace name context forever, level 1
sga_max_size = 675282944
shared_pool_size = 322961408
shared_pool_reserved_size= 32196526
filesystemio_options = setall
control_files = C:\ORACLE\SPB\ORIGLOGA\CNTRL\CNTRLSPB.DBF, C:\ORACLE\SPB\ORIGLOGB\CNTRL\CNTRLSPB.DBF, C:\ORACLE\SPB\SAPDATA1\CNTRL\CNTRLSPB.DBF
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 322961408
compatible = 10.2.0
log_archive_dest = C:\oracle\SPB\oraarch\SPBarch
log_buffer = 2061312
log_checkpoint_interval = 0
db_files = 254
log_checkpoints_to_alert = TRUE
dml_locks = 4000
replication_dependency_tracking= FALSE
undo_management = AUTO
undo_tablespace = PSAPUNDO
_in_memory_undo = FALSE
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
parallel_execution_message_size= 16384
_table_lookup_prefetch_size= 0
background_dump_dest = C:\ORACLE\SPB\SAPTRACE\BACKGROUND
user_dump_dest = C:\ORACLE\SPB\SAPTRACE\USERTRACE
core_dump_dest = C:\ORACLE\SPB\SAPTRACE\BACKGROUND
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = SPB
open_cursors = 800
_sort_elimination_cost_ratio= 10
_b_tree_bitmap_plans = FALSE
star_transformation_enabled= true
query_rewrite_enabled = false
_index_join_enabled = FALSE
_optim_peek_user_binds = FALSE
pga_aggregate_target = 429287014
_optimizer_mjc_enabled = FALSE
PMON started with pid=2, OS id=440
PSP0 started with pid=3, OS id=1556
MMAN started with pid=4, OS id=2136
DBW0 started with pid=5, OS id=2916
LGWR started with pid=6, OS id=724
CKPT started with pid=7, OS id=2620
SMON started with pid=8, OS id=756
RECO started with pid=9, OS id=868
CJQ0 started with pid=10, OS id=2888
MMON started with pid=11, OS id=656
MMNL started with pid=12, OS id=1900
Sun Oct 14 17:31:04 2012
ALTER DATABASE MOUNT
Sun Oct 14 17:31:08 2012
Errors in file c:\oracle\spb\saptrace\usertrace\spb_ora_2044.trc:
ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [4484], [4475], [0x000000000], [], [], [], []

Sun Oct 14 17:31:08 2012
ORA-600 signalled during: ALTER DATABASE MOUNT...
Sun Oct 14 17:32:29 2012
Starting ORACLE instance (normal)
Sun Oct 14 17:46:51 2012
Starting ORACLE instance (normal)
Dump file c:\oracle\spb\saptrace\background\alert_spb.log
Sun Oct 14 17:56:18 2012
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 1 - type 8664, 1 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:3479M/4095M, Ph+PgF:33963M/34318M
Sun Oct 14 17:56:18 2012
Starting ORACLE instance (normal)
Sun Oct 14 17:56:18 2012
Specified value of sga_max_size is too small, bumping to 675282944
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes = 80
sessions = 96
event = 10191 trace name context forever, level 1
sga_max_size = 675282944
shared_pool_size = 322961408
shared_pool_reserved_size= 32196526
filesystemio_options = setall
control_files = C:\ORACLE\SPB\ORIGLOGA\CNTRL\CNTRLSPB.DBF, C:\ORACLE\SPB\ORIGLOGB\CNTRL\CNTRLSPB.DBF, C:\ORACLE\SPB\SAPDATA1\CNTRL\CNTRLSPB.DBF
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 322961408
compatible = 10.2.0
log_archive_dest = C:\oracle\SPB\oraarch\SPBarch
log_buffer = 2061312
log_checkpoint_interval = 0
db_files = 254
log_checkpoints_to_alert = TRUE
dml_locks = 4000
replication_dependency_tracking= FALSE
undo_management = AUTO
undo_tablespace = PSAPUNDO
_in_memory_undo = FALSE
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
parallel_execution_message_size= 16384
_table_lookup_prefetch_size= 0
background_dump_dest = C:\ORACLE\SPB\SAPTRACE\BACKGROUND
user_dump_dest = C:\ORACLE\SPB\SAPTRACE\USERTRACE
core_dump_dest = C:\ORACLE\SPB\SAPTRACE\BACKGROUND
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = SPB
open_cursors = 800
_sort_elimination_cost_ratio= 10
_b_tree_bitmap_plans = FALSE
star_transformation_enabled= true
query_rewrite_enabled = false
_index_join_enabled = FALSE
_optim_peek_user_binds = FALSE
pga_aggregate_target = 429287014
_optimizer_mjc_enabled = FALSE
PMON started with pid=2, OS id=1724
PSP0 started with pid=3, OS id=1716
MMAN started with pid=4, OS id=1720
DBW0 started with pid=5, OS id=1712
LGWR started with pid=6, OS id=1708
CKPT started with pid=7, OS id=1704
SMON started with pid=8, OS id=1700
RECO started with pid=9, OS id=1480
CJQ0 started with pid=10, OS id=396
MMON started with pid=11, OS id=1744
MMNL started with pid=12, OS id=1496
Sun Oct 14 17:56:19 2012
ALTER DATABASE MOUNT
Sun Oct 14 17:56:23 2012
Errors in file c:\oracle\spb\saptrace\usertrace\spb_ora_1528.trc:
ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [4484], [4475], [0x000000000], [], [], [], []

Sun Oct 14 17:56:23 2012
ORA-600 signalled during: ALTER DATABASE MOUNT...

в этом файле что?

"Ай-яй-яй-яй-яй-яй убили базу, убили базу, убили...
Ай-яй-яй-яй-яй-яй ни за что ни про что [censored] замочили..."

Не погасили систему перед выключением машинки?

Машинку выключали через reset?
Оракл на моей памяти сам прекрасно "ложится" при нормальном выключении. А с версии 11.2.0.3 с гридом, вообще и запускается сам в линуксах, лепота прям.

Windows при шатдауне сервисам говорит, что пора ложиться. Но ни разу не ждет, пока они лягут. Поэтому oracle, чтобы выжить, убивает себя об стену со словами shutdown abort. Что само по себе не очень изящно, поскольку на старте он будет чекать базу. Но даже shutdown abort может не успеть выполниться. И тогда база рискует остановиться в весьма интересном положении.

какие варианты восстановления?

самые разные
самый простой и недешевый - обратиться к специалистам.

З.ы. повторяю в тысячный раз - SAP это не 1С, тут с наскока только баги рождаются.

домашняя система. я учусь только. базовые вещи делаю. Переставить систему займет 1 день, но это много:) да и хочется решить проблему, ведь она может и на работе произойти потом.
я еще не работаю спец.-ом по базису, готовлюсь пойди в ближайшем времени на собеедование на стажера какого-нибудь.

тогда мой Вам совет - учитесь пользоваться открытыми источниками, и если уж задаете вопросы, учитесь задавать их правильно с четкой формулировкой.

для разбега мысли вдоль открытых ресурсов:
sdn.sap.com
help.sap.com
google.com