cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Listener not working

Go to solution
Former Member

on ‎06-13-2013 9:50 AM

0 Kudos

Dear All

Our listener not able to connect when we try to connect it through Error 00155 no listener

following are the log for the same

sqlnet.ora

*-*-*-*-*-*-

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

# Filename......: sqlnet.ora

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

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

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

# @(#) $Id: //bas/720_REL/src/krn/tpls/ora/SQLNET.ORA#1 $

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

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

sqlnet.ora

NAMES.DEFAULT_DOMAIN = WORLD

# 05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

# 05.01.06 set the default to 10

SQLNET.EXPIRE_TIME = 10

SQLNET.AUTHENTICATION_SERVICES:none

# 05.01.06 set to default

#TCP.NODELAY=YES

# 05.01.06 set to 32768

DEFAULT_SDU_SIZE=32768

  

listener.ora

*-----------------

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

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

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

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

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

# @(#) $Id: //bas/720_REL/src/krn/tpls/ora/LISTENER.ORA#1 $

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

  (ADDRESS_LIST =

   (ADDRESS =

     (PROTOCOL = IPC)

     (KEY = IDS.WORLD)

   )  

   (ADDRESS=

      (PROTOCOL = IPC)

       (KEY = IDS)

    )

       (ADDRESS =

         (COMMUNITY = SAP.WORLD)

         (PROTOCOL = TCP)

         (HOST = IDESSOLMAN)

         (PORT = 1521)

         (CONNECT_DATA = (SID = IDS))

        )

  (ADDRESS =

    (PROTOCOL = IPC)

    (KEY = AFS.WORLD)

  )

   (ADDRESS =

     (PROTOCOL = IPC)

     (KEY = AFS)

   )

  )

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

    (SID_NAME = IDS)

    (ORACLE_HOME = D:\app\administrator\product\11.2.0\dbhome_1)

  )

)

(SID_DESC =

      (SID_NAME = AFS)

      (ORACLE_HOME = D:\app\administrator\product\11.2.0\dbhome_1)

  )

#ADR_BASE_LISTENER = D://oracle/AFS/saptrace

--------------------

tnsnames.ora

----------

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

# Filename......: tnsnames.ora

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

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

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

# @(#) $Id: //bas/720_REL/src/krn/tpls/ora/TNSNAMES.ORA#1 $

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

IDS.WORLD=

(DESCRIPTION =

    (ADDRESS_LIST =

        (ADDRESS =

          (COMMUNITY = SAP.WORLD)

          (PROTOCOL = TCP)

          (HOST = IDESSOLMAN)

          (PORT = 1521)

        )

    )

    (CONNECT_DATA =

     (SID = IDS)

      (GLOBAL_NAME = IDS.WORLD)

    )

  )

AFS.WORLD=

  (DESCRIPTION =

    (ADDRESS_LIST =

        (ADDRESS =

          (COMMUNITY = SAP.WORLD)

          (HOST = IDESSOLMAN)

          (PORT = 1521)

        )

    )

    (CONNECT_DATA =

    (SID = AFS)

    (GLOBAL_NAME = AFS.WORLD)

    

  )

-------------------

listener.log

------------

Started with pid=4712

TNS-01150: The address of the specified listener name is incorrect

Wed Jun 12 16:00:37 2013

System parameter file is D:\App\administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Log messages written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\alert\log.xml

Trace information written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\trace\ora_5828_5304.trc

Trace level is currently 0

Started with pid=5828

TNS-01150: The address of the specified listener name is incorrect

Wed Jun 12 16:01:08 2013

System parameter file is D:\App\administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Log messages written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\alert\log.xml

Trace information written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\trace\ora_4824_2156.trc

Trace level is currently 0

Started with pid=4824

TNS-01150: The address of the specified listener name is incorrect

Wed Jun 12 17:10:20 2013

System parameter file is D:\App\administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Log messages written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\alert\log.xml

Trace information written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\trace\ora_4168_4184.trc

Trace level is currently 0

Started with pid=4168

TNS-01150: The address of the specified listener name is incorrect

Thu Jun 13 10:59:50 2013

System parameter file is D:\App\administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Log messages written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\alert\log.xml

Trace information written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\trace\ora_4188_5756.trc

Trace level is currently 0

Started with pid=4188

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\IDS.WORLDipc)))

Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PARTIAL=yes)(QUEUESIZE=1))

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\IDS.WORLDipc)))

TNS-12560: TNS:protocol adapter error

TNS-00583: Valid node checking: unable to parse configuration parameters

Thu Jun 13 12:27:35 2013

System parameter file is D:\App\administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Log messages written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\alert\log.xml

Trace information written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\trace\ora_1888_5328.trc

Trace level is currently 0

Started with pid=1888

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\IDS.WORLDipc)))

Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PARTIAL=yes)(QUEUESIZE=1))

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\IDS.WORLDipc)))

TNS-12560: TNS:protocol adapter error

TNS-00583: Valid node checking: unable to parse configuration parameters

Thu Jun 13 12:27:44 2013

System parameter file is D:\App\administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Log messages written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\alert\log.xml

Trace information written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\trace\ora_4780_6124.trc

Trace level is currently 0

Started with pid=4780

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\IDS.WORLDipc)))

Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PARTIAL=yes)(QUEUESIZE=1))

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\IDS.WORLDipc)))

TNS-12560: TNS:protocol adapter error

TNS-00583: Valid node checking: unable to parse configuration parameters

Thu Jun 13 12:38:19 2013

System parameter file is D:\App\administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Log messages written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\alert\log.xml

Trace information written to D:\app\administrator\diag\tnslsnr\IDESSOLMAN\listener\trace\ora_2468_5964.trc

Trace level is currently 0

Started with pid=2468

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\IDS.WORLDipc)))

Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PARTIAL=yes)(QUEUESIZE=1))

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\IDS.WORLDipc)))

TNS-12560: TNS:protocol adapter error

TNS-00583: Valid node checking: unable to parse configuration parameters

Kindly provide some information i

Thanks & Regars

Rajendra

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

former_member206552
Active Contributor
‎06-13-2013 2:31 PM
0 Kudos

Hi Rajendra,

seems like you have 2 SID running in one listener trying to use the same port 1521

please split the 2 SID by using seperate listeners for each one on seperate ports

AFS

IDS

Best Regards

Marius

Show replies
Show replies
Former Member
‎06-14-2013 7:12 AM
0 Kudos

Dear all

try but not succeed

Regards

Answers (5)

Answers (5)

Reagan
Advisor
Advisor
‎06-14-2013 10:50 PM
0 Kudos

Hello

What I see is the listener.ora and tnsnames.ora files are configured with two systems.

The tnsnames.ora is configured with AFS and IDS on port 1521 on host IDESSOLMAN

It appears to me that there are two listeners and one is running and the other fails to start.

Can you show the status of the listeners in services.msc ?

If there are two SAP system running with two separate databases there should be two separate configuration files in their respective $ORACLE_HOME/network/admin locations with separate listener ports for each database.

I suggest you to configure the listener.ora and tnsnames.ora files for one system and remove the entries for the other system and restart the listener.

Check whether this configuration works.

listener.ora

-----------------

################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bas/720_REL/src/krn/tpls/ora/LISTENER.ORA#1 $
################
ADMIN_RESTRICTIONS_LISTENER = ON
LISTENER =
  (ADDRESS_LIST =
   (ADDRESS =
     (PROTOCOL = IPC)
     (KEY = IDS.WORLD)
   )  
   (ADDRESS=
      (PROTOCOL = IPC)
       (KEY = IDS)
   )
       (ADDRESS =
         (COMMUNITY = SAP.WORLD)
         (PROTOCOL = TCP)
         (HOST = IDESSOLMAN)
         (PORT = 1521)
         (CONNECT_DATA = (SID = IDS))
       )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
    (SID_NAME = IDS)
    (ORACLE_HOME = D:\app\administrator\product\11.2.0\dbhome_1)
  )
)

--------------------

tnsnames.ora

----------

################
# Filename......: tnsnames.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bas/720_REL/src/krn/tpls/ora/TNSNAMES.ORA#1 $
################
IDS.WORLD=
(DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = SAP.WORLD)
          (PROTOCOL = TCP)
          (HOST = IDESSOLMAN)
          (PORT = 1521)
        )
    )
    (CONNECT_DATA =
     (SID = IDS)
      (GLOBAL_NAME = IDS.WORLD)
    )
  )

Good Luck

RB

Show replies
Show replies
Former Member
‎06-18-2013 6:49 PM
0 Kudos

Thanks to all

now its working

Regards

Former Member
‎06-14-2013 12:05 PM
0 Kudos

Check listener.ora for syntax errors.

Show replies
Show replies
Former Member
‎06-13-2013 2:10 PM
0 Kudos

Why didn't anyone mention the error you get while starting the listener? You have a TNS-01150 error while starting up the listener, hence the DB is not able to register itself to the listener which leads to the connection problems.

Try to solve the problems with TNS-01150 first and then start or restart the listener and database and check if the problem persists.

One reason for a TNS-01150 might be indentation problems in the listener configuration, so check the listener.ora file for that.

Show replies
Show replies
Former Member
‎06-13-2013 1:21 PM
0 Kudos

Dear

No success

Show replies
Show replies
Former Member
‎06-13-2013 11:04 AM
0 Kudos

Hi Rajendra,

>> SQLNET.AUTHENTICATION_SERVICES:none

Could you change the setting with the below;

SQLNET.AUTHENTICATION_SERVICES= (NTS)

Then try again?

Best regards,

Orkun Gedik

Show replies
Show replies
Former Member
‎06-13-2013 1:21 PM
0 Kudos

no sucess

Ask a Question