db-control get-optimizer fails during with "ORA-24327: need explicit attach before authenticating a user"
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.