Re: listener question
- From: bdbafh <bdbafh@xxxxxxxxx>
- Date: Tue, 29 Jul 2008 07:19:54 -0700 (PDT)
On Jul 29, 10:02 am, pellicleund...@xxxxxxxxxxx (obakesan) wrote:
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
Hi Chris.
Its customary in this newsgroup to list the Oracle edition, version,
OS info.
I would guess that you're running 10.2.0.1 on a 32 bit Linux OS.
Yes, the configuration files
listener.ora
sqlnet.ora
tnsnames.ora
are indeed text files that can be edited directly.
One can also launch the Net Manager utility to made changes that will
be relatively certain to be in proper form so as to not through
errors.
$ netmgr
If you are not using an external procedure listener, that entry can be
removed.
That functionality increases the exposure surface ... and some people
take issue with the "enabled by default" attitude of the dbca and pre-
fabbed starter databases in general.
localhost.localdomain should resolve to the ip address of the host
using TCP (check it with a ping).
If you don't have execute privs on the ping utility, the utility
tnsping can be used.
If one is only supporting local connections, bequeath or IPC can also
be used.
Bequeathed connections do not involve connecting via a TNS Listener.
After you startup the database instance (which appears to be "ORCL"),
do you see the service registered with the listener?
$ lsnrctl status
If so, then you don't likely have any issues.
So ... fire up netmgr, delete the entry for the PLS external procedure
listener, check the entry for the service that you want to support,
save the configuration and restart the listener.
You'll need to wait for the database instance to re-register itself
with the listener, usually less than 3 minutes.
you can also manually register the service with the listener via
sqlplus:
$ export ORACLE_SID=orcl
$ sqlplus / as sysdba
SQL> alter system register;
SQL> quit
hth.
-bdbafh
.
- Follow-Ups:
- Re: listener question
- From: obakesan
- Re: listener question
- References:
- listener question
- From: obakesan
- listener question
- Prev by Date: Re: Moving/compressing *.trc files.
- Next by Date: Re: how much swap for 10g on a 4Gb RAM system?
- Previous by thread: listener question
- Next by thread: Re: listener question
- Index(es):
Relevant Pages
|
