On RHN Satellite, alert-rhnsat.log has "ORA-1122 signalled during: ALTER DATABASE OPEN" during start of oracle service

Solution Unverified - Updated -

Issue

  • On RHN Satellite - oracle service cannot start or stop cleanly.
  • Trying to login using sqlplus fails with error :
sqlplus $(spacewalk-cfg-get default_db)
SQL*Plus: Release 10.2.0.4.0 - Production on Sat Jul 13 13:39:26 2013
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

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

Enter user-name: rhnsat
Enter password:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
  • In alert_rhnsat.log we see :
ALTER DATABASE OPEN
ORA-1122 signalled during: ALTER DATABASE OPEN...
Sat Jul 13 07:42:47 2013
WARNING: inbound connection timed out (ORA-3136)
Shutting down instance: further logons disabled

Environment

  • Red Hat Satellite v5.5

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.