[Spacewalk-list] reposync hang- lost spacewalk urgently

[Colin Coe]

http://lmgtfy.com/?q=xe+ORA-01033

On Wed, Mar 10, 2010 at 3:51 PM, rob morrien <rmorrien at xs4all.nl> wrote:
>> 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
>
>
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>



-- 
RHCE#805007969328369