cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP database must be started first

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello Ramakrishna,

I already checked database by executing command "select status from v$instance;"

the result is OPEN.

I have checked many times keeping DB Open and mount phase also but same issue repeated.

tnsping W89/willsys89/IP i have checked already pinging properly.


I have checked /sapmnt/W89/profile/oracle. tnsnames.ora is existing and same in both locations.

Thanks,

Karthik

Former Member
0 Kudos

Hi KArathick,

can you paste the output for tnsping W89 and lsnrctl status command here.

And what activities you have performed before the system went down.

Regards,

Ram

Former Member
0 Kudos

Hello Ram,

Please find below screenshots

TNSPING W89:

LSNRCTL Status:

Just restarted application server..

Thanks,

Karthik

Former Member
0 Kudos

Hello Ram,

I have performed below modification :

Open for edit the file $ORACLE_HOME/network/lib/env_network.mk and identify the following line:

TNSLSNR_LINKLINE+=$(SYSLIBS)

Add above the line TNSLSNR_LINKLINE+=$(SYSLIBS) the following entry:

LLIBCRYPT = -lcrypt

Modify the entry TNSLSNR_LINKLINE+=$(SYSLIBS) as below

from

TNSLSNR_LINKLINE+=$(SYSLIBS)

to

TNSLSNR_LINKLINE+=$(SYSLIBS) $(LLIBCRYPT)

Relink again oracle:

$ cd $ORACLE_HOME/bin

$ ./relink all

After performing check below screenshot:

Thanks,

Karthik

Former Member
0 Kudos

it seems listener issue i have tried below:

[root@willsys89 ~]# su - w89adm

willsys89:w89adm 1> lsnrctl start w89

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-NOV-2015 11:29:45

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

Starting /oracle/W89/102_32/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production

System parameter file is /usr/sap/W89/SYS/profile/oracle/listener.ora

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

TNS-01151: Missing listener name, w89, in LISTENER.ORA

Listener failed to start. See the error message(s) above...

Former Member
0 Kudos

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)

)

)