Solved: ERROR last error reported by the step instance rea...

Former Member · ‎11-25-2014

Hi Gurus,

I'm facing a problem in a installation of SAP Netweaver 7.31 in phase 28 of 35 (Start Instance): Last error reported by the step instance reached state shutdown after having state starting.(Given UP).

There was already a development environment that machine and I am installing a quality environment. So I've done changes to files tnsnames.ora and listener.ora.

My swap is 131 gigas. I believe is not a page size problem.

The OS and DB installation is:

OS: Linux Rhel 6.X

DB: Oracle 11

Attached are the logs.

Thanks in advanced.

Former Member · ‎11-25-2014

I saw that the BWQADM user with the variable SHELL=/bin/bash.

The other user, BWDADM with the variable SHELL=/bin/csh.

This can be a problem?

Former Member · ‎11-25-2014

Hi,

Thanks for the help.

I added the parameter dbms/type = ora in the DEFAULT.PFL profile and tried to restart the step again. The error has now changed, I think this error is referring to the listener, I set them according to the note 98252 - Installing two Oracle database on the host.

Below the log dev_w0:

---------------------------------------------------

trc file: "dev_w0", trc level: 2, release: "720"

---------------------------------------------------

*

* ACTIVE TRACE LEVEL 2

* ACTIVE TRACE COMPONENTS all, MJ

*

M Tue Nov 25 14:53:28 2014

M

M command line arg 0: dw.sapBWQ_DVEBMGS06

M command line arg 1: pf=/usr/sap/BWQ/SYS/profile/BWQ_DVEBMGS06_sapdw02

M

M sysno 06

M sid BWQ

M systemid 390 (AMD/Intel x86_64 with Linux)

M relno 7200

M patchlevel 0

M patchno 117

M intno 20020600

M make single threaded, Unicode, 64 bit, optimized

M profile /usr/sap/BWQ/SYS/profile/BWQ_DVEBMGS06_sapdw02

M pid 5316

M

M kernel runs with dp version 133000(ext=118000) (@(#) DPLIB-INT-VERSION-133000-UC)

M length of sys_adm_ext is 588 bytes

M DpWpCreate: W0 started

M DpFreeResources(pid=5316)

M NiICloseHandle: shutdown and close hdl 1/sock 8

M DpDelSocketInfo: del info for nihdl 9 (pos/type=1/1)

M NiICloseHandle: shutdown and close hdl 9/sock 9 - sock 10

M clear adfunctable

M DpSlicFreeResources: free license server resources

M prctl(PR_SET_UNALIGN): generate SIGBUS on unaligned user access disabled.

M ThStart: th_step = TH_INIT

M ThStart: taskhandler started

M SemSetCb: set callbacks (tryLockCb/lockedCb/releasedCb/tryErrorCb=16af3d0/16af430/16af4a0/4de05b)

M SigIRegisterExitRoutine: exithandler installed (ThSigHandler)

M SigIRegisterRoutine: handler for signal SIGQUIT installed (ThSigIgnoreHandler)

M SigIRegisterRoutine: handler for signal SIGCHLD installed (SIG_DFL)

M ThrRegisterHooks: register basic hooks

M SosRegisterHook: add hook >ThrBtcStartUp(5d12c4)< (condition/order=0xf/1) for event AFTER_MSG_UP

M SosRegisterHook: add hook >ThrBtcStartUp(5d12c4)< (condition/order=0xf/1) for event AFTER_OPMODE_SWITCH

M SosRegisterHook: add hook >ThrtRaiseStopEvent(5cd10a)< (condition/order=0xf/1) for event SOFT_SHUTDOWN

M SosRegisterHook: add hook >ThrtFinishSoftShutdownTest(5cd0b4)< (condition/order=0xf/1) for event FINISH_SOFT_SHUTDOWN_TEST

M SosRegisterHook: add hook >ThrSaveSPAFields(5cdc2e)< (condition/order=0xf/1) for event BEFORE_DUMP

M SosRegisterHook: add hook >db_init(f7a76d)< (condition/order=0xf/1) for event CREATE_SHM

M SosRegisterHook: add hook >ThVBDbaRequired(16b77f0)< (condition/order=IF_ROLLED_IN/1) for event DB_ADMIN_REQUIRED

M SosRegisterHook: add hook >ThrRegisterSem(5ce0f6)< (condition/order=0xf/1) for event BEFORE_DB_CONNECT

M SosRegisterHook: add hook >ThrBtcCallLgCl(5d125a)< (condition/order=0xf/1) for event BEFORE_DUMP

M ThrRegisterHooks o.k.

M ThInit: initializing DIA work process W0

M eppSetEnvironment: set component = 1, version = 3, allocFunc = 52d8e2, freeFunc = 52ddbd, traceFunc = 52df5f, traceLevel = 2

M ThInit: ThEppInit o.k.

M

M ***LOG Q01=> ThInit, WPStart (Workp. 0 1 5316) [thxxhead.c 1321]

M

M ThSetTraceLevel: save trace level

M iRng_InitHighResTimer() : Use default timer = 0; Resolution of timer: 1000000000

M -----------------------------------------------------------

M Tue Nov 25 14:53:29 2014

M -----------------------------------------------------------

M Rng_PseudoRandomInit() : Initialization of the Pseudo-RNG (128/128/256)

M -----------------------------------------------------------

M NiHLFlush: cache flushed

M NiSrvLFlush: service cache flushed

M ThInit: dummy spa pointer = 62e7880

M ThInit: save spa pointer 7fb007cd51b0

M ThInitCpicStack: init cpic stack

M ThInit: running on host sapdw02

M ThPrivInit o.k.

M ThSysUsrCheck (1,1): check system user T0/U1/M0

M ThIEmFree: em state of T0/M0 (em_hdl=-1) is DP_EM_NO_CONTEXT

M ThSysUsrCheck: clear T0

M DpITmSlotClear: clear slot T0

M ThCallHooks: call hook >ThrRegisterSem< for event BEFORE_DB_CONNECT

M SosRegisterSem: malloc/realloc table

M SosRegisterSem: add sem >SEM_TM_ADM_KEY< for wptype 0x77

M SosRegisterSem: add sem >SEM_COMM_ADM_KEY< for wptype 0x77

M SosRegisterSem: add sem >SEM_STAT_KEY< for wptype 0x73

M SosRegisterSem: add sem >SEM_SHM_ADM_AREA_KEY< for wptype 0x73

M SosRegisterSem: add sem >SEM_REQ_QUEUE_KEY< for wptype 0x77

M SosRegisterSem: add sem >SEM_REQ_QUEUE_DIA_KEY< for wptype 0x77

M SosRegisterSem: add sem >SEM_REQ_QUEUE_NOWP_KEY< for wptype 0x77

M SosRegisterSem: add sem >SEM_MSBUF< for wptype 0x73

M SosRegisterSem: add sem >SEM_ASTAT_KEY< for wptype 0x73

M SosRegisterSem: add sem >SEM_PROFILE< for wptype 0x73

M SosRegisterSem: malloc/realloc table

M SosRegisterSem: add sem >SEM_THRUN_ADM< for wptype 0x73

M SosRegisterSem: add sem >SEM_VMC_ADM< for wptype 0x73

M SosRegisterSem: add sem >SEM_PXA_KEY< for wptype 0x73

M ThrRegisterSem: init SEM_PXA_KEY o.k.

M SosRegisterSem: add sem >SEM_ROLL_ADM_KEY< for wptype 0x73

M ThrRegisterSem: init SEM_ROLL_ADM_KEY o.k.

M SosRegisterSem: add sem >SEM_PAGING_KEY< for wptype 0x73

M ThrRegisterSem: init SEM_PAGING_KEY o.k.

M SosRegisterSem: add sem >SEM_CALI_BUFFER< for wptype 0x73

M ThrRegisterSem: init SEM_CALI_BUFFER o.k.

M SosRegisterSem: add sem >SEM_CCC_KEY< for wptype 0x73

M ThrRegisterSem: init SEM_CCC_KEY o.k.

M SosRegisterSem: add sem >SEM_VB_KEY< for wptype 0x73

M ThrRegisterSem: init SEM_VB_KEY o.k.

M SosRegisterSem: add sem >SEM_PRES_BUF< for wptype 0x73

M ThrRegisterSem: init SEM_PRES_BUF o.k.

M SosRegisterSem: add sem >SEM_DB_TBUFF< for wptype 0x73

M ThrRegisterSem: init SEM_DB_TBUFF o.k.

M SosRegisterSem: malloc/realloc table

M SosRegisterSem: add sem >SEM_DB_SYNC< for wptype 0x73

M ThrRegisterSem: init SEM_DB_SYNC o.k.

M SosRegisterSem: add sem >SEM_DB_TTAB< for wptype 0x73

M ThrRegisterSem: init SEM_DB_TTAB o.k.

M SosRegisterSem: add sem >SEM_DB_SNTAB< for wptype 0x73

M ThrRegisterSem: init SEM_DB_SNTAB o.k.

M SosRegisterSem: add sem >SEM_DB_IREC< for wptype 0x73

M ThrRegisterSem: init SEM_DB_IREC o.k.

M SosRegisterSem: add sem >SEM_DB_FTAB< for wptype 0x73

M ThrRegisterSem: init SEM_DB_FTAB o.k.

M SosRegisterSem: add sem >SEM_LOGFILE_KEY< for wptype 0x77

M ThrRegisterSem: init SEM_LOGFILE_KEY o.k.

M SosRegisterSem: add sem >SEM_DB_TBUFF_P< for wptype 0x73

M ThrRegisterSem: init SEM_DB_TBUFF_P o.k.

M SosRegisterSem: add sem >SEM_ENQ_REQ_KEY< for wptype 0x77

M ThrRegisterSem: init SEM_ENQ_REQ_KEY o.k.

M SosRegisterSem: add sem >SEM_ENQ_TABLE_KEY< for wptype 0x77

M ThrRegisterSem: init SEM_ENQ_TABLE_KEY o.k.

M SosRegisterSem: add sem >SEM_SAPCOM_1< for wptype 0x73

M ThrRegisterSem: init SEM_SAPCOM_1 o.k.

M SosRegisterSem: malloc/realloc table

M SosRegisterSem: add sem >SEM_SAPCOM_2< for wptype 0x73

M ThrRegisterSem: init SEM_SAPCOM_2 o.k.

M SosRegisterSem: add sem >SEM_VMS_FIXADR_KEY< for wptype 0x73

M ThrRegisterSem: init SEM_VMS_FIXADR_KEY o.k.

M SosRegisterSem: add sem >SEM_DB_CUA_BUFFER< for wptype 0x73

M ThrRegisterSem: init SEM_DB_CUA_BUFFER o.k.

M SosRegisterSem: add sem >SEM_RSPO_ADMIN< for wptype 0x73

M ThrRegisterSem: init SEM_RSPO_ADMIN o.k.

M SosRegisterSem: add sem >SEM_DB_OBJ_BUFFER< for wptype 0x73

M ThrRegisterSem: init SEM_DB_OBJ_BUFFER o.k.

M SosRegisterSem: add sem >SEM_CCMS_AS_MONI_KEY< for wptype 0x77

M ThrRegisterSem: init SEM_CCMS_AS_MONI_KEY o.k.

M SosRegisterSem: add sem >SEM_EG_ADM< for wptype 0x77

M ThrRegisterSem: init SEM_EG_ADM o.k.

M SosRegisterSem: add sem >SEM_STAT_BUF< for wptype 0x73

M ThrRegisterSem: init SEM_STAT_BUF o.k.

M SosRegisterSem: add sem >SEM_WP_ADM_KEY< for wptype 0x73

M ThrRegisterSem: init SEM_WP_ADM_KEY o.k.

M SosRegisterSem: add sem >SEM_RSPO_CACHE< for wptype 0x73

M ThrRegisterSem: init SEM_RSPO_CACHE o.k.

M SosRegisterSem: malloc/realloc table

M SosRegisterSem: add sem >SEM_AUDIT_SHM< for wptype 0x73

M ThrRegisterSem: init SEM_AUDIT_SHM o.k.

M SosRegisterSem: add sem >SEM_RSPO_RFC< for wptype 0x73

M ThrRegisterSem: init SEM_RSPO_RFC o.k.

M SosRegisterSem: add sem >SEM_AB_VMIT< for wptype 0x73

M ThrRegisterSem: init SEM_AB_VMIT o.k.

M SosRegisterSem: add sem >SEM_ENQID_KEY< for wptype 0x73

M ThrRegisterSem: init SEM_ENQID_KEY o.k.

M SosRegisterSem: add sem >SEM_ATRA_KEY< for wptype 0x73

M ThrRegisterSem: init SEM_ATRA_KEY o.k.

M SosRegisterSem: add sem >SEM_COV_KEY< for wptype 0x73

M ThrRegisterSem: init SEM_COV_KEY o.k.

M SosRegisterSem: add sem >SEM_ZDATE_TIMEINFO< for wptype 0x73

M ThrRegisterSem: init SEM_ZDATE_TIMEINFO o.k.

M SosRegisterSem: add sem >SEM_DB_OTR_BUFFER< for wptype 0x73

M ThrRegisterSem: init SEM_DB_OTR_BUFFER o.k.

M SosRegisterSem: add sem >SEM_DB_ESM_BUFFER< for wptype 0x73

M ThrRegisterSem: init SEM_DB_ESM_BUFFER o.k.

M SosRegisterSem: add sem >SEM_RTM_KEY< for wptype 0x73

M ThrRegisterSem: init SEM_RTM_KEY o.k.

M SosRegisterSem: malloc/realloc table

M SosRegisterSem: add sem >SEM_JAVA_1< for wptype 0x1

M ThrRegisterSem: init SEM_JAVA_1 o.k.

M SosRegisterSem: add sem >SEM_DBG_SESSION_BPS< for wptype 0x73

M ThrRegisterSem: init SEM_DBG_SESSION_BPS o.k.

M SosRegisterSem: add sem >SEM_HST_KEY< for wptype 0x73

M ThrRegisterSem: init SEM_HST_KEY o.k.

M ThCallHooks: hook >ThrRegisterSem< o.k.

M calling db_connect ...

B Loading DB library '/usr/sap/BWQ/DVEBMGS06/exe/dboraslib.so' ...

M DlLoadLib() success: dlopen("/usr/sap/BWQ/DVEBMGS06/exe/dboraslib.so"), hdl 0

B Library '/usr/sap/BWQ/DVEBMGS06/exe/dboraslib.so' loaded

B Version of '/usr/sap/BWQ/DVEBMGS06/exe/dboraslib.so' is "720.00", patchlevel (0.114)

B read_con_info_ssfs(): DBSL supports extended connect protocol

B ==> connect info for default DB will be read from ssfs

C Register application info.

C Oracle client version: 11.2.0.4.0, V2, default build, (dbsl 720 081211, UNICODE[2])

C Installed Oracle client patches:

C # Patch 12985200 : Created on 2 Jul 2014, 09:45:20 hrs PST8PDT

C # Patch 11742262 : Created on 6 Nov 2013, 15:22:08 hrs CET

C Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

C Connecting as SAPSR3/<pwd>@BWQ on connection 0 (nls 0) ... (dbsl 720 081211, UNICODE[2])

C Attaching to database server BWQ (con=0, svchp=692ca58, srvhp=6930250)

C Tue Nov 25 14:53:53 2014

C OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154:

C ORA-12154: TNS:could not resolve the connect identifier specified

C *** ERROR => CONNECT failed with sql error '12154'

[dbsloci.c 14533]

B ***LOG BV3=> severe db error 12154 ; work process is stopped [dbsh 1241]

B ***LOG BY2=> sql error 12154 performing CON [dblink 540]

B ***LOG BY0=> ORA-12154: TNS:could not resolve the connect identifier specified [dblink 540]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1490]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 11319]

M

M Info for wp 0

M

M pid = 5316

M severity = 0

M status = 0

M stat = WP_NEW

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M req.req_info =

M req.tid = -1

M req.uid = 4294967295

M req.mode = 255

M req.len = 0

M req.rq_id = 65535

M req.rq_source =

M last_tid = 0

M last_uid = 0

M last_mode = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M attachedVm = no VM

M

M ThIErrHandle: current request:

M

M -IN-- sender_id ? tid -1 wp_ca_blk -1 wp_id -1

M -IN-- action - uid -1 appc_ca_blk -1 type -

M -IN-- new_stat NO_CHANGE mode 255 len 0 rq_id -1

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 844]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 303]

M ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP

M ThCallHooks: hook >ThrBtcCallLgCl< o.k.

M ThIErrHandle: entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workp. 0 5316) [dpuxtool.c 327]

M Good Bye (-1).....

Former Member · ‎11-25-2014

Follow the dev_w0 log:

---------------------------------------------------

trc file: "dev_w0", trc level: 2, release: "720"

---------------------------------------------------

*

* ACTIVE TRACE LEVEL 2

* ACTIVE TRACE COMPONENTS all, MJ

*

M Tue Nov 25 13:55:20 2014

M

M command line arg 0: dw.sapBWQ_DVEBMGS06

M command line arg 1: pf=/usr/sap/BWQ/SYS/profile/BWQ_DVEBMGS06_sapdw02

M

M sysno 06

M sid BWQ

M systemid 390 (AMD/Intel x86_64 with Linux)

M relno 7200

M patchlevel 0

M patchno 117

M intno 20020600

M make single threaded, Unicode, 64 bit, optimized

M profile /usr/sap/BWQ/SYS/profile/BWQ_DVEBMGS06_sapdw02

M pid 16197

M

M kernel runs with dp version 133000(ext=118000) (@(#) DPLIB-INT-VERSION-133000-UC)

M length of sys_adm_ext is 588 bytes

M DpWpCreate: W0 started

M DpFreeResources(pid=16197)