Server Automation Support and News Forum
Showing results for 
Search instead for 
Do you mean 

Building a MulitMaster Mesh: Oracle permission problem??

Highlighted
Regular Advisor

Building a MulitMaster Mesh: Oracle permission problem??

Hi.  We are build a HPSA MultiMaster Mesh in our lab and have run into an issue.  We have Core A, which contains sabd and sasrv. Both servers we build using the HPSA binaries released 4 Feb 2013 (IE Software_Server_Automation_9.10_$PROD_T89000-1590#.iso).  sasrv was also patched using bootcert patch (based on KM00322074) and upgraded to 9.14.

 

      Core B servers are sadb2 and sasrv2. 

 

    In preparation for the MultiMaster Mesh we did

-              (from sasrv) define new facility; export model repository (get error about Opsware patch is installed and must be removed before proceeding per discussion with HPSA Engineer)

-              (from sasrv) export Model Repository (get error about Opsware patch is installed and must be removed before proceeding per discussion with HPSA Engineer)

-              copy response file from sasrv to sadb2

-              copy crypto database from sasrv to sasrv2

-              install database on sadb2

-              Copy database dump files from sadb to sadb2

-              Copy source_db_charset.txt from sasrv to sasrv2

 

sasvr2 -  run opware_install.sh –resp_file=/var/tmp/oiresponse.bui

 

                The installer starts to import the database schemas etc then I see these errors.  Please keep in mind that these are brand new servers that we built from scratch.

 

ORA-39082: Object type ALTER_PACKAGE_SPEC:”TRUTH”.”FIBREFABRICELEMENTS” created with complication errors

ORA-39082: Object type ALTER_PACKAGE_SPEC:”TRUTH”.”AGENTPACKAGE” created with complication errors

ORA-39082: Object type ALTER_PACKAGE_SPEC:”TRUTH”.”STORAGEDEVICES” created with complication errors

Processing ..

Processing..

Job “TRUTH”.”SA_TRUTH_IMPDP_JOB” completed with 4 error(s)

 

[INFO] Processing step 4(Aaa) of 6 for this phase

[INFO] Importing AAA schema

 

Does some more imports then we get this

 

ORA-31685: Object type PROCEDURE:”AAA”.”GATHER_AAA_SCHEMA_STATS” failed due to insufficient privileges.  Failing sql is:

CREATE_PROCEDURE gather_aaa_scheme_stats IS

                v_count NUMBER=0;

BEGIN

                DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>’AAA’, estimate_percent->dbms_stats.auto_sample_size, degree=>10, method_opt=>’FOR ALL COLUMNS SIZE AUTO’, options=>’GATHER’, cascade=>’TRUE’,gather_temp=>’TRUE’);

EXCEPTION

                WHEN OTHER THEN

                Raise_application_error(-20001, ‘An error was encountered –

Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

ORA-39083: Object type ALTER_PROCEDURE failed to create with error:

ORA-04043: Object GATHER_AAA_SCHEMA_STATS does not exist

Failing sql is:

ALTER PROCEDURE “AAA”.”GATHER_AAA_SCHEMA_STATS”  COMPILE  PLSQL_OPTIMIZE_LEVEL=2  PLSQL_CODE_TYPE=INTERPRETED  PLSQL_DEBUG= FALSE  PLSCOPE_SETTINGS- ‘IDENTIFIERS:NONE’ REUSE SETTINGS TIMESTAMP ‘2013-05-09 20:43:01’

 

By the way, these are the exact same procedures used to build the other Meshs in our lab environment.  

 

TIA, 

Bert