[Spacewalk-list] oracle setup failing

[Jim Kinney]

I'm setting up a 1.2 version using spacewalk-oracle and am using the
details on https://fedorahosted.org/spacewalk/wiki/OracleXeSetup for how
to set up the oracle db first.

As the page reads like a cookbook (yay!) I've just followed it line by
line (machine is F14 x86_64 and oracle is the exact version(s) from the
instructions). All goes well until :

sqlplus 'sys at xe as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jan 14 16:13:46 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in
connect descriptor

with a password setup during /etc/init.d/oracle-xe configure
to be simple letters only (bad security - only 5 lowercase letters).

Much digging on Google suggests nothing useful (mostly setting
ORACLE_HOME and ORACLE_SID - which I did to
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server and
ORACLE_SID=XE) of functional.

I've restarted oracle_xe, removed and reinstalled, basically spent a day
on this with no forward motion.

ugh.

Ideas?

-- 
Jim Kinney
Signature Technologies Lab
404-407-7967

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3094 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110114/a841aed2/attachment.p7s>