{"id":3995,"date":"2018-07-01T14:31:13","date_gmt":"2018-07-01T05:31:13","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3995"},"modified":"2018-07-01T14:43:38","modified_gmt":"2018-07-01T05:43:38","slug":"3995","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3995","title":{"rendered":"Exadata \uc810\uac80 \ub808\ud3ec\ud2b8"},"content":{"rendered":"

\uc624\ub77c\ud074 \uc5d1\uc0ac\ub370\uc774\ud0c0 \uc810\uac80 \uc2a4\ud06c\ub9bd\ud2b8\uc778 Exacheck (\uc5d1\uc0ac\uccb4\ud06c) \uc785\ub2c8\ub2e4.<\/p>\n

 <\/p>\n

\ubd80\ubd84 \ubd80\ubd84\uc744 \ub098\ub220 \ubcf4\uba74 Oracle RAC Database \uc758 Config Detail Check \ubc29\ubc95\uc744 \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

 <\/p>\n

[Sample]\u00a0\u00a0\u00a0\u00a0<\/span>
\n<\/span>Oracle Exadata ExaCheck Report<\/span>
\n<\/span><\/strong><\/span><\/p>\n

Customer\u00a0\u00a0\u00a0\u00a0:\u00a0\u00a0\u00a0\u00a0[Sample]<\/span>
\n<\/strong><\/span><\/p>\n

Author\u00a0\u00a0\u00a0\u00a0:
\n<\/strong><\/span><\/p>\n

Team\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0:
\n<\/strong><\/span><\/p>\n

Creation Date:\u00a0\u00a0\u00a0\u00a02017\ub144 09\uc6d4 13\uc77c<\/span>
\n<\/strong><\/span><\/p>\n

Last Updated\u00a0\u00a0\u00a0\u00a0:\u00a0\u00a0\u00a0\u00a02017\ub144 11\uc6d4 28\uc77c<\/span>
\n<\/strong><\/span><\/p>\n

Version\u00a0\u00a0\u00a0\u00a0:\u00a0\u00a0\u00a0\u00a01.1
\n<\/strong><\/span><\/p>\n

\"\"
\n<\/span><\/p>\n

Table of Contents
\n<\/strong><\/span><\/p>\n

Document Control<\/span>\u00a0\u00a0\u00a0\u00a05<\/span><\/strong>
\n<\/span><\/span><\/a><\/p>\n

Document Guide<\/span>\u00a0\u00a0\u00a0\u00a06<\/span><\/strong><\/span><\/a>
\n<\/span><\/p>\n

Database Server Summary<\/span>\u00a0\u00a0\u00a0\u00a09<\/span><\/span><\/a>
\n<\/span><\/p>\n

Storage Server Summary<\/span>\u00a0\u00a0\u00a0\u00a012<\/span><\/span><\/a>
\n<\/span><\/p>\n

Cluster Wide Summary<\/span>\u00a0\u00a0\u00a0\u00a013<\/span><\/span><\/a>
\n<\/span><\/p>\n

InfiniBand Switch Summary<\/span>\u00a0\u00a0\u00a0\u00a014<\/span><\/span><\/a>
\n<\/span><\/p>\n

Maximum Availability Architecture Summary<\/span>\u00a0\u00a0\u00a0\u00a015<\/span><\/span><\/a>
\n<\/span><\/p>\n

Database Server<\/span>\u00a0\u00a0\u00a0\u00a016<\/span><\/strong><\/span><\/a>
\n<\/span><\/p>\n

ASM Check<\/span>\u00a0\u00a0\u00a0\u00a016<\/span><\/span><\/a>
\n<\/span><\/p>\n

All disk groups should have compatible.advm attribute set to recommended values<\/span>\u00a0\u00a0\u00a0\u00a016<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

All disk groups should have compatible.rdbms attribute set to recommended values<\/span>\u00a0\u00a0\u00a0\u00a016<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

One or more disk groups do not have appliance mode attribute set to true<\/span>\u00a0\u00a0\u00a0\u00a017<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

There should be enough freespace in all diskgroups to reestablish redundancy after a single disk failure<\/span>\u00a0\u00a0\u00a0\u00a018<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

ASM Audit file destination file count > 100,000<\/span>\u00a0\u00a0\u00a0\u00a019<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database Check<\/span>\u00a0\u00a0\u00a0\u00a020<\/span><\/span><\/a>
\n<\/span><\/p>\n

Database parameters log_archive_dest_n with Location attribute are NOT all set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a020<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

The bundle patch version installed does not match the bundle patch version registered in the database<\/span>\u00a0\u00a0\u00a0\u00a021<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database control files are not configured as recommended<\/span>\u00a0\u00a0\u00a0\u00a022<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter CLUSTER_INTERCONNECTS is NOT set to the recommended value<\/span>\u00a0\u00a0\u00a0\u00a023<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter Db_create_online_log_dest_n is not set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a025<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database should not be in DST upgrade state<\/span>\u00a0\u00a0\u00a0\u00a025<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

OS Check<\/span>\u00a0\u00a0\u00a0\u00a027<\/span><\/span><\/a>
\n<\/span><\/p>\n

One or more non-default AWR baselines should be created<\/span>\u00a0\u00a0\u00a0\u00a027<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Exadata Storage Server GI software version does not meet requirement for rolling cell patching<\/span>\u00a0\u00a0\u00a0\u00a027<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Active system values should match those defined in configuration file “cell.conf”<\/span>\u00a0\u00a0\u00a0\u00a028<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

CRS_LIMIT_NPROC should be greater than 65535 and not “UNLIMITED”<\/span>\u00a0\u00a0\u00a0\u00a029<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

CSS misscount should be set to the recommended value of 60<\/span>\u00a0\u00a0\u00a0\u00a030<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

The CRS_HOME should be properly locked.<\/span>\u00a0\u00a0\u00a0\u00a031<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Hidden database initialization parameters should be set per best practice recommendations<\/span>\u00a0\u00a0\u00a0\u00a032<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

One or more database servers have stateful alerts that have not been cleared<\/span>\u00a0\u00a0\u00a0\u00a032<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

The InfiniBand Address Resolution Protocol (ARP) Configuration on Database Servers should be as recommended<\/span>\u00a0\u00a0\u00a0\u00a033<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Oracle Enterprise Linux 5 rpms are installed on Oracle Enterprise Linux 6<\/span>\u00a0\u00a0\u00a0\u00a037<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

The database server file systems should have “Check interval” = “0”<\/span>\u00a0\u00a0\u00a0\u00a038<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

The database server file systems should have “Maximum mount count” = “-1”<\/span>\u00a0\u00a0\u00a0\u00a039<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter _enable_NUMA_support should be set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a040<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter db_recovery_file_dest_size is NOT set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a041<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Operating system hugepages count does not satisfy total SGA requirements<\/span>\u00a0\u00a0\u00a0\u00a042<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Number of SCAN listeners is NOT equal to the recommended number of 3<\/span>\u00a0\u00a0\u00a0\u00a043<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

System model number is not correct<\/span>\u00a0\u00a0\u00a0\u00a043<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Downdelay attribute is not set to recommended value on bonded client interface<\/span>\u00a0\u00a0\u00a0\u00a044<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

One or more Ethernet network cables are not connected<\/span>\u00a0\u00a0\u00a0\u00a048<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

_reconnect_to_cell_attempts parameter in cellinit.ora is not set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a049<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

PGA allocation for all databases is more than total memory available on this system<\/span>\u00a0\u00a0\u00a0\u00a050<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

SQL Check<\/span>\u00a0\u00a0\u00a0\u00a051<\/span><\/span><\/a>
\n<\/span><\/p>\n

Some data or temp files are not autoextensible<\/span>\u00a0\u00a0\u00a0\u00a051<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Application objects were found to be invalid<\/span>\u00a0\u00a0\u00a0\u00a051<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

SYS or SYSTEM objects were found to be INVALID<\/span>\u00a0\u00a0\u00a0\u00a052<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Table AUD$[FGA_LOG$] should use Automatic Segment Space Management<\/span>\u00a0\u00a0\u00a0\u00a053<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

SQL Parameter Check<\/span>\u00a0\u00a0\u00a0\u00a054<\/span><\/span><\/a>
\n<\/span><\/p>\n

ASM parameter ASM_POWER_LIMIT is not set to the default value.<\/span>\u00a0\u00a0\u00a0\u00a054<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

ASM parameter AUDIT_SYS_OPERATIONS should be set to the recommended value<\/span>\u00a0\u00a0\u00a0\u00a055<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter AUDIT_SYS_OPERATIONS should be set to the recommended value<\/span>\u00a0\u00a0\u00a0\u00a056<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter AUDIT_TRAIL should be set to the recommended value<\/span>\u00a0\u00a0\u00a0\u00a057<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter OS_AUTHENT_PREFIX is NOT set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a057<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter PARALLEL_ADAPTIVE_MULTI_USER is not set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a058<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter PARALLEL_THREADS_PER_CPU is not set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a059<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter SQL92_SECURITY is NOT set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a060<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter USE_LARGE_PAGES is not set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a060<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

filesystemio_options is not set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a061<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter _parallel_adaptive_max_users is not set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a062<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter _SMM_AUTO_MAX_IO_SIZE should be set to the recommended value<\/span>\u00a0\u00a0\u00a0\u00a063<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Storage Server<\/span>\u00a0\u00a0\u00a0\u00a064<\/span><\/strong><\/span><\/a>
\n<\/span><\/p>\n

Storage Server Check<\/span>\u00a0\u00a0\u00a0\u00a064<\/span><\/span><\/a>
\n<\/span><\/p>\n

Hardware and firmware profile check not is successful on one or more storage servers<\/span>\u00a0\u00a0\u00a0\u00a064<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Storage Server alerts are not configured to be sent via email<\/span>\u00a0\u00a0\u00a0\u00a065<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

One or more storage servers have stateful alerts that have not been cleared<\/span>\u00a0\u00a0\u00a0\u00a066<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

One or more storage server has non-test stateless alerts with null “examinedby” fields.<\/span>\u00a0\u00a0\u00a0\u00a066<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Active system values should match those defined in configuration file “cell.conf”<\/span>\u00a0\u00a0\u00a0\u00a067<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

RAID controller version does not match on all storage servers<\/span>\u00a0\u00a0\u00a0\u00a069<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

ILOM Power Up Configuration for HOST_LAST_POWER_STATE should be set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a069<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Management network is not separate from data network on all storage servers<\/span>\u00a0\u00a0\u00a0\u00a070<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Cluster Wide<\/span>\u00a0\u00a0\u00a0\u00a072<\/span><\/strong><\/span><\/a>
\n<\/span><\/p>\n

Cluster Wide Check<\/span>\u00a0\u00a0\u00a0\u00a072<\/span><\/span><\/a>
\n<\/span><\/p>\n

Localtime configuration does not match on all Infiniband switches<\/span>\u00a0\u00a0\u00a0\u00a072<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

NTP server does not match across all database and storage servers<\/span>\u00a0\u00a0\u00a0\u00a073<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

InfiniBand Switch<\/span>\u00a0\u00a0\u00a0\u00a074<\/span><\/strong><\/span><\/a>
\n<\/span><\/p>\n

InfiniBand Switch Check<\/span>\u00a0\u00a0\u00a0\u00a074<\/span><\/span><\/a>
\n<\/span><\/p>\n

Hostname is not set in \/etc\/hosts<\/span>\u00a0\u00a0\u00a0\u00a074<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Maxinum Availability Architecture<\/span>\u00a0\u00a0\u00a0\u00a075<\/span><\/strong><\/span><\/a>
\n<\/span><\/p>\n

MAA Check<\/span>\u00a0\u00a0\u00a0\u00a075<\/span><\/span><\/a>
\n<\/span><\/p>\n

Redo log files should be appropriately sized<\/span>\u00a0\u00a0\u00a0\u00a075<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Local archive destination does not alternate destination configured<\/span>\u00a0\u00a0\u00a0\u00a077<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Exadata Critical Issues (Doc ID 1270094.1):- DB1-DB4,DB6,DB9-DB35, EX1-EX21, EX23-EX26,EX29 and IB1-IB3,IB5<\/span>\u00a0\u00a0\u00a0\u00a079<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

The SYS and SYSTEM user ids should have a default tablespace of SYSTEM<\/span>\u00a0\u00a0\u00a0\u00a086<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

RMAN controlfile autobackup should be set to ON<\/span>\u00a0\u00a0\u00a0\u00a087<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter DB_LOST_WRITE_PROTECT is NOT set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a088<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

Database parameter LOG_BUFFER is NOT set to recommended value<\/span>\u00a0\u00a0\u00a0\u00a089<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

fast_start_mttr_target should be greater than or equal to 300<\/span>\u00a0\u00a0\u00a0\u00a089<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

The data files should be recoverable<\/span>\u00a0\u00a0\u00a0\u00a090<\/span><\/em><\/span><\/a>
\n<\/span><\/p>\n

\uc81c\ubaa91 : Ctrl + 1
\n<\/span><\/p>\n

\uc81c\ubaa92 : Ctrl + 2 (\uc81c\ubaa92\uc704Bar)
\n<\/span><\/p>\n

\uc81c\ubaa92 : Ctrl + Shift + 2 (\uc81c\ubaa92 Title)
\n<\/span><\/p>\n

\uc81c\ubaa93 : Ctrl + 3 (\ubc11\uc904)
\n<\/span><\/p>\n

\uc81c\ubaa94 : Ctrl + 4 (\ub124\ubaa8 \uc810)
\n<\/span><\/p>\n

\uc81c\ubaa95 : Ctrl + 5 (\ub3d9\uadf8\ub77c\ubbf8 \uc810)
\n<\/span><\/p>\n

\uc81c\ubaa96 : Ctrl + 6 (>)
\n<\/span><\/p>\n

\uc81c\ubaa97 : Ctrl + 7 (\uacb0\ub860\ubd80\ubd84 \uc81c\ubaa9. \ub124\ubaa8)
\n<\/span><\/p>\n

\ubcf8\ubb381 : Alt + 1
\n<\/span><\/p>\n

\ubcf8\ubb382 : Alt + 2
\n<\/span><\/p>\n

\ubcf8\ubb382 : Alt + Shift + 2 (\ud30c\ub780\uc0c9 \uacb0\ub860\uc124\uba85)
\n<\/span><\/p>\n

\ubcf8\ubb383 : Alt + 3
\n<\/span><\/p>\n

\ubcf8\ubb384 : Alt + 4
\n<\/span><\/p>\n

\ubcf8\ubb385 : Alt + 5 (\uc791\uc740\uae00)
\n<\/span><\/p>\n

\ubcf8\ubb386 : Alt + 6 (\uc791\uc740\uae00, \ud68c\uc0c9\ubc14\ud0d5)
\n<\/span><\/p>\n

\ubcf8\ubb38-\uae00\uaf34\uc0c9\ub9cc \ubc14\ub2e4\uc0c9\uc73c\ub85c : Alt + 8
\n<\/span><\/p>\n

\ubcf8\ubb38-\uc228\uae40\uae00 : Alt + 9 (Word\uc5d0\uc11c\ub9cc \ubcf4\uc784)
\n<\/span><\/p>\n

\ubcf8\ubb38SQL : Alt + 0 ( Full Line Small Fixed Font)
\n<\/span><\/p>\n

Document Control
\n<\/strong><\/span><\/p>\n

Change Record
\n<\/strong><\/span><\/p>\n

\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n
\n

Date<\/span><\/p>\n<\/td>\n

\n

Author<\/span><\/p>\n<\/td>\n

\n

Version<\/span><\/p>\n<\/td>\n

\n

Change Reference<\/span><\/p>\n<\/td>\n<\/tr>\n

<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Document Guide
\n<\/strong><\/span><\/p>\n

Considerations
\n<\/strong><\/span><\/p>\n

\ubcf8 \ubb38\uc11c\ub294 \uc791\uc131 \ub2f9\uc2dc\uc758 \uad8c\uc7a5 \uc0ac\ud56d\uc744 \ubc14\ud0d5\uc73c\ub85c Exachk \uc218\ud589\uc2dc \ub098\ud0c0\ub098\ub294 \uc810\uac80 \uacb0\uacfc\uc5d0 \ub300\ud55c \ubd84\uc11d \uacb0\uacfc \uc0d8\ud50c\uc744 \uc791\uc131 \ud588\uc73c\ubbc0\ub85c \uc774\ud6c4 \ub610\ub294 \uc2e0\uaddc Exachk\ub85c \uc218\ud589\uc2dc \uad8c\uc7a5 \uc0ac\ud56d\uc774 \ubcc0\uacbd\ub420 \uc218 \uc788\uaca0\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\ubd84\uc11d \uacb0\uacfc \uc791\uc131\uc2dc \ubcf8 \ubd84\uc11d \uc0d8\ud50c\uc744 \ud65c\uc6a9\ud558\ub418 \uad8c\uc7a5\uc0ac\ud56d\uc774 \ubcc0\uacbd\ub41c \ubd80\ubd84\uc774 \uc788\ub294\uc9c0 \uad00\ub828 \ubb38\uc11c\ub97c \ud655\uc778\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.
\n<\/span><\/p>\n

Database Server Summary
\n<\/span><\/h2>\n
\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\ubd84\ub958<\/strong><\/span><\/td>\n\uc810\uac80 \uba54\uc2dc\uc9c0<\/strong><\/span><\/td>\n\uc810\uac80\ub0b4\uc6a9<\/strong><\/span><\/td>\n\n

\ub300\uc0c1<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

ASM Check<\/span><\/td>\nAll disk groups should have compatible.advm attribute set to recommended values<\/span><\/td>\nASM Diskgroup \uc18d\uc131 \uccb4\ud06c<\/span><\/td>\nAll ASM Instances<\/span><\/td>\n<\/tr>\n
ASM Check<\/span><\/td>\nAll disk groups should have compatible.rdbms attribute set to recommended values<\/span><\/td>\nASM Diskgroup \uc18d\uc131 \uccb4\ud06c<\/span><\/td>\nAll ASM Instances<\/span><\/td>\n<\/tr>\n
ASM Check<\/span><\/td>\nOne or more disk groups do not have appliance mode attribute set to true<\/span><\/td>\nASM Diskgroup \uc18d\uc131 \uccb4\ud06c<\/span><\/td>\nAll ASM Instances<\/span><\/td>\n<\/tr>\n
ASM Check<\/span><\/td>\nThere should be enough freespace in all diskgroups to reestablish redundancy after a single disk failure<\/span><\/td>\nASM \uc794\uc5ec \uc6a9\ub7c9 \uccb4\ud06c<\/span><\/td>\nAll ASM Instances<\/span><\/td>\n<\/tr>\n
ASM Check<\/span><\/td>\nASM Audit file destination file count > 100,000<\/span><\/td>\nAudit file \uce74\uc6b4\ud2b8 \uccb4\ud06c<\/span><\/td>\nAll ASM Instances<\/span><\/td>\n<\/tr>\n
Database Check<\/span><\/td>\nDatabase parameters log_archive_dest_n with Location attribute are NOT all set to recommended value<\/span><\/td>\nDB archivelog \uad6c\uc131 \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
Database Check<\/span><\/td>\nThe bundle patch version installed does not match the bundle patch version registered in the database<\/span><\/td>\nDB BP \ubc84\uc804 \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
Database Check<\/span><\/td>\nDatabase control files are not configured as recommended<\/span><\/td>\nDB Controfile \uad6c\uc131 \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
Database Check<\/span><\/td>\nDatabase parameter CLUSTER_INTERCONNECTS is NOT set to the recommended value<\/span><\/td>\nDB Interconnect \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
Database Check<\/span><\/td>\nDatabase parameter Db_create_online_log_dest_n is not set to recommended value<\/span><\/td>\nDB Redolog \uad6c\uc131 \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
Database Check<\/span><\/td>\nDatabase should not be in DST upgrade state<\/span><\/td>\nDB State \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nOne or more non-default AWR baselines should be created<\/span><\/td>\nAWR baseline \uc874\uc7ac\uc5ec\ubd80 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nExadata Storage Server GI software version does not meet requirement for rolling cell patching<\/span><\/td>\nCell Rolling \ud328\uce58 \uc870\uac74 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nActive system values should match those defined in configuration file “cell.conf”<\/span><\/td>\nCell.conf\uc640 \uc2e4\uc81c \uad6c\uc131 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nCRS_LIMIT_NPROC should be greater than 65535 and not “UNLIMITED”<\/span><\/td>\nCRS \ud30c\ub77c\uba54\ud130 \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nCSS misscount should be set to the recommended value of 60<\/span><\/td>\nCRS \ud30c\ub77c\uba54\ud130 \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nThe CRS_HOME should be properly locked.<\/span><\/td>\nCRS_HOME \uc5d4\uc9c4 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nHidden database Initialization Parameter usage is not correct for \u2026<\/span><\/td>\nDB \uad8c\uc7a5 \ud788\ub4e0 \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nOne or more database servers have stateful alerts that have not been cleared<\/span><\/td>\nDB\uc11c\ubc84 stateful alert \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nThe InfiniBand Address Resolution Protocol (ARP) Configuration on Database Servers should be as recommended<\/span><\/td>\nIB ARP \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nOracle Enterprise Linux 5 rpms are installed on Oracle Enterprise Linux 6<\/span><\/td>\nOS RPM \ubc84\uc804 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nThe database server file systems should have “Check interval” = “0”<\/span><\/td>\nOS \ub514\ubc14\uc774\uc2a4 \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nThe database server file systems should have “Maximum mount count” = “-1”<\/span><\/td>\nOS \ub514\ubc14\uc774\uc2a4 \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nDatabase parameter _enable_NUMA_support should be set to recommended value<\/span><\/td>\nOS\uc5f0\uacc4 DB \uad8c\uc7a5 \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nDatabase parameter db_recovery_file_dest_size is NOT set to recommended value<\/span><\/td>\nOS\uc5f0\uacc4 DB \uad8c\uc7a5 \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nOperating system hugepages count does not satisfy total SGA requirements<\/span><\/td>\nOS\uc758 Hugepage \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nNumber of SCAN listeners is NOT equal to the recommended number of 3.<\/span><\/td>\nSCAN \ub9ac\uc2a4\ub108 \uad6c\uc131 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nSystem model number is not correct<\/span><\/td>\nSystem \ubaa8\ub378\ubc88\ud638 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nDowndelay attribute is not set to recommended value on bonded client interface<\/span><\/td>\n\ub124\ud2b8\uc6cd \uc778\ud130\ud398\uc774\uc2a4 \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nOne or more Ethernet network cables are not connected.<\/span><\/td>\n\ub124\ud2b8\uc6cd \ucf00\uc774\ube14 \uc0c1\ud0dc \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\n_reconnect_to_cell_attempts parameter in cellinit.ora is not set to recommended value<\/span><\/td>\nCell\uc11c\ubc84 \uad6c\uc131 \uc815\ubcf4 \ud30c\uc77c \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nPGA allocation for all databases is more than total memory available on this system<\/span><\/td>\nPGA \uba54\ubaa8\ub9ac \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
SQL Check<\/span><\/td>\nSome data or temp files are not autoextensible<\/span><\/td>\nDB \ub370\uc774\ud130\ud30c\uc77c \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
SQL Check<\/span><\/td>\nApplication objects were found to be invalid<\/span><\/td>\nDB \uc624\ube0c\uc81d\ud2b8 \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
SQL Check<\/span><\/td>\nSYS or SYSTEM objects were found to be INVALID<\/span><\/td>\nDB \uc624\ube0c\uc81d\ud2b8 \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
SQL Check<\/span><\/td>\nTable AUD$[FGA_LOG$] should use Automatic Segment Space Management for \u2026<\/span><\/td>\nDB \uc624\ube0c\uc81d\ud2b8 \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nASM parameter ASM_POWER_LIMIT is not set to the default value.<\/span><\/td>\nASM \ud30c\ub77c\uba54\ud130 \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nASM parameter AUDIT_SYS_OPERATIONS should be set to the recommended value<\/span><\/td>\nASM \ud30c\ub77c\uba54\ud130 \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nDatabase parameter AUDIT_SYS_OPERATIONS should be set to the recommended value<\/span><\/td>\nDB Audit \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nDatabase parameter AUDIT_TRAIL should be set to the recommended value<\/span><\/td>\nDB Audit \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nDatabase parameter OS_AUTHENT_PREFIX is not set to recommended value<\/span><\/td>\nDB \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nDatabase parameter PARALLEL_ADAPTIVE_MULTI_USER is not set to recommended value<\/span><\/td>\nDB \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nDatabase parameter PARALLEL_THREADS_PER_CPU is not set to recommended value<\/span><\/td>\nDB \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nDatabase parameter sql92_security is not set to recommended value<\/span><\/td>\nDB \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nDatabase parameter USE_LARGE_PAGES is NOT set to recommended value<\/span><\/td>\nDB \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nfilesystemio_options is not set to recommended value<\/span><\/td>\nDB \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nDatabase parameter _parallel_adaptive_max_users is not set to recommended value<\/span><\/td>\nDB \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nDatabase parameter _SMM_AUTO_MAX_IO_SIZE should be set to the recommended value<\/span><\/td>\nDB \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Storage Server Summary
\n<\/span><\/h2>\n
\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n
\ubd84\ub958<\/strong><\/span><\/td>\n\uc810\uac80 \uba54\uc2dc\uc9c0<\/strong><\/span><\/td>\n\uc810\uac80\ub0b4\uc6a9<\/strong><\/span><\/td>\n\n

\ub300\uc0c1<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

Storage Server Check<\/span><\/td>\nHardware and firmware profile check not is successful on one or more storage servers.<\/span><\/td>\nHW & Firmware \ud504\ub85c\ud30c\uc77c \uccb4\ud06c<\/span><\/td>\nAll Storage Servers<\/span><\/td>\n<\/tr>\n
Storage Server Check<\/span><\/td>\nStorage Server alerts are not configured to be sent via email<\/span><\/td>\nEmail Alert \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Storage Servers<\/span><\/td>\n<\/tr>\n
Storage Server Check<\/span><\/td>\nOne or more storage servers have stateful alerts that have not been cleared.<\/span><\/td>\nStateful alert \uccb4\ud06c<\/span><\/td>\nAll Storage Servers<\/span><\/td>\n<\/tr>\n
Storage Server Check<\/span><\/td>\nOne or more storage server has non-test stateless alerts with null “examinedby” fields.<\/span><\/td>\nStateless alert \uccb4\ud06c<\/span><\/td>\nAll Storage Servers<\/span><\/td>\n<\/tr>\n
Storage Server Check<\/span><\/td>\nActive system values should match those defined in configuration file “cell.conf”<\/span><\/td>\nCell.conf\uc640 \uc2e4\uc81c \uad6c\uc131 \uccb4\ud06c<\/span><\/td>\nAll Storage Servers<\/span><\/td>\n<\/tr>\n
Storage Server Check<\/span><\/td>\nRAID controller version does not match on all storage servers<\/span><\/td>\nRAID \ubc84\uc804 \uccb4\ud06c<\/span><\/td>\nAll Storage Servers<\/span><\/td>\n<\/tr>\n
Storage Server Check<\/span><\/td>\nILOM Power Up Configuration for HOST_LAST_POWER_STATE should be set to recommended value<\/span><\/td>\nILOM \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Storage Servers<\/span><\/td>\n<\/tr>\n
Storage Server Check<\/span><\/td>\nManagement network is not separate from data network on all storage servers<\/span><\/td>\n\uad00\ub9ac\ub9dd \ub124\ud2b8\uc6cd \uccb4\ud06c<\/span><\/td>\nAll Storage Servers<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Cluster Wide Summary
\n<\/span><\/h2>\n
\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n
\ubd84\ub958<\/strong><\/span><\/td>\n\uc810\uac80 \uba54\uc2dc\uc9c0<\/strong><\/span><\/td>\n\uc810\uac80 \ub0b4\uc6a9<\/strong><\/span><\/td>\n\ubc1c\uc0dd\ub300\uc0c1<\/strong><\/span><\/td>\n<\/tr>\n
Cluster Wide Check<\/span><\/td>\nLocaltime configuration does not match on all Infiniband switches<\/span><\/td>\nLocaltime \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nCluster Wide<\/span><\/td>\n<\/tr>\n
Cluster Wide Check<\/span><\/td>\nNTP server does not match across all database and storage servers<\/span><\/td>\nNTP \ub3d9\uae30\ud654 \uccb4\ud06c<\/span><\/td>\nCluster Wide<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

InfiniBand Switch Summary
\n<\/span><\/h2>\n
\n\n\n\n\n\n<\/colgroup>\n\n\n\n
\ubd84\ub958<\/strong><\/span><\/td>\n\uc810\uac80 \uba54\uc2dc\uc9c0<\/strong><\/span><\/td>\n\uc810\uac80\ub0b4\uc6a9<\/strong><\/span><\/td>\n\ub300\uc0c1<\/strong><\/span><\/td>\n<\/tr>\n
Cluster Wide Check<\/span><\/td>\nHostname is not set in \/etc\/hosts<\/span><\/td>\nHost \ud30c\uc77c \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Infiniband Switches<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Maximum Availability Architecture Summary
\n<\/span><\/h2>\n
\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n
\ubd84\ub958<\/strong><\/span><\/td>\n\uc810\uac80 \uba54\uc2dc\uc9c0<\/strong><\/span><\/td>\n\uc810\uac80\ub0b4\uc6a9<\/strong><\/span><\/td>\n\n

\ub300\uc0c1<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

Database Check<\/span><\/td>\nRedo log files should be appropriately sized<\/span><\/td>\nRedo log \uc801\uc131 \uc0ac\uc774\uc988 \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
Database Check<\/span><\/td>\nLocal archive destination does not alternate destination configured<\/span><\/td>\nArchive \ub300\uc548 \uacbd\ub85c \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
OS Check<\/span><\/td>\nExadata Critical Issues (Doc ID 1270094.1):- DB1-DB4,DB6,\u2026 <\/span><\/td>\nExadata Critical Issue \uccb4\ud06c<\/span><\/td>\nAll Database Servers<\/span><\/td>\n<\/tr>\n
SQL Check<\/span><\/td>\nThe SYS and SYSTEM user ids should have a default tablespace of SYSTEM<\/span><\/td>\nDB \uc624\ube0c\uc81d\ud2b8 \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
SQL Check<\/span><\/td>\nRMAN controlfile autobackup should be set to ON<\/span><\/td>\nRMAN \uc124\uc815 \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nDatabase parameter DB_LOST_WRITE_PROTECT is NOT set to recommended value<\/span><\/td>\nDB \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nDatabase parameter LOG_BUFFER is NOT set to recommended value<\/span><\/td>\nDB \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nfast_start_mttr_target should be greater than or equal to 300.<\/span><\/td>\nDB \ud30c\ub77c\uba54\ud130 \uccb4\ud06c<\/span><\/td>\nAll Instances<\/span><\/td>\n<\/tr>\n
SQL Parameter Check<\/span><\/td>\nThe data files should be recoverable<\/span><\/td>\nDB \ud30c\uc77c \uccb4\ud06c<\/span><\/td>\nAll Databases<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/a>Database Server
\n<\/strong><\/span><\/p>\n

ASM Check
\n<\/strong><\/span><\/p>\n

All disk groups should have compatible.advm attribute set to recommended values
\n<\/strong><\/span><\/p>\n

ASM<\/span>\uc758<\/span> ACFS <\/span>\uc18d\uc131\uc744<\/span>
\n<\/span>\ud655\uc778\ud568<\/span>
\n<\/span><\/span><\/p>\n

ASM diskgroup\uc758 \ub2e4\uc74c\uc758 \uc124\uc815\uc774 BP\uc640 \uc77c\uce58\ud558\ub294\uc9c0 \ud655\uc778\ud568.
\n<\/span><\/p>\n

* COMPATIBLE.ADVM attribute is set to the Oracle ASM version in use.
\n<\/span><\/p>\n

#\uc124\uc815\ud655\uc778
\n<\/span><\/p>\n

ASM@SQL> col diskgroup for a20
\n<\/span><\/p>\n

col name for a50
\n<\/span><\/p>\n

col value for a20
\n<\/span><\/p>\n

SELECT DG.NAME AS DISKGROUP, SUBSTR(A.NAME,1,40) AS NAME,
\n<\/span><\/p>\n

SUBSTR(A.VALUE,1,24) AS VALUE, READ_ONLY
\n<\/span><\/p>\n

FROM V$ASM_DISKGROUP DG, V$ASM_ATTRIBUTE A
\n<\/span><\/p>\n

WHERE 1=1
\n<\/span><\/p>\n

AND DG.GROUP_NUMBER = A.GROUP_NUMBER
\n<\/span><\/p>\n

AND A.NAME LIKE ‘%advm%’;
\n<\/span><\/p>\n

#\uc124\uc815\ubcc0\uacbd
\n<\/span><\/p>\n

ASM@SQL> alter diskgroup <DG\uba85> set attribute ‘<\uc18d\uc131>’=’ 12.1.0.2.0′ ;
\n<\/span><\/p>\n

=================================================================
\n<\/span><\/p>\n

\uc218\ud589\uacb0\uacfc\uc0d8\ud50c: \ud604\uc7ac \ub2e4\uc74c\uacfc \uac19\uc774 advm \uc124\uc815 \ub418\uc5b4\uc788\uc9c0 \uc54a\uc74c. ACFS\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \uc0c1\uae30\uc640 \uac19\uc774 ADVM \uc18d\uc131\uc744 12.1.0.2.0\uc73c\ub85c \uc124\uc815\ud560\uac83
\n<\/span><\/p>\n

DATA FROM PRODDB01 – ASM DISK GROUP COMPATIBLE.ADVM ATTRIBUTE
\n<\/span><\/p>\n

Oracle Clusterware active version on the cluster is [12.1.0.2.0]
\n<\/span><\/p>\n

None of the diskgroups have compatible.advm attribute set
\n<\/span><\/p>\n

All disk groups should have compatible.rdbms attribute set to recommended values
\n<\/strong><\/span><\/p>\n

ASM<\/span>\uc758<\/span> RDBMS <\/span>\ubc84\uc804<\/span>
\n<\/span>\uc18d\uc131\uc744<\/span>
\n<\/span>\ud655\uc778\ud568<\/span>
\n<\/span><\/span><\/p>\n

ASM diskgroup\uc758 \ub2e4\uc74c\uc758 \uc124\uc815\uc774 BP\uc640 \uc77c\uce58\ud558\ub294\uc9c0 \ud655\uc778\ud568.
\n<\/span><\/p>\n

* COMPATIBLE.RDBMS attribute is set to the minimum Oracle database software version in use.
\n<\/span><\/p>\n

#\uc124\uc815\ud655\uc778
\n<\/span><\/p>\n

ASM@SQL> col diskgroup for a20
\n<\/span><\/p>\n

col name for a50
\n<\/span><\/p>\n

col value for a20
\n<\/span><\/p>\n

SELECT DG.NAME AS DISKGROUP, SUBSTR(A.NAME,1,40) AS NAME,
\n<\/span><\/p>\n

SUBSTR(A.VALUE,1,24) AS VALUE, READ_ONLY
\n<\/span><\/p>\n

FROM V$ASM_DISKGROUP DG, V$ASM_ATTRIBUTE A
\n<\/span><\/p>\n

WHERE 1=1
\n<\/span><\/p>\n

AND DG.GROUP_NUMBER = A.GROUP_NUMBER
\n<\/span><\/p>\n

AND A.NAME LIKE ‘%rdbms%’;
\n<\/span><\/p>\n

#\uc124\uc815\ubcc0\uacbd
\n<\/span><\/p>\n

ASM@SQL> alter diskgroup <DG\uba85> set attribute ‘<\uc18d\uc131>’='<\uac12>’ ;
\n<\/span><\/p>\n

=================================================================
\n<\/span><\/p>\n

\uc218\ud589\uacb0\uacfc\uc0d8\ud50c: \ud604\uc7ac \uc124\uce58 DB\uc758 \ucd5c\uc18c \ubc84\uc804\uc774 12.1.0.2\uc774\ub098 rdbms \ud638\ud658 \ubc84\uc804\uc740 11.2.0.2.0\uc73c\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc74c. 12c DB\ub9cc \uc874\uc7ac\ud558\ubbc0\ub85c \ub2e4\uc74c\uc758 \uc18d\uc131\ub4e4\uc740 \ubaa8\ub450 12.1.0.2.0\uc73c\ub85c \ubcc0\uacbd \ud560\uac83\uc744 \uad8c\uc7a5\ud568
\n<\/span><\/p>\n

DATA FROM PRODDB01 – ASM DISK GROUP COMPATIBLE.RDBMS ATTRIBUTE
\n<\/span><\/p>\n

lowest rdbms version = 121020
\n<\/span><\/p>\n

ASM DATAC1.compatible.rdbms = 11.2.0.2.0
\n<\/span><\/p>\n

ASM DBFS_DG.compatible.rdbms = 11.2.0.2.0
\n<\/span><\/p>\n

ASM RECOC1.compatible.rdbms = 11.2.0.2.0
\n<\/span><\/p>\n

One or more disk groups do not have appliance mode attribute set to true
\n<\/strong><\/span><\/p>\n

ASM Diskgroup<\/span>\uc758<\/span>
\n<\/span>\uc124\uc815\uc744<\/span>
\n<\/span>\ud655\uc778\ud568<\/span>
\n<\/span><\/span><\/p>\n

Exadata\uc758 ASM diskgroup\uc740 ASM \uc791\uc5c5\uc758 \uc548\uc815\uc131, \ubcf4\uc548, \uc131\ub2a5 \ud5a5\uc0c1\uc744 \uc704\ud574 appliance \ubaa8\ub4dc\ub97c TRUE\ub85c \uc124\uc815\ud560 \uac83\uc744 \uad8c\uc7a5\ud568
\n<\/span><\/p>\n

#\uc124\uc815\ud655\uc778
\n<\/span><\/p>\n

ASM@SQL> col diskgroup for a20
\n<\/span><\/p>\n

col name for a50
\n<\/span><\/p>\n

col value for a20
\n<\/span><\/p>\n

SELECT DG.NAME AS DISKGROUP, SUBSTR(A.NAME,1,40) AS NAME,
\n<\/span><\/p>\n

SUBSTR(A.VALUE,1,24) AS VALUE, READ_ONLY
\n<\/span><\/p>\n

FROM V$ASM_DISKGROUP DG, V$ASM_ATTRIBUTE A
\n<\/span><\/p>\n

WHERE 1=1
\n<\/span><\/p>\n

AND DG.GROUP_NUMBER = A.GROUP_NUMBER
\n<\/span><\/p>\n

AND A.NAME LIKE ‘%appliance.mode%’;
\n<\/span><\/p>\n

#\uc124\uc815\ubcc0\uacbd
\n<\/span><\/p>\n

ASM@SQL> alter diskgroup <DG\uba85> set attribute ‘<\uc18d\uc131>’=’TRUE’ ;
\n<\/span><\/p>\n