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$
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.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
