Bug 514046 - Oracle-xe page for Spacewalk doesn't work
Summary: Oracle-xe page for Spacewalk doesn't work
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Documentation
Version: 0.5
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
Assignee: Jan Pazdziora
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space08
TreeView+ depends on / blocked
 
Reported: 2009-07-27 18:53 UTC by Michael Schwager
Modified: 2010-02-16 12:58 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-02-16 12:55:55 UTC
Embargoed:


Attachments (Terms of Use)

Description Michael Schwager 2009-07-27 18:53:49 UTC
Description of problem:
Sorry about the classification of this.  I didn't see Spacewalk anywhere in Bugzilla!  Anyway, on the webpage https://fedorahosted.org/spacewalk/wiki/OracleXeSetup#Install, the install instructions don't work as advertised.  There, it says
    "Configure the Oracle XE database by running
    # /etc/init.d/oracle-xe configure"
This did not set the system/sys name correctly.  Yes, I know, the oracle-xe command comes from Oracle themselves, but on my RHEL53 machine it just refused to set the password correctly.  Did I try to do it 10 times or more?  Yes I did, and it did not work at all.  Did I fat finger my password every single lousy time I tried it?  No I did not, for I was able to create my password as easy as you please using my workaround below.

Version-Release number of selected component (if applicable):
oracle-xe-univ-10.2.0.1-1.0
oracle-instantclient-basic-10.2.0.4-1
oracle-instantclient-sqlplus-10.2.0.4-1

How reproducible:
Every time.

Steps to Reproduce:
1.  Do this on RHEL53 x86_64.  Install the Oracle-XE software as listed.
2.  Follow the instructions on https://fedorahosted.org/spacewalk/wiki/OracleXeSetup#Install, up to and including the "Test Your Connection with SQLPlus" part.
3.  You fail to login.
  
Actual results:
Fail to login.

Expected results:
Successful login.

Additional info:
The workaround is to perform the following after running /etc/init.d/oracle-xe configure : 

su - oracle
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
/usr/lib/oracle/10.2.0.4/client64/bin/sqlplus /NOLOG
CONNECT / AS SYSDBA
alter user sys identified by password;        
alter user system identified by password;
sqlplus64 'sys@xe as sysdba'

Comment 1 Jonathan Steffan 2009-07-28 04:08:04 UTC
I've run into similar issues. The exact issue I ran into was the use of too long of a password and a password with an @ in it. This is a bug with the oracle code, and not Fedora/Spacewalk related, IMHO.

Comment 2 Jan Pazdziora 2010-02-02 10:27:04 UTC
Taking.

Comment 3 Jan Pazdziora 2010-02-02 10:28:40 UTC
Michael, could you try the installation of Oracle XE based on instructions on https://fedorahosted.org/spacewalk/wiki/OracleXeSetup now? Note that the package oracle-lib-compat which is listed as one to install now should setup everything properly for you.

Thank you,

Jan

Comment 4 Michael Mráka 2010-02-16 12:58:37 UTC
Spacewalk 0.8 has been released


Note You need to log in before you can comment on or make changes to this bug.