R3trans error with code 0012 and its Solution

[Former Member]

After system refresh i got following error from Quality system while running R3trans -d

This is R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE

--- dbs_ora_tnsname = 'QUA'"

R3trans finished (0012).

[Former Member · Accepted solution]

Hi,

4 ETW000 http://dbsloci. ,00000 *** ERROR => CONNECT failed with sql error '28000'

SAPR3 is locked at oracle level, unlock it.

sqlplus /nolog

ALTER USER SAPR3 ACCOUNT UNLOCK;

Also follow SAP note 951167 for account lock out.

Regards,

Sachin Rane.

Edited by: Sachin Rane on Mar 23, 2009 7:49 AM

[Former Member]

@Sachin n Rohit

Thax

[Former Member]

I googled a lot and found many reasons likely reasons for it,

1)listener is down

2)SAPR3 or OPS$SIDADM users are locked.

3)SAPR3 password expired.

4)SAP3 password not updated in OPS$SIDADM.SAPUSER table

5)tnsnames.ora may not been updated.

I checked all the above reasons but all was OK

Finally the real problem was with script utlpwdmg.ora found in e:\oracle\ora92\RDBMS\ADMIN folder.

This script is used for imposing restictions on password for users SAPR3 ans subsequently on OPS$

user.Due to restrictions i was able to change passsword for SAPr3 but it was not reflecting in OPS$SIDADM.SAPUSER table.

Solution:

In file utlpwdmg.sql update following,

PASSWORD_VERIFY_FUNCTION Verify;

to PASSWORD_VERIFY_FUNCTION NULL;

Due to this the problem was solved though password restiction has been disabled.

[Former Member]

Trans Logs are,

4 ETW000 [developertra,00000] Got ORACLE_SID=QUA from environment 49921 55.681220

4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

4 ETW000 10732 55.691952

4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPR3's password 6065 55.698017

4 ETW000 [developertra,00000] Connecting as /@QUAon connection 0 ... 5661 55.703678

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='QUA') 5874 55.709552

4 ETW000 [developertra,00000] Now I'm connected to ORACLE 11073827 66.783379

4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1403 when accessing table SAPUSER

4 ETW000 523513 67.306892

4 ETW000 [developertra,00000] Disconnecting from connection 0 ... 5926 67.312818

4 ETW000 [developertra,00000] -->oci_logoff(con_hdl=0) 5316 67.318134

4 ETW000 [developertra,00000] Now I'm disconnected from ORACLE 426449 67.744583

4 ETW000 [developertra,00000] Try to connect with default password 7185 67.751768

4 ETW000 [developertra,00000] Connecting as SAPR3/<pwd>@QUA on connection 0 ...

4 ETW000 8873 67.760641

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='SAPR3', dbname='QUA')

4 ETW000 8634 67.769275

4 ETW000 [dbsloci. ,00000] *** ERROR => OCI-call 'olog' failed: rc = 28000 10999248 78.768523

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

4 ETW000 12028 78.780551

4 ETW000 [dblink ,00627] ***LOG BY2=>sql error 28000 performing CON 12525 78.793076

4 ETW000 [dblink ,00627] ***LOG BY0=> 5373 78.798449

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

[Former Member]

Hello Ganesh

Check the value of profile parameter dbs_ora_schema.

I think it is wrongly set

Also refer to notes 534765 and 400241

They will be useful to you for getting this error resloved

Rohit