Amazon RDS Custom for Oracle 19c database with sysdba login

 Amazon RDS Custom for Oracle

Login as sysdba to oracle database:

-bash-4.2$

-bash-4.2$ sqlplus "/as sysdba"

SQL*Plus: Release 19.0.0.0.0 - Production on Fri May 26 20:07:44 2023

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL>

SQL>

SQL> select name,open_mode,cdb from v$database;

NAME      OPEN_MODE            CDB

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

DEV       READ WRITE           NO

SQL> select * from v$tablespace;

       TS# NAME                           INC BIG FLA ENC     CON_ID

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

         0 SYSTEM                         YES YES YES              0

         1 SYSAUX                         YES YES YES              0

         2 UNDO_T1                        YES YES YES              0

         4 USERS                          YES YES YES              0

         5 RDSADMIN                       YES YES YES              0

         3 TEMP                           NO  YES YES              0

6 rows selected.

SQL> select file_name from dba_data_files;

FILE_NAME

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

/rdsdbdata/db/DEV_A/datafile/o1_mf_rdsadmin_l71tz3fk_.dbf

/rdsdbdata/db/DEV_A/datafile/o1_mf_users_l71t0bxh_.dbf

/rdsdbdata/db/DEV_A/datafile/o1_mf_undo_t1_l71t0bof_.dbf

/rdsdbdata/db/DEV_A/datafile/o1_mf_sysaux_l71t09xk_.dbf

/rdsdbdata/db/DEV_A/datafile/o1_mf_system_l71t08j1_.dbf

SQL>