Creating databases for asset lifecycles in Oracle

To set up the Oracle databases for asset lifecycles:

1. Using the Oracle Database Configuration Assistant, follow the steps in the wizard to create a new database.
   1. The database must be on the same host as the database that you created for assets.
   2. Use global database name ccmdb, and a system identifier (SID) ccmdb. The global database name and the system identifier must be the same.
   3. On the Character Sets page, select Use Unicode (AL32UTF8).
   4. Also on the Character Sets page, for National Character Set, select UTF8 - Unicode 3.0 UTF-8.
   5. Complete the other pages in the wizard, accepting the default values.
2. Create a tablespace. The tablespace must have the following properties:
   • A name other than oracle_tbs;
   • A location in a different directory than the oracle_tbs tablespace;
   • A size of at least 1 GB; for larger installations, you might need more space.
   The following command for a Windows computer shows a sample create statement:

   CREATE BIGFILE TABLESPACE jazz_tbs DATAFILE 'D:\jazz_tbs\jazz_tbs.dbf' SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE

   Note: In the above command, the directory D:\jazz_tbs\ must exist. The use of BIGFILE is not required, but recommended.
3. Create a database user:
   1. Open Database Control.
   2. Navigate to the Users page. (In Oracle 10.2(g), click Administration, then Users; in Oracle 11(g), click Server, then in the Security section click Users.)
   3. Create a user that meets the following qualifications:
      • You can use any valid user name. Unlike the database for assets, a specific user name is not required.
      • The user has the RESOURCE and CONNECT roles.
      • The user's quota setting is unlimited.
      • The default tablespace for the user is the tablespace that you created in step 2.
      • The user must have the following permissions:
        • CREATE PROCEDURE
        • CREATE SESSION
        • CREATE TABLE
        • CREATE VIEW
      Tip: Oracle provides a default user named "Scott" that has many of the appropriate permissions. You can use this default user as the basis for your new user account.
4. Repeat the above steps to create a database named jtsdb.