3
Using Oracle9i on Windows 2000

This chapter highlights differences between Windows 2000 and Windows NT, with emphasis on procedures for common database tasks.

This chapter contains these topics:

• How to Perform Common Tasks in Windows NT and Windows 2000

• Other Differences Between Windows NT and Windows 2000

How to Perform Common Tasks in Windows NT and Windows 2000

Table 3-1 lists common database administration tasks and the tools required to accomplish those tasks in Windows NT and Windows 2000.

Table 3-1  How to Perform Common Tasks in Windows NT and Windows 2000

Task	Windows NT	Windows 2000
Install a domain controller	Windows setup	Active Directory installation wizard from Configure Your Server
Manage user accounts	User Manager Choose Start > Programs > Administrative Tools > User Manager	Active Directory Users & Computers Choose Programs > Administrative Tools > Active Directory
Manage groups	User Manager	Active Directory Users & Computers
Manage computer accounts	Server Manager Choose Start > Programs > Administrative Tools > Server Manager	Active Directory Users & Computers
Add a computer to a domain	Server Manager	Active Directory Users & Computers
Create or manage trust relationships	User Manager	Active Directory Domains & Trusts
Manage account policy	User Manager	Active Directory Users & Computers
Manage user rights	User Manager	Active Directory Users & Computers: Edit the Group Policy object for the domain or organizational unit containing the computers to which the users rights apply.
Manage audit policy	User Manager	Active Directory Users & Computers: Edit the Group Policy object assigned to the Domain Controllers organizational unit.
Set policies on users and computers in a site	System Policy Editor Choose Start > Programs > Administrative Tools > System Policy Editor	Group Policy, accessed through Active Directory Sites & Services
Set policies on users and computers in a domain	System Policy Editor	Group Policy, accessed through Active Directory Users & Computers
Set policies on users and computers in an organizational unit	Not applicable	Group Policy, accessed through Active Directory Users & Computers
Use Security Groups to filter the scope of policy	Not applicable	Edit the permissions entry for Apply Group Policy on the security tab of the Group Policy Object properties sheet
Start Oracle Performance Monitor for Windows NT	Choose Start > Programs > Configuration and Migration Tools > Oracle for Windows NT Performance Monitor	Choose Start > Programs > Configuration and Migration Tools > Oracle for Windows NT Performance Monitor
Access services dialog box	Choose Start > Settings > Control Panel > Services	Choose Start > Settings > Control Panel > Administrative Tools > Services

Other Differences Between Windows NT and Windows 2000

DNS Domain Name

If a Windows 2000 computer is not identified with a DNS domain name, then you will receive the following error message:

Calling query w32RegQueries1.7.0.17.0  RegGetValue
Key = HKEY_LOCAL_MACHINE
SubKey = SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
Value = Domain

Query Exception: GetValueKeyNotFoundException
Query Exception Class: class oracle.sysman.oii.oiil.OiilQueryException
...

Perform the following steps:

1. Choose Start > Control Panel > System > Network Identification > More > Primary DNS.

2. Enter a domain name, for example, us.oracle.com.

Microsoft Management Console

Microsoft Management Console, available in Windows NT as a separate item from Microsoft, is included in Windows 2000.

Enterprise User Authentication

In Windows 2000, enterprise user authentication is enabled by setting the OSAUTH_X509_NAME registry parameter to true on the computer on which the Oracle9i database is running in a Windows 2000 domain. If this parameter is set to false (the default setting) in a Windows 2000 domain, then the Oracle9i database can authenticate the user as an external user (described in Oracle9i Network, Directory, and Security Guide for Windows).

Setting this parameter to true in a Windows NT 4.0 domain does not enable you to use enterprise users.

Raw Partitions

In Windows NT, use Disk Administrator to create the raw partitions required for Oracle Real Application Clusters.

In Windows 2000, use Computer Management to create basic disks (compatible with raw partitions on Windows NT). Choose Start > Programs > Administrative Tools > Computer Management.

Services Autostart

Oracle services autostart on Windows NT 4.0. After upgrading to Windows 2000, you may find that services start but the database does not start.

The solution is to use the ORADIM utility to delete and recreate the services.

To delete an instance using ORADIM, enter:

ORADIM -DELETE -SID SIDA, SIDB, SIDC, ... 
ORADIM -DELETE -SVRC SVRCA, SVRCB, SVRC, ... 

where:

• SIDA, SIDB, SIDC are the values of the SIDs to delete.

• SVRCA, SVRCB, SVRC are the values of the services to delete.

During upgrading, the disk is converted to NTFS 5, and a different access authorization is used. The new services autostart under the same account, but they no longer hold the same Windows permissions as before.