This discussion is archived
1 2 Previous Next 20 Replies Latest reply: Jul 28, 2013 10:12 PM by yxes2013 RSS

Rebuild WinXP oracle services?

yxes2013 Newbie
Currently Being Moderated

HI all,

 

10.2.0.3

 

We have installed a small prod app on winXP desktop with 10.2.0.3 database.

For some reason after some hardware maintenance....the oracle database would not start up

And I found out that all the oracle services was gone? How can this happened?

But the oracle_home and oradata are intact. How can I rebuild the services?

 

Thanks a lot,

 

zxy

  • 1. Re: Rebuild WinXP oracle services?
    sb92075 Guru
    Currently Being Moderated

    Is GOOGLE broken for you again/still??????????????

  • 2. Re: Rebuild WinXP oracle services?
    Aman.... Oracle ACE
    Currently Being Moderated

    yxes2013 wrote:

     

    HI all,

     

    10.2.0.3

     

    We have installed a small prod app on winXP desktop with 10.2.0.3 database.

    For some reason after some hardware maintenance....the oracle database would not start up

    And I found out that all the oracle services was gone? How can this happened?

    But the oracle_home and oradata are intact. How can I rebuild the services?

     

    Thanks a lot,

     

    zxy

    So exactly what you want us to tell you? The services are created when the software is installed. So you must check what has "really" happened ?

     

    Aman....

  • 3. Re: Rebuild WinXP oracle services?
    rp0428 Guru
    Currently Being Moderated

    yxes2013 wrote:

     

    HI all,

     

    10.2.0.3

     

    We have installed a small prod app on winXP desktop with 10.2.0.3 database.

    For some reason after some hardware maintenance....the oracle database would not start up

    And I found out that all the oracle services was gone? How can this happened?

    But the oracle_home and oradata are intact. How can I rebuild the services?

     

    Thanks a lot,

     

    zxy

    Umm - by rebuilding the services?

    >

    Recreate the listener service

    >

    sc create myListenerName binPath= "/myOracleHomePath/BIN/TNSLSNR.exe"
    >

    And then create the database service

    >

    oradim -new -sid mySid -startmode auto

    >

  • 4. Re: Rebuild WinXP oracle services?
    yxes2013 Newbie
    Currently Being Moderated

    Thanks rp

     

     

    But I saw like 5 services associated with my sid PROD. something like em dbconsole,mts recovery, clr agent, scheduler services.

    Is it ok not to create them?

  • 5. Re: Rebuild WinXP oracle services?
    sb92075 Guru
    Currently Being Moderated

    OK by me.

  • 6. Re: Rebuild WinXP oracle services?
    EdStevens Guru
    Currently Being Moderated

    yxes2013 wrote:

     

    HI all,

     

    10.2.0.3

     

    We have installed a small prod app on winXP desktop with 10.2.0.3 database.

     

    So your starting point for this brand new app is a database product that is no longer supported by its vendor, on an OS that is no longer supported by its vendor ....

     

     

    Sweet ....

     

    For some reason after some hardware maintenance....the oracle database would not start up

    And I found out that all the oracle services was gone? How can this happened?

    But the oracle_home and oradata are intact. How can I rebuild the services?

     

    Thanks a lot,

     

    zxy

  • 7. Re: Rebuild WinXP oracle services?
    yxes2013 Newbie
    Currently Being Moderated

    Thanks ed,

     

    I mean it brand new setup to another branch. But the same old apps. only the new branch as "NEW" is what I meant.

     

    By the way, Is it possible that I will create a service not the same as the database name?

     

    For example if the database name is PROD,  Can I create a service named "SERVICE1" or "ED_SERVICE" to be link

    or attached to the "PROD" instance? My point is how does the instance get attached to the service? Or how does it know that the service is "hers"? Is it becuase they have the same name"?

     

    Thankssss so manyyyyyyyyyy

  • 8. Re: Rebuild WinXP oracle services?
    sb92075 Guru
    Currently Being Moderated

    unwilling or incapable to use GOOGLE yourself?

     

     

    http://www.lmgtfy.com/?q=Oracle+oradim

  • 9. Re: Rebuild WinXP oracle services?
    yxes2013 Newbie
    Currently Being Moderated

    Hi Rp,

     

    Your sample above for the SID does not have link to the instance file at oracleHome?

    So, Is it possible that I will create a service not the same as the database name?

     

    For example if the database name is PROD,  Can I create a service named "SERVICE1" or "RP_SERVICE" to be link

    or attached to the "PROD" instance? My point is how does the instance get attached to the service? Or how does it know that the service is "hers"? Is it becuase they have the same name"?

     

    Thankssss so manyyyyyyyyyy

  • 10. Re: Rebuild WinXP oracle services?
    yxes2013 Newbie
    Currently Being Moderated

    I already did that, just want revalidation

  • 11. Re: Rebuild WinXP oracle services?
    sb92075 Guru
    Currently Being Moderated

    Please revalidate that 1+1 = 2, etc.

  • 12. Re: Rebuild WinXP oracle services?
    yxes2013 Newbie
    Currently Being Moderated

    Ok, I give u correct answer for that Thanks for the helpful link.

    Brb I gonna go to work now. Dont respond ne more? As is get unread post again

  • 13. Re: Rebuild WinXP oracle services?
    yxes2013 Newbie
    Currently Being Moderated

    Hi Rp

     

    Recreate the listener service

    >

    create myListenerName binPath= "/myOracleHomePath/BIN/TNSLSNR.exe"

     

     

    There is no create command in windows???

  • 14. Re: Rebuild WinXP oracle services?
    JohnWatson Guru
    Currently Being Moderated

    EdStevens wrote:

     

    So your starting point for this brand new app is a database product that is no longer supported by its vendor, on an OS that is no longer supported by its vendor ....

     

     

    Sweet ....

     

    Can someone explain the repeated references on this forum to database releases being unsupported? Of course we all know that DB10.2 is in extended support at the moment and goes into sustaining support at the end of the month. That means no more patches (not even for regulatory or security reasons). It doesn't mean "unsupported". At least, not to me. 

    I hope no-one will take this the wrong way: I am just asking what they mean by it.

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points