[Spacewalk-list] reposync hang- lost spacewalk urgently

[rob morrien]

> rob morrien wrote:
> % to support:
> %
> %
> % ok the machine is up , when i do a start of satellite
> % with /usr/sbin/rhn-satellite start i get the next info:
> %
> %
> % /usr/sbin/rhn-satellite start >> /tmp/log
> % RHN 26732 2010/03/09 12:07:45 +02:00: ('Connection attempt failed',
> 12528,
> % 'ORA-12528: TNS:listener: all appropriate instances are blocking new
> % connections\n')
> % RHN 26732 2010/03/09 12:07:45 +02:00: ('Error caught:',)
> % RHN 26732 2010/03/09 12:07:45 +02:00: ('Traceback (most recent call
> % last):\n  File "/usr/share/rhn/osad/jabber_lib.py", line 119, in main\n
> % self.setup_config(config)\n  File
> "/usr/share/rhn/osad/osa_dispatcher.py",
> % line 81, in setup_config\n    rhnSQL.initDB()\n  File
> % "/usr/share/rhn/server/rhnSQL/__init__.py", line 98, in initDB\n
> % __init__DB(backend, host, port, username, password, database)\n  File
> % "/usr/share/rhn/server/rhnSQL/__init__.py", line 52, in __init__DB\n
> % __DB.connect()\n  File
> "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py",
> % line 386, in connect\n    raise apply(sql_base.SQLConnectError,
> % err_args)\nSQLConnectError: (12528, \'ORA-12528: TNS:listener: all
> % appropriate instances are blocking new connections\\n\', \'xe\',
> % \'Connection_Connect(): server attach\')\n',)
> % httpd: Could not reliably determine the server's fully qualified domain
> % name, using 127.0.0.1 for ServerName
> % DBI connect('xe','spacewalk',...) failed: ORA-01033: ORACLE
> initialization
> % or shutdown in progress (DBD ERROR: OCISessionBegin) at
>
> Your oracle database is not running.
>
> % /usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/NOCpulseini.pm line 50
> %
> %
> % Looks also in the attached log file.
> %
> % regsrds rob
>
> Regards,
>
>
> --
> Michael Mráka
> Satellite Engineering, Red Hat
>


hello,


i stopped and start my oracle database:

i st[root at mirr ~]# /etc/init.d/oracle-xe stop
Shutting down Oracle Database 10g Express Edition Instance.
Stopping Oracle Net Listener.

[root at mirr ~]# /etc/init.d/oracle-xe start
Starting Oracle Net Listener.
Starting Oracle Database 10g Express Edition Instance.

check ora /listener


[root at mirr ~]# ps -ef | grep ora
root      2636  2614  0 Mar09 ?        00:00:11 hald-addon-storage:
polling /dev/hdc
oracle   14003     1  0 08:27 ?        00:00:00
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER
-inherit
oracle   14008     1  0 08:27 ?        00:00:00 xe_pmon_XE
oracle   14010     1  0 08:27 ?        00:00:00 xe_psp0_XE
oracle   14012     1  0 08:27 ?        00:00:00 xe_mman_XE
oracle   14014     1  0 08:27 ?        00:00:00 xe_dbw0_XE
oracle   14016     1  0 08:27 ?        00:00:00 xe_lgwr_XE
oracle   14018     1  0 08:27 ?        00:00:00 xe_ckpt_XE
oracle   14020     1  0 08:27 ?        00:00:00 xe_smon_XE
oracle   14022     1  0 08:27 ?        00:00:00 xe_reco_XE
oracle   14024     1  0 08:27 ?        00:00:00 xe_cjq0_XE
oracle   14026     1  0 08:27 ?        00:00:00 xe_mmon_XE
oracle   14028     1  0 08:27 ?        00:00:00 xe_mmnl_XE
oracle   14030     1  0 08:27 ?        00:00:00 xe_d000_XE
oracle   14032     1  0 08:27 ?        00:00:00 xe_s000_XE
oracle   14034     1  0 08:27 ?        00:00:00 xe_s001_XE
oracle   14036     1  0 08:27 ?        00:00:00 xe_s002_XE
oracle   14038     1  0 08:27 ?        00:00:00 xe_s003_XE
oracle   14042     1  0 08:27 ?        00:00:00 xe_arc0_XE
oracle   14044     1  0 08:27 ?        00:00:00 xe_arc1_XE
oracle   14046     1  0 08:27 ?        00:00:00 xe_arc2_XE
root     14739 12242  0 08:31 pts/0    00:00:00 grep ora
[root at mirr ~]# ps -ef | grep tns
oracle   14003     1  0 08:27 ?        00:00:00
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER
-inherit
root     14908 12242  0 08:32 pts/0    00:00:00 grep tns

check connection

sqlplus 'sys at xe as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 10 08:33:59 2010

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

Enter password:

Connected to:

sqlplus spacewalk/spacewalk at xe command gives  next info:

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 10 08:37:37 2010

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

ERROR:
ORA-01033: ORACLE initialization or shutdown in progress



pls can you tell me why and how cani get the database up.

regards rob