On this activity we are going to migrate a 19c NON-CDB with Encryption/TDE into a 26ai PDB and do the upgrade.
Since in 26ai is manadatory to have PDB’s, and YES we could migrade 19c NON-CDB into a 19C CBD reusing the datafiles and do the upgrade inplace, but that would make a rollback more complicated.
For that reason best option would be using the refreshable clone PDB method, which pulls the data into the PDB via dblink, and if you need to rollback, just start 19c DB.
Enviroment is a single server running GRID, previouly upgraded to 26ai using this guide.
| DB NAME | PDB | ORACLE_HOME | |
| source 19c Non-CDB DB | DBTEST | N/A | /u01/app/oracle/product/19c/db_1 |
| target 26ai CDB DB | DBTESTCDB | TESTPDB | /u01/app/oracle/product/26ai/db_home1 |
To test the encryption on source DB we have an auto login wallet and created a new encrypted tablespace, created a new user with default tablespace the new one, and created a table:
SYS/DBTEST> CREATE TABLESPACE USERS3
DATAFILE SIZE 5M
AUTOEXTEND ON NEXT 5M MAXSIZE 32767M; 2 3
Tablespace created.
SYS/DBTEST>
SYS/DBTEST> select TABLESPACE_NAME, ENCRYPTED from dba_tablespaces order by 1;
TABLESPACE_NAME ENC
------------------------------ ---
SYSAUX NO
SYSTEM NO
TEMP NO
UNDOTBS1 NO
USERS NO
USERS2 NO
USERS3 YES
7 rows selected.
SYS/DBTEST>
SYS/DBTEST> CREATE USER test_user IDENTIFIED BY t3st_user
DEFAULT TABLESPACE USERS3
TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK; 2 3
User created.
SYS/DBTEST>
SYS/DBTEST>GRANT CREATE SESSION TO test_user;
SYS/DBTEST>GRANT CONNECT, RESOURCE TO test_user;
SYS/DBTEST>ALTER USER TEST_USER QUOTA UNLIMITED ON USERS3;
SYS/DBTEST> connect test_user/t3st_user
Connected.
TEST_USER/DBTEST> CREATE TABLE test_data AS
SELECT DBMS_RANDOM.VALUE() AS random_value,
DBMS_RANDOM.STRING('x', 20) AS random_string
FROM dual
CONNECT BY LEVEL <= 100; 2 3 4 5
Table created.
TEST_USER/DBTEST> commit;
Commit complete.
TEST_USER/DBTEST>
TEST_USER/DBTEST> select count(*) from test_data;
COUNT(*)
----------
100
TEST_USER/DBTEST>On target CDB, we impoted the same KEYS than source, I did not try having different keys, If you need, you can test it…. but make sure wallet is open on TARGET and master key enabled:
ON TARGET CDB:
col WRL_PARAMETER format a25
set linesize 190
col STATUS format a20
col WRL_TYPE foramt a10
select * from v$encryption_wallet;
WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_OR KEYSTORE FULLY_BAC CON_ID
-------------------- ------------------------- -------------------- -------------------- --------- -------- --------- ----------
ASM +DATA/dbtestcdb/tde/ OPEN AUTOLOGIN SINGLE NONE NO 1
ASM OPEN AUTOLOGIN SINGLE UNITED NO 2
SYS/DBTESTCDB> set linesize 190
col key_id format a60
SYS/DBTESTCDB> SYS/DBTESTCDB> col TAG format a10
col creation_time format a35
col activation_time format a35
col origin format a10
SELECT key_id,
tag,
creation_time,
activation_time,
origin
FROM v$encryption_keys
ORDER BY creation_time;
KEY_ID TAG CREATION_TIME ACTIVATION_TIME ORIGIN
------------------------------------------------------------ ---------- ----------------------------------- ----------------------------------- ----------
Ac3KDOXXXXXXXXXXXXxxxxxxxxxxxxAAAAAAAAAAAAAAAAAAA 21-JUL-22 13.04.00.177077 +00:00 21-JUL-22 13.04.00.177081 +00:00 LOCAL
SYS/DBTESTCDB> SELECT masterkey_activated
FROM v$database_key_info;
MAS
---
NO
NO
SYS/DBTESTCDB>
** ENABLE MASTER KEY:
SYS/DBTESTCDB> col NAME format a20
col VALUE$ format a30
SELECT name, value$
FROM sys.props$
WHERE name = 'TDE_MASTER_KEY_ID';
NAME VALUE$
-------------------- ------------------------------
TDE_MASTER_KEY_ID
SYS/DBTESTCDB> ADMINISTER KEY MANAGEMENT USE KEY
'Ac3KDOXXXXXXXXXXXXxxxxxxxxxxxxAAAAAAAAAAAAAAAAAAA'
FORCE KEYSTORE
IDENTIFIED BY "xxxxxx"
WITH BACKUP USING 'ACTKEY';
keystore altered.
SYS/DBTESTCDB>
SYS/DBTESTCDB> SELECT masterkey_activated
FROM v$database_key_info;
MAS
---
YES
NO
Now, lets proceed with the Migration/Upgrade….
1:- Create DB LINK on SOURCE DB:
create user dblinkuser identified by SuperSECRETPASSWORD ;
grant create session,
create pluggable database,
select_catalog_role to dblinkuser;
grant read on sys.enc$ to dblinkuser;2:- Create DB LINK on TARGET DB:
SYS/DBTESTCDB> create database link clonepdb
connect to dblinkuser identified by SuperSECRETPASSWORD
using 'DBTEST';
Database link created.
SYS/DBTESTCDB>
**** make sure your 26ai tnsnames.ora has the SOURCE DB and test with tnsping.
3:- Download AUTOUPGRADE
Download autoupgrade from HERE and review parameters needed for the config file.
4:- Create autoupgrade config file:
[oracle@oraclelinux8 upgrade26ai]$ pwd
/home/oracle/upgrade26ai
[oracle@oraclelinux8 upgrade26ai]$ cat upgrade26ai-TDE.cfg
global.global_log_dir=/home/oracle/upgrade26ai/log
global.keystore=/home/oracle/upgrade26ai/keystore
upg1.source_home=/u01/app/oracle/product/19c/db_1
upg1.target_home=/u01/app/oracle/product/26ai/db_home1
upg1.sid=DBTEST
upg1.target_cdb=DBTESTCDB
upg1.source_dblink.DBTEST=CLONEPDB 1800
upg1.target_pdb_name.DBTEST=TESTPDB
upg1.parallel_pdb_creation_clause.DBTEST=2
upg1.target_pdb_copy_option.DBTEST=file_name_convert=NONE
upg1.raise_compatible=no
upg1.manage_network_files=ignore_read_only
upg1.drop_dblink=yes
[oracle@oraclelinux8 upgrade26ai]$
** upg1.sid=DBTEST <- SOURCE DB
** upg1.target_cdb=DBTESTCDB <- TARGET DB
** upg1.source_dblink.DBTEST=CLONEPDB 1800 <- dblink to use and refresh rate
** upg1.target_pdb_name.DBTEST=TESTPDB <- PDB to be created and import the data.5:- Load wallet password of your TARGET CDB:
[oracle@oraclelinux8 upgrade26ai]$ java -jar autoupgrade.jar -config upgrade26ai-TDE.cfg -load_password
Processing config file ...
Starting AutoUpgrade Password Loader - Type help for available options
Creating new AutoUpgrade keystore - Password required
Enter password:
Enter password again:
AutoUpgrade keystore was successfully created
TDE> add DBTESTCDB
Enter your secret/Password:
Re-enter your secret/Password:
TDE> save
Select auto-login mode for the AutoUpgrade keystore [YES|NO|SHARED]: YES
TDE> exit
AutoUpgrade Password Loader finished - Exiting AutoUpgrade
[oracle@oraclelinux8 upgrade26ai]$6:- RUN AUTOUPGRADE ANALYZE:
[oracle@oraclelinux8 upgrade26ai]$ java -jar autoupgrade.jar -config upgrade26ai-TDE.cfg -mode analyze
AutoUpgrade 26.5.260807 launched with default internal options
Processing config file ...
Loading AutoUpgrade keystore
AutoUpgrade keystore is loaded
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 Non-CDB(s) will be analyzed
Type 'help' to list console commands
upg> status
Config
User configuration file [/home/oracle/upgrade26ai/upgrade26ai-TDE.cfg]
General logs location [/home/oracle/upgrade26ai/log/cfgtoollogs/upgrade/auto]
Mode [ANALYZE]
Jobs Summary
Total databases in configuration file [1]
Total Non-CDB being processed [1]
Total Containers being processed [0]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|100|[||||||||||||||||| ] 33 %|
+---+---------------------------------------------------------+
upg> status -job 100 -a 30
Details
Job No 100
Oracle SID DBTEST
Start Time 26/09/25 17:25:52
Elapsed (min): 0
End time: N/A
Logfiles
Logs Base: /home/oracle/upgrade26ai/log/DBTEST
Job logs: /home/oracle/upgrade26ai/log/DBTEST/100
Stage logs: /home/oracle/upgrade26ai/log/DBTEST/100/prechecks
TimeZone: /home/oracle/upgrade26ai/log/DBTEST/temp
Remote Dirs:
Stages
SETUP <1 min
PRECHECKS ~0 min (RUNNING)
Stage-Progress Per Container
+--------+---------+
|Database|PRECHECKS|
+--------+---------+
| DBTEST| 63 % |
+--------+---------+
The command status is running every 30 seconds. PRESS ENTER TO EXIT
Job 100 completed
------------------- Final Summary --------------------
Number of databases [ 1 ]
Jobs finished [1]
Jobs failed [0]
Please check the summary report at:
/home/oracle/upgrade26ai/log/cfgtoollogs/upgrade/auto/status/status.html
/home/oracle/upgrade26ai/log/cfgtoollogs/upgrade/auto/status/status.log
[oracle@oraclelinux8 upgrade26ai]$
** Make sure Final Summary is NOT FAILEDIf ANALYZE finds something, it will report and you would need to fix.
If no issues found. DB is ready for the upgrade.
7:- RUN AUTOUPGRADE DEPLOY:
[oracle@oraclelinux8 upgrade26ai]$ java -jar autoupgrade.jar -config upgrade26ai-TDE.cfg -mode deploy
AutoUpgrade 26.5.260807 launched with default internal options
Processing config file ...
Loading AutoUpgrade keystore
AutoUpgrade keystore is loaded
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 Non-CDB(s) will be processed
Type 'help' to list console commands
upg> status
Config
User configuration file [/home/oracle/upgrade26ai/upgrade26ai-TDE.cfg]
General logs location [/home/oracle/upgrade26ai/log/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [1]
Total Non-CDB being processed [1]
Total Containers being processed [0]
Jobs finished successfully [0]
Jobs finished/stopped [1]
Jobs in progress [0]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|101|[||||| ] 8 %|
+---+---------------------------------------------------------+
upg> Monitor progress with:
upg> status -a 30
or
upg> status -job 101 -a 30
upg> status -job 101 -a 30
Details
Job No 100
Oracle SID DBTEST
Start Time 26/09/25 18:14:57
Elapsed (min): 612
End time: N/A
Logfiles
Logs Base: /home/oracle/upgrade26ai/log/DBTEST
Job logs: /home/oracle/upgrade26ai/log/DBTEST/101
Stage logs: /home/oracle/upgrade26ai/log/DBTEST/101/noncdbtopdb
TimeZone: /home/oracle/upgrade26ai/log/DBTEST/temp
Remote Dirs:
Stages
SETUP <1 min
PREUPGRADE <1 min
DRAIN <1 min
CLONEPDB 1 min
REFRESHPDB <1 min
DISPATCH <1 min
DISPATCH 4 min
DBUPGRADE 351 min
NONCDBTOPDB ~20 min (RUNNING)
POSTCHECKS
POSTFIXUPS
POSTUPGRADE
SYSUPDATES
Stage-Progress Per Container
The Stage NONCDBTOPDB does not have any data to show
The command status is running every 30 seconds. PRESS ENTER TO EXITAfter a while, if all goes ok:
Job 101 completed
------------------- Final Summary --------------------
Number of databases [ 1 ]
Jobs finished [1]
Jobs failed [0]
Jobs restored [0]
Jobs pending [0]There is another log with a summary of each step:
[oracle@oraclelinux8 upgrade26ai]$ cat /home/oracle/upgrade26ai/log/cfgtoollogs/upgrade/auto/status/status.log
==========================================
Autoupgrade Summary Report
==========================================
[Date] Sat Sep 26 04:38:20 BST 2026
[Number of Jobs] 1
==========================================
[Job ID] 100
==========================================
[DB Name] DBTEST
[Version Before Upgrade] 19.32.0.0.0
[Version After Upgrade] 23.26.1.0.0
------------------------------------------
[Stage Name] PREUPGRADE
[Status] SUCCESS
[Start Time] 2026-09-25 18:14:57
[Duration] 0:00:00
[Log Directory] /home/oracle/upgrade26ai/log/DBTEST/100/preupgrade
------------------------------------------
[Stage Name] DRAIN
[Status] SUCCESS
[Start Time] 2026-09-25 22:07:55
[Duration] 0:00:15
[Log Directory] /home/oracle/upgrade26ai/log/DBTEST/100/drain
------------------------------------------
[Stage Name] CLONEPDB
[Status] SUCCESS
[Start Time] 2026-09-25 22:08:10
[Duration] 0:01:58
[Log Directory] /home/oracle/upgrade26ai/log/DBTEST/100/clonepdb
------------------------------------------
[Stage Name] REFRESHPDB
[Status] SUCCESS
[Start Time] 2026-09-25 22:10:09
[Duration] 0:00:05
[Log Directory] /home/oracle/upgrade26ai/log/DBTEST/100/clonepdb
------------------------------------------
[Stage Name] DBUPGRADE
[Status] SUCCESS
[Start Time] 2026-09-25 22:14:49
[Duration] 5:51:33
[Log Directory] /home/oracle/upgrade26ai/log/DBTEST/100/dbupgrade
------------------------------------------
[Stage Name] NONCDBTOPDB
[Status] SUCCESS
[Start Time] 2026-09-26 04:06:22
[Duration] 0:23:08
[Log Directory] /home/oracle/upgrade26ai/log/DBTEST/100/noncdbtopdb
------------------------------------------
[Stage Name] POSTCHECKS
[Status] SUCCESS
[Start Time] 2026-09-26 04:29:31
[Duration] 0:00:22
[Log Directory] /home/oracle/upgrade26ai/log/DBTEST/100/postchecks
[Detail] /home/oracle/upgrade26ai/log/DBTEST/100/postchecks/dbtest_postupgrade.log
Check passed and no manual intervention needed
------------------------------------------
[Stage Name] POSTFIXUPS
[Status] SUCCESS
[Start Time] 2026-09-26 04:29:53
[Duration] 0:08:23
[Log Directory] /home/oracle/upgrade26ai/log/DBTEST/100/postfixups
[Detail] /home/oracle/upgrade26ai/log/DBTEST/100/postfixups/postfixups.html
------------------------------------------
[Stage Name] POSTUPGRADE
[Status] SUCCESS
[Start Time] 2026-09-26 04:38:17
[Duration] 0:00:03
[Log Directory] /home/oracle/upgrade26ai/log/DBTEST/100/postupgrade
------------------------------------------
[Stage Name] SYSUPDATES
[Status] SUCCESS
[Start Time] 2026-09-26 04:38:20
[Duration] 0:00:00
[Log Directory] /home/oracle/upgrade26ai/log/DBTEST/100/sysupdates
------------------------------------------
Summary:/home/oracle/upgrade26ai/log/DBTEST/100/dbupgrade/upg_summary.log
[oracle@oraclelinux8 upgrade26ai]$At this point, SOURCE DB is no longer running and disabled (done automatically by the AUTOUPGRADE) and Upgrade completed at this point so lets do few checks:
SYS/DBTESTCDB> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TESTPDB READ WRITE NO
CONNECT TO THE PDB WE JUST MIGRATED/UPGRADED:
SYS/DBTESTCDB> alter session set container=TESTPDB;
Session altered.
set lines 190
set pagesize 99
col comp_name format a45
col version format a15
col status format a12
select comp_id, comp_name, version, status
from dba_registry
order by comp_id;
COMP_ID COMP_NAME VERSION STATUS
------------------------------ --------------------------------------------- --------------- ------------
APS OLAP Analytic Workspace 23.0.0.0.0 VALID
CATALOG Oracle Database Catalog Views 23.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages 23.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types 23.0.0.0.0 VALID
CONTEXT Oracle Text 23.0.0.0.0 VALID
DV Oracle Database Vault 23.0.0.0.0 VALID
JAVAVM JServer JAVA Virtual Machine 23.0.0.0.0 VALID
OLS Oracle Label Security 23.0.0.0.0 VALID
OWM Oracle Workspace Manager 23.0.0.0.0 VALID
RAC Oracle Real Application Clusters 23.0.0.0.0 OPTION OFF
SDO Spatial 23.0.0.0.0 VALID
XDB Oracle XML Database 23.0.0.0.0 VALID
XML Oracle XDK 23.0.0.0.0 VALID
XOQ Oracle OLAP API 23.0.0.0.0 VALID
14 rows selected.
SYS/DBTESTCDB>
SYS/DBTESTCDB> select owner, object_type, count(*) invalid_count
from dba_objects
where status = 'INVALID'
group by owner, object_type
order by owner, object_type;
no rows selected
SYS/DBTESTCDB>
col action_time format a30
col DESCRIPTION format a60
select patch_id,
patch_type,
action,
status,
action_time,
description
from dba_registry_sqlpatch
order by action_time;
PATCH_ID PATCH_TYPE ACTION STATUS ACTION_TIME DESCRIPTION
---------- ---------- --------------- ------------ ------------------------------ ------------------------------------------------------------
38743669 RU APPLY SUCCESS 26-SEP-26 04.04.40.188351 Database Release Update : 23.26.1.0.0 (38743669) Gold Image
set linesize 220
col action_time format a30
col action format a15
col namespace format a24
col version format a22
col comments format a80
select action_time,
action,
namespace,
version,
id,
comments
from dba_registry_history
order by action_time;
ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS
------------------------------ --------------- ------------------------ ---------------------- ---------- --------------------------------------------------------------------------------
02-SEP-26 22.17.53.568748 RU_APPLY SERVER 19.0.0.0.0 Patch applied on 19.3.0.0.0: Release_Update - 190410122720
03-SEP-26 12.29.19.280965 jvmpsu.sql SERVER 19.32.0.0.260721OJVMRU 0 RAN jvmpsu.sql
03-SEP-26 12.29.19.324395 APPLY SERVER 19.32.0.0.260721OJVMRU 0 OJVM RU post-install
03-SEP-26 12.46.16.811449 RU_ROLLBACK SERVER 19.0.0.0.0 Patch rolled back from 19.3.0.0.0 to 19.1.0.0.0: Feature Release -
03-SEP-26 15.17.10.370433 jvmpsu.sql SERVER 19.32.0.0.260721OJVMRU 0 RAN jvmpsu.sql
03-SEP-26 15.17.10.397382 APPLY SERVER 19.32.0.0.260721OJVMRU 0 OJVM RU post-install
03-SEP-26 15.21.58.019284 jvmpsu.sql SERVER 19.32.0.0.260721OJVMRU 0 RAN jvmpsu.sql
03-SEP-26 15.21.58.031594 APPLY SERVER 19.32.0.0.260721OJVMRU 0 OJVM RU post-install
03-SEP-26 16.11.59.246936 RU_APPLY SERVER 19.0.0.0.0 Patch applied from 19.1.0.0.0 to 19.32.0.0.0: Release_Update - 260705220710
26-SEP-26 04.03.00.126774 UPGRADE SERVER 23.0.0.0.0 Upgraded from 19.32.0.0.0 to 23.26.1.0.0
26-SEP-26 04.04.40.257778 RU_INSTALL SERVER 23.26.1.0.0 Installed RU 23.26.1.0.0
26-SEP-26 04.28.40.690260 NONCDB_TO_PDB SERVER 23.0.0.0.0 Converted non-CDB to PDB in release 23.26.1.0.0
BOOTSTRAP DATAPATCH_PRVTQOPI 23 e0b85a0176a706b50918f5ba985f7bde|40E31CE3CE567D947FFFBE286C3BA439
BOOTSTRAP DATAPATCH_DBMSQOPI 23 cc33d7b58f7f4efa82f56bcd4e4cc655|CFE1C0F9D24EFBEAA05917AD4A3957B9
BOOTSTRAP DATAPATCH_PRVTSQLPATCH 23 abc11351967a0830b78c2a3ffc32a256|1D4E7F5CAB7BBEB1D9D78409E05253D7
BOOTSTRAP DATAPATCH 19 RDBMS_19.32.0.0.0DBRU_LINUX.X64_260705
BOOTSTRAP DATAPATCH 23 RDBMS_23.26.1.0.0DBRU_LINUX.X64_260116.1
BOOTSTRAP DATAPATCH_DBMSSQLPATCH 23 922a4c202e49dbaf5baecbe11c8372f1|42ECEA23B571E15BD852875F674AA82A
18 rows selected.
SYS/DBTESTCDB>
One of the last few things to do is to review any TNSMAMES and make sure they are correct, and also create any matching service that connects to the desired PDB:
**** IF YOU NEED TO RESTART THE OLD DB, BE CAREFULL SINCE SERVICE NAMES ARE THE SAME
OLD SERVICE:
[oracle@oraclelinux8 ~]$ srvctl config service -d DBTEST
Service name: PROD_SERVICE
Cardinality: SINGLETON
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type:
Failover method:
Failover retries:
Failover delay:
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Pluggable database name:
Hub service:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Drain timeout:
Stop option:
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Service uses Java: false
[oracle@oraclelinux8 ~]$
NEW 26ai to connect to PDB TESTPDB:
[oracle@oraclelinux8 ~]$ srvctl add service -db DBTESTCDB -service PROD_SERVICE -pdb TESTPDB -role PRIMARY
[oracle@oraclelinux8 ~]$ srvctl start service -db DBTESTCDB
[oracle@oraclelinux8 ~]$ srvctl status service -db DBTESTCDB
Service PROD_SERVICE is running
[oracle@oraclelinux8 ~]$ srvctl config service -db DBTESTCDB
Service name: PROD_SERVICE
Cardinality: SINGLETON
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: FALSE
AQ HA notifications: FALSE
Global: FALSE
Commit Outcome: FALSE
Commit Outcome Fastpath: FALSE
Reset State: NONE
Failover type: NONE
Failover method: NONE
Failover retries:
Failover delay:
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Pluggable database name: TESTPDB
True Cache service:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Failback : no
Replay Initiation Time: 300 seconds
Drain timeout:
Template timeout: 86400 seconds
Stop option:
Session State Consistency:
Auto Connection Rebalance: DEFAULT
GSM Flags: 0
Service is enabledLast Final check…. is the tablespace encrypted OK and readable???
SYS/DBTESTCDB> select TABLESPACE_NAME, ENCRYPTED from dba_tablespaces order by 1;
TABLESPACE_NAME ENC
------------------------------ ---
SYSAUX NO
SYSTEM NO
TEMP NO
UNDOTBS1 NO
USERS NO
USERS2 NO
USERS3 YES
7 rows selected.
SYS/DBTESTCDB>
[oracle@oraclelinux8 ~]$ sqlplus test_user/t3st_user@oraclelinux8:1521/TESTPDB
SQL*Plus: Release 23.26.1.0.0 - Production on Sat Sep 26 15:29:58 2026
Version 23.26.1.0.0
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Last Successful login time: Fri Sep 25 2026 17:13:59 +01:00
Connected to:
Oracle AI Database 26ai Enterprise Edition Release 23.26.1.0.0 - Production
Version 23.26.1.0.0
TEST_USER/oraclelinux8:1521/TESTPDB> show user
USER is "TEST_USER"
TEST_USER/oraclelinux8:1521/TESTPDB>
TEST_USER/oraclelinux8:1521/TESTPDB> select count(*) from test_data;
COUNT(*)
----------
100
TEST_USER/oraclelinux8:1521/TESTPDB>Ta-daa!!!!
Comments