View the Oracle database status

1. Run the lsnrctl status Command to view the instance status.

HS-PRD: oraprd 17> LSNRCTL status

LSNRCTL for IBM/aix risc system/6000: Version 10.2.0.2.0-production on 04-ja
04:37:52 2012

Copyright (c) 1991,200 5, Oracle. All rights reserved.

Connecting to (description = (address = (Protocol = IPC) (Key = extproc1 )))
Status of the listener
------------------------
Alias listener
Version tnslsnr for IBM/AIX Proteus system/6000: Version 10.2.0
. 0-Production
Start date 11---2011 07:46:24
Uptime 84 days 20 HR. 51 min. 28 sec
Trace Level off
Security on: Local OS Authentication
SNMP on
Listener parameter file/Oracle/PRD/102_64/Network/admin/listener. ora
Listener log file/Oracle/PRD/102_64/Network/log/listener. Log
Listening endpoints summary...
(Description = (address = (Protocol = IPC) (Key = extproc1 )))
(Description = (address = (Protocol = TCP) (host = HS-PRD) (Port = 1521 )))
(Description = (address = (Protocol = IPC) (Key = PRD. World )))
(Description = (address = (Protocol = IPC) (Key = PRD )))
(Description = (address = (Protocol = TCP) (host = HS-PRD) (Port = 1527 )))
Services summary...
Service "plsextproc" has 1 instance (s ).
Instance "plsextproc", status unknown, has 1 handler (s) for this service...
Service "PRD" has 1 instance (s ).
Instance "PRD", status unknown, has 1 handler (s) for this service...
The command completed successfully