[Spacewalk-list] spacewalk/rhn/Login.do is blank

[Eric]

When I type spacewalk-cfg-get hibernate.connection.url  I get: "None".

When I type: spacewalk-cfg-get list hibernate.connection
  I see:

========= Start of output ============
allowed_iss_slaves   = 
batch_size           = 0
db_backend           = oracle
db_host              = racdev.local
db_name              = rhnsat
db_password          = secret
db_port              = 1521
db_user              = spacewalk
debug                = 1
default_db           = spacewalk/secret at rhnsat
dialect              = org.hibernate.dialect.Oracle9iDialect
disable_iss          = 0
disconnected         = 1
driver_class         = oracle.jdbc.driver.OracleDriver
enable_snapshots     = 1
encrypted_passwords  = 1
idle_test_period     = 300
iss_ca_chain         = /usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT
iss_parent           = 
kickstart_mount_point = /var/satellite
log_file             = /var/log/rhn/rhn.log
max_size             = 20
max_statements       = 0
min_size             = 5
mount_point          = /var/satellite
password             = secre
provider_class       = org.hibernate.cache.OSCacheProvider
quiet_mail           = 15
repomd_cache_mount_point = /var/cache
session_secret_1     = [md5 hash]
session_secret_2     = [md5 hash]
session_secret_3     = [md5 hash]
session_secret_4     = [md5 hash]
timeout              = 300
traceback_mail       = root at localhost
url                  = jdbc:oracle:thin:@racdev.local:1521:rhnsat  <============================= hibernate.connection.url
use_outer_join       = true
use_query_cache      = true
use_reflection_optimizer = false
username             = spacewalk

========= End of output ============

However in /etc/rhn/rhn.conf I have:
    hibernate.dialect=org.hibernate.dialect.Oracle9iDialect
    hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
    hibernate.connection.username=spacewalk
    hibernate.connection.password=secret
    hibernate.connection.url=jdbc:oracle:thin:@racdev..local:1521:rhnsat

Thank in advance,

-Eric




----- Original Message ----
From: Michael Mraka <michael.mraka at redhat.com>
To: Eric <linux_4_u at yahoo.com>; spacewalk-list at redhat.com
Sent: Wed, March 10, 2010 5:11:16 AM
Subject: Re: [Spacewalk-list] spacewalk/rhn/Login.do is blank

Eric wrote:
% *Bump* I am probably missing something obvious in this output, but my eyes just don't want to see it.
...
% SQL> alter system set processes = 400 scope=spfile; 
% SQL> alter system set "_optimizer_filter_pred_pullup"=false scope=spfile; 
% SQL> alter system set "_optimizer_cost_based_transformation"=off scope=spfile; 

Hi Eric, 

altering _optimizer* settings is workaround for XE. You should not need
it fo 11g.

What is your connection string for RAC looks like (see `spacewalk-cfg-get hibernate.connection.url`)?

% Restart the database.
% 
% This did not resolve my issue.
% Regards,
% 
% -Eric
% 
% ----- Original Message ----
% I am trying login to Spacewalk through the webUI and the https://spw.mydomain.local/rhn/Login.do is blank.
% 
% I am able to get the Oracle Database on the Spacewalk server through sqlplus spacewalk/[password]@rhnsat .
% The Oracle database is 11g RAC.
...

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat