Oracle Enterprise Manager 12c Cloud Control Installation
Widows Server 16
Oracle DB 12c

INFO: oracle.sysman.top.oms:Still Running...INFO: oracle.sysman.top.oms:Still Running...INFO: oracle.sysman.top.oms:Still Running...INFO: oracle.sysman.top.oms:Completed...INFO: oracle.sysman.top.oms:The create is completed now running the MOSINFO: oracle.sysman.top.oms:Calling post corrective action apiINFO: oracle.sysman.top.oms:Post Corrective Action Execution Status :trueINFO: oracle.sysman.top.oms:id_check_invalid_objects_ins ==> passid_check_job_queue_processes_param_ins ==> passid_check_stats_gather_job ==> passid_check_nls_length_semantics ==> passid_check_undo_management ==> passid_check_table_space_check ==> passtable_space_check_2_id ==> passpartitioning_option_check_id ==> passid_sec_remote_login_passwordfile ==> passid_sec_maximum_enables_roles_check ==> passid_check_stale_percent_global_preference ==> passid_check_sysman_absence_in_install ==> passid_check_existence_of_public_synonym ==> passid_check_absence_of_tablespaces ==> passid_check_absence_of_em_schema ==> passid_check_db_is_enterprise_edition ==> passid_check_sql_baseline_plan_cap ==> passid_check_temp_ts_group_present ==> passtmp_tblspc_autoext_id ==> passid_check_parallel_max_servers ==> passid_securefile_permitted_check ==> passid_check_compatible_param_ins ==> passid_check_db_blocksize_param ==> passid_check_processes_param ==> passid_check_pga_aggregate_target_param ==> passid_check_workarea_size_policy_param ==> passid_check_session_cached_cursors_param ==> passid_check_open_cursors_param ==> passid_check_sga_target_param ==> passid_check_log_buffer_param ==> passid_check_shared_pool_size_param ==> passid_check_db_cache_size_param ==> passid_check_large_pool_size_param ==> passid_check_java_pool_size_param ==> passid_check_streams_pool_size_param ==> passid_check_timed_statistics_param ==> passid_check_statistics_level_param ==> passid_check_redo_log_size ==> passINFO: oracle.sysman.top.oms:Post Corrective Action SuccessINFO: oracle.sysman.top.oms:The plug-in Repository Configuration has successfully been performedINFO: oracle.sysman.top.oms:About to execute plug-in MDS Schema ConfigurationINFO: oracle.sysman.top.oms:The plug-in MDS Schema Configuration is runningINFO: oracle.sysman.top.oms:Internal PlugIn Class: oracle.sysman.oms.MDSSchemaConfigurationINFO: oracle.sysman.top.oms:Classpath = D:\EM\oms\sysman\jlib\omsConfig.jar;D:\EM\oms\jdbc\lib\ojdbc6.jar;D:\EM\oms\sysman\jlib\emcore_client.jar;D:\EM\oms\..\modules\com.bea.core.apache.log4j_1.2.13.jar;D:\EM\oms\jlib\rcucommon.jar;D:\EM\oms\jdbc\lib\ojdbc6.jar;D:\EM\oms\sysman\jlib\emagentSDK.jar;D:\EM\oms\..\oracle_common\modules\oracle.xdk_11.1.0\xmlparserv2.jar;D:\EM\oms\..\oracle_common\modules\oracle.odl_11.1.1\ojdl.jar;D:\EM\oms\..\oracle_common\modules\oracle.xdk_11.1.0\xml.jar;D:\EM\oms\..\oracle_common\modules\oracle.jdbc_11.1.1\ojdbc6dms.jar;D:\EM\oms\..\oracle_common\modules\oracle.dms_11.1.1\dms.jar;D:\EM\oms\..\oracle_common\modules\oracle.odl_11.1.1\ojdl.jar;D:\EM\oms\jlib\rcu.jar;D:\EM\oms\jlib\SchemaVersion.jar;D:\EM\oms\..\oracle_common\jlib\ua.jar;D:\EM\oms\..\oracle_common\modules\oracle.ldap_11.1.1\ojmisc.jar;D:\EM\oms\..\oracle_common\modules\oracle.pki_11.1.1\oraclepki.jar;D:\EM\oms\..\oracle_common\modules\oracle.osdt_11.1.1\osdt_cert.jar;D:\EM\oms\..\oracle_common\modules\oracle.osdt_11.1.1\osdt_core.jarINFO: oracle.sysman.top.oms:BaseConfiguration:invoke:Starting BaseConfiguration invoke method on an aggregate=oracle.sysman.top.oms for Action=configuration in step=8:microstep=0INFO: oracle.sysman.top.oms:__________________________DUMPING PARAMETERS______________________________________________INFO: oracle.sysman.top.oms:OracleHome: D:\EM\omsINFO: oracle.sysman.top.oms:Connect String: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle3.mks.local)(PORT=1521)))(CONNECT_DATA=(SID=test)))INFO: oracle.sysman.top.oms:SYS User: SYSINFO: oracle.sysman.top.oms:________________________________________________________________________INFO: oracle.sysman.top.oms:MDS Schema Creation status: FAILURE SEVERE: oracle.sysman.top.oms:MDS Schema Creation is failedINFO: oracle.sysman.top.oms:_______________________________________________________________________INFO: oracle.sysman.top.oms:Starting opss Schema Creation.INFO: oracle.sysman.top.oms:Failed to create OPSS schemaINFO: oracle.sysman.top.oms:_______________________________________________________________________INFO: oracle.sysman.top.oms:Starting APM Schema Creation.INFO: oracle.sysman.top.oms:Failed to create APM schemaINFO: oracle.sysman.top.oms:The plug-in MDS Schema Configuration has failed its perform method



2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : Oracle Home is D:\EM\oms2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : Trying to set RCU_HOME to D:\EM\oms2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : RCU_HOME is D:\EM\oms2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : Trying to set SCRIPT_HOME to D:\EM\oms\rcu\integration2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : SCRIPT_HOME is D:\EM\oms\rcu\integration2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : Trying to set RCU_LOG_LOCATION to D:\EM\oms\cfgtoollogs\cfgfw2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : RCU_LOG_LOCATION is D:\EM\oms\sysman\log\schemamanager\m_15.07.19_0719\m_15.07.19_0719.CREATE\2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : Trying to set RCU_LOG_NAME to emmds.log2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : RCU_LOG_NAME is rcu.log2019_07_15_н.э._08_52_43_VET EMSchemaMDSSchemaManager: The existing MDS schema may not be available. A new one will be created. Code is :2019_07_15_н.э._08_52_43_VET 9422019_07_15_н.э._08_52_43_VET MDS version is null2019_07_15_н.э._08_52_43_VET Has MDS user? false2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : Prepare to initialize RCU2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : RCU initialized with parameters : -silent -createRepository -compInfoXMLLocation D:\EM\oms\sysman\emdrep\config\mds\ComponentInfo.xml -storageXMLLocation D:\EM\oms\sysman\emdrep\config\mds\Storage.xml -connectString (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle3.mks.local)(PORT=1521)))(CONNECT_DATA=(SID=test))) -dbUser SYS -dbRole sysdba -schemaPrefix SYSMAN -component MDS 2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : Start rewriting mds.xml2019_07_15_н.э._08_52_43_VET removePrereqFromMDS : mdsComp.xml[D:\EM\oms\rcu\integration\mds\mdsComp.xml]2019_07_15_н.э._08_52_43_VET removePrereqFromMDS : mds.xml[D:\EM\oms\rcu\integration\mds\mds.xml]2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : Finish rewriting mds.xml2019_07_15_н.э._08_52_43_VET EMMDSSchemaManager: Info : Invoking RCU2019_07_15_н.э._08_56_19_VET ERROR:MDS: ORA-28104: ??????? ???????? ??? statement_types ???????? ????????????ORA-06512: ?? "SYS.DBMS_RLS_INT" line 23ORA-06512: ?? "SYS.DBMS_RLS" line 54ORA-06512: ?? line 115D:\EM\oms\rcu\integration\mds\sql\cremdsvpd.sqlStatement:DECLARE schemaName all_policies.object_owner%TYPE; vpdAvailable VARCHAR2(64);BEGIN BEGIN -- Skip policy creation if VPD is not supported. SELECT value INTO vpdAvailable FROM v$option WHERE parameter = 'Fine-grained access control'; IF ( vpdAvailable <> 'TRUE' ) THEN RETURN; END IF; EXCEPTION WHEN NO_DATA_FOUND THEN RETURN; WHEN OTHERS THEN -- Reraise the exception. RAISE; END; schemaName := SYS_CONTEXT('USERENV''SESSION_SCHEMA'); -- Add read policies DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_paths' policy_name => 'mds_paths_read' function_schema => schemaName policy_function => 'mds_internal_common.vpdReadPolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'select' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_depl_lineages' policy_name => 'mds_depl_lineages_read' function_schema => schemaName policy_function => 'mds_internal_common.vpdReadPolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'select' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_labels' function_schema => schemaName policy_name => 'mds_labels_read' policy_function => 'mds_internal_common.vpdReadPolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'select' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_streamed_docs' policy_name => 'mds_streamed_docs_read' function_schema => schemaName policy_function => 'mds_internal_common.vpdReadPolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'select' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_metadata_docs' policy_name => 'mds_metadata_docs_read' function_schema => schemaName policy_function => 'mds_internal_common.vpdReadPolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'select' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_dependencies' policy_name => 'mds_dependencies_read' function_schema => schemaName policy_function => 'mds_internal_common.vpdReadPolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'select' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_sandboxes' policy_name => 'mds_sandboxes_read' function_schema => schemaName policy_function => 'mds_internal_common.vpdReadPolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'select' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_components' policy_name => 'mds_components_read' function_schema => schemaName policy_function => 'mds_internal_common.vpdReadPolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'select' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_attributes' policy_name => 'mds_attributes_read' function_schema => schemaName policy_function => 'mds_internal_common.vpdReadPolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'select' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_large_attributes' policy_name => 'mds_large_attributes_read' function_schema => schemaName policy_function => 'mds_internal_common.vpdReadPolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'select' ); -- Add write policy DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_paths' policy_name => 'mds_paths_write' function_schema => schemaName policy_function => 'mds_internal_common.vpdWritePolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'update insert delete' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_depl_lineages' policy_name => 'mds_depl_lineages_write' function_schema => schemaName policy_function => 'mds_internal_common.vpdWritePolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'update insert delete' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_labels' policy_name => 'mds_labels_write' function_schema => schemaName policy_function => 'mds_internal_common.vpdWritePolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'update insert delete' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_streamed_docs' policy_name => 'mds_streamed_docs_write' function_schema => schemaName policy_function => 'mds_internal_common.vpdWritePolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'update insert delete' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_metadata_docs' policy_name => 'mds_metadata_docs_write' function_schema => schemaName policy_function => 'mds_internal_common.vpdWritePolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'update insert delete' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_dependencies' policy_name => 'mds_dependencies_write' function_schema => schemaName policy_function => 'mds_internal_common.vpdWritePolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'update insert delete' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_sandboxes' policy_name => 'mds_sandboxes_write' function_schema => schemaName policy_function => 'mds_internal_common.vpdWritePolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'update insert delete' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_components' policy_name => 'mds_components_write' function_schema => schemaName policy_function => 'mds_internal_common.vpdWritePolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'update insert delete' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_attributes' policy_name => 'mds_attributes_write' function_schema => schemaName policy_function => 'mds_internal_common.vpdWritePolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'update insert delete' ); DBMS_RLS.ADD_POLICY ( object_schema => schemaName object_name => 'mds_large_attributes' policy_name => 'mds_large_attributes_write' function_schema => schemaName policy_function => 'mds_internal_common.vpdWritePolicy' policy_type => dbms_rls.SHARED_STATIC statement_types => 'update insert delete' );END;2019_07_15_н.э._08_56_25_VET Creation of MDS schema fails

lleopolld1,
там,где выражение начинается на update должно быть statement_types => 'update, insert, delete'

123йй, точно,там ответ. В поисках глаз замылился) Спасибо!