Differences between Oracle on UNIX and Windows2000 partiii

Differences between Oracle on UNIX and Windows2000 III

Ian Adam, SAIC Ltd
David stien, SAIC Ltd
Translation: fenng www.itpub.net
Part III

Oracle Installation
Oracle8i is installed through a new Java-based Oracle universal Installer. The same interface [1 m cyran, 1999] is available on all platforms. The above sentence is correct, but some small differences should be noted. X-compatible display capability is required on UNIX, or an application like exceed is available on the client workstation. You can directly run the installer on Windows.

There are many manually set tasks in UNIX, which are not required in Windows 2000. In particular, you do not have to manually set environment variables. You do not need to generate a Unix DBA group for database management. You do not need to set a UNIX to run Oracle universal installer or an oracle user to install or Upgrade Oracle. In UNIX, Oracle can be reconnected, but not in Windows 2000.

In Windows 2000, you must be a member of the Administrator group to install the database. After the Oracle 8i database is installed, an ora_dba local group is automatically created. Members in this group automatically accept sysdba permissions. We recommend that you install administration assistant for windows during custom installation. Note that only one version of this software can be installed on each server.

Oracle 8.1.7 for Solaris is 2cd. Switching to the second CD is not as easy as described in the Manual. View [10
Metalink, 2001.

For installation instructions on Windows, see [3 Kennedy, 2000]. Oracle universal installer concept guide is not included in the Oracle8i server online document, but is automatically installed on your hard disk during Oracle universal installer installation.

Database Management Assistant on Windows
The Oracle management assistant on Windows is a GUI tool that runs from the Windows built-in MMC (Microsoft Management Console. Oracle's Windows Management Assistant integrates several common database management tasks into a tool. In Windows, you can create database administrators, operators, users, and roles. It can also be used to manage Oracle database services and Oracle Database startup and shutdown settings, edit registry parameter settings, and view Oracle process information.

Automatic task
On UNIX, automatic tasks such as backup are implemented by running shell scripts in cron. Use scheduling tasks on Windows to regularly run batch files. This scheduling is more flexible than the AT scheduling command on the previous Windows NT. It allows a task with a user context rather than a system user to run, and it allows permissions on the task. The batch processing script language is very restrictive, so it is worth a good look at Perl [9 o'reilly, 2000]. In Windows 2000, when manual hot backup is run, Oracle provides a command called ocopy to copy files to another disk location, or back up files to tape. Standard Windows commands (such as copy) do not copy an open file (all data files in the database are open ).

Adjustment and Diagnosis
There are very few tools on Windows 2000 to debug the operating system, but we should also talk about something we can do.
The default priority is specified for interactive foreground applications during Windows2000 installation. To prevent foreground applications from occupying additional processor time, affecting the Oracle8i Database and removing its priority, this can be done through advanced options of the system control panel.

In UNIX, the shared memory and semaphore settings usually need to be changed through/etc/system. This is not necessary on Windows 2000 and is not easy to change.

Oracle Performance Monitor for Windows is a pre-loaded Oracle8i Database Performance Component of Windows 2000 Performance Monitor. If you don't see these things, try this command to change the performance monitor settings:

Operfcfg-U System-P Manager-D ATEi

Windows NT's Oracle Performance Monitor allows you to monitor only one database instance at a time. The preceding commands can be switched between databases. In Windows 2000, Oracle writes information to the event log like the common alert and trace files, which can be read through the standard event viewer. In Windows 2000, dbverify (DBV) can be used to check online data files, which is the same as that in UNIX. In earlier windows, DBV only worked on closed databases or backup files.

Summary
For an Oracle DBA familiar with Unix, this article describes the main differences between Oracle and Windows 2000. We can see that Oracle has made a lot of efforts to make the oracle on the two platforms as similar as possible, but there is no clear difference yet. This article is worth reading.
 
About the author
David stien and Ian Adam are both Oracle8i certified database administrators working For SAIC's database management practice. they are both based in Aberdeen, Scotland. they are practising DBAs who provide Oracle Database Support and Development Services for customer databases on several different platforms.
Ian is a chartered engineer and Microsoft certified database administrator with over ten years experience of Oracle products. Ian can be reached by email at Ian.Adam@saic.com
David is a chemistry graduate with an MSc in information systems, Linux is his desktop operating system of choice. David can be reached by email at David.Stien@saic.com

Reference

[1] cyran M, "getting to know Oracle8i, Release 2 (8.1.6 )",
Oracle Corporation December 1999, part No. A76962-01

[2] Kelly h iii, Kennedy M, Rothenberg T, Slattery H,
"Oracle8i Administrator's Guide, Release 2 (8.1.6) for Windows NT"
Oracle Corporation 2000, part No. A73008-01

[3] Kennedy M, "Oracle8i Installation Guide, Release 3 (8.1.7) for Windows NT"
Oracle Corporation November 2000, part No. A85302-01

[4] leverenz L, rehfield D, Baird C "Oracle 8i concepts Release 2 (8.1.6 )"
Oracle Corporation December 1999, part No. A76965-01

[5] Metalink, "Oracle database server product support matrix for Windows 2000 ",
Oracle Corporation, http://metalink.oracle.com Note: 77627.1

[6] Metalink, "lkdbname-the Mount lock file ",
Oracle Corporation 2000, http://metalink.oracle.com Note: 50594.1

[7] Metalink, "Warning:" dbstart "does not work with 8.1.6 instances ",
Oracle Corporation 2000, http://metalink.oracle.com Note: 98418.1

[8] Microsoft, "Windows 2000 datacenter server ",
Microsoft Corporation 2000
Http: // www.microsoft.com/windows2000/datacenter/default.asp

[9] O 'Reilly, "the source for Perl", O 'Reilly & Associates Inc 2000,
Http://www.perl.com/pub

[10] Metalink, "alert: Cannot mount second CD during 8.1.7 installation ",
Oracle Corporation,
Http://metalink.oracle.com notes: 120801.1