Database Administration (MOSC)

MOSC Banner

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     

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center