cancel
Showing results for 
Search instead for 
Did you mean: 

R3trans -d finished with return code <0012>

Former Member
0 Kudos

Dear Gurus,

i tried to activating my Process integration Server, i have startup the DB ( using oracle 10g ) and when i check with r3trans -d i got return code 0012.

what should i do ?

this is the trans.log :

4 ETW000 r3trans version 6.14 (release 700 - 09.04.10 - 11:26:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 17.09.2013 - 15:57:26

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]  Tue Sep 17 15:57:30 2013                                                   0  0.000000

4 ETW000  [dev trc     ,00000]  db_con_init called                                                         0  0.000000

4 ETW000  [dev trc     ,00000]  create_con (con_name=R/3)                                                  0  0.000000

4 ETW000  [dev trc     ,00000]  Loading DB library 'dboraslib.dll' ...                                     0  0.000000

4 ETW000  [dev trc     ,00000]  DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 00000001889D0000

4 ETW000                                                                                                1018  0.001018

4 ETW000  [dev trc     ,00000]      using "D:\usr\sap\PIP\SYS\exe\uc\NTAMD64\dboraslib.dll"                9  0.001027

4 ETW000  [dev trc     ,00000]  Library 'dboraslib.dll' loaded                                            10  0.001037

4 ETW000  [dev trc     ,00000]  function DbSlExpFuns loaded from library dboraslib.dll                    12  0.001049

4 ETW000  [dev trc     ,00000]  Version of 'dboraslib.dll' is "700.08", patchlevel (0.244)               126  0.001175

4 ETW000  [dev trc     ,00000]  function dsql_db_init loaded from library dboraslib.dll                   14  0.001189

4 ETW000  [dev trc     ,00000]  function dbdd_exp_funs loaded from library dboraslib.dll                  15  0.001204

4 ETW000  [dev trc     ,00000]  New connection 0 created                                                  16  0.001220

4 ETW000  [dev trc     ,00000]  000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                                                  26  0.001246

4 ETW000  [dev trc     ,00000]  db_con_connect (con_name=R/3)                                             12  0.001258

4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection for reuse:                10  0.001268

4 ETW000  [dev trc     ,00000]  000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                                                  25  0.001293

4 ETW000  [dev trc     ,00000]  Prepending E:\oracle\PIP\102_64 to Path.                                 133  0.001426

4 ETW000  [dev trc     ,00000]  -->oci_init1                                                              51  0.001477

4 ETW000  [dev trc     ,00000]  Oracle Client Version: '10.2.0.4.0'                                     4983  0.006460

4 ETW000  [dev trc     ,00000]    Default connection: tnsname ='PIP'                                      16  0.006476

4 ETW000  [dev trc     ,00000]  -->oci_initialize(con_hdl=0, char='', nchar='')                           12  0.006488

4 ETW000  [dev trc     ,00000]  application info callback registered                                      10  0.006498

4 ETW000  [dev trc     ,00000]  OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000                                                                                                1352  0.007850

4 ETW000  [dev trc     ,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrHp=00000000000F16F0)

4 ETW000                                                                                                  35  0.007885

4 ETW000  [dev trc     ,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrBt=0000000000105DE8)

4 ETW000                                                                                                  77  0.007962

4 ETW000  [dev trc     ,00000]  Client character set UTF16 -> UTF8                                       104  0.008066

4 ETW000  [dev trc     ,00000]  Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

4 ETW000                                                                                                  20  0.008086

4 ETW000  [dev trc     ,00000]  charset='', chset='UTF8', UNI_ASC=FALSE/FALSE                             10  0.008096

4 ETW000  [dev trc     ,00000]  Logon as OPS$-user to get SAPSR3's password                               10  0.008106

4 ETW000  [dev trc     ,00000]  Connecting as /@PIP on connection 0 (nls_hdl 0) ... (dbsl 700 280110)

4 ETW000                                                                                                  17  0.008123

4 ETW000  [dev trc     ,00000]  Nls CharacterSet                 NationalCharSet                   EnvHp      ErrHp ErrHpBatch

4 ETW000                                                                                                  28  0.008151

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      00000000000E9C00 00000000000F16F0 0000000000105DE8

4 ETW000                                                                                                  30  0.008181

4 ETW000  [dev trc     ,00000]  Allocating service context handle for con_hdl=0                           19  0.008200

4 ETW000  [dev trc     ,00000]  Allocating server context handle                                          14  0.008214

4 ETW000  [dev trc     ,00000]  Attaching to DB Server PIP (con_hdl=0,svchp=0000000000105CA8,srvhp=0000000000108068)

4 ETW000                                                                                                  33  0.008247

4 ETW000  [dev trc     ,00000]  Tue Sep 17 15:58:34 2013                                             64253501  64.261748

4 ETW000  [dev trc     ,00000]     OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR                  28  64.261776

4 ETW000  [dev trc     ,00000]     OCIServerAttach(OCI_DEFAULT) failed with SQL error 12637:              53  64.261829

4 ETW000  [dev trc     ,00000]     ORA-12637: Packet receive failed                                                                                         

4 ETW000                                                                                                  18  64.261847

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

4 ETW000  [dev trc     ,00000]     set_ocica() -> SQL error code 12637                                    12  64.261878

4 ETW000  [dev trc     ,00000]  -->oci_get_errmsg (con_hdl=0, rc=12637)                                   12  64.261890

4 ETW000  [dev trc     ,00000]     OCIErrorGet -> SQL error code: 12637                                   29  64.261919

4 ETW000  [dev trc     ,00000]     ORA-12637: Packet receive failed                                                                                         

4 ETW000                                                                                                  20  64.261939

4 ETW000  [dev trc     ,00000]  SAPUSER or connect error 99=DBSL_ERR_DB, oerr=12637.                      14  64.261953

4 ETW000  [dblink      ,00433]  ***LOG BY2=>sql error 12637  performing CON [dblink#8 @ 433]              49  64.262002

4 ETW000  [dblink      ,00433]  ***LOG BY0=>ORA-12637: Packet receive failed [dblink#8 @ 433]             14  64.262016

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

please help me into this

thankyou.

best regards,

marvin

Accepted Solutions (1)

Accepted Solutions (1)

former_member235680
Active Participant
0 Kudos

Hi Marvin,

From your error logs, I can see that error ORA-12637: Packet receive failed is coming.

Please have a look on SAP Note below. Hope this will help you to solve your problem..

Note 1055400 - Oracle 10.2.0.2: Work processes terminate on Windows 2003

Thanks

Abhi

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi Marvin,

     This could be a problem with the OPS$ parameter.. Please check setting for the same .

Also check listener and the size of the SGA and whether the memory parameters are set based on SAP note 830576.

Regards

Sandy Sam

Former Member
0 Kudos

We had a similar problem once (R3trans unable to connect to database) which we fixed by installing a new version of the Oracle client on the server.  May not be the same issue but worth trying if all else fails.

Regards, Chris

Former Member
0 Kudos

Check and make sure..Oracle is running fine.

hugo_amo
Employee
Employee
0 Kudos

Hi Marvin,

Have a look at Note 1055400 - Oracle 10.2.0.2: Work processes terminate on Windows 2003

It might help.

Regards,

Hugo

naveegarg
Explorer
0 Kudos

Hi Marvin,

Please restart your Database and listener and then try connecting R3trans -d. This is due to packet not being received

Regards

Naveen Garg

former_member182921
Participant
0 Kudos

Hi Marvin,

Please check your Oracle alert.log if the database was completely started.

/oracle/SID/saptrace/background/alert_SID.log

Also have a look at shared memory....run cleanipc command to release shared memory.

cleanipc instanceno remove