Incorrect SYSDATE shown when connected via Listener in RAC
来源:互联网 发布:python字典增加元素 编辑:程序博客网 时间:2024/05/18 00:50
Oracle Net Services - Version 10.2.0.5 to 11.2.0.3 [Release 10.2 to 11.2]Oracle Database - Enterprise Edition - Version 10.2.0.5 to 11.2.0.3 [Release 10.2 to 11.2]Information in this document applies to any platform.Affected Database: OracleSYMPTOMSIncorrect SYSDATE shown when connected via listener Restart of database and listener did not help OS defined TZ timezone setting is correct, but still not picked up by listenerCAUSE- Listener might have a different Envs variable setting for Timezone - Listener is started by LSNRCTL instead of SRVCTL or vice versa - PMON only reads the OS environment variables when the database is started. If TZ is changed after the database is started PMON will not pick up the changed value.When dynamic database service registration is enabled to a listener, PMON both registers the service name and also the environment variables for the database associated with that service name. This means that connections via the dynamically registered service handler will continue to use the old TZ timezone setting. If the listener is restarted and also has a static service registration, connection via the listener will use the TZ set in the listener until PMON first re-registers the service handler again. When the listener has two service registrations, one static and one dynamic, then the dynamic one will be used.SOLUTIONFor 11.2.0.2 and above the TZ entry in $GRID_HOME/crs/install/s_crsconfig_<nodename>_env.txt sets to correct time zone! This enables resources started under the Grid Infrastructure home (listener, databases) using the timezone set in here and so has no requirement anymore to set TZ for DB and listener via setenv. For more details see: How To Change Timezone for 11gR2 Grid Infrastructure ( Document 1209444.1) 1) Check the environment variables set for database and listener in your CRS configurationsrvctl getenv database -d <dbname>srvctl getenv nodeapps -n <nodename>-- If you are 11.2, then use 'getenv listener' instead of 'getenv nodeapps':srvctl getenv listener2) Check the current environment variables used for PMON and Listener Refer: How to Check the Environment Variables for an Oracle Process Document 373303.13) Compare and if required set the TZ setting with the aboveNote: On HP-UX, if TZ is not present, then the value (default: EST5EDT) contained in /etc/default/tz is used. Also see Document 1209444.1 to check timezone current settings on the OS.4) If required set the correct TZ value for the database via SRVCTL as followssrvctl setenv database -d <dbname> -t 'TZ=<the TZ you want>'srvctl setenv nodeapps -n crmnode1 -t 'TZ=<the TZ you want>'-- If you are 11.2, then use 'setenv listener' instead of 'setenv nodeapps':srvctl setenv listener -l <listenername> -t 'TZ=<the TZ you want>'5) Restart the CRS 6) Start the database instance and listener via SRVCTL.Restarting the database instances will lead to re-registration of the services and the environment variables to the listener.
0 0
- Incorrect SYSDATE shown when connected via Listener in RAC
- Ora-12520 12516 Ora-12520 12516 Received When Listener on Node 1 is Down in RAC Setup
- Use View.isInEditMode() in your custom views to skip code when shown in Eclipse
- Use View.isInEditMode() in your custom views to skip code when shown in Eclipse
- Tip: Use View.isInEditMode() in your custom views to skip code when shown in Eclipse
- Tip: Use View.isInEditMode() in your custom views to skip code when shown in Eclipse
- Tip: Use View.isInEditMode() in your custom views to skip code when shown in Eclipse
- Tip: Use View.isInEditMode() in your custom views to skip code when shown in Eclipse
- Tip: Use View.isInEditMode() in your custom views to skip code when shown in Eclipse
- When many files was in deep directory of eMMC, Nozomi crash when connected to PC
- Use View.isInEditMode() in your custom views to skip code or show sample data when shown in the IDE
- Use View.isInEditMode() in your custom views to skip code or show sample data when shown in the IDE
- 使用eclipse编程出现Use View.isInEditMode() in your custom views to skip code when shown in Eclipse解决方法
- 自定义控件时Use View.isInEditMode() in your custom views to skip code when shown in Eclipse问题
- Use View.isInEditMode() in your custom views to skip code or show sample data when shown in the IDE
- 文献阅读笔记——Object Co-Detection via Efficient Inference in a Fully-Connected CRF
- ORA-12541: TNS: no listener when using Oracle Rac ScanIP for tnsname
- 11.2 RAC: In "crsctl stat res -t" State Details May Be Missing or Incorrect [ID 1086563.1]
- js日期转换
- JQuery中$.ajax()方法参数详解
- 生活物联网如何“接地气”,走进寻常百姓家
- Hadoop2.2.0异常集锦
- json对象转换成json字符串
- Incorrect SYSDATE shown when connected via Listener in RAC
- Linux环境变量PS1配置
- log4j 在android上的使用
- 用户管理1
- Ipad调用Wcf 断点调试Wcf
- 开发指南专题十一:JEECG微云快速开发平台--基础用户权限
- UML中的聚合,关联,泛化等关系
- 的数据库更健康撒地方和卡飓风桑迪健康
- 使用objdump看内核源码