angelagod小江's profile小江的魔法树屋PhotosBlogLists Tools Help

Blog


    November 28

    oracle无法启动的排障过程

      没有类别啊~~先加到everything里面好了
     
      首先万分感谢主管陈大侠拔刀相助!!!拜服一下先。

      资源管理系统的测试服务器,现在跟小朋的某个系统测试SERVER共用一台机。前两个星期,小朋跟厂家在上面装了sybase之后,不知什么原因,oracle数据库竟然无法启动了。在管理工具->服务里启动oracle服务时,出现报错。
     
      而使用oracle服务时(比如试用lsnrctl,比如启用enterprise console),会报错说程序无法找到msvcrt.dll
     
      陈大侠一语中的地说:要么是指向DLL文件的路径有问题,要么是DLL文件本身有问题

    我们先试着检查PATH

      右键点击“我的电脑”,在“系统特性”中选择“高级”选项卡,再点击“环境变量”按键,找到“系统变量”的PATH,进行编辑。发现里面当时好像只有sybase相关的变量。
     
      于是在自己本机上,找到同样的环境变量值,把跟oracle、java相关的路径信息取出来,修改成服务器上的实际路径,然后附加在原来的PATH后面。
      进入DOS命令行,使用命令echo %PATH%来查看环境变量是否修改成功——发现没有改变????陈大侠说,那是远程登录的关系。
      退出远程桌面,再次连接。PATH果然显示修改成功。

      但再次lsnrctl,还是找不到那个DLL文件。于是基本可以断定是DLL文件出问题了。

    接着,检查修正DLL文件问题

      在WINNT的system32下面找到了DLL文件。一看日期,竟然是两周前???按理说,这里的系统文件的修改日期,应该跟系统安装日期一致才对。于是决定在另找一个正常的DLL文件替换它。
      资源的WEB服务器,跟测试服务器一样都是2000SERVER的系统,可以系统文件互相替换应该不成问题。
      于是我先将原msvcrt.dll改名,再把正常的文件COPY进去。

      再启动,还是有问题????
      十分郁闷的我,只上GOOGLE、BAIDU之。看到一篇帖子里介绍,做一个BAT文件,把改名替换的工作事先用批命令写出来,然后改注册表,让系统一启动就自动替换文件。这样可以避免系统启动后,自动引用这个DLL文件,导致文件无法删除。
      当时我已经成功替换文件了,只是启动程序还是不正常。“会不会重启一下就可以了呢?”我很侥幸地想。然后试着重启系统——竟然OK了哦~~~~~

      万岁~~~~~

    小结:主要还是有高手指引,故障定位准确,这次故障才可以如此神速地解决~~~~
       另,以后一台机上装两种服务甚至两套DB的筒子们,还是要小心为上哦~~


    Comments (8)

    Please wait...
    Sorry, the comment you entered is too long. Please shorten it.
    You didn't enter anything. Please try again.
    Sorry, we can't add your comment right now. Please try again later.
    To add a comment, you need permission from your parent. Ask for permission
    Your parent has turned off comments.
    Sorry, we can't delete your comment right now. Please try again later.
    You've exceeded the maximum number of comments that can be left in one day. Please try again in 24 hours.
    Your account has had the ability to leave comments disabled because our systems indicate that you may be spamming other users. If you believe that your account has been disabled in error please contact Windows Live support.
    Complete the security check below to finish leaving your comment.
    The characters you type in the security check must match the characters in the picture or audio.

    To add a comment, sign in with your Windows Live ID (if you use Hotmail, Messenger, or Xbox LIVE, you have a Windows Live ID). Sign in


    Don't have a Windows Live ID? Sign up

    Oct. 22
    No namewrote:
    To the global wow gold the cheapest wow power leveling under the cheapest single-site!
    Sept. 11
    Sept. 4
    No namewrote:

    Amberdigital Branch,Southern Stars Enterprises Co is specializing in the development and manufacturing of advertisement screens, LCD digital signage and LCD signages. Established in 1996, we have explored and developed the international market with professionalism. We have built a widespread marketing network, and set up a capable management team dedicated to provide beyond-expectation services to our customers.

    amberdigital Contact Us
    Southern Stars Enterprises Co (Shenzhen Office)
    Add:DE, 16/F, Building 2, Nanguo Tower, Sungang Road, Shenzhen, China
    E-mail:sstar@netvigator.com carol@sstar-hk.com
    Tel:+86 755 2592 9100
    Fax:+86 755 2592 7171
    website:http://http://www.amberdigital.com.hk
    alibaba:http://amberdigital.en.alibaba.com[fiacgb

    Aug. 16
    Aug. 8
    No namewrote:
    Welcome to enter (wow gold) and (wow power leveling) trading site, (wow gold) are cheap, (wow power leveling) credibility Very good! Quickly into the next single! Key words directly to the website click on transactions! -189411578274024
    Aug. 7
    July 29
    utopiawrote:
    高手,猛将,太野蛮了。。。
    Nov. 28

    Trackbacks

    The trackback URL for this entry is:
    http://angelagod.spaces.live.com/blog/cns!106179100563428B!789.trak
    Weblogs that reference this entry
    • None