Installation guide

Preparation 45
Oracle Database Installation Information
The information you need is listed in the order of the installation flow.
Table 3-4 Oracle Database Information
Installation
Information
Explanation
Oracle User Schema
Options
You can either create a new user schema or specify an existing one that resides
on a server in your network. You can use the user schema to set up an external
Oracle database schema for use with ZENworks.
If you are creating a new user schema, a tablespace must already exist for
associating to the Oracle access user. In an existing user schema, the rights and
tablespace must already be set up.
Oracle Server
information
The database server must have an Oracle database installed. Defaults are
provided for some of this information, which can be changed as necessary.
 Server’s Address: We recommend that you identify the server by its DNS
name rather than its IP address, to be in sync with certificates that are
signed with DNS names.
IMPORTANT: If you later change your database server’s IP address or
DNS name, make sure that your corporate DNS server is updated with this
change to keep DNS for the database server in sync.
 Port: Specify the port used by the database server. By default, it is 1521.
Change the default port number if you have a conflict.
 Service Name: For a new user schema, specify the instance name (SID)
on which the user schema is to be created. For an existing user schema,
specify the instance name (SID) on which the user schema has been
created.
Oracle Administrator
(applicable only for
the new user schema)
 Username: Specify the user who can modify the database. The user must
have read/write permissions to modify the database.
 Password: Specify the password to be used to the access the database.
Oracle Access User
 Username: For a new user schema, specify a name. For an existing user
schema, specify the name of the user schema that already exists in the
Oracle database.
 Password: For a new user schema, specify a password to be used to
access the database. For an existing user schema, specify the password
used to access the user schema that already exists in the Oracle database.
 Default Tablespace: For a new user schema, specify a name of the
tablespace where you want the user schema to be created. For an existing
user schema, specify the tablespace that contains the user schema
specified in the Username field.
By default, it is USERS.
Review Database
Information
Review the database configuration information.
Review SQL Scripts Review the SQL scripts to be executed during the creation of the database.