R3trans Error

[Former Member]

Hi All

When i tried to start sap the database was failed and when i ran R3trans -x it says

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

R3trans finished (0012).

Following is the output of trans.log

4 ETW000 R3trans version 6.05 (release 46D - 07.09.04 - 10:30:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 date&time : 09.03.2010 - 16:02:05

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [developertra,00000] Tue Mar 9 16:02:05 2010 186 0.000186

4 ETW000 [developertra,00000] db_con_init called 21 0.000207

4 ETW000 [developertra,00000] create_con (con_name=R/3) 43 0.000250

4 ETW000 [developertra,00000] Loading DB library '/usr/sap/ED1/SYS/exe/run/dboraslib.so' ...

4 ETW000 45 0.000295

4 ETW000 [developertra,00000] load shared library (/usr/sap/ED1/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 14040 0.014335

4 ETW000 [developertra,00000] Library '/usr/sap/ED1/SYS/exe/run/dboraslib.so' loaded

4 ETW000 17 0.014352

4 ETW000 [developertra,00000] function DbSlExpFuns loaded from library /usr/sap/ED1/SYS/exe/run/dboraslib.so

4 ETW000 27 0.014379

4 ETW000 [developertra,00000] Version of library '/usr/sap/ED1/SYS/exe/run/dboraslib.so' is "46D.00", patchlevel (0.1685)

4 ETW000 111 0.014490

4 ETW000 [developertra,00000] function dsql_db_init loaded from library /usr/sap/ED1/SYS/exe/run/dboraslib.so

4 ETW000 21 0.014511

4 ETW000 [developertra,00000] function dbdd_exp_funs loaded from library /usr/sap/ED1/SYS/exe/run/dboraslib.so

4 ETW000 30 0.014541

4 ETW000 [developertra,00000] New connection 0 created 19 0.014560

4 ETW000 [developertra,00000] db_con_connect (con_name=R/3) 37 0.014597

4 ETW000 [developertra,00000] find_con found the following connection for reuse:

4 ETW000 16 0.014613

4 ETW000 [developertra,00000] Got ORACLE_HOME=/oracle/ED1/920_64 from environment

4 ETW000 258 0.014871

4 ETW000 [developertra,00000] -->oci_initialize 34 0.014905

4 ETW000 [developertra,00000] Got ORACLE_SID=ED1 from environment 14 0.014919

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

4 ETW000 17 0.014936

4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPED1's password 11 0.014947

4 ETW000 [developertra,00000] Connecting as /@ED1 on connection 0 ... 23 0.014970

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='ED1') 32 0.015002

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 1019 1001 0.016003

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

4 ETW000 21 0.016024

4 ETW000 [developertra,00000] Try to connect with default password 11 0.016035

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

4 ETW000 16 0.016051

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

4 ETW000 16 0.016067

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12705 44017 0.060084

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

4 ETW000 44 0.060128

4 ETW000 [developertra,00000] Got ORACLE_SID=ED1 from environment 64 0.060192

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

4 ETW000 18 0.060210

4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPED1's password 12 0.060222

4 ETW000 [developertra,00000] Connecting as /@ED1 on connection 0 ... 11 0.060233

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='ED1') 11 0.060244

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12705 44294 0.104538

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

4 ETW000 29 0.104567

4 ETW000 [developertra,00000] Try to connect with default password 12 0.104579

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

4 ETW000 17 0.104596

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

4 ETW000 16 0.104612

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12705 39779 0.144391

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

4 ETW000 33 0.144424

4 ETW000 [dblink ,00627] ***LOG BY2=>sql error 12705 performing CON 60 0.144484

4 ETW000 [dblink ,00627] ***LOG BY0=> 11 0.144495

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

Kindly suggest what could have gone wrong.

Thanks in Advance

Arun

[JPReyes]

You have a problem with your NLS settings

Read,

Note 121004 - ORA-1019 for Connect to an Oracle database

Note 592657 - ORA-12701/ORA-12705/ORA-12709

Regards

Juan