osa-dispatcher won't start and encounters 'Connection attempt failed', 12546, 'ORA-12546: TNS:permission denied\n' with Satellite using an external Oracle database

Solution Verified - Updated -

Issue

  • Installed Red Hat Network Satellite to use an external Oracle database.
  • Currently the Red Hat Network Satellite works but osa-dispatcher service doesn't start correctly:
[root@satellite ~]# /usr/sbin/rhn-satellite start
Starting spacewalk services...                                     
Initializing jabberd processes ...                                 
Starting router:                                           [  OK  ]
Starting sm:                                               [  OK  ]
Starting c2s:                                              [  OK  ]
Starting s2s:                                              [  OK  ]
Starting tomcat6:                                          [  OK  ]
Starting httpd:                                            [  OK  ]   
Starting osa-dispatcher: RHN 11640 2012/09/04 10:31:29 +02:00: ('Connection attempt failed', 12546, 'ORA-12546: TNS:permission denied\n')
RHN 11640 2012/09/04 10:31:29 +02:00: ('Error caught:',)                                             
RHN 11640 2012/09/04 10:31:29 +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 121, 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 385, in connect\n    raise apply(sql_base.SQLConnectError, err_args)\nSQLConnectError: (12546, \'ORA-12546: TNS:permission denied\\n\', \'SATDB\', \'Connection_Connect(): server attach\')\n',)
                                                           [  OK  ]   
...

[root@satellite ~]# service osa-dispatcher restart
Shutting down osa-dispatcher:                              [  OK  ]
Starting osa-dispatcher: RHN 30320 2012/11/05 15:00:58 +02:00: ('Connection attempt failed', 12546, 'ORA-12546: TNS:permission denied\n')
RHN 30320 2012/11/05 15:00:58 +02:00: ('Error caught:',)
RHN 30320 2012/11/05 15:00:58 +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 121, 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 385, in connect\n    raise apply(sql_base.SQLConnectError, err_args)\nSQLConnectError: (12546, \'ORA-12546: TNS:permission denied\\n\', \'SATDB\', \'Connection_Connect(): server attach\')\n',)
                                                           [  OK  ]

Environment

  • Red Hat Network Satellite 5.4.1
  • External Database

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.