{"id":303,"date":"2015-01-08T02:49:33","date_gmt":"2015-01-08T02:49:33","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=303"},"modified":"2015-01-08T02:49:33","modified_gmt":"2015-01-08T02:49:33","slug":"crs-timezone-%eb%b3%80%ea%b2%bd-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=303","title":{"rendered":"CRS TIMEZONE \ubcc0\uacbd \ubc29\ubc95"},"content":{"rendered":"

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

\u25cf<\/span> \ud658\uacbd : 11gR2 EE 2node RAC, Solaris11(x86)<\/span><\/p>\n<\/td>\n<\/tr>\n

<\/p>\n

1. CRS
\n configuration <\/span>\uccb4\ud06c<\/span><\/p>\n<\/td>\n<\/tr>\n

<\/p>\n

oracle@srac1:~$
\n srvctl getenv database -d sol11db<\/span><\/p>\n

sol11db: <\/span><\/p>\n

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

oracle@srac1:~$
\n srvctl getenv listener -l LISTENER<\/span><\/p>\n

LISTENER:<\/span><\/p>\n

ORACLE_BASE=\/grid\/app\/grid<\/span><\/p>\n<\/td>\n<\/tr>\n

<\/p>\n

2. <\/span>\ud574\ub2f9 \ud504\ub85c\uc138\uc2a4\uc758 \ud658\uacbd \ubcc0\uc218 \uccb4\ud06c<\/span><\/p>\n<\/td>\n<\/tr>\n

<\/p>\n

oracle@srac1:~$
\n ps -ef|grep pmon<\/span><\/p>\n

    grid 
\n 2479<\/b>     1  
\n 0 05:07:01 ?           0:02
\n asm_pmon_+ASM1<\/span><\/p>\n

  oracle 
\n 3661<\/b>     1  
\n 0 05:13:54 ?           0:03
\n ora_pmon_sol11db1<\/span><\/p>\n

  oracle 17366 17361   0 07:05:30 pts\/1       0:00 grep pmon<\/span><\/p>\n

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

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

oracle@srac1:~$
\n id<\/span><\/p>\n

uid=102(oracle)
\n gid=502(dba)<\/span><\/p>\n

oracle@srac1:~$
\n pargs -e 3661<\/b>|grep ORACLE<\/span><\/p>\n

envp[6]:
\n ORACLE_SPAWNED_PROCESS=1<\/span><\/p>\n

envp[28]:
\n ORACLE_HOME=\/oracle\/app\/product\/11.2.0\/db_1<\/span><\/p>\n

envp[59]:
\n ORACLE_SID=sol11db1 <\/span><\/p>\n

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

grid@srac1:~$ id<\/span><\/p>\n

uid=101(grid) gid=502(dba)<\/span><\/p>\n

grid@srac1:~$ pargs -e 2479<\/b>|grep
\n ORACLE<\/span><\/p>\n

envp[6]: ORACLE_SPAWNED_PROCESS=1<\/span><\/p>\n

envp[28]: ORACLE_HOME=\/grid\/app\/product\/11.2.0\/grid<\/span><\/p>\n

envp[56]: ORACLE_SID=+ASM1<\/span><\/p>\n

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

<\/p>\n

3. TZ <\/span>\ubcc0\uacbd \ud6c4 CRS <\/span>\uc7ac\uc2dc\uc791<\/span><\/p>\n<\/td>\n<\/tr>\n

<\/p>\n

oracle@srac1:~$
\n srvctl setenv database -d sol11db -t ‘TZ=Asia\/Seoul’<\/span><\/p>\n

oracle@srac1:~$
\n srvctl setenv listener -l LISTENER -t ‘TZ=Asia\/Seoul’<\/span><\/p>\n

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

root@srac1:\/grid\/app\/product\/11.2.0\/grid\/bin#
\n .\/crsctl stop crs<\/span><\/p>\n

root@srac1:\/grid\/app\/product\/11.2.0\/grid\/bin#
\n .\/crsctl start crs<\/span><\/p>\n

root@srac2:\/grid\/app\/product\/11.2.0\/grid\/bin#
\n .\/crsctl stop crs<\/span><\/p>\n

root@srac2:\/grid\/app\/product\/11.2.0\/grid\/bin#
\n .\/crsctl start crs<\/span><\/p>\n

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

<\/p>\n

4. <\/span>\ud655\uc778<\/span><\/p>\n<\/td>\n<\/tr>\n

<\/p>\n

oracle@srac1:~$
\n srvctl getenv database -d sol11db<\/span><\/p>\n

sol11db:<\/span><\/p>\n

TZ=Asia\/Seoul<\/span><\/p>\n

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

oracle@srac1:~$
\n srvctl getenv listener -l LISTENER<\/span><\/p>\n

LISTENER:<\/span><\/p>\n

TZ=Asia\/Seoul<\/span><\/p>\n

ORACLE_BASE=\/grid\/app\/grid<\/span><\/p>\n

 <\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/p>\n

<\/p>\n

\ucc38\uace0 : Incorrect SYSDATE shown when
\nconnected via Listener in RAC (<\/a><\/span>\ubb38\uc11c<\/a> ID 1390015.1)<\/a><\/span><\/span><\/b><\/p>\n","protected":false},"excerpt":{"rendered":"","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":[2],"tags":[],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/303"}],"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=303"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/303\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=303"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}