Ludens написал:
sqlplus '/ as sysdba'
delete from ops$sidadm.sapuser;
insert into ops$sidadm.sapuser values ('SAPSR3','<newpassword>');
commit;
exit
и еще раз сбросьте пароль для SAPSR3 на newpassword
Для упрощения задачи сделал чистый инстанс с сидом эдентичным бекапу.
Следующие шаги были предприняты после рестора выполненого командой - brrestore -m full -b beclizxq.afd -c -d disk. Контрол создал, база открывается.
SAPSR3 - пользователя нет, вместо него используется SAPPRD, выполнил все рекомендуемые действия для него, в итоге получил по R3trans -d
Code:
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 : 20.02.2010 - 10:02:58
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] Sat Feb 20 10:02:58 2010 79 0.000079
4 ETW000 [dev trc ,00000] db_con_init called 17 0.000096
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 26 0.000122
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' ...
4 ETW000 31 0.000153
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/PRD/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 8741 0.008894
4 ETW000 [dev trc ,00000] Library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' loaded
4 ETW000 20 0.008914
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so
4 ETW000 26 0.008940
4 ETW000 [dev trc ,00000] Version of '/usr/sap/PRD/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.144)
4 ETW000 51 0.008991
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so
4 ETW000 21 0.009012
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so
4 ETW000 31 0.009043
4 ETW000 [dev trc ,00000] New connection 0 created 18 0.009061
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.009085
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 19 0.009104
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 20 0.009124
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 20 0.009144
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 214 0.009358
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 19 0.009377
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 1909 0.011286
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 29 0.011315
4 ETW000 [dev trc ,00000] Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 21 0.011336
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 22 0.011358
4 ETW000 [dev trc ,00000] 0 UTF8 1 0x1a8a050 0x1a91aa0 0x1aa2198
4 ETW000 21 0.011379
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 19 0.011398
4 ETW000 [dev trc ,00000] Allocating server context handle 33 0.011431
4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x1aa20c8,srvhp=0x1aa43a8)
4 ETW000 46 0.011477
4 ETW000 [dev trc ,00000] Assigning server context 0x1aa43a8 to service context 0x1aa20c8
4 ETW000 20348 0.031825
4 ETW000 [dev trc ,00000] Allocating user session handle 32 0.031857
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x1aa20c8,srvhp=0x1aa43a8,usrhp=0x1a922b8)
4 ETW000 31 0.031888
4 ETW000 [dev trc ,00000] Assigning user session 0x1a922b8 to service context 0x1aa20c8
4 ETW000 6525 0.038413
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;
4 ETW000 50 0.038463
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;
4 ETW000 115 0.038578
4 ETW000 [dev trc ,00000] Now '/@PRD' is connected (con_hdl 0, nls_hdl 0).
4 ETW000 4433 0.043011
4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY
4 ETW000 34 0.043045
4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)
4 ETW000 404 0.043449
4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1403 when accessing table SAPUSER
4 ETW000 525 0.043974
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1403 16 0.043990
4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 114 0.044104
4 ETW000 [dev trc ,00000] Rolling back transaction ... 25 0.044129
4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x1aa20c8,usrhp=0x1a922b8)
4 ETW000 152 0.044281
4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 489 0.044770
4 ETW000 [dev trc ,00000] Try to connect with default password 17 0.044787
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 46 0.044833
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 28 0.044861
4 ETW000 [dev trc ,00000] 0 UTF8 1 0x1a8a050 0x1a91aa0 0x1aa2198
4 ETW000 21 0.044882
4 ETW000 [dev trc ,00000] Assigning username to user session 0x1a922b8 13 0.044895
4 ETW000 [dev trc ,00000] Assigning password to user session 0x1a922b8 24 0.044919
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x1aa20c8,srvhp=0x1aa43a8,usrhp=0x1a922b8)
4 ETW000 45 0.044964
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
4 ETW000 1546 0.046510
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 23 0.046533
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 12 0.046545
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#5 @ 431]
4 ETW000 119 0.046664
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#5 @ 431]
4 ETW000 31 0.046695
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRD'"
что рабить?
