Database Networking (MOSC)

MOSC Banner

Why am I getting this error? TNS-12541: TNS:no listener

edited Jun 20, 2018 1:55PM in Database Networking (MOSC) 8 commentsAnswered

Hi All,

Please see below the setup of tnsnames.ora on the servers involved.

Server 1:

Oracle Linux Server release 6.9

Database version: Oracle Database 11.2.0.1.0 Enterprise Edition

TNS entry for remote DB (Server 2)

HIST =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1525))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = HIST)

    )

  )

listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

      (SID_LIST =

      (SID_DESC =

       (SID_NAME = tst)

       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

                )

        )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1521))

    )

  )

ADR_BASE_LISTENER = /u01/app/oracle

# sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center