Re: spfile/listener question

  • From: Tanel Põder <tanel.poder.003@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 28 Jun 2004 20:44:42 +0300

Try to set the LOCAL_LISTENER to "DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=1421))" instead of tns alias.

Tanel.

----- Original Message ----- 
From: <Scott.Shafer@xxxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, June 28, 2004 8:30 PM
Subject: spfile/listener question


> Odd question time:
> RTFM'd until we're blue, but we can't get the listener services to
register
> when specified in the init.ora vs a listener.ora file. HR Apps 11.5.7 on
> Oracle 9.2.0.5, HPUX 11.11.
>
> We're trying to set the listener in the init.ora/spfile using the
> parameters:
> LOCAL_LISTENER=db1
> SERVICE_NAMES=db1.us.acme.com
> INSTANCE_NAME=db1
>
> tnsnames.ora entry looks like:
> db1= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=1421)))
>
> As SYSDBA we've done the:
> ALTER SYSTEM SET LOCAL_LISTENER='db1'


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: