Please do not reply directly to this email. All additional comments should be made in the comments box of this bug.
Summary: Oracle-xe page for Spacewalk doesn't work
https://bugzilla.redhat.com/show_bug.cgi?id=514046
Summary: Oracle-xe page for Spacewalk doesn't work Product: Fedora Hosted Projects Version: unspecified Platform: All OS/Version: Linux Status: NEW Severity: medium Priority: low Component: Deployment_Guide AssignedTo: mhideo@redhat.com ReportedBy: mschwage@gmail.com QAContact: rlerch@redhat.com CC: fedora-docs-list@redhat.com Classification: Fedora
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'