How can Unix and Linux systems running Oracle integrate with a Windows Server environment?
On UNIX, several files and scripts in different directories are used to start an instance automatically. Other scripts are run on computer shutdown, allowing applications such as Oracle Database to shut down cleanly.
For automatic startup on Windows, set registry parameter
ORA_SID_AUTOSTART to
true using an Oracle Database tool such as ORADIM.
Enter the following with parameters at the command prompt:
C:\> oradim options
To start the listener automatically, set services startup type to automatic.
For automatic shutdown on Windows, set registry parameters
ORA_SHUTDOWN and
ORA_SID_SHUTDOWN to stop the
relevant OracleServiceSID and shut down.
Set registry parameter
ORA_SID_SHUTDOWNTYPE to
control shutdown mode (default is i, or
immediate).
Background Processing and Batch Jobs
UNIX provides sophisticated control mechanisms for background processing and batch jobs.
For similar functionality on Windows, use the AT command or a GUI version in the Microsoft Resource Kit.
Diagnostic and Tuning Utilities
On UNIX, utilities such as sar and
vmstat are used to monitor Oracle Database background
and shadow processes. These utilities are not integrated with
Oracle Database.
Performance utilities available on Windows include Task Manager, Control Panel, Event Viewer, and Microsoft Management Console.
Oracle Database is integrated with several of these tools. For example:
Event Viewer displays system alert messages, including Oracle Database startup/shutdown messages and audit trail.
Task Manager on Windows displays currently running processes and
their resource usage, similar to the UNIX ps -ef
command or HP OpenVMS SHOW SYSTEM. But Task Manager is
easier to interpret and the columns can be customized.
Direct Writes to Disk
On both UNIX and Windows platforms, bypassing the file system buffer cache ensures data is written to disk.
On UNIX, Oracle Database uses the O_SYNC flag to
bypass the file system buffer cache. The flag name depends on the
UNIX port.
On Windows, Oracle Database bypasses the file system buffer cache completely.
Dynamic Link Libraries (DLLs)
Shared libraries on UNIX are similar to shared DLLs on Windows. Object files and archive libraries are linked to generate Oracle Database executables. Relinking is necessary after certain operations, such as installation of a patch.
On Windows, Oracle Database DLLs form part of the executable at run time and are therefore smaller. DLLs can be shared between multiple executables. Relinking by the user is not supported, but executable images can be modified using ORASTACK.
Modifying executable images on Windows reduces the chances of running out of virtual memory when using a large SGA or when supporting thousands of connections. However, Oracle recommends doing this only under the guidance of Oracle Support Services.
Hot Backups
A (manual) hot backup is equivalent to backing up a tablespace that is in offline backup mode.
Backup strategy on UNIX is as follows: put the tablespace into backup mode, copy the files to the backup location, and bring the tablespace out of backup mode.
Windows supports the same backup strategy, but you cannot copy files in use with usual Windows utilities. Use OCOPY to copy open database files to another disk location. Then use a utility to copy the files to tape.
How can Unix and Linux systems running Oracle integrate with a Windows Server environment?
Where is application and service configuration information stored on Unix and Linux systems? In Windows? Compare and contrast the two in terms of security, accessibility, and automation.
Scenario: Security and Memory Management Some have argued that Unix/Linux systems reuse a small number of security features in many contexts across the system, while windows systems provide a much larger number of more specifically targeted security features used in the appropriate contexts. This may be seen as a trade-off between simplicity verses lack of flexibility in the Unix/Linux approach against a better targeted but more complex and harder to correctly configure approach in Windows. question: Discuss the highlighted trade-off...
Provide a reason why a server engineer will boot a Linux/Unix server into single user mode?
You’re setting up a test environment that involves two subnets with three Windows Server 2016 servers on each subnet. The servers are running broadcast-based network services, such as DHCP. The host computer is attached to the production network, so you must prevent any conflicts. You want the two subnets to be able to communicate with each other. The test environment consists of a single Windows Server 2016 machine running Hyper-V. Describe how you plan to configure the virtual network.
Compare Windows and Linux memory systems used by the OSes.
1. You have a web server running on port 8888 in a Linux computer, but without any firewall rules in place for protection. Now, you want to use iptables to protect the website so that only computers from address 172.90.0.0/16 but excluding 172.90.255.0/24 can access the web server. Show the commands of iptables that add the Linux firewall rules to enforce the protection.
Based upon the labs and research from this topic, research the automation capabilities of the Linux server platform. What features does Windows support that are not covered in Linux?
1. Write a client program and a server program with multiple clients: Write a server application with multiple clients. This means your server program must use threads or fork methods to support multiple clients. You will use socket() and connect() system calls in Unix/Linux/Windows to write an application based on client/server socket programming. You can work on this project using either Java or C/C++. Through this assignment you will learn how to design a simple multithreading client-server programming using Java...
Explain how Unix and Windows manage memory and processors. Compare between the approaches of the two operating systems .
Using the task management tools in Microsoft Windows and Linux, you can explore the factors that affect your personal computer’s (PC’s) performance and troubleshoot problems, such as stopping a hung application. In the Windows operating system, you use Windows Task Manager to obtain information about the programs and processes running on your PC and common performance measurements, such as central processing unit (CPU) and memory usage, for these processes. Similarly, in Linux, you use the pscommand to display a variety...