Configuring an installation of CommandCentral Enterprise Reporter fails when trying to verify the Oracle schema.

Problem

After migrating the Oracle database to a new server and reinstalling CommandCentral Enterprise Reporter (CCER) the Oracle database schema verification fails. 

Error Message

installccer.log shows:

Verifying CommandCentral Enterprise Reporter schema....
Executing Executing /oracle/product/10.2.0/client_10g/bin/sqlplus -S -L SAHARA_APP/******@"(DESCRIPTION =(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST =
<host>)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME =CCER)))"
@/<path>/command_central_enterprise_reporter/scripts/db/saharaSchemaQuickCheck.sql
ERROR:
ORA-01017: invalid username/password; logon denied

SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus

Schema creation failed with SAHARA_APP login. Assuming table space files and schema are not created.

 

Cause

The SAHARA_APP user may not have the rights required to access the database.

Solution

Check the the SAHARA_APP has the select_catalog_role.

It may be possible then to check access to the database to determine it was replicated sucessfully, for example running the following query should return the users.

$ /oracle/product/10.2.0/client_10g/bin/sqlplus SAHARA_APP/******@CCER
SQL> select username from dba_users where username like 'SAHARA%';
USERNAME
------------------------------
SAHARA_COGNOS
SAHARA_REPORTS
SAHARA_APP
SAHARA
Check the schema by running the following script or the installation again and checking the installccer log:
<path>/command_central_enterprise_reporter/scripts/db/saharaSchemaQuickCheck.sql

 

 

Installccer.log shows:

.../command_central_enterprise_reporter/scripts/db/saharaSchemaQuickCheck.sql
exit=0
Verifying CommandCentral Enterprise Reporter schema....
CommandCentral Enterprise Reporter schema verification succeeded.

 


Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)