Red Hat Network Satellite certificate is failing with "'ORA-01034: ORACLE not available\nORA-27101: shared memory realm does not exist\nLinux-x86_64 Error: 2: No such file or directory\n', 'rhnsat', 'Connection_Connect(): begin session"

Issue

• Red Hat Network Satellite certificate activation fails with following traceback:

[root@rhsat]# rhn-satellite-activate -vvv --rhn-cert=/etc/sysconfig/rhn/social-security-administration.cert
RHN_PARENT: satellite.rhn.redhat.com
HTTP_PROXY: 172.16.254.233:3128
HTTP_PROXY_USERNAME: 012568
HTTP_PROXY_PASSWORD: <password>
CA_CERT: /usr/share/rhn/RHNS-CA-CERT
Checking cert XML sanity and GPG signature: '/usr/bin/validate-sat-cert.pl --keyring /etc/webapp-keyring.gpg /etc/sysconfig/rhn/rhn-entitlement-cert.xml-_qsioT'
RHN 26298 2012/10/25 13:20:54 -04:00: ('Connection attempt failed', 1034, 'ORA-01034: ORACLE not available\nORA-27101: shared memory realm does not exist\nLinux-x86_64 Error: 2: No such file or directory\n')

ERROR: unhandled exception occurred:
Traceback (most recent call last):
  File "/usr/bin/rhn-satellite-activate", line 45, in <module>
    sys.exit(abs(mod.main() or 0))
  File "/usr/share/rhn/satellite_tools/rhn_satellite_activate.py", line 591, in main
    username=db_user, password=db_password, database=database)
  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 121, in initDB
    __init__DB(backend, host, port, username, password, database)
  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 52, in __init__DB
    __DB.connect()
  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 385, in connect
    raise apply(sql_base.SQLConnectError, err_args)
server.rhnSQL.sql_base.SQLConnectError: (1034, 'ORA-01034: ORACLE not available\nORA-27101: shared memory realm does not exist\nLinux-x86_64 Error: 2: No such file or directory\n', 'rhnsat', 'Connection_Connect(): begin session')