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
During the creation of a new application, the following error occurs "The db specified is in use by another system"
Oracle 10G, Windows 2003, Cognos Planning 8.4.1
The schema user created by the planning application during the application creation already exist, due to insufficient permissions of the oracle planning user.
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
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