티스토리 뷰

컴퓨터활용/오라클

oracle listener status check

호주 멜번초이 2003.10.12 01:09
#krsead001457712[/oracle/OraHome1/bin] lsnrctl

LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production on 15-FEB-2001 10:53:28

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:

start               stop                status              
services            version             reload              
save_config         trace               spawn                
dbsnmp_start        dbsnmp_stop         dbsnmp_status        
change_password     quit                exit                
set*                show*                

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=211.218.147.20)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production
Start Date                15-FEB-2001 10:33:02
Uptime                    0 days 0 hr. 20 min. 35 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /oracle/OraHome1/network/admin/listener.ora
Listener Log File         /oracle/OraHome1/network/log/listener.log
Services Summary...
  NEOPROD               has 1 service handler(s)
The command completed successfully
LSNRCTL> exit


#krsead001457712[/oracle/OraHome1/bin] vi /oracle/OraHome1/network/admin/listener.ora                      <
"/oracle/OraHome1/network/admin/listener.ora" 16개 행, 395개 문자  
# LISTENER.ORA Network Configuration File: /oracle/OraHome1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 211.218.147.20)(PORT = 1521))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = NEOPROD )
      (ORACLE_HOME = /oracle/OraHome1)
      (SID_NAME = NEOPROD)
    )
   )

'컴퓨터활용 > 오라클' 카테고리의 다른 글

oracle user  (0) 2003.10.12
오라클 유저 생성  (0) 2003.10.12
oracle listener status check  (0) 2003.10.12
ORACLE export / import 예제  (0) 2003.10.12
ORACLE DATA DICTIONARY TABLE  (0) 2003.10.12
PRIMARY KEY 생성하기  (0) 2003.10.12
댓글
댓글쓰기 폼