LSNRCTL for Linux: Version 21.0.0.0.0 - Production on 24-APR-2024 13:30:50
Copyright (c) 1991, 2021, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=anolis8)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 21.0.0.0.0 - Production Start Date 24-APR-2024 13:29:32 Uptime 0 days 0 hr. 1 min. 18 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/21.3.0/db/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/anolis8/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=anolis8)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Services Summary... Service "16d177f6f2cd50bbe0638906a8c0ea02" has 1 instance(s). Instance "lucifer", status READY, has 1 handler(s) for this service... Service "c8209f27c6b16005e053362ee80ae60e" has 2 instance(s). Instance "lucifer", status READY, has 1 handler(s) for this service... Instance "orcl", status READY, has 1 handler(s) for this service... Service "lucifer" has 1 instance(s). Instance "lucifer", status READY, has 1 handler(s) for this service... Service "luciferXDB" has 1 instance(s). Instance "lucifer", status READY, has 1 handler(s) for this service... Service "oliver" has 1 instance(s). Instance "lucifer", status READY, has 1 handler(s) for this service... Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully
[oracle@anolis8:/home/oracle]$ . .orcl [oracle@anolis8:/home/oracle]$ sas
SQL*Plus: Release 21.0.0.0.0 - Production on Wed Apr 24 13:32:00 2024 Version 21.14.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.14.0.0.0
sys@ORCL 2024-04-24 13:32:00> show parameter name
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cdb_cluster_name string cell_offloadgroup_name string db_file_name_convert string db_name string orcl db_unique_name string orcl global_names boolean FALSE instance_name string orcl lock_name_space string log_file_name_convert string pdb_file_name_convert string processor_group_name string service_names string orcl sys@ORCL 2024-04-24 13:32:03> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 OLIVER READ WRITE NO sys@ORCL 2024-04-24 13:32:05> exit Disconnected from Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.14.0.0.0 [oracle@anolis8:/home/oracle]$ . .lucifer [oracle@anolis8:/home/oracle]$ sas
SQL*Plus: Release 21.0.0.0.0 - Production on Wed Apr 24 13:32:10 2024 Version 21.14.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.14.0.0.0
sys@LUCIFER 2024-04-24 13:32:10> show parameter name
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cdb_cluster_name string cell_offloadgroup_name string db_file_name_convert string db_name string lucifer db_unique_name string lucifer global_names boolean FALSE instance_name string lucifer lock_name_space string log_file_name_convert string pdb_file_name_convert string processor_group_name string service_names string lucifer sys@LUCIFER 2024-04-24 13:32:13> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 OLIVER READ WRITE NO