[Spacewalk-list] Startup error on new install

[Daniel Wittenberg]

On Mon, 2009-09-28 at 10:42 -0500, Daniel Wittenberg wrote:
> > > com.mchange.v2.resourcepool.BaseResourcePool$AcquireTask run
> > > WARNING:
> > >  com.mchange.v2.resourcepool.BaseResourcePool$AcquireTask at 52ef57f8 --
> > > Acquisition Attempt Failed!!!  Clearing pending acquires.  While trying
> > > to acquire a needed new resource, we failed to succeed more than the
> > > maximum number of allowed acquisition attempts (30).  
> > > 
> > > 
> > > But no idea what that means either :)
> > > 
> > > Dan
> > > 
> > > 
> > 
> > Looks like the java code can't talk to the database.  Are you able to run:
> > 
> > # sqlplus spacewalk/spacewalk at xe
> > 
> > without error?
> > 
> > Also can you run:
> > 
> > # grep hibernate /etc/rhn/rhn.conf
> > 
> > and provide that output?
> > 
> > Thanks,
> 
> hmm, can't login to sqlplus with spacewalk account...
> 
> # sqlplus spacewalk/spacewalk at xe
> 
> SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 28 11:41:03 2009
> 
> Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
> 
> ERROR:
> ORA-01017: invalid username/password; logon denied
> 
> 
> Enter user-name: spacewalk
> Enter password: 
> ERROR:
> ORA-12162: TNS:net service name is incorrectly specified
> 
> I know the password is good, and I even connected as sys account and ran
> 'PASSWORD spacewalk' and reset it to what is listed below.
> 
> 
> # grep hibernate /etc/rhn/rhn.conf
> hibernate.dialect=org.hibernate.dialect.Oracle9iDialect
> hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
> hibernate.connection.username=spacewalk
> hibernate.connection.password=######
> hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:XE
> 
> Dan

I did try this instead:

# sqlplus spacewalk at xe

and that prompted me for a password, and that worked.  What is the
difference between that and spacewalk/spacewalk at xe ?

Dan