Differences in Oracle on UNIX and Windows2000 III
Ian adam, saic ltddavid stien, saic Ltd Translation: fenng www.itpub.netpart iii
Oracle installation Oracle8i is installed through new Java-based Oracle Universal Installer, with the same interface on all platforms [1 m Cyran, 1999]. The above sentence is right, but some small differences should be indicated. The X-compatible display capabilities are required on UNIX, or there is an application like Exceed on the client's workstation. The installer can be run directly on the Windows 2000.
There are many manually set tasks in UNIX, which is not required in Windows 2000. Especially you don't have to set up environment variables. You don't have to generate a UNIX DBA group that manages the database, you don't have to set a UNIX to run Oracle Universal Installer or a user named Oracle to install or upgrade Oracle. Oracle in Unix can be re-connected and cannot be in Windows 2000.
In Windows 2000, the user must be a member of the administrator group to install the database. An ORA_DBA is automatically created after the Oracle 8i database is installed. Members of this group automatically accept SYSDBA permissions. Recommended when customizing installation When you choose to install Administration Assistant for Windows, pay attention to each server to install one version of this software.
Oracle 8.1.7 for Solaris is 2CD. Switching to the second CD is not as easy as the manual. View [10 Metalink, 2001] can be obtained.
The installation guidance on Windows can see [3 Kennedy, 2000]. "Oracle Universal Installer Concept Guide" is not included in the Oracle8i server online, but it is automatically installed in your hard drive during the Oracle Universal Installer installation.
The Database Administration Assistant on Windows The Oracle Management Assistant on Windows is a GUI tool that runs from the MMC (Microsoft Management Console) built in Windows. Oracle's Windows Management Assistant sets several commonly used database management work to a tool. You can make you easy to create a database administrator, operator, user, and role in Windows. It can also be used to manage the Oracle database service and the settings of the Oracle database, edit the registry parameter setting, and check the Oracle process information.
Automatic task on UNIX, auto task like a backup is to run the shell script with cron. Use the scheduled task on Windows2000 to regularly run batch files. This scheduling is more flexible than the AT scheduling command on the previous Windows NT. It allows a task run with a user context rather than a system user, and it allows tasks to give privileges. Batch scripting language restriction is very large, so it is worth a good to get Perl [9 O'Reilly, 2000]. When manual running hot backup in Windows 2000, Oracle provides an OCOPY to copy files to another disk location, or back up to the tape. Standard Windows commands (such as COPY) do not copy an open file (database data files are open).
Adjustment and Diagnostics There are very few tools on Windows 2000 to debug the operating system, but we must also say what you can do. The front desk application of the interaction specifies the default priority during the installation of Windows2000. In order to prevent the front desk application to occupy an additional processor time, affect the Oracle8i database, remove its priority, which can be done by the system controls the high-level options. In UNIX, the shared memory and semaphore settings typically need to change via / etc / system. Do nothing else in Windows 2000, and it is not easy to change.
Oracle Performance Monitor for Windows is a Windows 2000 Performance Monitor preloaded Oracle8i database performance component. If you don't see these things, try this command to change the performance monitor settings:
Operfcfg -u system -p manager -d ATEI
The Oracle Performance Monitor of Windows NT allows you to only monitor only one database instance. The above command can switch between the database. In Windows 2000, Oracle and the usual Alert and TRACE files are written to the event log, which can be read through the standard event viewer. DBVERIFY (DBV) in Windows 2000 can be used to check online data files, like the features in UNIX. In previous Windows, DBV only works on the closed database or a backup file.
Summary For an Oracle DBA familiar with UNIX, this article describes the main differences of Oracle on Windows 2000. It can be seen that Oracle has made a lot of efforts to make Oracle on both platforms as similar, but there is no complete removal difference. This article is still worth seeing. 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
