Application Server installation, no connect to database

[Former Member]

Hello.

We are trying to install an Application Server for a 4.7 R/3 on a second node , Windows 2003 , Oracle database.

The SAPINST doesn't install the kernel locally on the new node, but locates it on the node where the Central Instance is running. Same for the Oracle client.

At the end the start of the new instance fails.

Although we put the remote network path of the Oracle client in the sidadm environment , the R3trans -x check reports error code 12 and the following error:

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 705503 0.759896

4 ETW000 [dev trc ,00000] Got TNS_ADMIN=
LUCSAPP2\sapmnt\CHP\SYS\profile\oracle from environment

4 ETW000 113 0.760009

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 11 0.760020

4 ETW000 [dev trc ,00000] Connecting as /@CHP on connection 0 ... 9 0.760029

4 ETW000 [dev trc ,00000] Allocating service context handle 1715 0.761744

4 ETW000 [dev trc ,00000] Allocating server context handle 25 0.761769

4 ETW000 [dev trc ,00000] Attaching to DB Server CHP (con_hdl=0,svchp=022A0C80,svrhp=022A572C)

4 ETW000 47 0.761816

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12537

4 ETW000 32149 0.793965

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12537'

4 ETW000 170 0.794135

4 ETW000 [dev trc ,00000] Try to connect with default password 17 0.794152

4 ETW000 [dev trc ,00000] Connecting as SAPR3/<pwd>@CHP on connection 0 ...

4 ETW000 18 0.794170

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=022A572C) 12 0.794182

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=022A0C80,srvhp=022A572C)

4 ETW000 15 0.794197

4 ETW000 [dev trc ,00000] Deallocating server context handle 022A572C 13 0.794210

4 ETW000 [dev trc ,00000] Allocating server context handle 18 0.794228

4 ETW000 [dev trc ,00000] Attaching to DB Server CHP (con_hdl=0,svchp=022A0C80,svrhp=022A572C)

4 ETW000 40 0.794268

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12537

4 ETW000 15101 0.809369

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12537'

4 ETW000 18 0.809387

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12537 performing CON [dblink#1 @ 419]

4 ETW000 2324 0.811711

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12537: TNS:connection closed [dblink#1 @ 419]

4 ETW000 35 0.811746

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'CHP'"

We would normally expect to install the kernel and Oracle client locally , but there is no chance to do this.

Does anyone know how to manage this error?

Thanks a lot in advance.

Edited by: Dino Dose on Mar 25, 2010 7:01 PM

[former_member204746 · Accepted solution]

what do you mean by "node".

do you want to install an application server?

read http://www.dba-oracle.com/t_ora_12537_tns_error.htm

[Former Member · Accepted solution]

Node is intended as new machine.

Yes, the aim is to add an application server to the existing SAP Instance

[former_member204746 · Accepted solution]

run this program:

R3trans -d

post results from file trans.log

check listener status... and also read the link I provided 2 posts ago.

[Former Member]

Hi,

Whate OS flava is your DB server is it windows too?

Mark

[Former Member]

The problem was the setting of parameter TNS_INVITED_NODES in the sqlnet.ora

Thanks a lot.