[Spacewalk-list] Manual db schema upgrade 0.4 to 0.5

[Jan-Frode Myklebust]

On Tue, Apr 07, 2009 at 01:59:22PM +0200, Milan Zazrivec wrote:
> 
> The wiki page you are referring to should be the final version for
> 0.4 -> 0.5 upgrades.

Great, thanks!

I just upgraded our RHEL5/x86_64 server, with spacewalk 0.4, and the
database on an external Oracle cluster. A couple of minor issues:

	o oracle-lib-compat wrongly assume that we're running v10.2.0.4 of
	  the oracle client packages, and broke /usr/share/java/ojdbc14.jar 
	  and /usr/bin/sqlplus for us. So I had to manually point these at
	  v10.2.0.3.

	o the /usr/bin/spacewalk-schema-upgrade was first blocked by selinux:

	type=AVC msg=audit(1239108979.586:424345): avc:  denied  { read } for  pid=17000 comm="sqlplus" path="/var/log/spacewalk/schema-upgrade/20090407-145611-script.sql" dev=dm-2 ino=691803 scontext=user_u:system_r:oracle_sqlplus_t:s0 tcontext=user_u:object_r:var_log_t:s0 tclass=file

	 but I fixed that by temporarily running selinux permissive.	


I think that was all, and maybe both caused by us running old
oracle-instantclient. Guess we should have upgraded that long
time ago..



  -jf
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20090407/ec7d2a69/attachment.sig>