sky's profileDBA日记PhotosBlogListsMore Tools Help
    10/30/2008

    OCM过了

    Dearxxx,
    Congratulations! on the successful completion of the Oracle DBA 10g Certified Master practicum.
    You are now a member of an elite group of Oracle professionals. You will receive your Oracle DBA 10g Certified Master fulfillment kit that includes a congratulations letter, OCM certificate, OCM ID card, and denim OCM shirt to the mailing address mentioned in your Oracle DBA 10g OCM Hands-on course requirement Form.
    Address : xxxxxxxxxxxxxxxx,
    Changchun City Jilin Province
    China
    mobile phone:xxxxxxxxxxx/ (86)0431xxxxxxxx
    Shirt Size: L
    Please feel free to contact the OCP team at ocpexam_ww@oracle.com if you have questions.
    Kind regards,
    Oracle Certification Program

    10/27/2008

    时区引起的agent start failed。

    -bash-2.05b$ ./emctl start agent
    Oracle Enterprise Manager 10g Release 10.2.0.1.0. 
    Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
    Starting agent ..... failed.
    The agentTZRegion value in /u01/app/oracle/OracleHomes/agent10g/sysman/config/emd.properties is not in agreement with what agent thinks it should be.Please verify your environment to make sure that TZ setting has not changed since the last start of the agent.
    If you modified the timezone setting in the environment, please stop the agent and exectute 'emctl resetTZ agent' and also execute the script mgmt_target.set_agent_tzrgn(<agent_name>, <new_tz_rgn>) to get the value propagated to repository.
    Consult the log files in: /u01/app/oracle/OracleHomes/agent10g/sysman/log

    -bash-2.05b$ ./emdctl validateTZ agent PST8PDT
    tzOffset for PST8PDT is -480(min), but agent is runnning with tzOffset -420(min)
    trying again after waiting for 1 sec to account for daylight transition
    tzOffset for PST8PDT is -480(min), but agent is runnning with tzOffset -420(min)

    查看sysman/config/emd.properties里面,时区设置的也是PST8PDT

    可以用这个下面命令解决:

    export TZ=GMT (用MDT也可以,PST8PDT不行,其他没尝试)

    这时emd.properties里面的agentTZRegion=GMT,原先是PST8PDT.
    emctl resetTZ agent
    emctl start agent

    10/14/2008

    ocm考试出师不利

    终于考完了ocm考试了,不过考得并不好
    据老师说,ocm考试做了调整,我们是调整后的全球第一期考生。不知道是不是这个原因,第一天上午一直无法进行考试,下午才开始考,考试一直到晚上10点多才结束。
     
    还是准备不足,在两个最容易的地方出了问题
    1.安装图形界面时,安装程序死掉了,不相应鼠标键盘输入,看日志也没有进展
       监考老师也不能给出解决办法,只是答应向美国那边如实反应情况。
       没办法只好杀掉进程,然后用grid control自带的低版本数据库安装了grid control,但是因为时间很紧张,在收集成绩时,emrep数据库还没有建成。
       这给后续章节带来了隐患,比如后续的传输表空间因为版本兼容性无法完成(exp/expdp都无法完成)
      但是老师说,从采分点来看,这个章节我得了一半以上的分。
    2.在更为容易的data guard章节,又再次遇到故障,图形界面配置dataguard失败。第二次虽然成功了,但是但是在做了一部分题目后,又出现了后台进程异常终止的问题。
    这样,在三个使用图形界面的章节,grid control、rac、data gurad,除了rac完美成功外,其他都不好。
    3.最郁闷的是在dw章节,居然少做了半道题,直到快结束了才发现,最后还是没有完成。不过这个章节其他题目自我感觉还不错。
     
    其他章节感觉还成,但是也有没复习到的,有些没有很好理解题目意图,给的答案并不是最佳方案。
    除了出问题的gc和dg章节,其他章节都在规定时间内完成了