Re: listener question

On Jul 29, 10:02 am, pellicleund..._at_hotmail.com (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 prefabbed  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 Received on Tue Jul 29 2008 - 09:19:54 CDT