[-문구-Compeople-문구-]

+::DataBase::/Oracle2011. 10. 23. 22:07

1. DB Startup
[oracle@edu-db db_1]$ su oracle
[oracle@edu-db db_1]$ sqlplus /nolog
SQL> conn sys/암호 as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218968 bytes
Variable Size              96470632 bytes
Database Buffers          180355072 bytes
Redo Buffers                7168000 bytes
Database mounted.
Database opened.
SQL> exit

** or
[root@eduweb ~]# su - oracle
[eduweb:/home/oracle/product/10.2$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on 월 8월 16 09:22:26 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

휴지 인스턴스에 접속되었습니다.

SQL> startup
ORACLE 인스턴스가 시작되었습니다.

Total System Global Area 1073741824 bytes
Fixed Size                  1999864 bytes
Variable Size             322976776 bytes
Database Buffers          742391808 bytes
Redo Buffers                6373376 bytes
데이터베이스가 마운트되었습니다.
데이터베이스가 열렸습니다.

2. DB listener start
[oracle@edu-db db_1]$ su oracle
[oracle@edu-db root]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-AUG-2009 08:58:30

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /home/oracle/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 /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=edu-db)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                04-AUG-2009 08:58:32
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=edu-db)(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@edu-db root]$
 
3. 웹관리콘솔 시작
[oracle@edu-db db_1]$ su oracle
[oracle@edu-db db_1]$ emctl start dbconsole
TZ set to ROK
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://edu-db:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ....
........................ started.
------------------------------------------------------------------
Logs are generated in directory /home/oracle/oracle/product/10.2.0/db_1/edu-db_orcl/sysman/log


4. 테이블스페이스 이름 알아보는 쿼리
select tablespace_name,contents
from dba_tablespaces order by tablespace_name;


5. Shutdown (oracle 사용자모드에서..)
* 리스너종료

[eduweb:/home/oracle/product/10.2$ lsnrctl stop

LSNRCTL for Linux IA64: Version 10.2.0.1.0 - Production on 16-8¿ù -2010 09:50:05

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))에 연결되었습니다
명령이 성곡적으로 수행되었습니다

* 오라클종료
[eduweb:/home/oracle/product/10.2$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on ¿ù 8¿ù 16 09:50:16 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


다음에 접속됨:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate

데이터베이스가 닫혔습니다.
데이터베이스가 마운트 해제되었습니다.
ORACLE 인스턴스가 종료되었습니다.

SQL> quit
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options에서 분리되었습니다.


Posted by Compeople