Re: Listener Question

Scott,

Assuming you are talking about connecting to a PDB, you probably want to use USE_SID_AS_SERVICE_listener_name.
https://docs.oracle.com/en/database/oracle/oracle-database/19/netrf/oracle-net-listener-parameters-in-listener-ora.html#GUID-5055BBB9-26E5-465D-B79A-A712FADF3595

Seth

On Fri, Oct 16, 2020 at 8:11 AM Scott Canaan <srcdco_at_rit.edu> wrote:

> We are trying to install Oracle OPI using an Oracle 19c database. The
> database is running on Red Hat 7. The issue we are running into is that
> the OPI software wants to connect to the database using the SID, but the
> OPI configuration software wants to connect to the database using the
> service_name. Is there a way to configure the listener to accept both?
>
>
>
> This is the definition in the listener.ora file:
>
>
>
> SID_LIST_LISTENER =
>
> (SID_LIST =
>
> (SID_DESC =
>
> (GLOBAL_DBNAME = rinnprod.rit.edu)
>
> (SID_NAME = RINNPROD)
>
> (ORACLE_HOME = /oracle/app/product/19.0.0.0)
>
> )
>
> )
>
>
>
> Thank you,
>
>
>
> *Scott Canaan ‘88*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> *srcdco_at_rit.edu <srcdco_at_rit.edu>* | c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
>
>

--
http://www.freelists.org/webpage/oracle-l