2013/10/14 ws1 memo

* ADR : directory 구조(oracle system 자체에서 관리)

- trace

- alert log

- health monitor reports

+ single instance 에서도 쓰이지만 multi 에서 더 유용하게 쓰인다

* ADR base (ADR manage) 

: DIAGNOSTIC_DEST 초기화 파라미터가 ADR BASE 를 나타낸다.

ORACLE_BASE 환경변수에 들어간다

따로 지정을 안할경우 ORACLE_HOME/LOG

ADR_BASE = ORACLE_BASE

ADR_HOME = ADR_BASE/DIAGNOSIC_DEST/(INSTANCE TYPE)/(DB NAME)/INSTANCE NAME)

/u01/app/oracle/diag/rdbms/orcl/orcl/(trace or hm or log) 

v$diag_info

* volumn manager

: 여러개의 disk 를 한개의 Vloumn 으로 사용할수 있게 관리

- lvm : linux 

- asm :  file manager 의 기능(도 한다)

- RAID

* ASM - 201p 참고

균등분할 (rebalance)- RBAL/ ARBn

asm_powe_limit  최대 11( system 모든 resource 를 )

default listner : 1521

vi /u01/app/oracle/product/11.2.0/grid/network/admin/listner.ora

-----------------------------------------------------------------------------------

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = edydr1p0.us.oracle.com)(PORT = 1521))

    )

  )

ADR_BASE_LISTENER = /u01/app/oracle

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent

-----------------------------------------------------------------------------------

* load balacing

리눅스 network 설정후

* windows cmd 창에서

> sqlplus hr/oracle_4U@192.168.56.10:1521/orcl.example.com

or

> sqlplus hr@"192.168.56.10/orcl.example.com"

* sys user 로 접속시

> sqlplus sys/oracle_4U@192.168.56.10:1521/orcl.example.com as sysdba

> shutdown abort

> select instance_name, status from v$instance;

> connect sys@"192.168.56.10:11521/orcl.example.com as sysdba
-> enter password :

종료한 instance 는 em에서 살려야한다.

종료

> emctl stop dbconsole

> emctl s dbconsole

vi desktop/start.sh

------------------------------

 sqlplus / as sysdba<<EOF

 startup

 exit

 EOF

 emctl start dbconsole

------------------------------

emctl status dbconsole

select V$diag

62542---217p까지 내용-----------------------------------------------------