Skip to Content
author's profile photo Former Member
Former Member

Error in PREP_EXTENSION/TR_CMDIMPORT_PREPARE phase

Hi,

I am installing techincal usage inusrance on ERP 6.06 on Linux/Oracle.

But i get the following error in PREP_EXTENSION/TR_CMDIMPORT_PREPARE phase of configuration roadmap.

Error message set: 'Calling '/usr/sap/ER6/SUM/abap/exe/tp' failed with return code 232,

check /usr/sap/ER6/SUM/abap/log/TP.ECO for details'

Ouput of TP.ECO is as follows

****************************************************

SAPup> Starting subprocess with PID 572 at 20120525052553

ENV: DIR_LIBRARY=/usr/sap/ER6/SUM/abap/exe

ENV: JAVA_HOME=/usr/sap/ER6/DVEBMGS11/exe/sapjvm_5

ENV: LD_LIBRARY_PATH=/usr/sap/ER6/SUM/abap/exe:/usr/sap/ER6/SUM/jvm/jre/lib/amd64/server:/usr/sap/ER6/SUM/jvm/jre/lib/amd64:/usr/sap/ER6/SUM/jvm/jre/../lib/amd64:/usr/sap/ER6/SYS/exe/run:/usr/sap/ER6/SYS/exe/uc/linuxx86_64:/oracle/client/11x_64/instantclient

ENV: NLS_LANG=AMERICAN_AMERICA.UTF8

ENV: ORACLE_BASE=/oracle

ENV: ORACLE_HOME=/oracle/ER6/112_64

ENV: ORACLE_SID=ER6

ENV: PATH=/usr/sap/ER6/SUM/abap/exe:/oracle/ER6/112_64/bin:/usr/sap/ER6/DVEBMGS11/exe/sapjvm_5/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/opt/nsr:/opt/gnome/bin:.:/usr/sap/ER6/SYS/exe/uc/linuxx86_64:/usr/sap/ER6/SYS/exe/run:/usr/sap/ER6/home

ENV: SAPDATA_HOME=/oracle/ER6

ENV: SAPSYSTEMNAME=ER6

ENV: auth_shadow_upgrade=0

ENV: dbms_type=ORA

ENV: dbs_ora_schema=SAPSR3

ENV: dbs_ora_tnsname=ER6

EXECUTING /usr/sap/ER6/SUM/abap/exe/tp (tp) pf=/usr/sap/ER6/SUM/abap/var/PCMDIMP.TPP cmd all ER6

This is tp version 380.03.82 (release 720, unicode enabled)

ERROR: Connect to ER6 failed (20120525052553, probably wrong environment).

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter INTERRUPT is no longer used.

Warning: unknown parameter DYNAMIC_PARAMETERS in parameter file (line 22).

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter INTERRUPT is no longer used.

Warning: unknown parameter DYNAMIC_PARAMETERS in parameter file (line 22).

Warning: Parameter DBCONFPATH is no longer used.

TRACE-INFO: 1: [ dev trc,00000] Fri May 25 05:25:53 2012 9664 0.009664

TRACE-INFO: 2: [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/ER6/SUM/abap/exe/dboraslib.so"), hdl 0 9 0.009673

TRACE-INFO: 3: [ dev trc,00000] -->DbSlConnect(vers=-1, type=0, env='[default env]', userid='[default usr]') 170 0.009843

TRACE-INFO: 4: [ dev trc,00000] Register application info. 262 0.010105

TRACE-INFO: 5: [ dev trc,00000] Oracle client version: 11.2.0.2.0, V1, default build, (dbsl 720 090112, UNICODE[2])

TRACE-INFO: 6: 156 0.010261

TRACE-INFO: 7: [ dev trc,00000] Installed Oracle client patches: 26 0.010287

TRACE-INFO: 8: [ dev trc,00000] # Patch 9930315 : Created on 15 Oct 2010, 03:55:06 hrs PST8PDT 12 0.010299

TRACE-INFO: 9: [ dev trc,00000] # Patch 10302309 : Created on 23 Nov 2010, 12:10:03 hrs CET 14 0.010313

TRACE-INFO: 10: [ dev trc,00000] Default connection: tnsname ='ER6' 10 0.010323

TRACE-INFO: 11: [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2 20 0.010343

TRACE-INFO: 12: [ dev trc,00000] ➖ OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle) 7997 0.018340

TRACE-INFO: 13: [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=2863f50) 27 0.018367

TRACE-INFO: 14: [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=2865ca0) 18 0.018385

TRACE-INFO: 15: [ dev trc,00000] NLS env. settings: lang=41004D00450052004900430041004E00 115 0.018500

TRACE-INFO: 16: [ dev trc,00000] terr=41004D0045005200490043004100 15 0.018515

TRACE-INFO: 17: [ dev trc,00000] char=55005400460031003600 13 0.018528

TRACE-INFO: 18: [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16' 12 0.018540

TRACE-INFO: 19: [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 12 0.018552

TRACE-INFO: 20: [ dev trc,00000] Logon as OPS$-user to get SAPSR3's password 23 0.018575

TRACE-INFO: 21: [ dev trc,00000] Connecting as /@ER6 on connection 0 (nls 0) ... (dbsl 720 090112, UNICODE[2])

TRACE-INFO: 22: 26 0.018601

TRACE-INFO: 23: [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=2863e70) 20 0.018621

TRACE-INFO: 24: [ dev trc,00000] Allocating server context handle 32 0.018653

TRACE-INFO: 25: [ dev trc,00000] Attaching to database server ER6 (con=0, svchp=2863e70, srvhp=28696a8) 29 0.018682

TRACE-INFO: 26: [ dev trc,00000] Assigning server context 28696a8 to service context 2863e70 18216 0.036898

TRACE-INFO: 27: [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=2898c28) 35 0.036933

TRACE-INFO: 28: [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='/', svc=2863e70, srv=28696a8, usr=2898c28)

TRACE-INFO: 29: 16 0.036949

TRACE-INFO: 30: [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 4149 0.041098

TRACE-INFO: 31: [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 257: 84 0.041182

TRACE-INFO: 32: [ dev trc,00000] ORA-00257: archiver error. Connect internal only, until freed.

TRACE-INFO: 33: 14 0.041196

TRACE-INFO: 34: [ dev trc,00000] server_detach(con=0,stale=1,srvhp=28696a8) 15 0.041211

TRACE-INFO: 35: [ dev trc,00000] Server handle (con=0,svchp=2863e70,srvhp=28696a8) detached 165 0.041376

TRACE-INFO: 36: [ dev trc,00000] Free server handle 28696a8 of con=0 11 0.041387

TRACE-INFO: 37: [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '257' 31 0.041418

TRACE-INFO: 38: [ dev trc,00000] set_ocica() -> SQL error code 257 13 0.041431

TRACE-INFO: 39: [ dev trc,00000] -->oci_get_errmsg (con=0, rc=257) 9 0.041440

TRACE-INFO: 40: [ dev trc,00000] OCIErrorGet -> SQL error code: 257 68 0.041508

TRACE-INFO: 41: [ dev trc,00000] ORA-00257: archiver error. Connect internal only, until freed.

TRACE-INFO: 42: 12 0.041520

TRACE-INFO: 43: [ dev trc,00000] SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=257. 13 0.041533

TRACE-INFO: 44: [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 11 0.041544

TRACE-INFO: 45: [ dblink ,00000] ***LOG BY2=>sql error 257 performing CON 40 0.041584

TRACE-INFO: 46: [ dblink ,00000] ***LOG BY0=>ORA-00257: archiver error. Connect internal only, until freed. 12 0.041596

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

tp finished with return code: 232

meaning:

connect failed

**********************************************************

Please help me here.

Thanks,

Nishitha

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jun 04, 2012 at 07:07 AM

    TRACE-INFO: 32: [ dev trc,00000] ORA-00257: archiver error. Connect internal only, until freed.

    indicating something wrong with oracle archival process.

    Maybe your archive directory is full /oracle/ER6/oraarch --> check if this location is full,

    In this case, extend its capacity a little then run brarchive to move them to your tape.

    If it is not full try investigate the oracle dump file(alert_ER6.log) for more error detail

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2012 at 02:35 PM

    Hi Nishitha,

    Please check the trans.log for error messages and also check if you're able to successfully execute the command R3trans -d (if not, post the error); also try updating the kernel to the latest level.

    Regards,

    Suresh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.