Installation of Red Hat Network (RHN) Satellite 5.5 fails with the error 'DBI connect('//localhost:1521/rhnsat.world','rhnsat',...) failed: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist'

Issue

• Installation of Red Hat Network (RHN) Satellite 5.5 fails with the following error message

DBI connect('//localhost:1521/rhnsat.world','rhnsat',...) failed: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at /usr/share/perl5/vendor_perl/Spacewalk/Setup.pm line 1629

• End of /var/log/rhn/instal_db.log shows:

Creating: Database storage directory
Configuration file for rhnsat is /rhnsat/admin/rhnsat/init.ora
Adding 'rhnsat' entry to /etc/oratab
logout
+ LISTFILE=/opt/apps/oracle/web/product/10.2.0/db_1/network/admin/listener.ora
+ cat
+ chown oracle:dba /opt/apps/oracle/web/product/10.2.0/db_1/network/admin/listener.ora
+ chkconfig --add oracle
+ service oracle restart
Shutting down Oracle Net Listener ...[  OK  ]
tee: /usr/lib/oracle/10.2.0.4/client64/log/shutdown.log: No such file or directory
Shutting down Oracle DB instance "rhnsat" .../etc/init.d/oracle[125]: /usr/lib/oracle/10.2.0.4/client64/log/shutdown.log: cannot create [No such file or directory]
/etc/init.d/oracle[126]: /usr/lib/oracle/10.2.0.4/client64/log/shutdown.log: cannot create [No such file or directory]
[FAILED]
logout
Starting Oracle Net Listener ... [  OK  ]
tee: /usr/lib/oracle/10.2.0.4/client64/log/startup.log: No such file or directory
Starting Oracle DB instance "rhnsat" ... /etc/init.d/oracle[82]: /usr/lib/oracle/10.2.0.4/client64/log/startup.log: cannot create [No such file or directory]
/etc/init.d/oracle[85]: /usr/lib/oracle/10.2.0.4/client64/log/startup.log: cannot create [No such file or directory]
[FAILED]
bkkh: Error: Oracle DB instance rhnsat NOT started.