Re: TNS-12541 TNS:no listener

From: daniel <test_at_test.com>
Date: Fri, 22 Mar 2002 20:23:36 -0000
Message-ID: <a7g3pa$8af$1@news8.svr.pol.co.uk>

here is a listener.ora file that i use; replace hostname with the name of your host;

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1526))
      )

    )
    (DESCRIPTION =
(PROTOCOL_STACK = (PRESENTATION = GIOP)(SESSION = RAW))
        (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 2481))     )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e:\oracle\ora81)
(PROGRAM = extproc)

    )
    (SID_DESC =
(ORACLE_HOME = e:\oracle\ora81)
(SID_NAME = TEST)
(GLOBAL_DBNAME = TEST)

    )
    (SID_DESC =
(ORACLE_HOME = e:\oracle\ora81)
(SID_NAME = PROD)
(GLOBAL_DBNAME = PROD)

    )
  )

LOGGING_LISTENER = ON
LOG_FILE_LISTENER = listener.log
LOG_DIRECTORY_LISTENER = e:\oracle\ora81\network\log

TRACE_TIMESTAMP_LISTENER = OFF
TRACE_LEVEL_LISTENER = OFF
TRACE_FILE_LISTENER = listener.trc
TRACE_DIRECTORY_LISTENER = e:\oracle\ora81\network\trace

CONNECT_TIMEOUT_LISTENER = 10
# PASSWORDS_LISTENER = (oracle)

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

Here is a sqlnet.ora file I use;

automatic_ipc = off

# trace_unique_client = on
# trace_timestamp_client = true
# trace_timestamp_server = true

tnsping_trace_level = off
tnsping.trace_directory = e:\oracle\ora81\network\trace

log_file_client = sqlnet
log_directory_client = e:\oracle\ora81\network\log

trace_level_client = off
trace_file_client = sqlnet
trace_directory_client = e:\oracle\ora81\network\trace

log_directory_server = e:\oracle\ora81\network\log

trace_level_server = off
trace_file_server = server
trace_directory_server = e:\oracle\ora81\network\trace

sqlnet.expire_time = 0
names.default_domain = world
name.default_zone = world
#names.directory_path = (ldap, hostname, onames, tnsnames) names.directory_path = (tnsnames)
#sqlnet.authentication_services = (none) sqlnet.authentication_services = (nts)

# use_cman = true
# use_dedicated_server = on
# sqlnet.client_registration = hostname

daemon.trace_level = off
daemon.trace_directory=e:\oracle\ora81\network\trace

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

And here is a tnsnames.ora file;

TEST.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = test)

    )
  )

PROD.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = prod)

    )
  )

change the hostname to yours, once the db has registered with the lsnr then you can address it with either a SID entry or a SERVICES entry.

Daniel...

"Hans de Ruiter" <hans.ruiter-de_at_siemens.nl> wrote in message news:a7evbn$rqd_at_thor.siemens.nl...
> By domain name I don't mean your NT-domain. Oracle domains are something > different and are used to identify databases inside a company worldwide. By
> domain I mean e.a. sales.mydomain.com. Your sqlnet.ora doesn't contain the > names.default_domain clause. If there were, connecting to the database sales

> will search inside your tnsnames.ora for a sales.defaultdomain.com as a
> servicename, and by that resolving how to talk to the listener. Honestly
> just stick with netconfig 8i for resolving your problem. It will sort

things
> out (can do it manually but the risk that if you don't know what your doing

> things will never work) and test it!
>
> "Julian K. Black" <julianb_at_bellsouth.net> wrote in message
> news:4nnm8.136137$Yd.6715455_at_e3500-atl1.usenetserver.com...
> > It is oralce 8i .  When you say domain if you are referring to my NT
> domain
> > is it needed since it resides on the same computer?   If so can you make
> the
> > necessary modification and post it for me(just use mydomainname ).
> thanks.
> > Here is a copy of my sqlnet.ora file:
> >
>
>
>

Received on Fri Mar 22 2002 - 14:23:36 CST