Symptom
When trying to create a new Cognos Planning 8.4.1 application, an error comes up when trying to generate scripts for an planning application
Problem
During the creation of a new application, the following error occurs "The db specified is in use by another system"
Environment
Oracle 10G, Windows 2003, Cognos Planning 8.4.1
Cause
The schema user created by the planning application during the application creation already exist, due to insufficient permissions of the oracle planning user.
Solution
1. check the permissions of the planning store Oracle user. These permissions are required.
- CREATE SESSION, USER
- CREATE ANY INDEX
- CREATE ANY SEQUENCE
- CREATE ANY SYNONYM
- CREATE ANY TABLE
- CREATE ANY TRIGGER
- CREATE ANY VIEW
- DELETE ANY TABLE
- INSERT ANY TABLE
- UPDATE ANY TABLE
- SELECT ANY TABLE
- DROP ANY VIEW, TABLE
- DROP USER
- EXP_FULL_DATABASE
Table spaces “USERS” and“TEMP should be accessable for the schema_user
2. Drop the Oracle schema user and create the same planning application again
www.cogknowhow.com