[Home] [Help]
1069: -- 1) Admin - Currently no processes are defined for this server
1070: -- 2) Web - Consists of Apache Web Listener, Apache Jserv
1071: -- 3) Forms - Consists of the forms launcher
1072: -- 4) CP - Consists of the Internal Concurrent Manager, Reports
1073: -- 5) Data - Consists of the database instances as defined in gv$instance.
1074: --
1075: -- Input Arguments
1076: --
1077: -- Output Arguments
1142: end loop;
1143:
1144: -- For DATA SERVER
1145: -- We will need to collect database statuses for all the
1146: -- individual instances list in gv$instance
1147: declare
1148: v_db_status number := STATUS_NORMAL;
1149: v_db_count number := 0;
1150: v_node_name varchar2(100);
1150: v_node_name varchar2(100);
1151: v_db_node_registered boolean := false;
1152: cursor dbst_c is
1153: select upper(host_name) host_name, instance_name, database_status
1154: from gv$instance;
1155:
1156: -- added the where clause to this cursor as a fix for bug 3955412
1157: cursor nodex_c is
1158: --rjaiswal bug#4917109
1156: -- added the where clause to this cursor as a fix for bug 3955412
1157: cursor nodex_c is
1158: --rjaiswal bug#4917109
1159: -- For virtual host we have the entry of main host in this column 'webhost'
1160: -- So this column can be used to compare the gv$instance host_name value
1161: -- instead of comparing it with node_name.Added webhost column
1162: select upper(node_name) node_name,upper(webhost) webhost from FND_OAM_FNDNODES_VL
1163: where node_mode = 'O'
1164: and (nvl(support_cp, 'N') = 'Y' or
1207: substr(ndx.webhost, 0,
1208: instr(ndx.webhost, '.') - 1))
1209: into v_fn_webhost from dual;
1210: -- ADDED "or v_gv_host = v_fn_webhost" in the "if" condition
1211: -- This column can be used to compare the gv$instance host_name value
1212: if ( v_gv_host = v_fn_node or v_gv_host = v_fn_webhost) then
1213: v_node_name := ndx.node_name;
1214: --rjaiswal bug#4917109 ends
1215: v_db_node_registered := true;