(Show Contents)

Creating the Oracle Database

This section includes the procedure to create Oracle databases from Sybase databases. It covers both Hq and Schema databases.

ARCHIBUS will de-support Oracle8 from 17.2. Use Oracle9 to build the databases.

1. Go to Control Panel->System->Advanced->Environment Variable->New System Variable: set: Name: "NLS_LANG", Value:"AMERICAN_AMERICA.UTF8".
2. Create a UTF8 encoded database on Oracle.

   Note: You choose the custom option to set the UTF8 encoding.

3. Run "afmohq9.bat" file. Change the service name and tablespace datafile name according to the settings on each machine.

   Note: You must comment out the import section in afmohq8.bat, because we want to use an empty database.
   REM imp system/system@hq fromuser=afm_secure touser=afm_secure file=afmohq.dmp log=afm_secure.log
   
   REM imp system/system@hq fromuser=afm touser=afm file=afmohq.dmp log=afm.log

4. Create a new Oracle project in ARCHIBUS. On the Database section on the New Project dialog in ARCHIBUS, select Oracle from the Engine Type list.
5. Run the Database Update Wizard by using all of the default options. Select:
   Source: HQ Sybase project;
   Destination: the new Oracle project.
6. Open ARCHIBUS. Go to System Management->Schema->Define-> Execute all of the tasks from "Update Space Management SQL Views" to the end.
7. In ARCHIBUS, go to File->Run Basic Script-> Browse to: /Schema->Common->Hotlschg.Abs.
8. In ARCHIBUS, go to File->Run Basic Script-> Browse to: / Schema->Oracle->Rmvals.Abs.
9. Optionally, you can verify the correctness of your database: In ARCHIBUS, go to File->Run Basic Script-> Browse to: / Schema->System->Comparator50.abs to compare the ARCHIBUS data dictionary to the actual physical database. .

   Three versions of the .abs ship with ARCHIBUS in the folder: …\Afm18\Schema\System\

   • Comparator50.abs
   • ComparatorMSSQLSvr50.abs
   • ComparatorOracle50.abs
10. In ARCHIBUS, go to File->Run Basic Script-> Browse to: / Schema->Common->Recount.Abs. This will give a summary for the record count of the Sybase and Oracle databases. Compare the record numbers for each table in the two databases.

    The acceptable differences include:

    • One more view in Oracle: rmvals
    • One more record in afm_tbls (for the rmvals SQL View “table”)
    • Six more records in afm_flds because of rmvals
    • Ten less records in afm_hotlist table

11. Create an Oracle dump (*.dmp) file, by running "afmohq_exp.bat."