Setting up your Oracle database manually for Application Center
You can set up your Oracle database for Application Center manually.
About this task
Procedure
- Ensure that you have at least one Oracle database.
In many Oracle installations, the default database has the SID (name) ORCL. For best results, specify Unicode (AL32UTF8) as the character set of the database.
If the Oracle installation is on a UNIX or Linux computer, make sure that the database is started next time the Oracle installation is restarted. To this effect, make sure that the line in /etc/oratab that corresponds to the database ends with a Y, not with an N.
- Create the user APPCENTER, either by using
Oracle Database Control, or by using the Oracle SQLPlus command-line
interpreter.
- To create the user for the Application Center database/schema,
by using Oracle Database Control, proceed as follows:
- Connect as SYSDBA.
- Go to the Users page.
- Click Server, then Users in the Security section.
- Create a user, named APPCENTER with the following
attributes:
Profile: DEFAULT Authentication: password Default tablespace: USERS Temporary tablespace: TEMP Status: Unlocked Add system privilege: CREATE SESSION Add system privilege: CREATE SEQUENCE Add system privilege: CREATE TABLE Add quota: Unlimited for tablespace USERS
To create the user by using Oracle SQLPlus, enter the following commands:
CONNECT SYSTEM/<SYSTEM_password>@ORCL CREATE USER APPCENTER IDENTIFIED BY password DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS; GRANT CREATE SESSION, CREATE SEQUENCE, CREATE TABLE TO APPCENTER; DISCONNECT;
- To create the user for the Application Center database/schema,
by using Oracle Database Control, proceed as follows:
- Create the tables for the Application Center database:
- Using the Oracle SQLPlus command-line interpreter, create
the tables for the Application Center database
by running the create-appcenter-oracle.sql file:
CONNECT APPCENTER/APPCENTER_password@ORCL @product_install_dir/ApplicationCenter/databases/create-appcenter-oracle.sql DISCONNECT;
- Using the Oracle SQLPlus command-line interpreter, create
the tables for the Application Center database
by running the create-appcenter-oracle.sql file:
- Download and configure the Oracle JDBC driver:
- Download the JDBC driver from the Oracle website at Oracle: JDBC, SQLJ, Oracle JPublisher and Universal Connection Pool (UCP):
- Ensure that the Oracle JDBC driver is in the system path. The driver file is ojdbc6.jar.