This section applies only to RHN Satellite Server with Stand-Alone Database as the requirements for the Embedded Database are included in the Satellite machine's hardware requirements. Red Hat supports RHN Satellite Server 3.6 installations in conjunction with Oracle 9i R2. The Stand-Alone Database must not run on the same server as the RHN Satellite Server.
A single 4 GB tablespace is recommended as more than sufficient for most installations. It is possible for many customers to function with a smaller tablespace. An experienced Oracle database administrator (DBA) will be necessary to assess sizing issues. The following formula should be used to determine the required size of your database:
192 KB per client system
64 MB per channel
For instance, an RHN Satellite Server containing 10 channels serving 10,000 systems would require 1.92 GB for its clients and 640 MB for its channels. If custom channels are to be established for testing and staging of packages, they must be included in this formula.
Keep in mind, the database storage needs may grow rapidly, depending upon the variance of the following factors:
The number of public Red Hat packages imported (typical: 5000)
The number of private packages to be managed (typical: 500)
The number of systems to be managed (typical: 1000)
The number of packages installed on the average system (typical: 500)
Although you should be generous in your database sizing estimates, you need to consider that size does affect the time to conduct backups and adds load to other system resources. If the database is being shared, its hardware and spacing is entirely dependent on what else is using it.
The Oracle database should have a user assigned to RHN Satellite Server with full DDL and DML access to that user's default tablespace. The user will need standard connection information for the database at the time of installation.
The precise access levels required by the Oracle user are as follows:
ALTER SESSION
CREATE SEQUENCE
CREATE SYNONYM
CREATE TABLE
CREATE VIEW
CREATE PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE SESSION
Additional database requirements include:
Security Identifier (SID)
Listener Port
Username
Uniform Extent Size
Auto Segment Space Management
UTF-8 character set
The disk layout on the database machine is independent of the RHN Satellite Server and entirely up to the customer.