Invantive Estate
Duplicate Environment using an Export Schema |
To duplicate an environment using a schema export makes it possible to change the names of the schemas involved.
Perform the following steps to copy an environment, for example, by copying production back to test:
•Create a configuration file.
•Create the users and tablespaces with bubs_create.bat.
•Install the database of Invantive Estate till the instantiate objects if the target environment is used for the first time.
•Export the data to a file with the statements:
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
exp userid=pbubs/pbubs@orcl buffer=1000000 file=pbubs.dmp grants=no log=pbubs_exp.log consistent=yes
•In the first ten lines of the log file check that there has been no conversion of characters between character sets.
•Stop Microsoft IIS and Apache Tomcat for the target environment.
•Clear the target environment: delete all old tables, sequences, views, functions, procedures, triggers and packages.
•Upload the file in the new environment based upon an export made by the owner of the application:
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
imp userid=tbubs/tbubs@orcl buffer=1000000 file=pbubs.dmp log=imp_bubs.log full=y ignore=y
•Check that all objects are valid and check that the counts concerning numbers of objects between the environments are correct, for instance with the following query:
select owner
, count(*)
, object_type
, status
from dba_objects
where owner like '%BUBS'
group
by owner
, object_type
, status
/
•Copy the rights by executing the following script as being the Invantive Estate application owner (in this example pbubs). Do replace OLD and NEW by the right schema names:
set pages 0
set feedback off
set lines 500
set trimspool on
spool grt.sql
select replace
( replace
( 'grant '
|| privilege
|| ' on '
|| table_name
|| ' to '
|| grantee
|| ';'
, 'OUD'
, 'NIEUW'
)
, 'OUDITGEN'
, 'NIEUWITGEN'
)
txt
from user_tab_privs
where 1=1
and grantee <> 'OUD'
/
spool off
exit
•Then, log on as the new Invantive Estate application owner NEW under Oracle SQL*Plus and execute the script:
connect NIEUW@orcldb01
@grt
•Add the needed synonyms under Oracle SQL*Plus:
connect NIEUW_tomcat@DATABASEID
begin
<BUBS OWNER>.bubs_maintain_my_synonyms('<BUBS OWNER>');
end;
•Finally, copy the software from the Tomcat webapps tree to the target server:
cd /opt/tomcat/webapps
mv bubstarget /tmp/bubstarget
cp -pr bubssource bubstarget
•Do not forget to enter the correct passwords into site.properties and to adjust the URL's. See Site.properties.
•Restart Invantive Estate:
/etc/init.d/bubs3 restart
•Open the application as user ‘system’.
•Change in settings the description of the environment.
•Adapt the profile options.
•Change in the screen financial Administrations, the administration from where data is uploaded.
•If necessary, change the passwords of all users with an SQL update:
connect NIEUW_tomcat@DATABASEID
begin
bubs_session.set_session_info(null, null, 'system', null, null, null, null);
end;
/
update bubs_gebruikers_v
set gbr_wachtwoord='test'
where gbr_wachtwoord is not null
/
commit
/
•Delete all documents from the document folder of the target environment.
•Copy the documents in the document folder of the source environment to the target environment.
•Link the documents to the new directory:
update bubs_documenten_v
set dct_bestandsinhoud=bfilename('<NIEUW_DCT>', bubs_get_bfile_filename(dct_bestandsinhoud))
where bubs_get_bfile_directory(dct_bestandsinhoud) <> '<NIEUW>_DCT'
and dct_bestand_url is null
/
commit
/
•Update the license as user ‘system’.
