We help IT Professionals succeed at work.

Oracle11g: problems adding listener, something wrong with my config?

epifanio67
epifanio67 asked
on
Hello Experts,

below are is my listener.ora, sqlnet.ora, and tnsnames.ora files.
I am able to ping successfully confserv listener; but unable to ping logdb...
I get the error below:

// ERROR ------------

[oracle@oracle /]$ oracle/bin/tnsping logdb 4

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-NOV-2011 04:27:16

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:
/oracle/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 5500))) (CONNECT_DATA = (SERVICE_NAME = logdb)))
TNS-12541: TNS:no listener

// end of error --------------

do you see anything wrong?

thanks,
------ listner.ora --------------

# listener.ora Network Configuration File: /oracle/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = confserv)
      (ORACLE_HOME = /oracle)
      (SID_NAME = confserv)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = logdb)
      (ORACLE_HOME = /oracle)
      (SID_NAME = logdb)
    )
  )
# LISTENER section what host the database exists on
# and what port it accepts connections on

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 5500))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC5500))
    )
  )


----- tnsnames.ora --------------

# tnsnames.ora Network Configuration File: /oracle/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

# After making changes to this file, it is not necessary
# to restart the database or listener process

# tnsnames.ora
# It provides the address or location of the database
# you are trying to connect
#
# TNS: Transport Network Substrate
# when connecting to a database instance, you actually
# specify the TNS alias, not the database name

CONFSERV =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = confserv)
    )
  )

LOGDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 5500))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = logdb)
    )
  )


------------- sqlnet.ora -------------------

# sqlnet.ora is one additional configuration file.
# the param below tells the client to use tnsnames.ora
# instead of any other resource
NAMES.DIRECTORY_PATH=TNSNAMES

Open in new window

Comment
Watch Question

SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Log into the server 'oracle' as the oracle user and from a command prompt post the results of: lsnrctl start

Author

Commented:
thank you expert...

that was it.. I needed to restart the listener...

thank you...

Explore More ContentExplore courses, solutions, and other research materials related to this topic.