신문지한장

[Tech] oracle TDE 설정 방법 (12c 이상)

OS : CentOS 7.9 (64bit) DB : Oracle Database 12c (12.2.0.1)💡 TDE (Transparent Data Encryption) 제약 사항    - EE(Enterprise Edition) 에서만 사용 가능    - SYSTEM, SYSAUX, UNDO, TEMP tablespace는 암호화 불가    - Database 재기동 필요 (parameter file 적용 때문)  1. wallet 설정 여부 확인col WRL_PARAMETER for a50select * from v$encryption_wallet;  2. sqlnet.ora 내용 변경$ cd $ORACLE_HOME/network/admin$ vi sqlnet.ora# sqlnet.ora Netwo..
Oracle/Tech 2024. 11. 21. 14:31
[Tech] oracle TDE 설정 방법 (11g 이하)

OS : CentOS 7.9 (64bit)DB : Oracle Database 11g ( Release - 11.2.0.4 )  TDE (Transparent Data Encryption) 제약 사항- EE(Enterprise Edition)에서만 사용 가능- SYSTEM, SYSAUX, UNDO, TEMP tablespace는 암호화 불가- Database 재기동 필요 (parameter file 변경 때문)  1. wallet 설정 여부 확인col WRL_PARAMETER for a50select * from v$encryption_wallet;  2. TDE 적용 (암호화 된) 테이블스페이스 확인SQL> select tablespace_name, encrypted from dba_tablespace..
Oracle/Tech 2024. 11. 21. 14:20
[Error] ORA-38802 : edition does not exist

OS : CentOS 7.9 (64bit) DB : Oracle Database 19c (19.18.0.0) Error MesseagesORA-38802 : edition does not exist  원인● 오브젝트 권한 부여해야 함 해결 방법● SQL> grant use on edition "" to ;grant use on edition ORA$BASE to SAMIM;
Oracle/Error Messages 2024. 11. 20. 14:39
[SQL] oracle clean.sh

#!/bin/kshexport CDATE=`date +%Y%m%d`mkdir old_trace_$CDATEmv *.trc old_trace_$CDATEmv *.trm old_trace_$CDATEmv alert_$ORACLE_SID.log ./old_log/alert_$ORACLE_SID.log_$CDATEtar zcvf ./old_log/old_trace_$CDATE.tar.gz old_trace_$CDATE
Oracle/sql&script 2024. 11. 20. 14:13
[Error] ORA-27102: out of memory

OS : SPARC M12-1 (64bit)DB : Oracle Database 11g ( Release - 11.2.0.4 ) Error MesseagesORA-27102: out of memory  원인OS max-shm-memory 값이 현재 메모리보다 낮음root@db # projects -l group.dbagroup.dba projid : 100 comment: "Oracle Group Project" users : (none) groups : dba attribs: process.max-file-descriptor=(priv,65536,deny) process.max-sem-nsems=(privile..
Oracle/Error Messages 2024. 11. 14. 16:57
이전 Prev 1 2 3 4 5 6 ··· 19 Next 다음