Skip to Content
avatar image
Former Member

ABAP database must be started first

Hello Experts,

I have a issue while starting SAP when execute startsap r3 I have experienced the error

TNS-12541: TNS:no listener, V2 connect is not available. Terminating.

My SAP environment is RHEL 5 and SAP NW7.0 with Oracle.

Please help me how to fix the issue.

before executing I have checked R3trans -d also it's fineshed with 0012.

Please refer below screenshot of error.

Lsnrctl start:

DBstartup.log:

R3trans -d:


R3trans.log

4 ETW000 R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 01.11.2015 - 12:46:34

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]  Sun Nov  1 12:46:34 2015                             116  0.000116

4 ETW000  [dev trc     ,00000]  db_con_init called                                    19  0.000135

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

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

4 ETW000                                                                              39  0.000207

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

4 ETW000                                                                            6731  0.006938

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

4 ETW000                                                                              23  0.006961

4 ETW000  [dev trc     ,00000]  function DbSlExpFuns loaded from library /usr/sap/W89/SYS/exe/run/dboraslib.so

4 ETW000                                                                               4  0.006965

4 ETW000  [dev trc     ,00000]  Version of '/usr/sap/W89/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.107)

4 ETW000                                                                               3  0.006968

4 ETW000  [dev trc     ,00000]  function dsql_db_init loaded from library /usr/sap/W89/SYS/exe/run/dboraslib.so

4 ETW000                                                                               1  0.006969

4 ETW000  [dev trc     ,00000]  function dbdd_exp_funs loaded from library /usr/sap/W89/SYS/exe/run/dboraslib.so

4 ETW000                                                                               0  0.006969

4 ETW000  [dev trc     ,00000]  New connection 0 created                               1  0.006970

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                                                                               0  0.006970

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

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

4 ETW000                                                                               0  0.006970

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                                                                               0  0.006970

4 ETW000  [dev trc     ,00000]  Oracle Client Version: '10.2.0.2.0'                  968  0.007938

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

4 ETW000  [dev trc     ,00000]  Client NLS settings: AMERICAN_AMERICA.UTF8          2565  0.010526

4 ETW000  [dev trc     ,00000]  Logon as OPS$-user to get SAPSR3's password           24  0.010550

4 ETW000  [dev trc     ,00000]  Connecting as /@W89 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000                                                                              23  0.010573

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

4 ETW000                                                                              34  0.010607

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      1  0xa21f2b0  0xa22491c  0xa2241a4

4 ETW000                                                                              23  0.010630

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

4 ETW000  [dev trc     ,00000]  Allocating server context handle                      32  0.010715

4 ETW000  [dev trc     ,00000]  Attaching to DB Server W89 (con_hdl=0,svchp=0xa224130,srvhp=0xa235914)

4 ETW000                                                                              54  0.010769

4 ETW000  [dev trc     ,00000]  Sun Nov  1 12:46:55 2015                         21013400  21.024169

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

4 ETW000                                                                              28  21.024197

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

4 ETW000                                                                              29  21.024226

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

4 ETW000  [dev trc     ,00000]  Try to connect with default password                  43  21.024293

4 ETW000  [dev trc     ,00000]  Connecting as SAPSR3/<pwd>@W89 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000                                                                              24  21.024317

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

4 ETW000                                                                              25  21.024342

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      1  0xa21f2b0  0xa22491c  0xa2241a4

4 ETW000                                                                              23  21.024365

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

4 ETW000                                                                              22  21.024387

4 ETW000  [dev trc     ,00000]  Detaching from DB Server (con_hdl=0,svchp=0xa224130,srvhp=0xa235914)

4 ETW000                                                                              21  21.024408

4 ETW000  [dev trc     ,00000]  Deallocating server context handle 0xa235914           3  21.024411

4 ETW000  [dev trc     ,00000]  Allocating server context handle                       3  21.024414

4 ETW000  [dev trc     ,00000]  Attaching to DB Server W89 (con_hdl=0,svchp=0xa224130,srvhp=0xa235914)

4 ETW000                                                                               2  21.024416

4 ETW000  [dev trc     ,00000]  Sun Nov  1 12:47:16 2015                         21011598  42.036014

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

4 ETW000                                                                              36  42.036050

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

4 ETW000                                                                              25  42.036075

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

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

4 ETW000                                                                              99  42.036189

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

4 ETW000                                                                              22  42.036211

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

Listener.log

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 01-NOV-2015 15:55:49

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

System parameter file is /oracle/W89/102_32/network/admin/listener.ora

Log messages written to /oracle/W89/102_32/network/log/listener.log

Trace information written to /oracle/W89/102_32/network/trace/listener.trc

Trace level is currently 0

Started with pid=5530

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

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

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=willsys89)(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

01-NOV-2015 15:56:10 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0

WARNING: Subscription for node down event still pending

01-NOV-2015 15:56:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0

WARNING: Subscription for node down event still pending

01-NOV-2015 17:20:31 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=W89.WORLD)))

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=W89)))

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=willsys89)(PORT=1527)))

Listener completed notification to CRS on stop

01-NOV-2015 17:20:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * stop * 0

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 01-NOV-2015 17:21:35

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

System parameter file is /oracle/W89/102_32/network/admin/listener.ora

Log messages written to /oracle/W89/102_32/network/log/listener.log

Trace information written to /oracle/W89/102_32/network/trace/listener.trc

Trace level is currently 0

Started with pid=25861

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

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

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=willsys89)(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

01-NOV-2015 17:21:35 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0

WARNING: Subscription for node down event still pending

01-NOV-2015 17:22:12 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 02-NOV-2015 10:40:29

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

System parameter file is /oracle/W89/102_32/network/admin/listener.ora

Log messages written to /oracle/W89/102_32/network/log/listener.log

Trace information written to /oracle/W89/102_32/network/trace/listener.trc

Trace level is currently 0

Started with pid=5624

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

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

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=willsys89)(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

02-NOV-2015 10:40:51 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=willsys89)(USER=oraw89))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0

TNSNAMES.ORA:

Please help me how to fix the issue and let me know any information required. 

Thanks in Advance,

Karthik Bura

Error.PNG (23.1 kB)
Screenshot.png (119.6 kB)
Screenshot-1.png (117.8 kB)
Screenshot-2.png (139.7 kB)
Screenshot-3.png (97.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 02, 2015 at 06:05 AM

    Hi Karthick,

    AS from the r3trans log its clear your system is unable to connect using Listerner.

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

    4 ETW000                                                                              28  21.024197

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

    4 ETW000                                                                              29  21.024226

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

    4 ETW000  [dev trc     ,00000]  Try to connect with default password                  43  21.024293

    So can you check if your DB is perfectly up and runnng fine in "OPEN" mode.

    As from the Listner start it say unknown handlers.

    You can check the same from below command;

    select OPEN_MODE from v$database;

    Also do below validations:-

    run below command by SIDadm in your case w89adm:-

    tnsping W89

    And check if you have tnsnames.ora in your profile directory:- /sapmnt/W89/profile/oracle.

    And has the same descriptors

    Update us on the same.

    Regards,

    Ram

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Below is listener.ora file which is located in Oracle home/admin/network/

      Listener.ora :

      ###### # Filename......: listener.ora

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

      # Name..........:

      # Date..........:

      # @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

      ###### ADMIN_RESTRICTIONS_LISTENER = on

      LISTENER =

      (ADDRESS_LIST =

      (ADDRESS =

      (PROTOCOL = IPC)

      (KEY = W89.WORLD)

      )

      (ADDRESS=

      (PROTOCOL = IPC)

      (KEY = W89)

      )

      (ADDRESS =

      (COMMUNITY = SAP.WORLD)

      (PROTOCOL = TCP)

      (HOST = willsys89)

      (PORT = 1527)

      )

      )

      STARTUP_WAIT_TIME_LISTENER = 0

      CONNECT_TIMEOUT_LISTENER = 10

      TRACE_LEVEL_LISTENER = OFF

      SID_LIST_LISTENER =

      (SID_LIST =

      (SID_DESC =

      (SID_NAME = W89)

      (ORACLE_HOME = /oracle/W89/102_32)

      )

      )



      same file already available also in profiles/oracle/listener.ora

      /usr/sap/W89/SYS/profile/oracle/listener.ora



      ###### # Filename......: listener.ora

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

      # Name..........:

      # Date..........:

      # @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

      ###### ADMIN_RESTRICTIONS_LISTENER = on

      LISTENER =

      (ADDRESS_LIST =

      (ADDRESS =

      (PROTOCOL = IPC)

      (KEY = W89.WORLD)

      )

      (ADDRESS=

      (PROTOCOL = IPC)

      (KEY = W89)

      )

      (ADDRESS =

      (COMMUNITY = SAP.WORLD)

      (PROTOCOL = TCP)

      (HOST = willsys89)

      (PORT = 1527)

      )

      )

      STARTUP_WAIT_TIME_LISTENER = 0

      CONNECT_TIMEOUT_LISTENER = 10

      TRACE_LEVEL_LISTENER = OFF

      SID_LIST_LISTENER =

      (SID_LIST =

      (SID_DESC =

      (SID_NAME = W89)

      (ORACLE_HOME = /oracle/W89/102_32)

      )

      )