DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Oracle on Win NT only

  1. #1
    Join Date
    Oct 2000
    Posts
    449

    Oracle on Win NT only

    Hello Guys:

    All along I have been working on Oracle on Unix and I am going for a short term project where the environment is Win NT/2000 Server only.

    I need to know some good websites where I can find answers to some situations only happening to NT and some administration issues as well. As well become aware to finding solutions to problems etc.,

    The role would be of a typical DBA along with some disaster recovery planning etc.,

    Thanks, ST2000

  2. #2
    Join Date
    Feb 2003
    Location
    Kolkata, India
    Posts
    33

    Smile

    Sorry mate I don't have any website dealing with ORACLE-Win NT/2000 issues specifically... But I do have some experience in Win NT/2000 platforms.. Guess I can help you resolve some of your more specific OS related issues.

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    some points

    NTFS can allocate more then 2G;
    your database runs in a NT-Service
    see oradim ...
    your dba-group is ORA_DBA
    The sessions are always working as threads ( you see only one oralce.exe in taskmanager )
    and a lot is to configure in the nt-registry like
    TNS_ADMIN, ORACLE_HOME, ORACLE_SID ...

    Orca

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    One important difference in NT cannot write to open files..so for backups you gotta to use ocopy,

    for killing session you need to use orakill at the os level

    learn about ms toolkit

    You can install cygwin and make NT behave as Unix (well sorta of)

    Batch scripting isnt as rich Unix shell scripting

    Learn how to use Oradim

    And windows if you want to start a database the oracle service has to be up n running

    windows does not have a mailx utility ..but you can download blat search for it on google..

    And the most important thing..when all else fails JUST REBOOT THE SERVER..AND EVERYTHING WILL START WORKIN FINE..(I DONT KNOW WHY THIS IS ALWAYS TRUE)and this can be a differentiating factor when you come from a Unix background

    regards
    Hrishy

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    i recall that there is a key to add to the registry on win machines that stops the o/s from updating the last modified flag on files -- it's a performance thing. Can't remember it, though there are quite a few web pags out there covering oracle on win machines -- google is a good starting point
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Oct 2000
    Posts
    449
    Good Information guys..

    Thanks a lot.. I definitely came to know a lot more things from the responses on NT and I need to have a different thinking attitude now I suppose that makes me little odd..

    How about disaster recovery strategies on Win NT/2000 adv server systems? Where could I start looking out, as that will be the area where I will be landing into in my first week.. plus system administration on NT...

    I have been working with RAID 1 (Mirroring and duplexing) for all our production instances, with usual backup and recovery strategies. How feasible is Replication or any other good alternatives at db level.. OR is it better to stick with System level for the same?

    Thanks, ST2000

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    For disaster recovery..I dont really recommend replication..replication is okay if there one or two tables and these undergo some small changes which needs to be available at the other site..You should be looking at Oracle Data gaurd or Oracle standby for disaster recovery..just make sure that the two primary and secondary are at different sites..I maybe wrong here but some of the other DBA's may come up with other ideas perhaps

    For system administration you can look for

    http://www.sysinternals.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width