The software described in this documentation is either no longer supported or is in extended support.
Oracle recommends that you upgrade to a current supported release.
Configure the database as follows:
The database must use the
AL32UTF8
character set that supports Unicode.NoteYou can select the
AL32UTF8
character set if you select Advanced install in the Installation GUI but not if you select Typical install.The database must have a Spacewalk user. For example, you could create a user named
spacewalk
for Oracle Database 11gR2 orc##spacewalk
for Oracle Database 12c.If several Spacewalk servers will share the same database server, you must create a separate Spacewalk user for each server. For example, if you intend to set up two Spacewalk servers that share the same database, you could create users named
spacewalk
andspacewalk2
for Oracle Database 11gR2 orc##spacewalk
andc##spacewalk2
for Oracle Database 12c.The Spacewalk user must have the
CONNECT
andRESOURCE
roles.The Spacewalk user must have the
ALTER SESSION
,CREATE SYNONYM
,CREATE TABLE
,CREATE TRIGGER
,CREATE VIEW
andUNLIMITED TABLESPACE
system privileges.
To create a Spacewalk user:
Log in as a database administrator (typically,
SYSDBA
) on the database server.$
sqlplus / as SYSDBA
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jun 2 11:25:42 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL>Enter the following SQL*Plus commands to set up the Spacewalk user:
SQL>
create user
SQL>sw_user
identified bysw_passwd
;grant connect,resource to
SQL>sw_user
;grant alter session, create synonym, create table, create trigger, create view to
SQL>sw_user
;grant unlimited tablespace to
sw_user
;Replace
sw_user
andsw_passwd
with the Spacewalk user name and password.
Repeat these steps for each Spacewalk user that you need to set up.