[Spacewalk-list] TNS:listener trouble

[Michael Mraka]

Artem wrote:
% hello,
% 
% what to do? i run sync repo.
% 
% ##########################################################################
% 
% [root at ds-srv ~]# /etc/init.d/oracle-xe restart
% Shutting down Oracle Database 10g Express Edition Instance.
% Stopping Oracle Net Listener.
% 
% Starting Oracle Net Listener.
% Starting Oracle Database 10g Express Edition Instance.
% 
% [root at ds-srv ~]# sqlplus 'sys/<my pass>@//localhost/XE as sysdba'
% 
% SQL*Plus: Release 11.2.0.2.0 Production on Sun Feb 20 19:25:47 2011
% 
% Copyright (c) 1982, 2010, Oracle.  All rights reserved.
% 
% 
% Connected to:
% Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
% 
% SQL> exit
% Disconnected from Oracle Database 10g Express Edition Release
% 10.2.0.1.0 - Production
% #############################################################################
% 
% run sync repo and ...
% 
% [root at ds-srv ~]# sqlplus 'sys/<my pass>@//localhost/XE as sysdba'
% 
% SQL*Plus: Release 11.2.0.2.0 Production on Sun Feb 20 19:26:50 2011
% 
% Copyright (c) 1982, 2010, Oracle.  All rights reserved.
% 
% ERROR:
% ORA-12516: TNS:listener could not find available handler with matching protocol
% stack
% 
% #################################################################################

Oracle XE probably died during repo sync; check
/var/log/rhn/reposync/*.log and
/usr/lib/oracle/xe/app/oracle/admin/XE/bdump/alert_XE.log for errors.

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat