Bug 485706

Could you do

# semodule -l | grep oracle

? I assume due to the unconfined_devpts_t problem, SELinux modules are not loaded on this compose at all.

Also, rhn-installation.log will probably have something like

libsepol.print_missing_requirements: spacewalk's global requirements were not met: type/attribute oracle_port_t
libsemanage.semanage_link_sandbox: Link packages failed
/usr/sbin/semodule:  Failed!
libsepol.context_from_record: type cobbler_port_t is not defined
libsepol.context_from_record: could not create context structure
libsepol.port_from_record: could not create port structure for range 25152:25152 (tcp)
libsepol.sepol_port_modify: could not load port range 25152 - 25152 (tcp)
libsemanage.dbase_policydb_modify: could not modify record value
libsemanage.semanage_base_merge_components: could not merge local modifications into policy
/usr/sbin/semanage: Could not add port tcp/25152

it it.

I'm working on a fix.

After fixing the unconfined_devpts_t issue, I got

Can't load '/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: /opt/apps/oracle/web/product/10.2.0/db_1/lib/libocci.so.10.1: cannot restore segment prot after reloc: Permission denied at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.
 at /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 539
Compilation failed in require at /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 539.
BEGIN failed--compilation aborted at /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 539.
Compilation failed in require at /usr/lib/perl5/vendor_perl/5.8.8/Dobby/DB.pm line 18.
BEGIN failed--compilation aborted at /usr/lib/perl5/vendor_perl/5.8.8/Dobby/DB.pm line 18.
Compilation failed in require at /usr/lib/perl5/vendor_perl/5.8.8/Dobby/CLI/MiscCommands.pm line 21.
BEGIN failed--compilation aborted at /usr/lib/perl5/vendor_perl/5.8.8/Dobby/CLI/MiscCommands.pm line 21.
Compilation failed in require at /usr/bin/db-control line 11.
BEGIN failed--compilation aborted at /usr/bin/db-control line 11.

The problem is that interactive oracle user has

LD_LIBRARY_PATH=/opt/apps/oracle/web/product/10.2.0/db_1/lib

set. So we are using

-rwxrwxr-x  oracle dba system_u:object_r:lib_t          /opt/apps/oracle/web/product/10.2.0/db_1/lib/libocci.so.10.1

instead of

-rwxr-xr-x  root root system_u:object_r:textrel_shlib_t /usr/lib/oracle/10.2.0.4/client/lib/libocci.so.10.1

So:

su oracle -c 'db-control report' works.
su - oracle -c 'db-control report' does not

I'll change the context on /opt/apps/oracle/web/product/10.2.0/db_1/lib/libocci.so.10.1 but I wonder if it's correct that DBD::Oracle uses non-InstantClient libraries.

The unconfined_devpts_t problem fixed in 2d664ad720651b3fd31dfd9afcb5050fd31aeab8, the libocci.so.10.1 in d4995d6ea8f2523a33a7cf47d1e74e49a2bec0db.

With compose Satellite-5.3.0-RHEL5-re20090220.1 available, moving ON_QA.

[root@grandprix ~]# su - oracle
-bash-3.2$ db-control report
Tablespace                  Size    Used   Avail   Use%
DATA_TBS                    3.9G    3.1G  775.8M    81%
SYSAUX                      250M   64.4M  185.5M    26%
SYSTEM                      400M  239.9M    160M    60%
UNDO_TBS                    500M  177.5M  322.4M    36%
USERS                       128M     64K  127.9M     0%
-bash-3.2$ exit
logout
[root@grandprix ~]# getenforce 
Enforcing
[root@grandprix ~]#

Verified in stage with the exact same results as stated in the comment
above -> RELEASE_PENDING

An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on therefore solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.

http://rhn.redhat.com/errata/RHEA-2009-1434.html