Bug 231964 - Satellite Installation documentation bug - database block size
Satellite Installation documentation bug - database block size
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Installer (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: John Ha
Corey Welton
: Documentation
Depends On:
Blocks: 248622
  Show dependency treegraph
Reported: 2007-03-13 05:52 EDT by Nick Strugnell
Modified: 2014-08-04 18:17 EDT (History)
2 users (show)

See Also:
Fixed In Version: sat510
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2008-04-02 20:35:55 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Nick Strugnell 2007-03-13 05:52:19 EDT
Description of problem:
The section in the installation guide for satellite regarding the configuration 
of an external database makes no mention of what database block size to use 
therefore we have used the defaults in all installations. However, the default 
on Oracle for Windows 2000 is 4KB rather than the more usual 8KB. 
This turns out to be too small to hold the index keys for the 
rhn_pkg_cl_pid_n_txt_time_uq index created on the rhnPackageChangelog table. 
Thus, schema creation fails. Unfortunately this failure happens silently, and 
the problem is not apparent until satellite activation fails at a later stage 
of the install.pl script.

Version-Release number of selected component (if applicable):
4.1.5 however I suspect that this affects all versions of satellite.

How reproducible:

Steps to Reproduce:
1. Configure external database with 4KB block size (the default on 9iR2 on 
Windows 2000)
2. Install satellite with external database
Actual results:
Satellite activation fails. No further error messages are given. Further 
investigation shows the following in populate_db.log:- 
SQL> create unique index rhn_pkg_cl_pid_n_txt_time_uq 
        on rhnPackageChangelog(package_id, name, text, time) 
        nologging tablespace RHNSS_DATA 
storage ( freelists 16 ) 
        initrans 32; 
on rhnPackageChangelog(package_id, name, text, time) 
ERROR at line 2: 
ORA-01450: maximum key length (3118) exceeded 

Expected results:
Satellite installation should proceed normally.

Additional info:

Two things we need to do here:-

* Fix installer.pl so that it detects failure of the schema to create properly 
and does not carry on with the satellite installation.

* Fix documentation so that it states clearly that an 8KB minimum db_block_size 
is required to install satellite with an external database.
Comment 2 Brandon Perkins 2007-08-03 23:25:19 EDT
Reassign bugs to jha@redhat.com.
Comment 3 Michael Hideo 2007-11-05 18:50:01 EST
Moving Status to 'Assigned'
Comment 4 John Ha 2007-12-20 16:15:05 EST
This is fixed in the latest build of Satellite 5.1.0 Installation Guide. Here is
the content with the 8kb block size database requirement stated:

Comment 5 Corey Welton 2008-02-13 13:09:41 EST
QA Verified, text exists in db requirements on iso.
Comment 6 Brandon Perkins 2008-04-02 20:35:55 EDT
5.1 Sat GA so Docs bugs Closed for Current Release.

Note You need to log in before you can comment on or make changes to this bug.