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@xxxxxxx> 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@xxxxxxx <srcdco@xxxxxxx>* | 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.
