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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content