Re: spfile/listener question

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Mon, 28 Jun 2004 20:52:52 +0300
Message-ID: <00aa01c45d38$bd091fa0$6a879fd9@porgand>

Sorry, remove the DESCRIPTION part. The correct syntax should be:

alter system set
local_listener="(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))";

Tanel.

• Original Message ----- From: "Tanel Põder" <tanel.poder.003_at_mail.ee> To: <oracle-l_at_freelists.org> Sent: Monday, June 28, 2004 8:44 PM Subject: Re: spfile/listener question

> 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_at_dcpds.cpms.osd.mil>
> To: <oracle-l_at_freelists.org>
> 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_at_freelists.org
> 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
> -----------------------------------------------------------------
>

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org 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
-----------------------------------------------------------------

Received on Mon Jun 28 2004 - 12:49:42 CDT