2EETW169 no connect possible: "DBMS = ORACLE

[former_member526245]

Unable to start database :

error :Database is not available via R3 trans.

IQAS:xiqadm 45> startsap r3 Checking XIQ Database ------------------------------ ABAP Database is not available via R3trans Starting SAP-Collector Daemon ------------------------------ Start of saposcol failed ABAP Database XIQ must be started first XIQAS:xiqadm 46> R3trans -d This is R3trans version 6.14 (release 700 - 28.07.08 - 15:52:00). unicode enabled version 2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'XIQ'" R3trans finished (0012).

Listner and db is running...

trans.log as fllow

4 ETW000 R3trans version 6.14 (release 700 - 28.07.08 - 15:52:00). 4 ETW000 unicode enabled version 4 ETW000 =============================================== 4 ETW000 4 ETW000 date&time : 14.08.2019 - 17:38:56 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] Wed Aug 14 17:38:56 2019 254 0.000254 4 ETW000 [dev trc ,00000] db_con_init called 38 0.000292 4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 127 0.000419 4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/XIQ/SYS/exe/run/dboraslib.so' ... 4 ETW000 72 0.000491 4 ETW000 [dev trc ,00000] load shared library (/usr/sap/XIQ/SYS/exe/run/dboraslib.so), hdl 0 4 ETW000 36252 0.036743 4 ETW000 [dev trc ,00000] Library '/usr/sap/XIQ/SYS/exe/run/dboraslib.so' loaded 4 ETW000 48 0.036791 4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/XIQ/SYS/exe/run/dboraslib.so 4 ETW000 86 0.036877 4 ETW000 [dev trc ,00000] Version of '/usr/sap/XIQ/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.167) 4 ETW000 254 0.037131 4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/XIQ/SYS/exe/run/dboraslib.so 4 ETW000 53 0.037184 4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/XIQ/SYS/exe/run/dboraslib.so 4 ETW000 83 0.037267 4 ETW000 [dev trc ,00000] New connection 0 created 54 0.037321 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 81 0.037402 4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 61 0.037463 4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 4 ETW000 44 0.037507 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 48 0.037555 4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.5.0' 570 0.038125 4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 32 0.038157 4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 7918 0.046075 4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 68 0.046143 4 ETW000 [dev trc ,00000] Connecting as /@XIQ on connection 0 (nls_hdl 0) ... (dbsl 700 030508) 4 ETW000 46 0.046189 4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch 4 ETW000 70 0.046259 4 ETW000 [dev trc ,00000] 0 UTF8 1 0x600000000103f4b0 0x6000000001047698 0x6000000001081918 4 ETW000 50 0.046309 4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 50 0.046359 4 ETW000 [dev trc ,00000] Allocating server context handle 42 0.046401 4 ETW000 [dev trc ,00000] Attaching to DB Server XIQ (con_hdl=0,svchp=0x60000000010475c8,srvhp=0x6000000001083b58) 4 ETW000 142 0.046543 4 ETW000 [dev trc ,00000] Assigning server context 0x6000000001083b58 to service context 0x60000000010475c8 4 ETW000 82712 0.129255 4 ETW000 [dev trc ,00000] Allocating user session handle 97 0.129352 4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x60000000010475c8,srvhp=0x6000000001083b58,usrhp=0x60000000011080e0) 4 ETW000 97 0.129449 4 ETW000 [dev trc ,00000] Assigning user session 0x60000000011080e0 to service context 0x60000000010475c8 4 ETW000 11228 0.140677 4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=0x600000000108d0f0) 4 ETW000 186 0.140863 4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END; 4 ETW000 54 0.140917 4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=0x600000000108e148) 4 ETW000 582 0.141499 4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END; 4 ETW000 114 0.141613 4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x600000000108b010) 4 ETW000 1735 0.143348 4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2 4 ETW000 102 0.143450 4 ETW000 [dev trc ,00000] Connected to session 281. 1086 0.144536 4 ETW000 [dev trc ,00000] Now '/@XIQ' is connected: con_hdl=0, nls_hdl=0, session_id=281. 4 ETW000 49 0.144585 4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x600000000108b010) 4 ETW000 48 0.144633 4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY 4 ETW000 46 0.144679 4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x600000000108b010) 4 ETW000 341 0.145020 4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1) 4 ETW000 46 0.145066 4 ETW000 [dev trc ,00000] Got SAPSR3's password from OPS$-user 665 0.145731 4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 32 0.145763 4 ETW000 [dev trc ,00000] Rolling back transaction ... 41 0.145804 4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x60000000010475c8,usrhp=0x60000000011080e0) 4 ETW000 243 0.146047 4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 647 0.146694 4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@XIQ on connection 0 (nls_hdl 0) ... (dbsl 700 030508) 4 ETW000 49 0.146743 4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch 4 ETW000 49 0.146792 4 ETW000 [dev trc ,00000] 0 UTF8 1 0x600000000103f4b0 0x6000000001047698 0x6000000001081918 4 ETW000 49 0.146841 4 ETW000 [dev trc ,00000] Assigning username to user session 0x60000000011080e0 4 ETW000 43 0.146884 4 ETW000 [dev trc ,00000] Assigning password to user session 0x60000000011080e0 4 ETW000 51 0.146935 4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x60000000010475c8,srvhp=0x6000000001083b58,usrhp=0x60000000011080e0) 4 ETW000 756 0.147691 4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=28001 4 ETW000 3632 0.151323 4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x6000000001083b58) 4 ETW000 45 0.151368 4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x60000000010475c8,srvhp=0x6000000001083b58) 4 ETW000 48 0.151416 4 ETW000 [dev trc ,00000] Deallocating server context handle 0x6000000001083b58 4 ETW000 783 0.152199 4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '28001' 4 ETW000 74 0.152273 4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 28001 36 0.152309 4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 28001 performing CON [dblink#5 @ 431] 4 ETW000 399 0.152708 4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-28001: the password has expired [dblink#5 @ 431] 4 ETW000 115 0.152823 2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'XIQ'"

Iam unable to find the solution please help...

[dennispadia]

Hello,

In the last part of your log, it states that the password has been expired. So you need to change the password of your database user.

ORA-28001: the password has expired

Check the database owner with the following statement

SELECT owner FROM dba_tables WHERE table_name='T000';

Use of below statement will not change the password in SAPUSER table and you will face another error

ALTER USER <username> IDENTIFIED BY <new_password>;

So you should update password using brconnect

brconnect -u system/<password> -f chpass -o <username> -p <password>

Regards,

Dennis

[former_member526245]

ok, has been solution this issue ,thanks

[former_member526245]

sorry i didn't remember my system password.

so can you tell me how can i using brconnect step by step

[dennispadia]

Hello,

You can follow below link to reset password.

Changing the Passwords of the SAP ABAP Schema

Regards,

Dennis