오라클 9i서버 시작하기
svrmgrl없어졌고, sqlplus가 그 기능(?)을 통합했습니다.
거두절미하고 예제를 보면 쉽게 알 수 있을 겁니다.
주의하실 점은 oracle계정에서 sqlplus를 실행하는 것입니다
bash-2.04$ id
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),200(dba)
bash-2.04$ sqlplus /nolog
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jan 16 11:47:12 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
SQL> connect system/xxxxxx as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 638346768 bytes
Fixed Size 280080 bytes
Variable Size 419430400 bytes
Database Buffers 218103808 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL> quit
Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
bash-2.04$
종료는 시동과 나머지 과정은 동일하고 startup대신 shutdown만 하시면 됩니다.
bash-2.04$ sqlplus /nolog
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jan 16 11:46:45 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
SQL> connect system/xxxxxx as sysdba
Connected.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
|
This article comes from dbakorea.pe.kr (Leave this line as is)
|
