1.3.2 Oracle Database Configuration

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.

1.3.2 Oracle Database Configuration

Configure the database as follows:

The database must use the AL32UTF8 character set that supports Unicode.
Note
You 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 or c##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 and spacewalk2 for Oracle Database 11gR2 or c##spacewalk and c##spacewalk2 for Oracle Database 12c.
The Spacewalk user must have the CONNECT and RESOURCE roles.
The Spacewalk user must have the ALTER SESSION, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE VIEW and UNLIMITED TABLESPACE system privileges.

To create a Spacewalk user:

$ 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 sw_user identified by sw_passwd;
SQL> grant connect,resource to sw_user;
SQL> grant alter session, create synonym, create table, create trigger, create view to sw_user; 
SQL> grant unlimited tablespace to sw_user;

Replace sw_user and sw_passwd with the Spacewalk user name and password.

Repeat these steps for each Spacewalk user that you need to set up.