Manually modify the occurrences of the Source database user name with a new Target database user name (see the REMAP_SCHEMA attribute mentioned in the Restore the Complete Exported Dumps Into the Target Environment Database section).
1. Manually modify the occurrences of the Source Config database user name with the new Target Config database user name. See the following table for details.
Table 3: Source and Target Config Database User Name Files
|
Sl. No. |
Directory Path |
File Name |
|
1. 1 |
$FIC_HOME/conf/ |
Reveleus.SEC |
|
2. 2 |
$FIC_HOME/utility/OFSAAGenerateRepository/conf/ |
Reveleus.SEC |
|
3. 3 |
$FIC_HOME/conf/ |
DynamicServices.xml |
|
4. 4 |
$FIC_HOME/MigrationUtilities/Migration_LDAP/conf/ |
DynamicServices.xml |
|
5. 5 |
$FIC_HOME/utility/OFSAAGenerateRepository/conf/ |
DynamicServices.xml |
|
6. 6 |
$FIC_HOME/ficweb/webroot/conf/ |
DynamicServices.xml |
|
7. 7 |
$FIC_HOME/EXEWebService/Tomcat/ROOT/conf/ |
DynamicServices.xml |
|
8. 8 |
$FIC_HOME/EXEWebService/WebSphere/ROOT/conf/ |
DynamicServices.xml |
|
9. 9 |
$FIC_HOME/EXEWebService/weblogic/ROOT/conf/ |
DynamicServices.xml |
|
NOTE |
· Based on the web application server, choose the relevant directory path from Sl. No. 7, 8, or 9 from Table 3. · If any file is not available in the mentioned path, you can ignore it. |
2. Log in to the newly imported Atomic Schemas. Perform the following steps on each Atomic Schema to modify the interdependent object:
Execute the following query to verify invalid object status:
select object_type, object_name from user_objects
where object_type in ('FUNCTION','PACKAGE','PACKAGE BODY','PROCEDURE','TRIGGER','VIEW') and status = 'INVALID'
order by object_type , object_name;
If the preceding query lists out the objects, then you can compile the invalid objects by following step 2.
3. Run the following anonymous block to compile the invalid objects:
BEGIN
FOR cur_rec IN ( select object_type, object_name from user_objects
where object_type in ('FUNCTION','PACKAGE','PACKAGE BODY','PROCEDURE','TRIGGER','VIEW') and status = 'INVALID'
order by object_type , object_name )
LOOP
BEGIN
IF cur_rec.object_type = 'PACKAGE BODY' THEN
EXECUTE IMMEDIATE 'ALTER PACKAGE ' || ' "' || cur_rec.object_name || '" COMPILE BODY';
COMMIT;
ELSE
EXECUTE IMMEDIATE 'ALTER ' || cur_rec.object_type || ' "' || cur_rec.object_name || '" COMPILE';
COMMIT;
END IF;
EXCEPTION
WHEN OTHERS THEN NULL;
END;
END LOOP;
END;