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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In