Opening existing database with fresh build image

[gyurovb]

Just to share
I have a database on docker, build (the database and the image) some one year ago. For various reasons I downloaded the repo again and built new 19.3 docket image. Mounted the existing volume as appropriate and.. surprisingly instead of opening the existing database, it started building a new one. Appears now it checks if the database exists by looking for
$ORACLE_BASE"/oradata/.${ORACLE_SID}"${CHECKPOINT_FILE_EXTN} but not for existence of
$ORACLE_BASE/oradata/$ORACLE_SID
as it used to be.
So... hack one
touch $ORACLE_BASE/oradata/.ORCLCDB.created

Then surprisingly container opened the database but... went to unhealthy state
The check script have changed to use OS authentication, but not "as sysdba" connection. Fixing security issue I guess, but still ... it fails.

So... hack 2

sqlplus / as sysdba << EOF
   ALTER SESSION SET "_oracle_script" = true;
   CREATE USER OPS\$oracle IDENTIFIED EXTERNALLY;
   GRANT CREATE SESSION TO OPS\$oracle;
   GRANT SELECT ON sys.v_\$pdbs TO OPS\$oracle;
   ALTER USER OPS\$oracle SET container_data=all for sys.v_\$pdbs container = current;
   exit;
EOF

Will see if something more appears.