AIX clustered server: Creating JCR table spaces

This topic provides manual instructions for creating JCR table spaces for Oracle.

About this task

If you have run the setup-database script, you should not perform the steps in this topic. As an alternative to creating JCR table spaces, you can run the setup-database script to create the required JCR table spaces. In addition to creating JCR table spaces, the setup-database script automatically creates users and grants privileges.
Note: Oracle Automatic Storage Management users should use the following instructions only as a reference. As you manually create your table spaces, create the exact table space names listed in this topic with the recommended sizes.

Procedure

  1. In the database directory, create the data directory data and the index directory index.
  2. Create tablespaces using the following commands as examples:
    Substitute the values of your environment for the following variables:
    • &jcrdb. is the name of the database you created to store user data.
    • &dbpath. is the directory where you created the database; the default path is /oracle/oradata.
    Ensure that the '.' is included in the variables when you substitute the values of your environment with these variables.
    Important: You must use the same table space names listed in the commands. The table space names cannot be customized or modified.

    create tablespace ICMLFQ32 datafile '&dbpath./&jcrdb./data/&jcrdb._ICMLFQ32_01.dbf' size 300M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;

    create tablespace ICMLNF32 datafile '&dbpath./&jcrdb./data/&jcrdb._ICMLNF32_01.dbf' size 25M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;

    create tablespace ICMVFQ04 datafile '&dbpath./&jcrdb./data/&jcrdb._ICMVFQ04_01.dbf' size 25M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;

    create tablespace ICMSFQ04 datafile '&dbpath./&jcrdb./data/&jcrdb._ICMSFQ04_01.dbf' size 150M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;

    create tablespace ICMLSNDX datafile '&dbpath./&jcrdb./index/&jcrdb._ICMLSNDX_01.dbf' size 10M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;

    1. Set the size, autoextend, and maxsize values according to your environment. For example, you may want to change the maxsize to a set value rather than UNLIMITED.
    2. Consult your Database Administrator for specific guidance about creating tablespaces for your environment.
    3. Refer to the Oracle command reference for more information about using the create tablespaces command.
  3. Ensure the database is registered with the Oracle listener. Use the tnsnames.ora file to describe this database and recycle the listener.