Building a MulitMaster Mesh: Oracle permission problem?? (157 Views)
Reply
Frequent Advisor
Bertram Fukuda
Posts: 95
Registered: ‎11-30-2009
Message 1 of 1 (157 Views)

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

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation