유닉스상에서 오라클 9i DBMS를 시작하고 종료하는 것은 알고보면 아주 간단하다.
#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 <--- 리스너 빠져나오기
/*********************************************************/
원문 :
http://blog.empas.com/jgj00180/15466311
