Unpacking an Oracle test database

To test your installation, unpack an Oracle test database.

About this task

Unpack a database from the installation directory, $CCM_HOME/packfiles.

For example, on the database server computer, unpack a base model database (base.cpk) to a new database, /data/ccmdb/testdb.

Procedure

  1. Log in as ccm_root and set the environment variables.
       $ su - ccm_root
       Password: *****
       $ ORACLE_SID=sargasso; export ORACLE_SID
       $ ORACLE_HOME=/opt/oracle; export ORACLE_HOME
       $ CCM_HOME=ccm_home; export CCM_HOME
       $ PATH=$CCM_HOME/bin:$PATH; export PATH
  2. If necessary, create an Oracle user that has the privileges required to unpack a database.

    The ccmdb unpack command prompts you for an Oracle user that has the privileges required for unpacking a database. You can use the sys or system Oracle users. Both users have the correct privileges. You can also create an Oracle user that has the required privileges.

    You cannot enter / (meaning yourself), because this syntax is not supported by the unpack command. You also cannot use the ccm_root user (equivalent to OPS$CCM_ROOT).

    The Oracle user must have the following privileges:

    CREATE USER
    DROP USER
    CREATE ANY INDEX
    DROP ANY INDEX
    ALTER ANY INDEX
    SELECT ANY SEQUENCE 
    CREATE ANY SEQUENCE
    ALTER ANY SEQUENCE
    SELECT ANY TABLE
    CREATE ANY TABLE
    DROP ANY TABLE
    ALTER ANY TABLE
    INSERT ANY TABLE
    DELETE ANY TABLE
    UPDATE ANY TABLE
    GRANT ANY OBJECT PRIVILEGE
  3. Unpack the database.
    $ ccmdb unpack $CCM_HOME/packfiles/base.cpk -t /data/ccmdb/testdb
    If you are not using the default server name, include the
    -s servername option with the ccmdb unpack command.

Feedback