Executing 'db-control get-optimizer' command, fails with "ORA-00942: table or view does not exist"

Issue

• While performing the upgrade of RHN Satellite v5.2 to v5.4, executing db-control get-optimizer commad failed with :

  -bash-4.1$ db-control get-optimizer
  DBD::Oracle::db selectrow_array failed: ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 25 in '
    select value
      from <*>v$system_parameter
     where name = 'optimizer_mode'
    ') [for Statement "
    select value
      from v$system_parameter
     where name = 'optimizer_mode'
    "] at /usr/share/perl5/vendor_perl/Dobby/DB.pm line 278.
  -bash-4.1$