Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question