오라클 10g 재시작 및 리스너 접속

출처 : http://nicebury.tistory.com/1

오라클 재시작 및 리스너 (명령 모드)

#su - oracle

/************* 오라클 SQLPlUS 접속하기 방법 1 ***************/

[oracle:/경로명/oracle]% sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Dec 7 14:05:51 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.1.0 - Production

SQL>startup                 <--- 오라클DB 시작명령

SQL>shutdown abort     <--- 오라클DB 종료명령

SQL>exit                      <--- 오라클 SQLPLUS 빠져나오기

/************* 오라클 SQLPlUS 접속하기 방법 2 ***************/

[oracle:/경로명/oracle]% sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Dec 7 14:17:35 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>conn /as sysdba

SQL>startup                 <--- 오라클DB 시작명령

SQL>shutdown abort     <--- 오라클DB 종료명령

SQL>exit                      <--- 오라클 SQLPLUS 빠져나오기

/**********************************************************/

/************ 오라클 리스너 접속하기 ***********************/

[oracle:/경로명/oracle]% lsnrctl

LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 07-DEC-2005 14:10:01

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL>start             <--- 리스너 시작하기

LSNRCTL>stop             <--- 리스너 종료하기

LSNRCTL>exit              <--- 리스너 빠져나오기

/*********************************************************/