Re: NT vs. Unix????

On Tue, 02 Dec 1997 21:46:52 GMT, gedau_at_isa.mim.com.au (George Dau) wrote:

>hboswell_at_lance.netdoor.com (Harry Boswell) wrote:
>
>]Apologies if this has been asked to death, but I've been out of
>]the Oracle orbit for the past couple of years. I've used Oracle
>]versions 4, 5, 6, and 7, all on Unix machines. I'm now looking at
>]a new Oracle implementation, supporting up to possibly 250 or so
>]users, that may be on Unix or NT. Are there any red flags about NT?
>]Is the DBA's job significantly different on NT? Any advice or
>]general comments are most welcome.
>]
>
>The main difference I felt was the loss of unix scripts and the unix tools. I
>did install the Cygnus tools for NT, this helped but its just not all there. The
>Cygnus tools are also slow. http://www.cygnus.com
>
>Oracle also runs much slower on our NT box than on the Suns. We will have to
>upgrade the NT box soon to get better performance. Make sure you have room to
>upgrade in your NT hardware.
>
>At the moment I can't remotely DBA the NT instance. I think all I need to do is
>install server manager and the rest on my NT PC here. How does that work from a
>remote unix box (at home)? With the Unix instances I can telnet to the boxes and
>easily DBA them from home. I haven't worked out how I'm going to do this with
>the NT instance yet. (I have only very recently been involved with the NT
>instance).

You should be able to administer the NT instance from unix. You need to do the following:

1. Create a password file with orapwd (or whatever NT calls it) on the NT box. Set it to "oraclent" for this example. I don't know the name of this file for NT. On unix it would be $ORACLE_HOME/dbs/orapw$ORACLE_SID
2. Set remote_login_passwordfile = exclusive in the NT instances init.ora file
3. bounce the NT instance
4. Copy the NT init.ora file to your unix box. Call it initNT.ora for this example.
5. Add an entry in TNSNAMES.ORA on the unix box for the NT instance. Call it NT.WORLD for this example.

You can now shutdown and startup the NT instance from unix.

svrmgrl
connect internal/oraclent_at_nt.world
shutdown immediate
startup pfile=initNT.ora
exit

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!