심리학이 서른살에게 답하다
Y.으네/책 2013. 3. 10. 00:13 |
심리학이 서른 살에게 답하다
작가 김혜남 출판 걷는나무 발매 2009.05.11
서른이 되지 않은 나에게도,
서른이 훌쩍 넘은 분에게도 추천하고 싶은 책.
'Y.으네 > 책' 카테고리의 다른 글
| 여기에 당신의 욕망이 보인다 <Big Data> (0) | 2013.03.10 |
|---|
Tablespace 생성 예제
Database/Workshop I 2013. 3. 6. 17:23 |
이름 : insa_tbs
데이터 파일 : /u01/app/oracle/oradata/orcl/insa_tbs01.dbf
데이터 파일크기 : 10M
최대크기가 30M로 extent가 더 필요할때 1M씩 자동 확장을 활성화 합니다.
extent 관리 : local uniform size 1M
자동 세그먼트 공간 관리
CREATE TABLESPACE insa_tbs
DATAFILE '/u01/app/oracle/oradata/orcl/insa_tbs01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M maxsize 30M
EXTENT MANAGEMENT LOCAL UNIFORM size 1M
SEGMENT SPACE MANAGEMENT AUTO;
이름 : insa_ind_tbs
데이터 파일 : /u01/app/oracle/oradata/orcl/insa_ind_tbs01.dbf
데이터 파일크기 : 10M
최대크기가 20M로 extent가 더 필요할 때 1M씩 자동 확장을 활성화 합니다.
extent 관리 : local uniform size 1M
자동 세그먼트 공간 관리
CREATE TABLESPACE insa_ind_tbs
DATAFILE '/u01/app/oracle/oradata/orcl/insa_ind_tbs01.dbf' SIZE 10M
AUTOEXTEND ON NEXT 1M maxsize 20M
EXTENT MANAGEMENT LOCAL UNIFORM size 1M
SEGMENT SPACE MANAGEMENT AUTO;
Daily check list
Database/준비 2013. 3. 5. 15:03 |1. db open 상태 체크
[orcl:~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 22 08:59:49 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1337720 bytes
Variable Size 381683336 bytes
Database Buffers 146800640 bytes
Redo Buffers 5840896 bytes
Database mounted.
Database opened.
SQL> select status from v$instance;
STATUS
------------
OPEN
2. listener 상태 체크 // sql plus 말고 다른 툴 써도 리스너는 항상 떠있어야함
[orcl:~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-FEB-2013 09:01:30
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=edydr1p0.us.oracle.com)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[orcl:~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-FEB-2013 09:01:59
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/edydr1p0/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=edydr1p0.us.oracle.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=edydr1p0.us.oracle.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 22-FEB-2013 09:01:59
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/edydr1p0/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=edydr1p0.us.oracle.com)(PORT=1521)))
The listener supports no services
The command completed successfully
[orcl:~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-FEB-2013 09:02:24
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=edydr1p0.us.oracle.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 22-FEB-2013 09:01:59
Uptime 0 days 0 hr. 0 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/edydr1p0/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=edydr1p0.us.oracle.com)(PORT=1521)))
Services Summary...
Service "orcl.oracle.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.oracle.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully