[oracle@test trace]$ echo $ORACLE_SID
orcl
[oracle@test trace]$ export ORACLE_SID=hong
[oracle@test trace]$ echo $ORACLE_SID
hong
[oracle@test trace]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 30 13:57:01 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1140850632 bytes
Fixed Size 9134024 bytes
Variable Size 301989888 bytes
Database Buffers 822083584 bytes
Redo Buffers 7643136 bytes
Database mounted.
Database opened.
SQL> show parameter local
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_HONG
parallel_force_local boolean FALSE
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string hong
SQL>
[oracle@test trace]$ lsnrctl stop HONG
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 30-NOV-2023 14:07:30
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.com)(PORT=1530)))
The command completed successfully
[oracle@test trace]$ lsnrctl start HONG
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 30-NOV-2023 14:07:42
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/test/hong/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.com)(PORT=1530)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.com)(PORT=1530)))
STATUS of the LISTENER
------------------------
Alias HONG
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 30-NOV-2023 14:07:42
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/test/hong/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.com)(PORT=1530)))
The listener supports no services
The command completed successfully
[oracle@test trace]$
[oracle@test trace]$ lsnrctl status HONG
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 30-NOV-2023 14:08:30
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.com)(PORT=1530)))
STATUS of the LISTENER
------------------------
Alias HONG
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 30-NOV-2023 14:07:42
Uptime 0 days 0 hr. 0 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/test/hong/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.com)(PORT=1530)))
Services Summary...
Service "0b5331dc15e059d6e063e102a8c0e71c.com" has 1 instance(s).
Instance "hong", status READY, has 1 handler(s) for this service...
Service "86b637b62fdf7a65e053f706e80a27ca.com" has 1 instance(s).
Instance "hong", status READY, has 1 handler(s) for this service...
Service "hong.com" has 1 instance(s).
Instance "hong", status READY, has 1 handler(s) for this service...
Service "hongXDB.com" has 1 instance(s).
Instance "hong", status READY, has 1 handler(s) for this service...
Service "hongpdb.com" has 1 instance(s).
Instance "hong", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@test trace]$
