listener question



Hi

when I start my listener I get the following appear on the screen

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).

however in my tnsnames.ora file and my listner.ora files I have a different
host

tnsnames.ora:

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.koti)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

and listener.ora:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.koti)(PORT = 1521))
)
)

is this just a text file that can be edited or have I made some errors?

thanks

See Ya
(when bandwidth gets better ;-)

Chris Eastwood
Photographer, Programmer Motorcyclist and dingbat
blog: http://cjeastwd.blogspot.com/

please remove undies for reply
.



Relevant Pages

  • Re: Listener is on but db istance is down
    ... (SID_NAME = PLSExtProc) ... (SERVICE_NAME = ORCL) ... If you want to see what the listener ...
    (comp.databases.oracle.server)
  • Re: ORA-12514 with 10g Install (LONG...)
    ... and so does the listener. ... Remains to be seem if orcl exists. ... Copyright 1997, 2005, Oracle. ... ORA-12560: TNS:protocol adapter error ...
    (comp.databases.oracle.misc)
  • Re: Login problem
    ... the database instance doesnt appear, ... Either be patient (your listener.ora does not have an entry for orcl, ... is known as a bequeath connection, it uses no tcp/ip stack - listener ... manually setting the oracle_sid. ...
    (comp.databases.oracle.server)
  • Re: Listener is on but db istance is down
    ... tnsping orcl return successful but when I try a test like ... (SID_NAME = PLSExtProc) ... LISTENER = ... Loose the EXTPROC line and following, ...
    (comp.databases.oracle.server)
  • Re: 10g Database Configuration Assistant fails with code ORA-12546
    ... You have an entry in your tnsnames, ... database - assuming it is ORCL - replace with your choice): ... the instance will register itself with the listener in due time. ... lsnrctl start ...
    (comp.databases.oracle.server)