Windows stand-alone: Create Oracle or Oracle RAC database schemas and users

Windows stand-alone: Create Oracle or Oracle RAC database schemas and users

To create database schemas and users, we 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 beginning:

You should have installed Oracle.

If WebSphere Portal v8.0 and an earlier version of WebSphere Portal coexist, the database user IDs for WebSphere Portal v8.0 must be different than earlier versions to avoid conflicts during installation.

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 if you plan to use that user in a Turkish environment.
SQL script templates:

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: Windows stand-alone: Set up Oracle or Oracle RAC manually

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