CRS TIMEZONE 변경 방법

haisins

10년 ago

● 환경 : 11gR2 EE 2node RAC, Solaris11(x86)

1. CRS
configuration 체크

oracle@srac1:~$
srvctl getenv database -d sol11db

sol11db:

oracle@srac1:~$
srvctl getenv listener -l LISTENER

LISTENER:

ORACLE_BASE=/grid/app/grid

2. 해당 프로세스의 환경 변수 체크

oracle@srac1:~$
ps -ef|grep pmon

    grid
2479     1
0 05:07:01 ?           0:02
asm_pmon_+ASM1

oracle
3661 1
0 05:13:54 ? 0:03
ora_pmon_sol11db1

oracle 17366 17361 0 07:05:30 pts/1 0:00 grep pmon

oracle@srac1:~$
id

uid=102(oracle)
gid=502(dba)

oracle@srac1:~$
pargs -e 3661|grep ORACLE

envp[6]:
ORACLE_SPAWNED_PROCESS=1

envp[28]:
ORACLE_HOME=/oracle/app/product/11.2.0/db_1

envp[59]:
ORACLE_SID=sol11db1

grid@srac1:~$ id

uid=101(grid) gid=502(dba)

grid@srac1:~$ pargs -e 2479|grep
ORACLE

envp[6]: ORACLE_SPAWNED_PROCESS=1

envp[28]: ORACLE_HOME=/grid/app/product/11.2.0/grid

envp[56]: ORACLE_SID=+ASM1

3. TZ 변경 후 CRS 재시작

oracle@srac1:~$
srvctl setenv database -d sol11db -t ‘TZ=Asia/Seoul’

oracle@srac1:~$
srvctl setenv listener -l LISTENER -t ‘TZ=Asia/Seoul’

root@srac1:/grid/app/product/11.2.0/grid/bin#
./crsctl stop crs

root@srac1:/grid/app/product/11.2.0/grid/bin#
./crsctl start crs

root@srac2:/grid/app/product/11.2.0/grid/bin#
./crsctl stop crs

root@srac2:/grid/app/product/11.2.0/grid/bin#
./crsctl start crs