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