Rem drv: Rem Rem $Header: website_post_creation.sql 23-jul-2007.12:37:51 shnavane Exp $ Rem Rem website_post_creation.sql Rem Rem Copyright (c) 2005, 2007, Oracle. All rights reserved. Rem Rem NAME Rem website_post_creation.sql - Rem Rem DESCRIPTION Rem Rem Rem NOTES Rem Rem Rem MODIFIED (MM/DD/YY) Rem shnavane 07/23/07 - Fix bug #5970781 Rem shnavane 07/23/07 - Backport shnavane_bug-5970781 from main Rem yxie 11/21/06 - XbranchMerge yxie_bug5527422 from main Rem yxie 11/09/06 - XbranchMerge yxie_bug5567723 from main Rem yxie 11/21/06 - XbranchMerge yxie_bug5527422 from main Rem yxie 11/09/06 - XbranchMerge yxie_bug5567723 from main Rem yxie 07/11/05 - change 102010 to 102020 Rem gsbhatia 07/03/05 - New repmgr header impl Rem yxie 06/20/05 - yxie_bug-4390544 Rem yxie 05/25/05 - Created Rem -- Add new supportsEUM and supportsE2E properties BEGIN MGMT_TARGET.add_target_type_property(MGMT_GLOBAL.G_WEBSITE_TARGET_TYPE, MGMT_WEBSITE_TARGET.SUPPORTS_EUM_PROP, 1); MGMT_TARGET.add_target_type_property(MGMT_GLOBAL.G_WEBSITE_TARGET_TYPE, MGMT_WEBSITE_TARGET.SUPPORTS_E2E_PROP, 1); mgmt_log.register_logging_module ( MGMT_WEBSITE_TARGET.MODULE_NAME, 'Website EUME2E Association Callbacks'); END; / show errors; -- Register callbacks BEGIN mgmt_assoc.add_assoc_deletion_callback( 'MGMT_WEBSITE_TARGET.key_del_callback', MGMT_ASSOC.ASSOC_DEF_DEPENDS_ON, MGMT_GLOBAL.G_WEBSITE_TARGET_TYPE); mgmt_assoc.add_assoc_deletion_callback( 'MGMT_WEBSITE_TARGET.cluster_mem_del_callback', MGMT_ASSOC.ASSOC_DEF_CONTAINS, 'oc4j_cluster'); mgmt_assoc.add_assoc_addition_callback( 'MGMT_WEBSITE_TARGET.cluster_mem_add_callback', MGMT_ASSOC.ASSOC_DEF_CONTAINS, 'oc4j_cluster'); mgmt_assoc.add_assoc_deletion_callback( 'MGMT_WEBSITE_TARGET.cluster_mem_del_callback', MGMT_ASSOC.ASSOC_DEF_CONTAINS, 'oracle_apache_cluster'); mgmt_assoc.add_assoc_addition_callback( 'MGMT_WEBSITE_TARGET.cluster_mem_add_callback', MGMT_ASSOC.ASSOC_DEF_CONTAINS, 'oracle_apache_cluster'); mgmt_assoc.add_assoc_deletion_callback( 'MGMT_WEBSITE_TARGET.cluster_mem_del_callback', MGMT_ASSOC.ASSOC_DEF_CONTAINS, MGMT_GLOBAL.G_REDUNDANCY_GROUP_TARGET_TYPE); mgmt_assoc.add_assoc_addition_callback( 'MGMT_WEBSITE_TARGET.cluster_mem_add_callback', MGMT_ASSOC.ASSOC_DEF_CONTAINS, MGMT_GLOBAL.G_REDUNDANCY_GROUP_TARGET_TYPE); em_target.add_tgt_pre_deletion_callback('MGMT_WEBSITE_TARGET.del_key_cluster_callback', ' ', 'oc4j_cluster', 0); em_target.add_tgt_pre_deletion_callback('MGMT_WEBSITE_TARGET.del_key_cluster_callback', ' ', 'oracle_apache_cluster', 0); em_target.add_tgt_pre_deletion_callback('MGMT_WEBSITE_TARGET.del_key_cluster_callback', ' ', MGMT_GLOBAL.G_REDUNDANCY_GROUP_TARGET_TYPE, 0); END; / show error; @&EM_SQL_ROOT/core/10.2.0.4/website/website_post_creation.sql BEGIN DELETE FROM EUME2E_ASSOCS_LOOKUP; INSERT INTO EUME2E_ASSOCS_LOOKUP (TARGET_TYPE, ASSOC_GUID, IS_GROUP, EXPAND_GROUP) VALUES(MGMT_GLOBAL.G_WEBCACHE_TARGET_TYPE, MGMT_WEBSITE_TARGET.supports_eum_on_guid, 0, 0); INSERT INTO EUME2E_ASSOCS_LOOKUP (TARGET_TYPE, ASSOC_GUID, IS_GROUP, EXPAND_GROUP) VALUES(MGMT_GLOBAL.G_HTTP_SERVER_TARGET_TYPE, MGMT_WEBSITE_TARGET.supports_eum_on_guid, 0, 0); INSERT INTO EUME2E_ASSOCS_LOOKUP (TARGET_TYPE, ASSOC_GUID, IS_GROUP, EXPAND_GROUP) VALUES('generic_apache', MGMT_WEBSITE_TARGET.supports_eum_on_guid, 0, 0); INSERT INTO EUME2E_ASSOCS_LOOKUP (TARGET_TYPE, ASSOC_GUID, IS_GROUP, EXPAND_GROUP) VALUES('oracle_apache_cluster', MGMT_WEBSITE_TARGET.supports_eum_on_guid, 1, 0); INSERT INTO EUME2E_ASSOCS_LOOKUP (TARGET_TYPE, ASSOC_GUID, IS_GROUP, EXPAND_GROUP) VALUES(MGMT_GLOBAL.G_REDUNDANCY_GROUP_TARGET_TYPE, MGMT_WEBSITE_TARGET.supports_eum_on_guid, 1, 0); INSERT INTO EUME2E_ASSOCS_LOOKUP (TARGET_TYPE, ASSOC_GUID, IS_GROUP, EXPAND_GROUP) VALUES(MGMT_GLOBAL.G_OC4J_TARGET_TYPE, MGMT_WEBSITE_TARGET.supports_e2e_on_guid, 0, 0); INSERT INTO EUME2E_ASSOCS_LOOKUP (TARGET_TYPE, ASSOC_GUID, IS_GROUP, EXPAND_GROUP) VALUES('oc4j_cluster', MGMT_WEBSITE_TARGET.supports_e2e_on_guid, 1, 0); INSERT INTO EUME2E_ASSOCS_LOOKUP (TARGET_TYPE, ASSOC_GUID, IS_GROUP, EXPAND_GROUP) VALUES(MGMT_GLOBAL.G_REDUNDANCY_GROUP_TARGET_TYPE, MGMT_WEBSITE_TARGET.supports_e2e_on_guid, 1, 0); INSERT INTO EUME2E_ASSOCS_LOOKUP (TARGET_TYPE, ASSOC_GUID, IS_GROUP, EXPAND_GROUP) VALUES('oracle_forms', MGMT_WEBSITE_TARGET.supports_forms_on_guid, 0, 0); END; / show errors;