Connection ODBC fails after database upgrade
Hi Experts,
We have upgarded our 2 node RAC EBS database from 12.1.0.2(noncdb) to 19.17(cdb with single pdb)
User using odbc connection to database fails.
Which entry should we provide.Any example
tnsnames for oraclehome/network/admin->prodcdb is CDB and PRODDB is PDB prodcdb = (DESCRIPTION = (ADDRESS = (PROTOCOL=tcp)(HOST=erpproddb1.abc.com)(PORT=1528)) (CONNECT_DATA = (SERVICE_NAME=prodcdb)(INSTANCE_NAME=prodcdb1)) ) $ORACLE_HOME/network/admin/PRODDB_hostname PRODDB= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=**********.79)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=**********.80)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=**********.81)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=ebs_PRODDB) (INSTANCE_NAME=prodcdb1) ) )
Application uses ebs_PRODDB to connect to databas and it is working fine. listener status [oraprod@erpproddb1 19cdbhome]$ lsnrctl status prodcdb LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-FEB-2023 17:52:44 Copyright (c) 1991, 2022, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=erpproddb1-vip.abc.com)(PORT=1528))) STATUS of the LISTENER ------------------------ Alias prodcdb Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 05-FEB-2023 16:04:10 Uptime 1 days 1 hr. 48 min. 33 sec Trace Level off Security
0