반응형
[주의사항]
[참고문서]
Be Cautious When Revoking Privileges Granted to PUBLIC (문서 ID 247093.1)
퍼블릭으로 부여된 권한을 회수할 때 주의할 점 (문서 ID 2119996.1)
[개인의견]
초기설치 후 PUBLIC권한과 설정이 끝난 후 Public 권한을 비교해서 추가된 Public 권한 만 회수 하면 될 같다.
반응형
전체 글
퍼블릭으로 부여된 권한을 회수할 때 주의할 점 / Be Cautious When Revoking Privileges Granted to PUBLIC
2022. 6. 3. 09:00
AWS EC2 Timezone 변경 하기
2022. 5. 16. 09:00
반응형
[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/localtime’? y
[root@ip-XXX-XX-XX-XX ~]# ln -s /usr/share/zoneinfo/Asia/Seoul /etc/localtime
[root@ip-XXX-XX-XX-XX ~]#
[root@ip-XXX-XX-XX-XX ~]# more /etc/sysconfig/clock
ZONE="UTC"
UTC=true
[root@ip-XXX-XX-XX-XX ~]#
[root@ip-XXX-XX-XX-XX ~]# date
Tue May 10 16:06:22 KST 2022
[root@ip-XXX-XX-XX-XX ~]#반응형
EC2 OS ROOT Partition Resize 하기
2022. 5. 12. 09:00
반응형
[기존 상태]
[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 483M 0 483M 0% /sys/fs/cgroup
/dev/xvda1 8.0G 1.6G 6.5G 20% /
tmpfs 97M 0 97M 0% /run/user/1000
[ec2-user@ip-XXX-XX-XX-XX ~]$
[ec2-user@ip-XXX-XX-XX-XX ~]$ lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
xvda 202:0 0 8G 0 disk
└─xvda1 202:1 0 8G 0 part /
[ec2-user@ip-XXX-XX-XX-XX ~]$[ EBS 볼륨 증설]
Elastic Block Store > 볼륨 > 원하는 볼륨선택 > 작업 > 볼륨수정
볼륨수정에서 원하는 값 입력 후 수정 클릭
Elastic Block Store > 볼륨 에서 변경 사항 확인(조금 시간 걸림)
[ROOT Partition Resize]
[ec2-user@ip-XXX-XX-XX-XX ~]$ lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
xvda 202:0 0 11G 0 disk
└─xvda1 202:1 0 8G 0 part /
[ec2-user@ip-XXX-XX-XX-XX ~]$
[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 483M 0 483M 0% /sys/fs/cgroup
/dev/xvda1 8.0G 1.6G 6.5G 20% /
tmpfs 97M 0 97M 0% /run/user/1000
[ec2-user@ip-XXX-XX-XX-XX ~]$
[ec2-user@ip-XXX-XX-XX-XX ~]$
[ec2-user@ip-XXX-XX-XX-XX ~]$ sudo growpart /dev/xvda 1
CHANGED: partition=1 start=4096 old: size=16773087 end=16777183 new: size=23064543 end=23068639
[ec2-user@ip-XXX-XX-XX-XX ~]$
[ec2-user@ip-XXX-XX-XX-XX ~]$ lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
xvda 202:0 0 11G 0 disk
└─xvda1 202:1 0 11G 0 part /
[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 483M 0 483M 0% /sys/fs/cgroup
/dev/xvda1 8.0G 1.6G 6.5G 20% /
tmpfs 97M 0 97M 0% /run/user/1000
[ec2-user@ip-XXX-XX-XX-XX ~]$
[ec2-user@ip-XXX-XX-XX-XX ~]$ sudo xfs_growfs -d /
meta-data=/dev/xvda1 isize=512 agcount=4, agsize=524159 blks
= sectsz=512 attr=2, projid32bit=1
= crc=1 finobt=1 spinodes=0
data = bsize=4096 blocks=2096635, imaxpct=25
= sunit=0 swidth=0 blks
naming =version 2 bsize=4096 ascii-ci=0 ftype=1
log =internal bsize=4096 blocks=2560, version=2
= sectsz=512 sunit=0 blks, lazy-count=1
realtime =none extsz=4096 blocks=0, rtextents=0
data blocks changed from 2096635 to 2883067
[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 483M 0 483M 0% /sys/fs/cgroup
/dev/xvda1 11G 1.6G 9.5G 15% /
tmpfs 97M 0 97M 0% /run/user/1000
[ec2-user@ip-XXX-XX-XX-XX ~]$
[ec2-user@ip-XXX-XX-XX-XX ~]$ lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
xvda 202:0 0 11G 0 disk
└─xvda1 202:1 0 11G 0 part /
[ec2-user@ip-XXX-XX-XX-XX ~]$
[ec2-user@ip-XXX-XX-XX-XX ~]$
[참고자료]
https://customer.gabia.com/manual/cloud/8521/9740
반응형
반응형
[증 상]
Oracle CRS 19c를 중지 하는 경우
"A system call received a parameter that is not valid. (Write failed)"
메시지 출력 되면
[현 상]
[rac1:P:root:/u01/grid/bin] # id
uid=0(root) gid=0(system) groups=2(bin),3(sys),7(security),8(cron),10(audit),11(lp)
[rac1:P:root:/u01/grid/bin] # pwd
/u01/grid/bin
[rac1:P:root:/u01/grid/bin] #
[rac1:P:root:/u01/grid/bin] # ./crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'rac1'
CRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.cvu' on 'rac1'
CRS-2673: Attempting to stop 'ora.LI_DBBREP1.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.LI_DBAREP1.lsnr' on 'rac1'
CRS-33673: Attempting to stop resource group 'ora.asmgroup' on server 'rac1'
CRS-2673: Attempting to stop 'ora.OCRVOTE.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.DBAARCH.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.DBADATA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.DBBARCH.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.DBBDATA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.qosmserver' on 'rac1'
CRS-2677: Stop of 'ora.rac2.vip' on 'rac1' succeeded
CRS-2677: Stop of 'ora.cvu' on 'rac1' succeeded
CRS-2677: Stop of 'ora.DBAARCH.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.DBADATA.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.LI_DBBREP1.lsnr' on 'rac1' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'
CRS-2677: Stop of 'ora.DBBDATA.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.OCRVOTE.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.DBBARCH.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.LI_DBAREP1.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded
CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac1'
A system call received a parameter that is not valid. (Write failed)
CRS-2677: Stop of 'ora.qosmserver' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asmnet1.asmnetwork' on 'rac1'
CRS-2677: Stop of 'ora.asmnet1.asmnetwork' on 'rac1' succeeded
CRS-33677: Stop of resource group 'ora.asmgroup' on server 'rac1' succeeded.
CRS-2673: Attempting to stop 'ora.ons' on 'rac1'
CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'rac1'
CRS-2673: Attempting to stop 'ora.crf' on 'rac1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded
CRS-2677: Stop of 'ora.storage' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[rac1:P:root:/u01/grid/bin] #[해결책]
무시하면 됨
[참고문서]
"a System Call Received A Parameter That Is Not Valid.(write Falied)" When Stop Crs (문서 ID 2706112.1)
반응형
Oracle 19c ACFS Resize 하기
2022. 4. 13. 09:00
반응형
[기본환경]
-OEL 8.2
-Oracle RAC 19 + RU 19.13
[Resize전 상황]
[oracle@rac1 ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 3.9G 0 3.9G 0% /dev
tmpfs 3.9G 853M 3.1G 22% /dev/shm
tmpfs 3.9G 9.2M 3.9G 1% /run
tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup
/dev/sda2 134G 47G 88G 35% /
tmpfs 796M 0 796M 0% /run/user/0
/dev/asm/ogg-232 9.0G 568M 8.5G 7% /OGG
tmpfs 796M 0 796M 0% /run/user/54321
[oracle@rac1 ~]$
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rac1 ~]$ asmcmd lsdg -g OGG
Inst_ID State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
1 MOUNTED EXTERN N 512 512 4096 4194304 10236 872 0 872 0 N OGG/
2 MOUNTED EXTERN N 512 512 4096 4194304 10236 872 0 872 0 N OGG/
[oracle@rac1 ~]$
[oracle@rac1 ~]$ asmcmd lsattr -l -G OGG
Name Value
access_control.enabled FALSE
access_control.umask 066
appliance._partnering_type GENERIC
ate_conversion_done true
au_size 4194304
cell.smart_scan_capable FALSE
cell.sparse_dg allnonsparse
compatible.advm 19.0.0.0.0
compatible.asm 19.0.0.0.0
compatible.rdbms 10.1.0.0.0
content.check FALSE
content.type data
content_hardcheck.enabled FALSE
disk_repair_time 12.0h
failgroup_repair_time 24.0h
idp.boundary auto
idp.type dynamic
logical_sector_size 512
maxblkdump_content.check 3
maxdump_content.check 32
maxerr_content.check 1048576
phys_meta_replicated true
preferred_read.enabled FALSE
scrub_async_limit 1
scrub_metadata.enabled TRUE
sector_size 512
thin_provisioned FALSE
vam_migration_done false
[oracle@rac1 ~]$
[ACFS Resize]
[oracle@rac1 ~]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rac1 ~]$
[oracle@rac1 ~]$ which acfsutil
/usr/sbin/acfsutil
[oracle@rac1 ~]$
[oracle@rac1 ~]$ ls -al /usr/sbin/acfsutil
-rwxr-xr-x. 1 root root 2862 Mar 19 16:38 /usr/sbin/acfsutil
[oracle@rac1 ~]$ acfsutil size 5G /OGG
acfsutil size: new file system size: 5368709120 (5120MB)
[oracle@rac1 ~]$
[oracle@rac1 ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 3.9G 0 3.9G 0% /dev
tmpfs 3.9G 853M 3.1G 22% /dev/shm
tmpfs 3.9G 9.2M 3.9G 1% /run
tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup
/dev/sda2 134G 47G 88G 35% /
tmpfs 796M 0 796M 0% /run/user/0
/dev/asm/ogg-232 5.0G 376M 4.7G 8% /OGG
tmpfs 796M 0 796M 0% /run/user/54321
[oracle@rac1 ~]$
[oracle@rac1 ~]$ acfsutil size 7G /OGG
acfsutil size: new file system size: 7516192768 (7168MB)
[oracle@rac1 ~]$
[oracle@rac1 ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 3.9G 0 3.9G 0% /dev
tmpfs 3.9G 853M 3.1G 22% /dev/shm
tmpfs 3.9G 9.2M 3.9G 1% /run
tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup
/dev/sda2 134G 47G 88G 35% /
tmpfs 796M 0 796M 0% /run/user/0
/dev/asm/ogg-232 7.0G 376M 6.7G 6% /OGG
tmpfs 796M 0 796M 0% /run/user/54321
[oracle@rac1 ~]$
반응형