Netweaver 7.3 installation error while starting dispatcher

[Former Member]

Hi Experts

I am installing PI 7.3 on a distributive host Linux RHEL 5.7 & Oracle 11.2g

I have installed ASCS & SCS and DB instance and now i am installing CI while installing CI its stuck while starting dispatcher

Please see the below logs

dev_disp trace

pTraceWpStatus: child (pid=9939) exited with exit code 255

DpUnlockWpAdm: force unlock of wp_adm mutex W12

DpProcFreeBlks: free blocks for WORK_PROCESS (pid=9939; flags=3)

DpListRemove: remove elem 12 from wpadm_btc_list

DpListRemove: 0 elems in wpadm_btc_list

DpListRemove: elem 12 not in wpadm_free_btc_list

DpHdlDeadWp: handling of W12 o.k.

DpGetMsgTypes: my types = MS_DIA,MS_VB,MS_BTC,MS_SPO,MS_VB2,MS_ICMAN

DpGetMsgTypes: my types = MS_DIA,MS_VB,MS_BTC,MS_SPO,MS_VB2,MS_ICMAN

DpGetMsgTypes: my types = MS_DIA,MS_VB,MS_BTC,MS_SPO,MS_VB2,MS_ICMAN

DpGetMsgTypes: my types = MS_DIA,MS_VB,MS_BTC,MS_SPO,MS_VB2,MS_ICMAN

• DP_FATAL_ERROR => DpWPCheck: no more work processes

• DISPATCHER EMERGENCY SHUTDOWN

dev_w0 trace

• ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

[dbcon.c 5081]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 008192)

I already have a dbms_type=ORA set , R3trans -D works fine .

i have checked many posts here but its not helping me .

I have restarted the server and done the cleanipc as well

Any help will be much appreciated.

Thanks

dEE

[Former Member]

ORA-12154:

TNS:could not resolve the connect identifier specified

Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached.

Action:

- If you are using local naming (TNSNAMES.ORA file):

- Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)

- Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible.

- Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file.

- Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable.

- If you are using directory naming:

- Verify that "LDAP" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).

- Verify that the LDAP directory server is up and that it is accessible.

- Verify that the net service name or database name used as the connect identifier is configured in the directory.

- Verify that the default context being used is correct by specifying a fully qualified net service name or a full LDAP DN as the connect identifier

- If you are using easy connect naming:

- Verify that "EZCONNECT" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).

- Make sure the host, port and service name specified are correct.

- Try enclosing the connect identifier in quote marks. See the Oracle Net Services Administrators Guide or the Oracle operating system specific guide for more information on naming.

[Former Member]

its hard to believe but i scrapped the install and tried it again but again struck with the same error , now i doubt the media i am using 51039309 & 51041560

[Former Member]

Solution : user <sid>adm default shell was Bash instead of csh

copy the env for csh to bash .and it worked fine.

Thanks everyone for their inputs.

Edited by: Deep Kwatra on Aug 30, 2011 12:46 AM

[sunny_pahuja2]

Hi,

Please paste dev_w0 and dev_ms logs.

Thanks

Sunny

[Former Member]

After adding dbms/type=ora in the profile , i am getting a different error now.

tnsnames.ora looks good also r3 trans working fine , working with DBA to resolve this.

dev_w0

B Loading DB library '/usr/sap/NPD/DVEBMGS02/exe/dboraslib.so' ...

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

B Library '/usr/sap/NPD/DVEBMGS02/exe/dboraslib.so' loaded

B Version of '/usr/sap/NPD/DVEBMGS02/exe/dboraslib.so' is "720.00", patchlevel (0.64)

C Oracle Client Version: 10.2.0.4.0, V5

C Installed Oracle client 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 Wed Aug 24 12:48:43 2011

C Client NLS setting (OCINlsGetInfo): connection handle 0, 'AMERICAN_AMERICA.UTF8'

C Logon as OPS$-user to get SAPR3's password

C Connecting as /@NPD on connection 0 (nls_hdl 0) ... (dbsl 720 140910)

C Nls CharacterSet NationalCharSet Env Err ErrBt

C 0 UTF8 90b7410 90bef10 90d1698

C Attaching to database server NPD (con=0, svchp=90d15c8, srvhp=90d3d68)

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 14329]

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 1474]

[Former Member]

tnsnames.ora

1. @(#) $Id: //bas/720_REL/src/krn/tpls/ora/TNSNAMES.ORA#1 $

################

NPD.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = dvhals31)

(PORT = 1526)

)

)

(CONNECT_DATA =

(SID = NPD)

(GLOBAL_NAME = NPD.WORLD)

)

)

Environment variables

dbs_ora_tnsname=NPD

LD_LIBRARY_PATH=/usr/sap/NPD/SYS/exe/run:/usr/sap/NPD/SYS/exe/uc/linuxx86_64:/oracle/client/10x_64/instantclient

ORACLE_BASE=/oracle

dbs_ora_schema=SAPSR3

TNS_ADMIN=/usr/sap/NPD/SYS/profile/oracle

PWD=/usr/sap/NPD/SYS/profile/oracle

SAPDATA_HOME=/oracle/NPD

[sunny_pahuja2]

Hi,

It seems like issue is with tns or listener settings. I saw you are using port 1526. Could you please check if same port is there in tnsnames file in oracle folder under profile directory.

Also run tnsping command, check if it gives you some error.

Thanks

Sunny

[Former Member]

i am doing a distributive installation .

tnsnames.ora listner & sqlnet.ora seems fine . TNS ping works fine in database host

R3trans -D also works fine from CI.

[sunny_pahuja2]

Hi,

Since your error is related to listener, I would suggest you to check all scenario as per SAP note 443867.

Thanks

Sunny

[Former Member]

yeah i have looked at this note and subsequent notes in it but its not really helping in solving my problem ?