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

Solution Verified - Updated -

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$
    

Environment

  • Red Hat Network Satellite v5.2 (being upgraded to v5.4)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.