Bug 651342

Summary: "db-control shrink-segments" does not work
Product: Red Hat Satellite 5 Reporter: Miroslav Suchý <msuchy>
Component: OtherAssignee: Michael Mráka <mmraka>
Status: CLOSED NOTABUG QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: medium Docs Contact:
Priority: high    
Version: 540CC: cperry
Target Milestone: ---Keywords: Regression
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-11-27 11:49:56 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Miroslav Suchý 2010-11-09 10:32:38 UTC 
Description of problem:
-bash-3.2$ db-control shrink-segments
Running segment advisor to find out shrinkable segments...
WARNING: this may be a slow process.
DBD::Oracle::db do failed: ORA-13616: The current user RHNSAT has not been granted the ADVISOR privilege.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_ADVISOR", line 986
ORA-06512: at "SYS.DBMS_ADVISOR", line 100
ORA-06512: at line 8 (DBD ERROR: OCIStmtExecute) [for Statement "DECLARE
  taskname VARCHAR2(100) := 'SAT-SEGADV-' || to_char(sysdate, 'YYYYMMDDHH24MISS');
  tbsname VARCHAR2(30);
  task_id NUMBER;
  oid NUMBER;
BEGIN
  select default_tablespace into tbsname from user_users;
  DBMS_ADVISOR.CREATE_TASK('Segment Advisor', task_id, taskname, NULL, NULL);
  DBMS_ADVISOR.CREATE_OBJECT(taskname, 'TABLESPACE', tbsname, ' ', ' ', NULL, oid);
  DBMS_ADVISOR.SET_TASK_PARAMETER(taskname, 'RECOMMEND_ALL', 'TRUE');
  DBMS_ADVISOR.RESET_TASK(taskname);
  DBMS_ADVISOR.EXECUTE_TASK(taskname);
END;
"] at /usr/lib/perl5/vendor_perl/5.8.8/Dobby/DB.pm line 204.

Version-Release number of selected component (if applicable):
spacewalk-dobby-1.2.7-7.el5sat

How reproducible:
always

Steps to Reproduce:
1. upgrade sat5.2 to 5.3
2. try to shrink segments
Comment 3 Michael Mráka 2010-11-27 11:49:56 UTC 
> DBD::Oracle::db do failed: ORA-13616: The current user RHNSAT has not been
> granted the ADVISOR privilege.

ADVISOR privilege is included in DBA privilege which is granted to rhnsat user by default.

For some reason your installation miss DBA privilege granted to rhnsat.