. Уже базу отресторил, контрол создал, импортировал база запускается. Листенер запустил. Пробую стартовать сап, вываливается с ошибкой. Полопатил инет, разблокировал пользователя sasr3. Ошибка не исчезла. SLES11 Oracle 10.0.2.0 ABAP. Запустил R3trans -d, получил уточнение по своей проблеме, пароли вроде sasr3 поменял на такой как был до рестора. Подскажите пожалуйста, голова совсем распухла. Второй месяц бьюсь.
4 ETW000 R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 16.02.2010 - 14:53:53
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Tue Feb 16 14:53:53 2010 69 0.000069
4 ETW000 [dev trc ,00000] db_con_init called 17 0.000086
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 26 0.000112
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/TST/SYS/exe/run/dboraslib.so' ...
4 ETW000 30 0.000142
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/TST/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 8493 0.008635
4 ETW000 [dev trc ,00000] Library '/usr/sap/TST/SYS/exe/run/dboraslib.so' loaded
4 ETW000 20 0.008655
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/TST/SYS/exe/run/dboraslib.so
4 ETW000 25 0.008680
4 ETW000 [dev trc ,00000] Version of '/usr/sap/TST/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.144)
4 ETW000 51 0.008731
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/TST/SYS/exe/run/dboraslib.so
4 ETW000 20 0.008751
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/TST/SYS/exe/run/dboraslib.so
4 ETW000 30 0.008781
4 ETW000 [dev trc ,00000] New connection 0 created 18 0.008799
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 24 0.008823
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 17 0.008840
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 19 0.008859
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 21 0.008880
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 211 0.009091
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 18 0.009109
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 1861 0.010970
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 28 0.010998
4 ETW000 [dev trc ,00000] Connecting as /@TS1 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 22 0.011020
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 22 0.011042
4 ETW000 [dev trc ,00000] 0 UTF8 1 0x1a8a050 0x1a91aa0 0x1aa2198
4 ETW000 20 0.011062
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 19 0.011081
4 ETW000 [dev trc ,00000] Allocating server context handle 31 0.011112
4 ETW000 [dev trc ,00000] Attaching to DB Server TS1 (con_hdl=0,svchp=0x1aa20c8,srvhp=0x1aa43a8)
4 ETW000 42 0.011154
4 ETW000 [dev trc ,00000] Assigning server context 0x1aa43a8 to service context 0x1aa20c8
4 ETW000 24734 0.035888
4 ETW000 [dev trc ,00000] Allocating user session handle 33 0.035921
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x1aa20c8,srvhp=0x1aa43a8,usrhp=0x1a922b8)
4 ETW000 31 0.035952
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1045
4 ETW000 5246 0.041198
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x1aa43a8)
4 ETW000 22 0.041220
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x1aa20c8,srvhp=0x1aa43a8)
4 ETW000 19 0.041239
4 ETW000 [dev trc ,00000] Deallocating server context handle 0x1aa43a8 180 0.041419
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1045'
4 ETW000 42 0.041461
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1045 16 0.041477
4 ETW000 [dev trc ,00000] Try to connect with default password 62 0.041539
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@TS1 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 22 0.041561
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 23 0.041584
4 ETW000 [dev trc ,00000] 0 UTF8 1 0x1a8a050 0x1a91aa0 0x1aa2198
4 ETW000 21 0.041605
4 ETW000 [dev trc ,00000] Allocating server context handle 12 0.041617
4 ETW000 [dev trc ,00000] Attaching to DB Server TS1 (con_hdl=0,svchp=0x1aa20c8,srvhp=0x1aa43a8)
4 ETW000 34 0.041651
4 ETW000 [dev trc ,00000] Assigning server context 0x1aa43a8 to service context 0x1aa20c8
4 ETW000 17967 0.059618
4 ETW000 [dev trc ,00000] Assigning username to user session 0x1a922b8 19 0.059637
4 ETW000 [dev trc ,00000] Assigning password to user session 0x1a922b8 29 0.059666
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x1aa20c8,srvhp=0x1aa43a8,usrhp=0x1a922b8)
4 ETW000 26 0.059692
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
4 ETW000 4995 0.064687
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 24 0.064711
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 12 0.064723
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#5 @ 431]
4 ETW000 106 0.064829
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#5 @ 431]
4 ETW000 38 0.064867
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TS1'"
Вход
Регистрация
FAQ пользователя
Поиск
. Уже базу отресторил, контрол создал, импортировал база запускается. Листенер запустил. Пробую стартовать сап, вываливается с ошибкой. Полопатил инет, разблокировал пользователя sasr3. Ошибка не исчезла. SLES11 Oracle 10.0.2.0 ABAP. Запустил R3trans -d, получил уточнение по своей проблеме, пароли вроде sasr3 поменял на такой как был до рестора. Подскажите пожалуйста, голова совсем распухла. Второй месяц бьюсь. 
. Судя по логу ошибка аутенфикации, пароль пользователя менял, создал пользователей оракла которые затерлись после наката базы через brrestore. Как можно проверить пользователей и необходимые привилегии для пользователей.