{"id":799,"date":"2015-12-08T04:28:30","date_gmt":"2015-12-08T04:28:30","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=799"},"modified":"2015-12-08T04:28:30","modified_gmt":"2015-12-08T04:28:30","slug":"asm-spfile-%ec%98%ae%ea%b8%b0%eb%8a%94-%eb%b0%a9%eb%b2%95diskgroup-%ea%b0%84-%ec%9d%b4%eb%8f%99","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=799","title":{"rendered":"ASM SPFILE \uc62e\uae30\ub294 \ubc29\ubc95(DISKGROUP \uac04 \uc774\ub3d9)"},"content":{"rendered":"

# \uae30\uc874<\/span> DB\uc5d0\uc11c\ucc98\ub7fc<\/span> Parameter\ud30c\uc77c\uc744<\/span>
\n\t\t\uc0dd\uc131\ud574\uc8fc\uc2dc\uba74<\/span>
\n\t\t\ub429\ub2c8\ub2e4<\/span>.(create pfile from spfile;)\n<\/p>\n

SPFILE\uc774<\/span> 2\uac1c\uc758<\/span> Diskgroup\uc5d0<\/span>
\n\t\t\uadf8\ub300\ub85c<\/span>
\n\t\t\uc874\uc7ac<\/span>
\n\t\t\ud558\ub294\ub370<\/span>
\n\t\t\uc5b4\ub5a4<\/span> SPFILE\uc744<\/span>
\n\t\t\ubcf4\uace0<\/span>
\n\t\t\uc62c\ub77c\uc62c\uc9c0<\/span>
\n\t\t\uad81\uae08\ud558\uc600\ub294\ub370<\/span>\n\t<\/p>\n

\ud14c\uc2a4\ud2b8<\/span>
\n\t\t\uacb0\uacfc<\/span>
\n\t\t\uc0c8\ub85c<\/span>
\n\t\t\uc0dd\uc131\ud574\uc900<\/span>(=\uac00\uc7a5<\/span>
\n\t\t\ucd5c\uadfc\uc5d0<\/span>
\n\t\t\uc0dd\uc131\ub41c<\/span>) SPFILE\uc744<\/span>
\n\t\t\ubc14\ub77c\ubcf4\uace0<\/span> ASM\uc774<\/span> Start \ub418\ub294<\/span>
\n\t\t\uac83\uc73c\ub85c<\/span>
\n\t\t\ubcf4\uc600\uc2b5\ub2c8\ub2e4<\/span>.\n<\/p>\n

Diskgroup \uac04\uc758<\/span>
\n\t\t\uc774\ub3d9\uc774<\/span>
\n\t\t\ud544\uc694\ud560<\/span>
\n\t\t\ub54c<\/span>
\n\t\t\uc801\uc6a9\ud558\uc2dc\uba74<\/span>
\n\t\t\ub429\ub2c8\ub2e4<\/span>.\n<\/p>\n

<\/p>\n

1. ASM \uc811\uc18d\ud558\uc5ec<\/span> SPFILE \uc704\uce58<\/span>
\n\t\t\t\ud655\uc778<\/span><\/p>\n

[oracle@11g-single-asm ~]$ . oraenv\n<\/p>\n

ORACLE_SID = [SASM1] ? +ASM\n<\/p>\n

The Oracle base has been changed from \/u01\/app\/oracle to \/u01\/app\/grid\n<\/p>\n

[oracle@11g-single-asm ~]$ sqlplus \/ as sysasm\n<\/p>\n

 
\n <\/p>\n

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 4 08:00:53 2015\n<\/p>\n

 
\n <\/p>\n

Copyright (c) 1982, 2013, Oracle. All rights reserved.\n<\/p>\n

 
\n <\/p>\n

 
\n <\/p>\n

Connected to:\n<\/p>\n

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production\n<\/p>\n

With the Automatic Storage Management option\n<\/p>\n

 
\n <\/p>\n

SQL> show parameter spfile\n<\/p>\n

 
\n <\/p>\n

NAME TYPE VALUE\n<\/p>\n

———————————— ———– ——————————\n<\/p>\n

spfile string +CRS\/asm\/asmparameterfile\/regi\n<\/p>\n

stry.253.894893135\n<\/p>\n

   <\/p>\n

2. SPFILE\uc744<\/span> PFILE\ub85c<\/span>
\n\t\t\t\ub9cc\ub4e4\uc5b4<\/span> LOCAL\uc5d0<\/span>
\n\t\t\t\uc800\uc7a5<\/span><\/p>\n

SQL> create pfile=’\/tmp\/pfile+ASM.ora’ from spfile;\n<\/p>\n

 
\n <\/p>\n

File created.\n<\/p>\n

<\/p>\n

3. PFILE\uc744<\/span>
\n\t\t\t\uc774\uc6a9\ud558\uc5ec<\/span> SPFILE\uc744<\/span> ASM\uc601\uc5ed\uc5d0<\/span>
\n\t\t\t\uc0dd\uc131<\/span><\/p>\n

SQL> create spfile=’+DATA’ from pfile=’\/tmp\/pfile+ASM.ora’;\n<\/p>\n

 
\n <\/p>\n

File created.\n<\/p>\n

 
\n <\/p>\n

SQL> exit\n<\/p>\n

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production\n<\/p>\n

With the Automatic Storage Management option\n<\/p>\n

<\/p>\n

4. HAS(or CRS) \uc7ac\uae30\ub3d9<\/span><\/p>\n

[oracle@11g-single-asm ~]$ su –\n<\/p>\n

\uc554\ud638<\/span>:\n<\/p>\n

[root@11g-single-asm ~]# cd \/u01\/app\/grid\/product\/11.2.0.4\/grid\/bin\/\n<\/p>\n

[root@11g-single-asm bin]# .\/crsctl stop has\n<\/p>\n

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ’11g-single-asm’\n<\/p>\n

CRS-2673: Attempting to stop ‘ora.CRS.dg’ on ’11g-single-asm’\n<\/p>\n

CRS-2673: Attempting to stop ‘ora.racdb.db’ on ’11g-single-asm’\n<\/p>\n

CRS-2673: Attempting to stop ‘ora.LISTENER.lsnr’ on ’11g-single-asm’\n<\/p>\n

CRS-2677: Stop of ‘ora.racdb.db’ on ’11g-single-asm’ succeeded\n<\/p>\n

CRS-2673: Attempting to stop ‘ora.DATA.dg’ on ’11g-single-asm’\n<\/p>\n

CRS-2677: Stop of ‘ora.DATA.dg’ on ’11g-single-asm’ succeeded\n<\/p>\n

CRS-2677: Stop of ‘ora.LISTENER.lsnr’ on ’11g-single-asm’ succeeded\n<\/p>\n

CRS-2677: Stop of ‘ora.CRS.dg’ on ’11g-single-asm’ succeeded\n<\/p>\n

CRS-2679: Attempting to clean ‘ora.CRS.dg’ on ’11g-single-asm’\n<\/p>\n

CRS-2681: Clean of ‘ora.CRS.dg’ on ’11g-single-asm’ succeeded\n<\/p>\n

CRS-2673: Attempting to stop ‘ora.asm’ on ’11g-single-asm’\n<\/p>\n

CRS-2677: Stop of ‘ora.asm’ on ’11g-single-asm’ succeeded\n<\/p>\n

CRS-2673: Attempting to stop ‘ora.cssd’ on ’11g-single-asm’\n<\/p>\n

CRS-2677: Stop of ‘ora.cssd’ on ’11g-single-asm’ succeeded\n<\/p>\n

CRS-2673: Attempting to stop ‘ora.evmd’ on ’11g-single-asm’\n<\/p>\n

CRS-2677: Stop of ‘ora.evmd’ on ’11g-single-asm’ succeeded\n<\/p>\n

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ’11g-single-asm’ has completed\n<\/p>\n

CRS-4133: Oracle High Availability Services has been stopped.\n<\/p>\n

[root@11g-single-asm bin]# .\/crsctl start has\n<\/p>\n

CRS-4123: Oracle High Availability Services has been started.\n<\/p>\n

[root@11g-single-asm bin]# exit\n<\/p>\n

Logout\n<\/p>\n

<\/p>\n

5. ASM \uc778\uc2a4\ud134\uc2a4\uc5d0\uc11c<\/span> SPFILE\uc758<\/span>
\n\t\t\t\uc704\uce58<\/span>
\n\t\t\t\ud655\uc778<\/span><\/p>\n

[oracle@11g-single-asm ~]$ echo $ORACLE_SID\n<\/p>\n

+ASM\n<\/p>\n

[oracle@11g-single-asm ~]$ sqlplus \/ as sysasm\n<\/p>\n

 
\n <\/p>\n

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 4 08:15:21 2015\n<\/p>\n

 
\n <\/p>\n

Copyright (c) 1982, 2013, Oracle. All rights reserved.\n<\/p>\n

 
\n <\/p>\n

 
\n <\/p>\n

Connected to:\n<\/p>\n

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production\n<\/p>\n

With the Automatic Storage Management option\n<\/p>\n

 
\n <\/p>\n

SQL> show parameter spfile\n<\/p>\n

 
\n <\/p>\n

NAME TYPE VALUE\n<\/p>\n

———————————— ———– ——————————\n<\/p>\n

spfile string +DATA\/asm\/asmparameterfile\/reg\n<\/p>\n

istry.253.897552133\n<\/p>\n

SQL> select name, state from v$asm_diskgroup;\n<\/p>\n

 
\n <\/p>\n

NAME STATE\n<\/p>\n

—————————— ———–\n<\/p>\n

DATA MOUNTED\n<\/p>\n

CRS MOUNTED\n<\/p>\n

 
\n <\/p>\n

SQL> exit\n<\/p>\n

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production\n<\/p>\n

With the Automatic Storage Management option]<\/span><\/p>\n


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

6. \uae30\uc874<\/span> SPFILE \uc0ad\uc81c<\/span><\/p>\n

[oracle@11g-single-asm ~]$ asmcmd -p\n<\/p>\n

ASMCMD [+] > ls\n<\/p>\n

CRS\/\n<\/p>\n

DATA\/\n<\/p>\n

ASMCMD [+] > cd crs\n<\/p>\n

ASMCMD [+crs] > ls\n<\/p>\n

ASM\/\n<\/p>\n

ASMCMD [+crs] > cd asm\n<\/p>\n

ASMCMD [+crs\/asm] > ls\n<\/p>\n

ASMPARAMETERFILE\/\n<\/p>\n

ASMCMD [+crs\/asm] > cd asmparameterfile\n<\/p>\n

ASMCMD [+crs\/asm\/asmparameterfile] > ls\n<\/p>\n

REGISTRY.253.894893135\n<\/p>\n

ASMCMD [+crs\/asm\/asmparameterfile] > rm REGISTRY.253.894893135\n<\/p>\n

ASMCMD [+crs\/asm\/asmparameterfile] > ls\n<\/p>\n

ASMCMD-8002: entry ‘asm’ does not exist in directory ‘+crs\/’\n<\/p>\n

ASMCMD [+crs\/asm\/asmparameterfile] ><\/p>\n","protected":false},"excerpt":{"rendered":"

# \uae30\uc874 DB\uc5d0\uc11c\ucc98\ub7fc Parameter\ud30c\uc77c\uc744 \uc0dd\uc131\ud574\uc8fc\uc2dc\uba74 \ub429\ub2c8\ub2e4.(create pfile from spfile;) SPFILE\uc774 2\uac1c\uc758 Diskgroup\uc5d0 \uadf8\ub300\ub85c \uc874\uc7ac \ud558\ub294\ub370 \uc5b4\ub5a4 SPFILE\uc744 \ubcf4\uace0 \uc62c\ub77c\uc62c\uc9c0 \uad81\uae08\ud558\uc600\ub294\ub370 \ud14c\uc2a4\ud2b8 \uacb0\uacfc \uc0c8\ub85c \uc0dd\uc131\ud574\uc900(=\uac00\uc7a5 \ucd5c\uadfc\uc5d0 \uc0dd\uc131\ub41c) SPFILE\uc744 \ubc14\ub77c\ubcf4\uace0 ASM\uc774 Start \ub418\ub294 \uac83\uc73c\ub85c \ubcf4\uc600\uc2b5\ub2c8\ub2e4. Diskgroup \uac04\uc758 \uc774\ub3d9\uc774 \ud544\uc694\ud560 \ub54c \uc801\uc6a9\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4. 1. ASM \uc811\uc18d\ud558\uc5ec SPFILE \uc704\uce58 \ud655\uc778 [oracle@11g-single-asm ~]$ . oraenv ORACLE_SID = [SASM1] ? +ASM […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[25],"tags":[72,470,471,472],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/799"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=799"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/799\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=799"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}