Oracle on Win NT only
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.,
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.
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 ...
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
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
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?
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
Click Here to Expand Forum to Full Width