반응형
[주의사항]
[참고문서]
Be Cautious When Revoking Privileges Granted to PUBLIC (문서 ID 247093.1)
퍼블릭으로 부여된 권한을 회수할 때 주의할 점 (문서 ID 2119996.1)
[개인의견]
초기설치 후 PUBLIC권한과 설정이 끝난 후 Public 권한을 비교해서 추가된 Public 권한 만 회수 하면 될 같다.
반응형
Database/Oracle
퍼블릭으로 부여된 권한을 회수할 때 주의할 점 / Be Cautious When Revoking Privileges Granted to PUBLIC
2022. 6. 3. 09:00
반응형
[증 상]
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 ~]$
반응형