db-control get-optimizer fails during with "ORA-24327: need explicit attach before authenticating a user"

Solution Verified - Updated -

Issue

  • db-control get-optimizer command fails with :
DBI connect('rhnsat','rhnsat',...) failed: ORA-24327: need explicit attach before authenticating a user (DBD ERROR: OCISessionBegin) at /usr/lib/perl5/vendor_perl/5.8.8/RHN/DBI.pm line 72
  • We receive this message when running the db-control get-optimizer command when testing to see if we're using cost based optimization.
  • Also trying to connect to embedded database fails with :
sqlplus $(spacewalk-cfg-get default_db)

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Jan 26 13:15:56 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Environment

  • RHN Satellite v5.5 with embedded database

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content