trans.log file showing 'ERROR => CONNECT failed with sql error 12541'

[Former Member]

Dear All

We have upgraded our datatabse from Oracle 9.2.0.8 to Oracel 10.2.0.4 on our ECC 5.0 IS-AFS SAP system. When we check version from SQL, it's showing 10.2.0.4. That means database is successfully upgraded. Now, when we login through our <SID>adm user and checking R3trans -d, it is showing

'This is R3trans version 6.13 (release 640 - 07.01.08 - 14:25:00).

unicode enabled version

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

AP'"

R3trans finished (0012).'

In the trans.log file it is showing,

4 ETW000 R3trans version 6.13 (release 640 - 07.01.08 - 14:25:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 22.06.2009 - 11:56:40

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Jun 22 11:56:40 2009 110 0.000

110

4 ETW000 [dev trc ,00000] db_con_init called 27 0.000

137

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 62 0.000

199

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/VAP/SYS/exe/run/dboraslib.o' ...

4 ETW000 77 0.000

276

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/VAP/SYS/exe/run/dboraslib.o), hdl

0

4 ETW000 8142 0.008

418

4 ETW000 [dev trc ,00000] Library '/usr/sap/VAP/SYS/exe/run/dboraslib.o' loaded

4 ETW000 43 0.008

461

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/VAP/SYS/exe/r

un/dboraslib.o

4 ETW000 61 0.008

522

4 ETW000 [dev trc ,00000] Version of '/usr/sap/VAP/SYS/exe/run/dboraslib.o' is "640.00",

patchlevel (0.276)

4 ETW000 421 0.008

943

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/VAP/SYS/exe/

run/dboraslib.o

4 ETW000 46 0.008

989

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/VAP/SYS/exe

/run/dboraslib.o

4 ETW000 75 0.009

064

4 ETW000 [dev trc ,00000] New connection 0 created 48 0.009

112

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm =

YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 53 0.009

165

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 55 0.009

220

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 53 0.009

273

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm =

YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 49 0.009

322

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/VAP/102_64 from environment

4 ETW000 521 0.009

843

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 84 0.009

927

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment

4 ETW000 65 0.009

992

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 2033 0.012

025

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPVAP's password 49 0.012

074

4 ETW000 [dev trc ,00000] Connecting as /@VAP on connection 0 (nls_hdl 0) ... (dbsl 640 1

80309)

4 ETW000 57 0.012

131

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C

EnvHp ErrHp ErrHpBatch

4 ETW000 49 0.012

180

4 ETW000 [dev trc ,00000] 0 UTF8 1

0x1113a4400 0x1113b6b00 0x1113b63b8

4 ETW000 58 0.012

238

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 48 0.012

286

4 ETW000 [dev trc ,00000] Allocating server context handle 42 0.012

328

4 ETW000 [dev trc ,00000] Attaching to DB Server VAP (con_hdl=0,svchp=0x1113b97d8,srvhp=0

x1113b99f8)

4 ETW000 95 0.012

423

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

4 ETW000 4556 0.016

979

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

4 ETW000 59 0.017

038

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12541 39 0.017

077

4 ETW000 [dev trc ,00000] Try to connect with default password 184 0.017

261

4 ETW000 [dev trc ,00000] Connecting as SAPVAP/<pwd>@VAP on connection 0 (nls_hdl 0) ...

(dbsl 640 180309)

4 ETW000 46 0.017

307

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C

EnvHp ErrHp ErrHpBatch

4 ETW000 48 0.017

355

4 ETW000 [dev trc ,00000] 0 UTF8 1

0x1113a4400 0x1113b6b00 0x1113b63b8

4 ETW000 48 0.017

403

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0x1113b99f8)

4 ETW000 54 0.017

457

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x1113b97d8,srvhp=0x1

113b99f8)

4 ETW000 54 0.017

511

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x1113b99f8 42 0.017

553

4 ETW000 [dev trc ,00000] Allocating server context handle 33 0.017

586

4 ETW000 [dev trc ,00000] Attaching to DB Server VAP (con_hdl=0,svchp=0x1113b97d8,srvhp=0

x1113b99f8)

4 ETW000 54 0.017

640

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

4 ETW000 2547 0.020

187

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

4 ETW000 45 0.020

232

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12541 28 0.020

260

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 12541 performing CON [dblink#3 @ 428]

4 ETW000 220 0.020

480

4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#3 @ 428]

4 ETW000 42 0.020

522

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

AP'"

Checked the listener service. It is already started and status is OK. Please help.

Regards

Shashank Shekhar

[Former Member]

Hi

Yes, I am trying it with orasid user also. There in trans.log file it is showing:

'4 ETW000 R3trans version 6.13 (release 640 - 07.01.08 - 14:25:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 22.06.2009 - 15:54:42

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Jun 22 15:54:42 2009 109 0.000

109

4 ETW000 [dev trc ,00000] db_con_init called 27 0.000

136

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 61 0.000

197

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/VAP/SYS/exe/run/dboraslib.o' ...

4 ETW000 79 0.000

276

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/VAP/SYS/exe/run/dboraslib.o), hdl

0

4 ETW000 8174 0.008

450

4 ETW000 [dev trc ,00000] Library '/usr/sap/VAP/SYS/exe/run/dboraslib.o' loaded

4 ETW000 43 0.008

493

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/VAP/SYS/exe/r

un/dboraslib.o

4 ETW000 61 0.008

554

4 ETW000 [dev trc ,00000] Version of '/usr/sap/VAP/SYS/exe/run/dboraslib.o' is "640.00",

patchlevel (0.276)

4 ETW000 430 0.008

984

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/VAP/SYS/exe/

run/dboraslib.o

4 ETW000 46 0.009

030

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/VAP/SYS/exe

/run/dboraslib.o

4 ETW000 76 0.009

106

4 ETW000 [dev trc ,00000] New connection 0 created 48 0.009

154

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm =

YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 53 0.009

207

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 57 0.009

264

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 54 0.009

318

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm =

YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 49 0.009

367

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/VAP/102_64 from environment

4 ETW000 526 0.009

893

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 84 0.009

977

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment

4 ETW000 64 0.010

041

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIEnvCreate(mode=16384)' failed: rc = -

1

4 ETW000 1464 0.011

505

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code -1 40 0.011

545

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

4 ETW000 58 0.011

603

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error -1 performing CON [dblink#3 @ 428]

4 ETW000 74 0.011

677

4 ETW000 [dblink ,00428] ***LOG BY0=>Cannot get Oracle error text. [dblink#3 @ 428]

4 ETW000 55 0.011

732

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

AP'"

Someone suggested 'The solution is to download the new oracle client dll into the kernel'. Can anyone tell from where i can get the client dll for the kernel.

Regards

Shashank Shekhar

[Former Member]

Can you check all files per note Note 602843 - Environment settings for R/3/Oracle on UNIX

are the dbs_ora_tnsname is set corretly in all places,

"DBMS = ORACLE --- dbs_ora_tnsname = 'V AP'"

Why the V AP ? I can't understand .... Regards.

[Former Member]

Shashank,

Did you modify tnsnames.ora file?

Try to comment following line in tnsnames.ora and start the listner. Remember listner name has to be same.

LISTENER_VAP.WORLD =
(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = IS-AFS)(PORT = 1527))

Hope this works for you.

Manoj

[Former Member]

Hi Manoj

I have commented the following line in tnsnames.ora file.

#LISTENER_VAP.WORLD =

1. (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = IS-AFS)(PORT = 1527))

Still the problem is same. Please help.

Regards

Shashank Shekhar

[Former Member]

Please also check file tnsnames.ora in \usr\sap\SID\SYS\profile\oracle directory.

[Former Member]

Hi Manoj

As i have upgraded from Oracle 9, this directory doesnot exist.

Regards

Shashank Shekhar

[markus_doehr2]

> '4 ETW000 R3trans version 6.13 (release 640 - 07.01.08 - 14:25:00).

Your R3trans is very old (over a year) I'd update it to the latest patchlevel available.

> 4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIEnvCreate(mode=16384)' failed: rc = -

> 1

> 4 ETW000 1464 0.011

> 505

> 4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code -1 40 0.011

> 545

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

> 4 ETW000 58 0.011

> 603

> 4 ETW000 [dblink ,00428] ***LOG BY2=>sql error -1 performing CON [dblink#3 @ 428]

> 4 ETW000 74 0.011

> 677

> 4 ETW000 [dblink ,00428] ***LOG BY0=>Cannot get Oracle error text. [dblink#3 @ 428]

> 4 ETW000 55 0.011

> 732

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

> AP'"

There are a few things to consider here.

Executables from kernel version 640 and 640_EXT use the Oracle 9.2 client library. It seems, that ORA_NLS33 is not (correctly) set in your environment and pointing to a directory that does not exist. This happens usually, when your Oracle client was not an installed client (under /oracle/client/92x_64) but only links to installed Oracle database server software.

Since those links are now invalid since the server was upgraded and the necessary clients are no more available you can't connect.

You have two possibilities:

1) install the latest Oracle client (9.2.0.8) and make sure ORA_NLS33 points to the correct directory

2) install kernel 640_EX2 and also install the Oracle 10g instantclient

Markus

[Former Member]

Hi,

Did you check whether your Listner service is up or not?

check Note 609332 - Composite note: ORA-12541/ORA-12224

Also see below links.

Hope it helps

Thanks

Sushil

[Former Member]

Hi Sushil

I have already gone through the note 609332. Listener service is running as i mentioned earlier.

Regards

Shashank Shekhar

[Former Member]

Can you reboot whole server , start listener and check now the same R3trans ?

Also in listener.log all are fine?

P.S. can you say your SAP kernel version and P.L. are this 640_EX2 ?

Regards.

[Former Member]

Hi

I have restarted the system. It's still the same error in R3trans. SAP Kernel version is 640 unicode.

The listener.log file is:

'TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 22-JUN-2009 13:22:02

Copyright (c) 1991, 2007, Oracle. All rights reserved.

System parameter file is /oracle/VAP/102_64/network/admin/listener.ora

Log messages written to /oracle/VAP/102_64/network/log/listener.log

Trace information written to /oracle/VAP/102_64/network/trace/listener.trc

Trace level is currently 0

Started with pid=463054

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=VAP.WORLD)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=VAP)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=IS-AFS)(PORT=1527)))

Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

WARNING: Subscription for node down event still pending

22-JUN-2009 13:22:04 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=IS-AFS)(USER=oravap))(COMMAND=status

(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0'

Regards

Shashank Shekhar

[Former Member]

Can you say the kernel 640_EX2 ?

Are you trying the tnsping under orasid ? Regards.

[Former Member]

Hi Karan

I have checked the envrionment for user and also LISTENER is running. I am attaching the output of env command for user sidadm for your reference.

'TERM=ansi

AUTHSTATE=files

SHELL=/bin/csh

HOME=/home/vapadm

USER=vapadm

PATH=/oracle/VAP/102_64/bin:/home/vapadm:/usr/sap/VAP/SYS/exe/runU:/usr/sap/VAP/SYS/exe/run:/us

r/bin:/etc:/usr/sbin:/usr/ucb:/home/vapadm/bin:/usr/bin/X11:/sbin:.

TZ=PAKST-5PAKDT

LANG=en_US

LDR_CNTRL=USERREGS

LOCPATH=/usr/lib/nls/loc

LC__FASTMSG=true

NLSUI_7BIT_FALLBACK=YES

ORACLE_HOME=/oracle/VAP/102_64

ODMDIR=/etc/objrepos

LOGNAME=vapadm

LOGIN=vapadm

SAPSYSTEMNAME=VAP

DIR_LIBRARY=/usr/sap/VAP/SYS/exe/run

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=VAP

dbs_ora_schema=SAPVAP

ORACLE_PSRV=VAP

ORACLE_SID=VAP

DB_SID=VAP

ORACLE_BASE=/oracle

NLS_LANG=AMERICAN_AMERICA.UTF8

ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

SAPDATA_HOME=/oracle/VAP

MAIL=/var/spool/mail/vapadm

MAILMSG=[YOU HAVE NEW MAIL]

LIBPATH=/usr/sap/VXP/SYS/exe/run:/usr/sap/VAP/SYS/exe/run:/usr/sap/VAP/SYS/exe/runU:/sapmnt/VAP

/exe

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat'

Regards

Shashank Shekhar

[Former Member]

OOP's sorry, it's about R3trans ...

Can you post the Env of ORA"SID" user ?

Are you set the ORA_NLS10=$ORACLE_HOME/nls/data ?

That do you see if trying to start SAP ?

P.P.S

can you check in your log :

"DBMS = ORACLE --- dbs_ora_tnsname = 'V AP'"

Looks like the V AP is not correct also ... Try to recheck the tnsnames.ora and listener.ora

Regards.

[Former Member]

Hi

This is the output of env command for user orasid.

'TERM=ansi

AUTHSTATE=files

SHELL=/bin/csh

HOME=/oracle/VAP

USER=oravap

PATH=/oracle/VAP/102_64/bin:/oracle/VAP:/usr/sap/VAP/SYS/exe/runU:/usr/sap/VAP/SYS/exe/run:/usr

/bin:/etc:/usr/sbin:/usr/ucb:/oracle/VAP/bin:/usr/bin/X11:/sbin:.

TZ=PAKST-5PAKDT

LANG=en_US

LDR_CNTRL=USERREGS

LOCPATH=/usr/lib/nls/loc

LC__FASTMSG=true

NLSUI_7BIT_FALLBACK=YES

ORACLE_HOME=/oracle/VAP/102_64

ODMDIR=/etc/objrepos

LOGNAME=oravap

LOGIN=oravap

SAPSYSTEMNAME=VAP

DIR_LIBRARY=/usr/sap/VAP/SYS/exe/run

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=VAP

dbs_ora_schema=SAPVAP

ORACLE_PSRV=VAP

ORACLE_SID=VAP

DB_SID=VAP

ORACLE_BASE=/oracle

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/VAP

ORA_NLS10=/oracle/VAP/102_64/nls/data

MAIL=/var/spool/mail/oravap

MAILMSG=[YOU HAVE NEW MAIL]

LIBPATH=/usr/sap/VXP/SYS/exe/run:/usr/sap/VAP/SYS/exe/run:/usr/sap/VAP/SYS/exe/runU:/sapmnt/VAP/exe

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat'

Please check.

Regards

Shashank Shekhar

[Former Member]

Post the

tnsnames.ora and listener.ora Regards.

[Former Member]

Hi Sergo Beradze

The listener.ora file:

IS-AFS:oravap 9> cat listener.ora

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

1. Filename......: listener.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/640-2/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = VAP.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = VAP)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = IS-AFS)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = VAP)

(ORACLE_HOME = /oracle/VAP/102_64)

)

)

and the tnsnames.ora file:

IS-AFS:oravap 8> cat tnsnames.ora

1. tnsnames.ora Network Configuration File: /oracle/VAP/102_64/network/admin/tnsnames.ora

2. Generated by Oracle configuration tools.

LISTENER_VAP.WORLD =

(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = IS-AFS)(PORT = 1527))

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

1. Filename......: tnsnames.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/640-2/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

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

VAP.WORLD =

(DESCRIPTION =

(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = IS-AFS)(PORT = 1527))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = VAP)

)

)

Regards

Shashank Shekhar

[former_member227600]

Hi,

Have you check environment variable & also oracle home in profile.And also check listner is running or not.

Regrads

Karan