My Oracle Support Banner

After Upgrading to Oracle 19c RAC Multitenant (Single PDB) Cannot Connect to PDB Using SQL*Plus from AP Tier (Doc ID 2800720.1)

Last updated on JULY 02, 2023

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.2.10 and later
Information in this document applies to any platform.


After upgrading Oracle Database to 19c on RAC Multitenant (Single PDB) by referencing below document

Using Oracle 19c RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.2 (<Document:2530665.1>)

On section

9.1 Perform Preparatory Steps
3. Confirm that you are able to connect to one of the instances in the Oracle RAC environment from the run file system. This can be verified using sqlplus to connect to the PDB as the apps user.

Tried to connect to PDB from AP tier using sqlplus but it ended in below error.


ORA-12541: TNS:no listener

1. DB server runs on Linux
2. From DB server can connect to PDB from below steps.

1. On AP tier, try to connect to PDB using below command

sqlplus apps/<apps password>@<PDB Name>


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.