Bug 1023587 - Additional Oracle Database Requirements when upgrading to Satellite 5.6
Summary: Additional Oracle Database Requirements when upgrading to Satellite 5.6
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Docs Installation Guide
Version: 560
Hardware: All
OS: Linux
medium
high
Target Milestone: ---
Assignee: Dan Macpherson
QA Contact: Dan Macpherson
URL:
Whiteboard:
Depends On:
Blocks: sat-docs
TreeView+ depends on / blocked
 
Reported: 2013-10-25 20:34 UTC by hmiles
Modified: 2018-12-03 20:28 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-09-16 02:44:39 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1035947 1 None None None 2021-01-20 06:05:38 UTC
Red Hat Knowledge Base (Article) 521743 0 None None None Never
Red Hat Knowledge Base (Solution) 521743 0 None None None Never

Internal Links: 1035947

Description hmiles 2013-10-25 20:34:33 UTC
Description of problem:
We should add to this section :
2.3.3.2. Oracle Database Requirements
https://access.redhat.com/site/documentation/en-US/Red_Hat_Satellite/5.6/html-single/Installation_Guide/index.html#sect-Installation_Guide-External_Database_Requirements

In addition to this statement :
=================
    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
=================
We should add the following :
=================
   note: the database user has to have privileges above granted directly (not via role)
 
Example :
   SQL> grant  CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, CREATE VIEW, CREATE PROCEDURE,CREATE TRIGGER, CREATE TYPE, CREATE SESSION, ALTER SESSION to rhnsat;
=================

There have been 2 support cases so far where customer's using external db's did not have this set and they were unable to upgrade.

Comment 3 Dan Macpherson 2014-01-21 15:20:01 UTC
This bug can be worked on early during the planning stages for Satellite 5.7.


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