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 laterInformation in this document applies to any platform.
Symptoms
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.
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.
Error
ERROR:
ORA-12541: TNS:no listener
Fact
1. DB server runs on Linux
2. From DB server can connect to PDB from below steps.
Steps
1. On AP tier, try to connect to PDB using below command
sqlplus apps/<apps password>@<PDB Name>
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |