Bug 514046

Summary: Oracle-xe page for Spacewalk doesn't work
Product: [Community] Spacewalk Reporter: Michael Schwager <mschwage>
Component: DocumentationAssignee: Jan Pazdziora (Red Hat) <jpazdziora>
Status: CLOSED CURRENTRELEASE QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: medium Docs Contact:
Priority: low    
Version: 0.5CC: docs, jonathansteffan, jpazdziora
Target Milestone: ---Keywords: Documentation
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-02-16 12:55:55 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 543511    

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 (Red Hat) 2010-02-02 10:27:04 UTC
Taking.

Comment 3 Jan Pazdziora (Red Hat) 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