Unable to connect to the database at the time of Red Hat Network Satellite installation due to ORA-24327 error.

Issue

• Unable to install an external database on RHN Satellite 5.5 because of an ORA-24327

• Red Hat Network Satellite installation with external database is failing with below menitoned error message:

[root@My-rhnsat1 ]# ./install.pl --disconnected --external-db
* Starting the Red Hat Network Satellite installer.
* Performing pre-install checks.
:
:
Error while providing SID value.
* Now running spacewalk-setup.
* Setting up Oracle environment.
* Setting up database.
** Database: Setting up database connection for Oracle backend.
Database service name (SID)? <my SID>
Database hostname [localhost]? 10.XX.XX.XXX
Database (listener) port [1521]? 1521
DBI connect('//10.XX.XX.XXX:1521/<my SID>','',...) failed: ORA-24327: need explicit attach before authenticating a user (DBD ERROR: OCISessionBegin) at /usr/share/perl5/vendor_perl/Spacewalk/Setup.pm line 1629