티스토리

Database Sync

검색하기

블로그 홈

Database Sync

datasyncxml.tistory.com/m

동기(Sync) 님의 블로그입니다.

구독자: 1

방명록 방문하기

주요 글 목록

OCI VM기반 ACFS 삭제 기존 상태 확인 [grid@one19c ~]$ id uid=102(grid) gid=1001(oinstall) groups=1001(oinstall),1002(dbaoper),1004(asmadmin),1005(asmoper),1006(asmdba) [grid@one19c ~]$ df -h Filesystem Size Used Avail Use% Mounted on devtmpfs 32G 0 32G 0% /dev tmpfs 32G 845M 31G 3% /dev/shm tmpfs 32G 17M 32G 1% /run tmpfs 32G 0 32G 0% /sys/fs/cgroup /dev/mapper/vg00-root 9.6G 2.9G 6.2G 32% / /dev/sda2 488M 237M 216M 53% /b.. 공감수 0 댓글수 0 2022. 10. 24.
OCI VM기반 DBCLI명령어를 이용한 Oracle Database Patch작업 Patch전 사전 확인 [root@one19c ~]# cliadm update-dbcli Job details ---------------------------------------------------------------- ID: fe8c68e7-4f63-41af-bebb-23b0901ffccb Description: DcsCli patching Status: Created Created: September 26, 2022 11:17:59 AM KST Message: Dcs cli will be updated Task Name Start Time End Time Status -----------------------------------------------------------------------.. 공감수 0 댓글수 0 2022. 10. 17.
OCI VM기반 ACFS Resize 및 생성 기존 상태 확인 [grid@one19c ~]$ id uid=102(grid) gid=1001(oinstall) groups=1001(oinstall),1002(dbaoper),1004(asmadmin),1005(asmoper),1006(asmdba) [grid@one19c ~]$ df -h Filesystem Size Used Avail Use% Mounted on devtmpfs 32G 0 32G 0% /dev tmpfs 32G 845M 31G 3% /dev/shm tmpfs 32G 25M 32G 1% /run tmpfs 32G 0 32G 0% /sys/fs/cgroup /dev/mapper/vg00-root 9.6G 2.9G 6.2G 32% / /dev/sda2 488M 237M 216M 53% /b.. 공감수 0 댓글수 0 2022. 10. 11.
OCI DBCS Oracle Database 19c SE2 Transparent Data Encryption(TDE) 일반적인 On-Premise환경에서 Oracle DB Standard Edition은 Transparent Data Encryption(TDE)를 지원 하지 않는다. 그러나 OCI DBCS환경에서는 Oracle DB Standard Edition에도 TDE를 지원 한다. TDE 설정 확인 [oracle@one19c admin]$ pwd /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin [oracle@one19c admin]$ ls samples shrept.lst sqlnet.ora tnsnames.ora [oracle@one19c admin]$ more sqlnet.ora # ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=.. 공감수 0 댓글수 0 2022. 10. 4.
전통적인 MOS 화면과 OCI MOS화면 전통적인 MOS화면 OCI MOS 화면 공감수 0 댓글수 0 2022. 9. 5.
AWS EC2 Oracle과 AWS RDS for Orace간 성능 비교 결과 Swingbench Benchmark Configuration Swingbench Results Case#1 Case #2 Case #3 결론 참고만 하면 될 것 같다. 공감수 0 댓글수 0 2022. 8. 29.
AWS EC2 Oracle과 AWS RDS for Orace간 성능 비교 준비 기본환경 Oracle Database Version : Oracle Database EE 19c + RU19.14 Oracle Database Type : Single AWS EC2 Instacne Type : r5.large (DB Instance Name : TEST) AWS RDS Instacne Type : db.r5.large (DB Instance Name : RDSTST) 성능 Test Tool : Swingbench select instance_name, version_full, archiver, database_type from v$instance; 주요 Parameter 비교 select name, value from v$spparameter where value is not null .. 공감수 0 댓글수 0 2022. 8. 22.
AWS RDS for Oracle 기본 환경 Default Tablespace Type select * from DATABASE_PROPERTIES where property_name='DEFAULT_TBS_TYPE' ; AWS RDS for Oracle 생성 후 생성된 Tablespace 목록 select ddf.tablespace_name, ddf.file_name, round(ddf.bytes/1024/1024,2) MB, ddf.autoextensible, ddf.increment_by, dts.bigfile from dba_data_files ddf, dba_tablespaces dts where ddf.tablespace_name = dts.tablespace_name ; Big Tablespace와 Small Tablespace 생성 .. 공감수 0 댓글수 0 2022. 8. 16.
AWS RDS for Oracle 생성 주요 Alert Log 내용 Controlfile Reuse 및 DB resetlogs Open ORACLE_BASE from environment = /rdsdbbin Spfile /rdsdbbin/oracle/dbs/spfileRDSTSTEE.ora is in old pre-11 format and compatible >= 11.0.0; converting to new H.A.R.D. compliant format. 2022-XX-XXT04:02:13.257388+00:00 CREATE CONTROLFILE REUSE SET DATABASE "RDSTSTEE" RESETLOGS NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 30 MAXINSTANCES 1 MAXLOGHIST.. 공감수 0 댓글수 0 2022. 8. 8.
Amazon RDS for Oracle 19c Patch List(19.14 기준) Patch Id: 29585399 Patch Description: OCW RELEASE UPDATE 19.3.0.0.0 (29585399) Patch Apply Time: 2019-04-18T07:21:33Z Patch Id: 33515361 Patch Description: Database Release Update : 19.14.0.0.220118 (33515361) Patch Apply Time: 2022-02-07T08:44:16Z Patch Id: 33561310 Patch Description: OJVM RELEASE UPDATE: 19.14.0.0.220118 (33561310) Patch Apply Time: 2022-02-07T08:48:36Z Patch Id: 28730253 Patc.. 공감수 0 댓글수 0 2022. 8. 1.
AWS EC2 Timezone 변경 하기 [Timezone 변경 방법] [ec2-user@ip-XXX-XX-XX-XX ~]$ [ec2-user@ip-XXX-XX-XX-XX ~]$ more /etc/sysconfig/clock ZONE="UTC" UTC=true [ec2-user@ip-XXX-XX-XX-XX ~]$ [ec2-user@ip-XXX-XX-XX-XX ~]$ date Tue May 10 07:04:55 UTC 2022 [ec2-user@ip-XXX-XX-XX-XX ~]$ [ec2-user@ip-XXX-XX-XX-XX ~]$ sudo su - root [root@ip-XXX-XX-XX-XX ~]# [root@ip-XXX-XX-XX-XX ~]# rm /etc/localtime rm: remove regular file ‘/etc/localt.. 공감수 0 댓글수 0 2022. 5. 16.
EC2 OS ROOT Partition Resize 하기 [기존 상태] [ec2-user@ip-XXX-XX-XX-XX ~]$ uname -a Linux ip-XXX-XX-XX-XX.us-west-2.compute.internal 5.10.109-104.500.amzn2.x86_64 #1 SMP Wed Apr 13 20:31:43 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux [ec2-user@ip-XXX-XX-XX-XX ~]$ [ec2-user@ip-XXX-XX-XX-XX ~]$ df -h Filesystem Size Used Avail Use% Mounted on devtmpfs 474M 0 474M 0% /dev tmpfs 483M 0 483M 0% /dev/shm tmpfs 483M 444K 482M 1% /run tmpfs 48.. 공감수 0 댓글수 0 2022. 5. 12.

문의안내

티스토리
로그인
고객센터

티스토리는 카카오에서 사랑을 담아 만듭니다.