Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jun 22, 2009 at 06:14 AM

    Hi,

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

    Regrads

    Karan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 22, 2009 at 06:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Sergo Beradze

      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

  • avatar image
    Former Member
    Jun 22, 2009 at 07:30 AM

    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.

    db-error

    dbsl-trace-ora1403-when-accessing-table-sapuser

    Hope it helps

    Thanks

    Sushil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 22, 2009 at 10:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • > '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