|
● 환경 : 11gR2 EE 2node RAC, Solaris11(x86) |
|
1. CRS |
|
oracle@srac1:~$ sol11db:
oracle@srac1:~$ LISTENER: ORACLE_BASE=/grid/app/grid |
|
2. 해당 프로세스의 환경 변수 체크 |
|
oracle@srac1:~$ grid oracle oracle 17366 17361 0 07:05:30 pts/1 0:00 grep pmon
oracle@srac1:~$ uid=102(oracle) oracle@srac1:~$ envp[6]: envp[28]: envp[59]:
grid@srac1:~$ id uid=101(grid) gid=502(dba) grid@srac1:~$ pargs -e 2479|grep 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:~$ oracle@srac1:~$
root@srac1:/grid/app/product/11.2.0/grid/bin# root@srac1:/grid/app/product/11.2.0/grid/bin# root@srac2:/grid/app/product/11.2.0/grid/bin# root@srac2:/grid/app/product/11.2.0/grid/bin#
|
|
4. 확인 |
|
oracle@srac1:~$ sol11db: TZ=Asia/Seoul
oracle@srac1:~$ LISTENER: TZ=Asia/Seoul ORACLE_BASE=/grid/app/grid
|
참고 : Incorrect SYSDATE shown when
connected via Listener in RAC (문서 ID 1390015.1)