AIX clustered server: Create Oracle or Oracle RAC database schemas and users

To create database schemas and users, you can create a copy of the template SQL scripts and edit this copy to manually create the database schemas and users. The template SQL scripts should be used as a guide for creating executable scripts and contain invalid SQL syntax.

Before you begin:

Ensure that you create users and grant the appropriate privileges in Oracle before configuring WebSphere Portal to work with Oracle.

Take care to create users in an environment that has the same settings as the actual runtime environment. For example, avoid creating a user in an English environment to use that user in a Turkish environment.

Refer to the following locations to refer to the SQL script templates:

Table 1. List of SQL script templates by database domain

Database domain Location of template
Release $PORTAL_HOME/base/wp.db.impl/config/templates/setupdb/oracle/release/createRuntimeUsers.sql

$PORTAL_HOME/base/wp.db.impl/config/templates/setupdb/oracle/release/createUsers.sql

Community $PORTAL_HOME/base/wp.db.impl/config/templates/setupdb/oracle/community/createRuntimeUsers.sql

$PORTAL_HOME/base/wp.db.impl/config/templates/setupdb/oracle/community/createUsers.sql

Customization $PORTAL_HOME/base/wp.db.impl/config/templates/setupdb/oracle/customization/createRuntimeUsers.sql

$PORTAL_HOME/base/wp.db.impl/config/templates/setupdb/oracle/customization/createUsers.sql

JCR $PORTAL_HOME/base/wp.db.impl/config/templates/setupdb/oracle/jcr/createRuntimeUsers.sql

$PORTAL_HOME/base/wp.db.impl/config/templates/setupdb/oracle/jcr/createUsers.sql

Feedback $PORTAL_HOME/pzn/prereq.pzn/config/templates/setupdb/oracle/feedback/createRuntimeUsers.sql

$PORTAL_HOME/pzn/prereq.pzn/config/templates/setupdb/oracle/feedback/createUsers.sql

Likeminds $PORTAL_HOME/pzn/prereq.pzn/config/templates/setupdb/oracle/likeminds/createRuntimeUsers.sql

$PORTAL_HOME/pzn/prereq.pzn/config/templates/setupdb/oracle/likeminds/createUsers.sql


Parent

AIX clustered server: Set up Oracle or Oracle RAC manually

 


+

Search Tips   |   Advanced Search