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
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
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’);
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