Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

How to troubleshooting "Can not connect as sys in 19c PDB (EBA 12.2.0)"

edited Aug 20, 2021 9:27AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

Hi All.

The system is ebs 12.1.3 and 19c CDB/PDB. just finishing the upgrade to 12.2.0 and about to do "Performing post-upgrade Tasks"

both are on Linux 7u6

and found out that I could not connect to PDB as sys

$ source <CDB_NAME>_<NODE_NAME>.env

$ export ORACLE_PDB_SID=<PDB NAME>;

$ sqlplus "/ as sysdba"


[oracle@test-db1 dbhome_1]$ . ./ebscdb1_test-db1.env

[oracle@test-db1 dbhome_1]$ export ORACLE_PDB_SID=TEST

$ sqlplus "/ as sysdba"

SQL> show con_id

CON_ID

------------------------------

1

Even export ORACLE_PDB_SID=TEST

It still connects to CDB

check the trigger and it is enabled.

TRIGGER_NAME   STATUS

--------------- --------

Tagged:

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