1 PACKAGE dbms_registry AS
2
3 -- CONSTANTS
4 release_version CONSTANT registry$.version%type := '12.1.0.2.0';
5 release_status CONSTANT VARCHAR2(30) := 'Production';
6
7 -- Component Hierarchy Type and CONSTANTS
8 TYPE comp_list_t IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
9 IMD_COMPS CONSTANT NUMBER :=1; /* immediate subcomponents */
10 TRM_COMPS CONSTANT NUMBER :=2; /* terminal subcomponents */
11 ALL_COMPS CONSTANT NUMBER :=3; /* all subcomponents */
12
13 -- Schema List Parameter
14 TYPE schema_list_t IS TABLE OF dbms_id;
15
16 -- Component dependency Type - table of component IDs
17 TYPE comp_depend_list_t IS TABLE OF VARCHAR2(30);
18
19 -- Component dependency Type - table of component IDs and associated namespaces
20 TYPE comp_depend_record_t IS RECORD(
21 cid VARCHAR2(30), -- component id
22 cnamespace VARCHAR2(30) -- component namespace
23 );
24
25 TYPE comp_depend_rec IS TABLE OF comp_depend_record_t INDEX BY BINARY_INTEGER;
26
27 PROCEDURE set_session_namespace (namespace IN VARCHAR2);
28
29 PROCEDURE set_comp_namespace (comp_id IN VARCHAR2,
30 namespace IN VARCHAR2);
31
32 PROCEDURE set_rdbms_status(comp_id IN VARCHAR2,
33 status IN NUMBER);
34
35 PROCEDURE set_rdbms_upgraded_status(comp_id IN VARCHAR2);
36
37 PROCEDURE invalid (comp_id IN VARCHAR2);
38
39 PROCEDURE valid (comp_id IN VARCHAR2);
40
41 PROCEDURE loading (comp_id IN VARCHAR2,
42 comp_name IN VARCHAR2,
43 comp_proc IN VARCHAR2 DEFAULT NULL,
44 comp_schema IN VARCHAR2 DEFAULT NULL,
45 comp_parent IN VARCHAR2 DEFAULT NULL);
46
47 PROCEDURE loading (comp_id IN VARCHAR2,
48 comp_name IN VARCHAR2,
49 comp_proc IN VARCHAR2,
50 comp_schema IN VARCHAR2,
51 comp_schemas IN schema_list_t,
52 comp_parent IN VARCHAR2 DEFAULT NULL);
53
54 PROCEDURE loaded (comp_id IN VARCHAR2,
55 comp_version IN VARCHAR2 DEFAULT NULL,
56 comp_banner IN VARCHAR2 DEFAULT NULL);
57
58 PROCEDURE upgrading (comp_id IN VARCHAR2,
59 new_name IN VARCHAR2 DEFAULT NULL,
60 new_proc IN VARCHAR2 DEFAULT NULL,
61 new_schema IN VARCHAR2 DEFAULT NULL,
62 new_parent IN VARCHAR2 DEFAULT NULL);
63
64 PROCEDURE upgrading (comp_id IN VARCHAR2,
65 new_name IN VARCHAR2,
66 new_proc IN VARCHAR2,
67 new_schema IN VARCHAR2,
68 new_schemas IN schema_list_t,
69 new_parent IN VARCHAR2 DEFAULT NULL);
70
71 PROCEDURE upgraded (comp_id IN VARCHAR2,
72 new_version IN VARCHAR2 DEFAULT NULL,
73 new_banner IN VARCHAR2 DEFAULT NULL);
74
75 PROCEDURE downgrading (comp_id IN VARCHAR2,
76 old_name IN VARCHAR2 DEFAULT NULL,
77 old_proc IN VARCHAR2 DEFAULT NULL,
78 old_schema IN VARCHAR2 DEFAULT NULL,
79 old_parent IN VARCHAR2 DEFAULT NULL);
80
81 PROCEDURE downgraded (comp_id IN VARCHAR2,
82 old_version IN VARCHAR2 DEFAULT NULL);
83
84 PROCEDURE removing (comp_id IN VARCHAR2);
85
86 PROCEDURE removed (comp_id IN VARCHAR2);
87
88 PROCEDURE option_off (comp_id IN VARCHAR2);
89
90 PROCEDURE startup_required (comp_id IN VARCHAR2);
91
92 PROCEDURE startup_complete (comp_id IN VARCHAR2);
93
94 PROCEDURE reset_version (comp_id IN VARCHAR2);
95
96 PROCEDURE update_schema_list
97 (comp_id IN VARCHAR2,
98 comp_schemas IN schema_list_t);
99
100 FUNCTION status_name (status NUMBER) RETURN VARCHAR2;
101
102 FUNCTION status (comp_id IN VARCHAR2) RETURN VARCHAR2;
103
104 FUNCTION version (comp_id IN VARCHAR2) RETURN VARCHAR2;
105
106 FUNCTION prev_version (comp_id IN VARCHAR2) RETURN VARCHAR2;
107
108 FUNCTION edition (comp_id IN VARCHAR2) RETURN VARCHAR2;
109
110 FUNCTION schema (comp_id IN VARCHAR2) RETURN VARCHAR2;
111
112 FUNCTION schema_list (comp_id IN VARCHAR2) RETURN schema_list_t;
113
114 FUNCTION schema_list_string (comp_id IN VARCHAR2) RETURN VARCHAR2;
115
116 FUNCTION subcomponents (comp_id IN VARCHAR2,
117 comp_option IN NUMBER DEFAULT 1)
118 RETURN comp_list_t;
119
120 FUNCTION comp_name (comp_id IN VARCHAR2) RETURN VARCHAR2;
121
122 FUNCTION session_namespace RETURN VARCHAR2;
123
124 FUNCTION script (comp_id IN VARCHAR2,
125 script_name IN VARCHAR2) RETURN VARCHAR2;
126
127 FUNCTION script_path (comp_id IN VARCHAR2) RETURN VARCHAR2;
128
129 FUNCTION script_prefix (comp_id IN VARCHAR2) RETURN VARCHAR2;
130
131 FUNCTION nothing_script RETURN VARCHAR2;
132
133 FUNCTION is_loaded (comp_id IN VARCHAR2,
134 version IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;
135
136 FUNCTION is_valid (comp_id IN VARCHAR2,
137 version IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;
138
139 FUNCTION is_startup_required (comp_id IN VARCHAR2) RETURN NUMBER;
140
141 FUNCTION is_component (comp_id VARCHAR2) RETURN BOOLEAN;
142
143 FUNCTION is_in_registry (comp_id IN VARCHAR2) RETURN BOOLEAN;
144
145 FUNCTION count_errors_in_registry (comp_id IN VARCHAR2) RETURN NUMBER;
146
147 FUNCTION is_in_upgrade_mode RETURN BOOLEAN;
148
149 FUNCTION is_trace_event_set(trace_event VARCHAR2) RETURN BOOLEAN;
150
151 FUNCTION is_db_consolidated RETURN BOOLEAN;
152
153 FUNCTION is_db_root RETURN BOOLEAN;
154
155 FUNCTION is_db_pdb RETURN BOOLEAN;
156
157 FUNCTION is_db_pdb_seed RETURN BOOLEAN;
158
159 FUNCTION set_session_to_container_name(con_name IN obj$.name%TYPE) RETURN BOOLEAN;
160
161 FUNCTION get_container_name(con_id IN container$.con_id#%TYPE)
162 RETURN obj$.name%TYPE;
163
164 FUNCTION set_session_container (con_id IN container$.con_id#%TYPE) RETURN BOOLEAN;
165
166 FUNCTION num_of_exadata_cells RETURN NUMBER;
167
168 PROCEDURE check_server_instance;
169
170 PROCEDURE set_progress_action (comp_id IN VARCHAR2,
171 action IN VARCHAR2,
172 value IN VARCHAR2 DEFAULT NULL,
173 step IN NUMBER DEFAULT NULL);
174
175 PROCEDURE delete_progress_action (comp_id IN VARCHAR2,
176 action IN VARCHAR2);
177
178 PROCEDURE set_progress_value (comp_id IN VARCHAR2,
179 action IN VARCHAR2,
180 value IN VARCHAR2);
181
182 PROCEDURE set_progress_step (comp_id IN VARCHAR2,
183 action IN VARCHAR2,
184 step IN NUMBER);
185
186 FUNCTION get_progress_value (comp_id IN VARCHAR2,
187 action IN VARCHAR2) RETURN VARCHAR2;
188
189 FUNCTION get_progress_step (comp_id IN VARCHAR2,
190 action IN VARCHAR2) RETURN NUMBER;
191
192 PROCEDURE set_required_comps (comp_id IN VARCHAR2,
193 comp_depend_list IN comp_depend_list_t );
194
195 PROCEDURE set_required_comps (comp_id IN VARCHAR2,
196 comp_depend_list IN comp_depend_rec );
197
198 FUNCTION get_required_comps (comp_id IN VARCHAR2) RETURN comp_depend_list_t;
199
200 FUNCTION get_required_comps_rec (comp_id IN VARCHAR2) RETURN comp_depend_rec;
201
202 FUNCTION get_dependent_comps (comp_id IN VARCHAR2) RETURN comp_depend_list_t;
203
204 FUNCTION get_dependent_comps_rec (comp_id IN VARCHAR2) RETURN comp_depend_rec;
205
206 PROCEDURE set_edition (comp_id IN VARCHAR2);
207
208 PROCEDURE set_edition (comp_id IN VARCHAR2,
209 edition_var IN VARCHAR2);
210
211 FUNCTION get_con_id RETURN NUMBER;
212
213 END dbms_registry;