We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

[sap-basis] CONNECT failed with sql error '12154'

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by basisgroup
on Apr 24 at 9:46 AM
Hi All,

I am installing NW7.0 with ehp2 on RHEL5 (x86_64). During the Start Instance phase of the installation it throws and error "Instance DPD/DVEBMGS00 reached state SHUTDOWN after having state STARTING. Giving up."

The dev_w0 log is given below. The status of R3trans is R3trans finished (0000). Both the database and listener are up and running.

---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "720"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
M sysno 00
M sid DPD
M systemid 390 (AMD/Intel x86_64 with Linux)
M relno 7200
M patchlevel 0
M patchno 46
M intno 20020600
M make single threaded, Unicode, 64 bit, optimized
M profile /usr/sap/DPD/SYS/profile/DPD_DVEBMGS00_engpth01
M pid 27913
M
M
M Sun Apr 24 06:11:03 2011
M kernel runs with dp version 125000(ext=118000) (@(#) DPLIB-INT-VERSION-125000-UC)
M length of sys_adm_ext is 588 bytes
M ThStart: taskhandler started
M ThInit: initializing DIA work process W0
M ***LOG Q01=> ThInit, WPStart (Workp. 0 1 27913) [thxxhead.c 1292]
M Sun Apr 24 06:11:05 2011
M DpTrcOnOff: switched trace level (1 -> 2)
*
* ACTIVE TRACE LEVEL 2
* ACTIVE TRACE COMPONENTS all, MJ
*
M ------------------ C-STACK ----------------------
(CTrcStack2+0x82)[0x6c7bf2]
(DpTrcOnOff+0x166)[0x4b591b]
/lib64/libpthread.so.0[0x3116e0e4c0]
/lib64/libc.so.6(times+0x7)[0x3116299247]
/lib64/libc.so.6(clock+0x1a)[0x311628aa3a]
(iRng_GetRealRandom+0x3c)[0x1d77f06]
(iRng_FillEntropyPool+0xa4)[0x1d7833a]
(Rng_PseudoRandomInit+0x4f)[0x1d77bcc]
(ThInit+0x789)[0x525cd9]
(ThStart+0x2cd)[0x52872d]
(DpMain+0x22c)[0x45775c]
/lib64/libc.so.6(__libc_start_main+0xf4)[0x311621d9 74]
M -------------------------------------------------
M Sun Apr 24 06:11:14 2011
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 = 5cb86a0
M ThInit: save spa pointer 2b7a7a86eb20
M ThInitCpicStack: init cpic stack
M ThInit: running on host engpth01
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_READ_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
--More--(34%)
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.
--More--(55%)
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 create_con (con_name=R/3)
B Loading DB library '/usr/sap/DPD/DVEBMGS00/exe/dboraslib.so' ...
M DlLoadLib() success: dlopen("/usr/sap/DPD/DVEBMGS00/exe/dboraslib.so&qu ot;), hdl 1
B Library '/usr/sap/DPD/DVEBMGS00/exe/dboraslib.so' loaded
B Version of '/usr/sap/DPD/DVEBMGS00/exe/dboraslib.so' is "720.00", patchlevel (0.34)
B New connection 0 created
C Oracle Client Version: 10.2.0.4.0, V5
C Installed Oracle patches:
C # Unique Patch ID: 12114073Created on 15 Jan 2010, 09:30:31 hrs PST8PDT
C # Patch 8732366 : Created on 27 Jul 2009, 15:49:18 hrs CEST
C # Patch 6944036 : Created on 3 Jun 2008, 23:35:37 hrs PST8PDT
C # Patch 6826661 : Created on 20 May 2008, 00:23:58 hrs PST8PDT
C # Patch 6775231 : Created on 2 Dec 2008, 21:45:40 hrs PST8PDT
C # Unique Patch ID: 12924916Created on 13 Sep 2010, 23:47:52 hrs PST8PDT
C application info callback registered
C Client NLS setting (OCINlsGetInfo): connection handle 0, 'AMERICAN_AMERICA.UTF8'
C Logon as OPS$-user to get SAPR3's password
C Connecting as /@DPD on connection 0 (nls_hdl 0) ... (dbsl 720 280110)
C Nls CharacterSet NationalCharSet Env Err ErrBt
C 0 UTF8 14bb6860 14bbe360 14bd0ae8
C Attaching to database server DPD (con=0, svchp=14bd0a18, srvhp=14bd2a68)
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'
--More--(79%)
[dbsloci.c 14350]
C SAPUSER or connect error 99=DBSL_ERR_DB, oerr=12154.
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 1461]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 11087]
M
M Info for wp 0
M
M pid = 27913
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 = -1
M req.rq_id = 65535
M req.rq_source =
M req.vm = no VM
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
--More--(92%)
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 = -1
M req.rq_id = 65535
M req.rq_source =
M req.vm = no VM
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 -1 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 779]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 303]
M ThCallHooks: hook >ThrSaveSPAFields< o.k.
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 27913) [dpuxtool.c 327]
M Good Bye (-1).....
[root@engpth01 work]#

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

Thanks.
__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
View this online
  
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language