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

Article:TECH145933

Created: 2010-12-10

Updated: 2011-08-16

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

Article Type
Technical Solution

Product(s)

Show all

Languages

Show all

Problem

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

Value	ORA-01017
Description	invalid username/password; logon denied

Source	Error Code
Value	SP2-0751
Description	Unable to connect to Oracle. Exiting SQL*Plus