How to troubleshooting "Can not connect as sys in 19c PDB (EBA 12.2.0)"
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
--------------- --------