Create a new user account on the database and assign it
the following system privileges:
CREATE SEQUENCE
CREATE VIEW
UNLIMITED TABLESPACE
CREATE TABLE
CREATE CLUSTER
CREATE SESSION
Important: (WebLogic only) When using WebLogic and an Oracle database, ensure that the database user name does not have a number as the first character, nor a hyphen (-) within the user name. Otherwise, the database does not bootstrap properly.
Note: For deployments on AIX, Linux, or Solaris, the user name must
not exceed 8 characters; on Windows, it must not exceed 12 characters.
You need the following information when you configure the data
source on the application server:
SID (Service ID)
User name and password of the Oracle user account
Host name or IP address of the database server
Oracle LISTENER port number (default is 1521)
For information about using Oracle 11g, see the appropriate user
documentation.