리눅스 오라클 시작/중지

리눅스 오라클 시작/중지

오라클 인스턴스 시작/중지

오라클 리스너 시작/중지

목차  [숨기기]  1 명령어 2 실행예시 3 같이 보기 4 주석 5 참고 자료

명령어

오라클DB는 인스턴스와 리스너를 따로 시작하도록 되어 있다.^[1]

인스턴스 시작/중지

sqlplus를 시작하여 나오는 SQL> 프롬프트에서 인스턴스를 시작/중지할 수 있다

sqlplus '/as sysdba'

startup
shutdown

리스너 시작/중지

lsnrctl start
lsnrctl stop

실행예시

인스턴스 시작

oracle@jmnote:/oracle> sqlplus '/as sysdba'
 
SQL*Plus: Release 10.2.0.1.0 - Production on 화 5월 7 13:04:31 2013
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup
ORACLE instance started.
 
Total System Global Area 1241513984 bytes
Fixed Size                  1219136 bytes
Variable Size             234882496 bytes
Database Buffers          989855744 bytes
Redo Buffers               15556608 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
oracle@jmnote:/oracle>

리스너 시작

oracle@jmnote:/oracle> lsnrctl start
 
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-5월 -2013 12:31:59
 
Copyright (c) 1991, 2005, Oracle.  All rights reserved.
 
Starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
 
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=jmn)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jmnote)(PORT=1521)))
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=JMP)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                07-5월 -2013 12:32:01
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=jmn)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jmnote)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

oracle@jmnote:/oracle> netstat -anp | grep 1521 | grep LISTEN
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
tcp        0      0 0.0.0.0:1521                0.0.0.0:*                   LISTEN      3534/tnslsnr

→ 리스너가 1521 포트를 LISTEN한다.

같이 보기

• 오라클
• ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

주석

1. ↑ 반면 MySQL은 인스턴스와 리스너가 mysqld 하나로 되어 있어서, mysqld만 시작하면 즉시 서비스 가능하다.

참고 자료

• http://docs.oracle.com/cd/B10501_01/server.920/a96521/start.htm

 

 

 

 

 

 

 

 

 

출처 : http://jmnote.com/wiki/%EB%A6%AC%EB%88%85%EC%8A%A4_%EC%98%A4%EB%9D%BC%ED%81%B4_%EC%8B%9C%EC%9E%91/%EC%A4%91%EC%A7%80