[Spacewalk-list] Error connecting to Database

[Michael Mraka]

Vishal Patil wrote:
% Hi All,
% 
% I get the following error when trying to connect to Oracle XE database ....
% 
% *************
% 
% sqlplus 'sys at xe as sysdba'
% SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 3 11:00:33 2010
% Copyright (c) 1982, 2005, Oracle.  All rights reserved.
% Enter password:
% ERROR: ORA-12528: TNS:listener: all appropriate instances are blocking new
% connections
% 
% ***************************

Did you follow 'Additional Oracle configuration' section on
https://fedorahosted.org/spacewalk/wiki/OracleXeSetup ?

What does 

  # sqlplus $(spacewalk-cfg-get default_db)
  SQL> show parameters processes

show?

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat