We help IT Professionals succeed at work.
Get Started

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

epifanio67
epifanio67 asked
on
339 Views
Last Modified: 2012-05-12
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
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2020
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE