Добрый день!
Не доступна база по R3trans
Ошибка - R3trans finished (0012)

Прочитал что как то через brtools можно сменить пароль для пользователя sapr3
Подскажите как? Что -то не могу разобраться

учу пользоваться гуглом, дорого (с)

https://www.google.com/#hl=en&tbo=d&sclient=psy-ab&q=brconnect+change+password+help.sap.com&oq=brconnect+change+password+help.sap.com&gs_l=hp.3...26124.27177.4.27328.7.7.0.0.0.0.47.285.7.7.0.les%3B..0.0...1c.1.AbCff8ISsTY&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.&fp=463c0738cb0b3e9f&bpcl=39650382&biw=1440&bih=770

первая ссылка.

Не помогло.
В чем может быть ошибка, ранее работало

test:ddtadm 52> R3trans -d
This is R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DDT'"
R3trans finished (0012).

Сама база поднимается через SQLPlus без ошибок
tnsping SID - OK

Почему по R3trans может быть не доступна?

почитайте trans.log, который остается от запуска этой команды.

поиском прошелся - нет этого файла. где он обычно лежит?

сделал так

test:~ # R3trans -d -w $HOME/dbconn.log
This is R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DDT'"
R3trans finished (0012).
test:~ # cat $HOME/dbconn.log
4 ETW000 R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 10.12.2012 - 16:13:00
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d -w /root/dbconn.log
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [ dev trc,00000] Mon Dec 10 16:13:00 2012 69 0.000069
4 ETW000 [ dev trc,00000] db_con_init called 16 0.000085
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): usage of ssfs switched off (rsdb/ssfs_connect=0)
4 ETW000 30 0.000115
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 16 0.000131
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 10 0.000141
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/DDT/SYS/exe/run/dboraslib.so' ... 26 0.000167
4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/DDT/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 6804 0.006971
4 ETW000 [ dev trc,00000] Library '/usr/sap/DDT/SYS/exe/run/dboraslib.so' loaded 13 0.006984
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/DDT/SYS/exe/run/dboraslib.so
4 ETW000 21 0.007005
4 ETW000 [ dev trc,00000] Version of '/usr/sap/DDT/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.114)
4 ETW000 47 0.007052
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/DDT/SYS/exe/run/dboraslib.so
4 ETW000 16 0.007068
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/DDT/SYS/exe/run/dboraslib.so
4 ETW000 35 0.007103
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_version loaded from library /usr/sap/DDT/SYS/exe/run/dboraslib.so
4 ETW000 17 0.007120
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_flavor loaded from library /usr/sap/DDT/SYS/exe/run/dboraslib.so
4 ETW000 14 0.007134
4 ETW000 [ dev trc,00000] function sapic_get_patchset_version loaded from library /usr/sap/DDT/SYS/exe/run/dboraslib.so
4 ETW000 13 0.007147
4 ETW000 [ dev trc,00000] function sapic_get_ls_inventory loaded from library /usr/sap/DDT/SYS/exe/run/dboraslib.so
4 ETW000 13 0.007160
4 ETW000 [ dev trc,00000] New connection 0 created 12 0.007172
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 23 0.007195
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 13 0.007208
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 22 0.007230
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 8 0.007238
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 19 0.007257
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=-1, type=0, env='[default env]', userid='[default usr]')
4 ETW000 52 0.007309
4 ETW000 [ dev trc,00000] Register application info. 197 0.007506
4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.3.0, V1, default build, (dbsl 720 081211, UNICODE[2])
4 ETW000 102 0.007608
4 ETW000 [ dev trc,00000] Installed Oracle client patches: 25 0.007633
4 ETW000 [ dev trc,00000] # Patch 13508485 : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT
4 ETW000 15 0.007648
4 ETW000 [ dev trc,00000] # Patch Description: Created on 3 Jan 2012, 02:50:27 hrs PST8PDT 19 0.007667
4 ETW000 [ dev trc,00000] # Patch 11742262 : Created on 7 Mar 2012, 12:22:41 hrs CET 27 0.007694
4 ETW000 [ dev trc,00000] Default connection: tnsname ='DDT' 13 0.007707
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2
4 ETW000 21 0.007728
4 ETW000 [ dev trc,00000] (-) OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)
4 ETW000 3398 0.011126
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=2f5b1a8) 32 0.011158
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=2f5c438) 19 0.011177
4 ETW000 [ dev trc,00000] NLS env. settings: lang=41004D00450052004900430041004E00 65 0.011242
4 ETW000 [ dev trc,00000] terr=41004D0045005200490043004100 20 0.011262
4 ETW000 [ dev trc,00000] char=55005400460031003600 15 0.011277
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 18 0.011295
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 11 0.011306
4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPSR3's password 18 0.011324
4 ETW000 [ dev trc,00000] Connecting as /@DDT on connection 0 (nls 0) ... (dbsl 720 081211, UNICODE[2])
4 ETW000 22 0.011346
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=2f5c358) 19 0.011365
4 ETW000 [ dev trc,00000] Allocating server context handle 13 0.011378
4 ETW000 [ dev trc,00000] Attaching to database server DDT (con=0, svchp=2f5c358, srvhp=2f5f820)
4 ETW000 64 0.011442
4 ETW000 [ dev trc,00000] Assigning server context 2f5f820 to service context 2f5c358 14573 0.026015
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=2f9ddc0) 41 0.026056
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='/', svc=2f5c358, srv=2f5f820, usr=2f9ddc0)
4 ETW000 21 0.026077
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 3746 0.029823
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 84 0.029907
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 21 0.029928
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 17 0.029945
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 14 0.029959
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 12 0.029971
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 60 0.030031
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 17 0.030048
4 ETW000 [ dev trc,00000] Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.
4 ETW000 18 0.030066
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@DDT on connection 0 (nls 0) ... (dbsl 720 081211, UNICODE[2])
4 ETW000 18 0.030084
4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp= 2f9ddc0 12 0.030096
4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=2f9ddc0 21 0.030117
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=2f5c358, srv=2f5f820, usr=2f9ddc0)
4 ETW000 143 0.030260
4 ETW000 [ dev trc,00000] Mon Dec 10 16:13:10 2012 10004193 10.034453
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 43 10.034496
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 161 10.034657
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 42 10.034699
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 35 10.034734
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 26 10.034760
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 27 10.034787
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 140 10.034927
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 39 10.034966
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 59 10.035025
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 86 10.035111
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 30 10.035141
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DDT'"

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Note 134592 - Importing the SAPDBA role (sapdba_role.sql)

на всякий случай:
Note 700548 - FAQ: Oracle authorizations
Note 583861 - UNIX: Errors due to Oracle executable
Note 1617976 - Case sensitive logon with Oracle 11g

не помогает ничего.
При старте
startsap
Checking DDT Database
Database is not available via R3trans

от R3trans лог тот же, пишет что не может подключиться под SAPSR3, неверный логин пароль

Через SQLplus подключиться можно...
SQL> connect sapsr3/111111@DDT
Connected.

печаль...

я даже стесняюсь спросить - а что не помогает то?
нота "Note 400241 - Problems with ops$ or sapr3 connect to Oracle" исчерпывающе описывает всю работу OPS$-механизма авторизации, равно как и симптомы и решения проблем при этом возникающих.
в частности - Вам, нужен блок ORA-01017: invalid username/password; logon denied из этой ноты.


Да, при работе сугубо с JAVA-стэком, эта проверка проходить и не должна... проверять ее и настраивать в этом случае, бесполезно.

при добавлении REMOTE_OS_AUTHENT = TRUE в Initsid.ora при старте БД пишет что имеются устаревшие параметры

OPS$<os_user> - у меня пользователь отсутствует...

Подскажите кратко по шагам что делать...)

в ноте написано -
Log entries: Try to connect with default password
Connecting as <sapowner>/<pwd>@<sid> on connection 0
*** ERROR => OCI-call 'olog' failed: rc = 1017
*** ERROR => CONNECT failed with sql error '1017'

If you want to use the standard password "sap" and do not need the OPS$ mechanism, reset the <sapowner> password to "sap":

ALTER USER <sapowner> IDENTIFIED BY sap;

If you do not want to use the standard password, you cannot avoid the error at this stage. Instead, you must set up the OPS$ mechanism as described above.

If the error ORA-01017 occurs when you set up a secondary database connection, see Note 569302.

Да, я хочу использовать стандартный пароль.
Сделал: ALTER USER <sapowner> IDENTIFIED BY sap;
Connecting as <sapowner>/<pwd>@<sid> - нормально проходит
Что еще настроить чтоб R3trans заработал непойму)

иногда к этому нужно добавлять 2 волшебных слова - "account unlock", особенно для user system и sys

аккаунт не заблокирован, проверял..

какой аккаунт?

SAPSR3