リスナーを起動していない場合【ORACLE】

リスナーが起動していない場合

リスナーが起動後

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx)(PORT=1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 19.0.0.0.0 - Production

Start Date 06-APR-2022 23:34:53

Uptime 0 days 0 hr. 0 min. 16 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File C:\Users\xxx

Listener Log File C:\app\xxx

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\xxx)))

Services Summary...

Service "xxx" has 1 instance(s).

Instance "xxx", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully