Unpacking an Oracle test database

About this task

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

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

Note: If you are not using the default server name, you must use the
-s servername option on the ccmdb unpack command.

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 privileges. You can also create an Oracle user that has the required privileges.

    You cannot enter / (meaning yourself), as 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
                   CREATE ANY SEQUENCE
                   ALTER ANY TABLE
                   CREATE ANY TABLE
                   INSERT ANY TABLE
                   DROP ANY TABLE
                   DELETE ANY TABLE
                   SELECT ANY TABLE
                   UPDATE ANY TABLE
                   GRANT ANY OBJECT PRIVILEGE
                   SELECT ANY SEQUENCE 
                   ALTER ANY INDEX
                   ALTER ANY TABLE
                   ALTER ANY SEQUENCE
  3. Unpack the database.
       $ ccmdb unpack $CCM_HOME/packfiles/base.cpk -t
    /data/ccmdb/testdb

Troubleshooting NLS_LANG and NLS_CHARACTERSET do not match

About this task

Rational Synergy for Oracle can encounter problems when mismatching a client NLS_LANG and a database NLS_CHARACTERSET.

For example, if the client NLS_LANG is set to American_America.WE8ISO8859P1 and the server NLS_CHARACTERSET is UTF8, then ccmdb unpack fails with an error like:

ERROR: Failed to add record to table attrib (-1401), terminating

ERROR: Cannot load database.

As another example, the Synergy Classic session startup fails with an error like:

Warning: The value of the 'active_model' attribute on the admin

component version, ba, is not a model in this database.

Warning: Oracle: ORA-03127: no new operations allowed until the active

operation ends


Feedback