Skip to Content
0
Former Member
Apr 11, 2014 at 11:30 AM

NOT ABLE TO CONNECT TO DATABASE with R3trans -d

1449 Views

HI SAP Gurus,

We have recovered our BW quality system from backup of production system.

Database is restored and recovered. We are able to open database:

We have performed OPS$ schema conversion with below queries:

1)CREATE USER "OPS$TBWADM" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;

2)GRANT SAPDBA,CONNECT,RESOURCE to OPS$TBWADM

3)SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'OPS$TBWADM';

4)CREATE USER "OPS$ORATBW" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;

5)GRANT SAPDBA,CONNECT,RESOURCE to OPS$ORATBW

6)SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'OPS$ORATBW';

7)SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

8)CREATE TABLE OPS$TBWADM.SAPUSER (USERID VARCHAR2(255), PASSWD VARCHAR2(255));

9)INSERT INTO OPS$TBWAADM.SAPUSER VALUES ('SAPPBW', 'london123');

10)CREATE TABLE OPS$ORATBW.SAPUSER (USERID VARCHAR2(255), PASSWD VARCHAR2(255));

11)INSERT INTO OPS$ORATBW.SAPUSER VALUES ('SAPPBW', 'london123');


I am able to connect to database with users OPS$TBWADM and OPS$ORATBW with password london123

I am also able to connect to DB with SAPPBW with password london123.


When I am giving R3trans -d from tbwadm i am getting below error:


This is R3trans version 6.23 (release 720 - 27.03.12 - 17:30:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TBW'"

R3trans finished (0012).

Trans.log files says:

4 ETW000 [ dev trc,00000] Connecting as SAPTBW/<pwd>@TBW on connection 0 (nls_hdl 0) ... (dbsl 720 140910)

4 ETW000 66 0.131040

4 ETW000 [ dev trc,00000] Nls CharacterSet NationalCharSet Env Err ErrBt

4 ETW000 69 0.131109

4 ETW000 [ dev trc,00000] 0 UTF8 102ba7eb0 102bb32c8 102bd8188

4 ETW000 69 0.131178

4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp= 102c297d0 43 0.131221

4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=102c297d0 50 0.131271

4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='SAPTBW', svc=102bb31e8, srv=102bda330, usr=102c297d0)

4 ETW000 498 0.131769

4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 5132 0.136901

4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 149 0.137050

4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 74 0.137124

4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 53 0.137177

4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 41 0.137218

4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 43 0.137261

4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 109 0.137370

4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 66 0.137436

4 ETW000 [ dev trc,00000] DbSlConnect(con=-1) -> orc=0, 99=DBSL_ERR_DB 46 0.137482

4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 189 0.137671

4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 52 0.137723

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TBW'"

It is trying to connect to SAPTBW where as for a BW system schema is SAPPBW. SAPTBW is not at all present in dba_users view.

Kindly advice me on this..please let me know if any further logs are required.

Thanks,

Avadhesh

+91 8095226536