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

Article:TECH145933  |  Created: 2010-12-09  |  Updated: 2011-08-15  |  Article URL http://www.symantec.com/docs/TECH145933
Article Type
Technical Solution


Issue



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


Error



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.

 


Supplemental Materials

ValueORA-01017
Description

invalid username/password; logon denied


SourceError Code
ValueSP2-0751
Description

Unable to connect to Oracle.  Exiting SQL*Plus



Article URL http://www.symantec.com/docs/TECH145933


Terms of use for this information are found in Legal Notices