on 09-17-2013 4:35 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marvin,
Have a look at Note 1055400 - Oracle 10.2.0.2: Work processes terminate on Windows 2003
It might help.
Regards,
Hugo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.