[Oracle] differences between UNIX and Oracle on Windows 2000 (III)

Oracle Installation

Oracle8i is installed through a new Java-based Oracle universal Installer (Oui). 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. Switch to the second "> CdIt is not as easy as described in the Manual. Check [10 Metalink, 2001] to obtain the specific content.

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

Oracle management assistant on Windows is a "> GuiTool, which runs from the Windows built-in MMC (Microsoft 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 "> 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 few tools for debugging the operating system on Windows 2000, but we should also talk about what 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 a familiar oracle on Unix "> DBAThis 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

References

[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"> CdDuring 8.1.7 installation ", Oracle Corporation, http://metalink.oracle.com Note: 120801.1

Http://www.dbanotes.net/database/oracle_unix_vs_windows_2000_iii.html