(Show Contents)

Setting Up the Database Server Computer (Oracle)

Database Server: Install Oracle

On the database server computer, install Oracle by consulting your Oracle documentation.

Database Server: Upload the Project Database

Once you have the server installed, you need to create the Oracle tablespace, and upload a database containing the ARCHIBUS schema.

An overview of this three-step procedure is described below. This overview section describes how to load a new project into an Oracle 9 database. Later in the text, specific instructions are provided for loading the files appropriate for Oracle 9i, 10, and 11.

Also provided are specific instructions for loading a file containing the ARCHIBUS sample data project, or a blank file ready to accept the data for your site.

File Locations:

The databases and the script files referenced below are located on your release DVD

Files for loading the sample HQ project are in the in the \databases\oracle\hq folder

Files for creating new projects from a blank schema database are in the \databases\oracle\schema folder
:

To upload the project database:

1. Edit the appropriate permissions script file (afmoscm_perm9.sql)
2. The script then creates the tablespace -- the disk area in which the ARCHIBUS database will store its data. You will have to change the database credential name and path name to suit your installation.
3. The script uses the database credentials to log into the database's administrator account. The script creates the default accounts that the ARCHIBUS program uses, namely AFM and AFM_SECURE. It also grants resources and roles.
   
2. Edit the appropriate batch file (afmoscm9.bat) for importing the .dmp file. You will need to change the database credentials.
3. The batch file executes the permissions script file using Oracle's sqlplus System/Manager program. The batch file then imports the ARCHIBUS schema and data using Oracle's imp.exe program.
4. The .dmp file was created with a user-level export of the ARCHIBUS sample database from user AFM. Similarly, the batch file imports this script to the user account AFM.
5. The log files are created to record what has been imported.
   sqlplus system/system@trihq
imp system/manager fromuser=afm_secure touser=afm_secure
file=afmscm.dmp log=afm_secure_scm.log
imp system/manager fromuser=afm touser=afm
file=afmscm.dmp log=afm_scm.log
   
3. Run the batch file (Afmoscm9.bat) to upload the sample HQ project. The import may take about 30 minutes.

Using the Oracle Administration Tools

If you prefer, you can use the Oracle administration tools rather than the batch file to execute the permissions script file and load the ARCHIBUS .dmp file. To upload the project using these tools:

1. Use the Oracle SQL*Worksheet to execute the script file.
2. Use the Oracle Data Manager to import the .dmp file.
3. Perform a Full Database Import to import the objects owned by the user AFM and the objects owned by the user AFM_SECURE.
4. Enable the options for Grants, Rows, and Indexes.

The following section walks through the details of the three steps for loading the sample project and for loading a blank project. To proceed, choose one of the following methods.

Uploading the HQ Sample Project

The AfmoHq.dmp file contains sample data for demonstrating, evaluating, and training ARCHIBUS. To load this project:

1. Edit the AfmoHq_Perm9.sql file.
2. Change the System/Manager parameter to the username and password of your administrator account.
3. Modify the data file pathing directory, if required. Change C:\Afmxx\Projects\Hq to the actual location of your Oracle data file. This directory should already exist because the ARCHIBUS installation program creates it during the installation process.
2. Edit the AfmoHq9.bat file to change the System/Manager parameter to the username and password of your administrator account.
3. Execute the AfmoHq9.bat file at the operating system command line.

Uploading a New Project

The AfmoScm.dmp file contains a blank project database for starting your own new project. To load this project:

1. Edit the Afmo_Perm9.sql file.
2. Change the System/Manager parameter to the username and password of your administrator account.
3. Modify the data file pathing directory. Change C:\Afmxx\Project\HQ to the actual location of your Oracle datafile. This directory should already exist because the ARCHIBUS installation program creates it as part of the installation process.
2. Edit the AfmoScm9.bat file and change the System/Manager parameter to the username and password of your administrator account.
3. Execute execute the AfmoScm9.bat file at the operating system command line.

Oracle TNS Ping Test

To test the server installation, perform the transparent network substrate ping test (the TNS Ping test). This is a low-level test of the connection to the Oracle server.

At a command prompt, type a command similar to the one below. (If you have both the server and client software on the same machine, be certain that you are executing TNSPing.exe from the server directory.)

C:\>TNSPing wgs_DATASERVER_ORCL 5

wgs_DATASERVER_ORCL is the address (the database alias name) and 5 is a small number of pings. Wait a few minutes. The utility will show OK with each ping if the test is successful.

SQL*Worksheet Test

To test whether the database loaded onto the server:

1. Run the Oracle SQL*Worksheet program.
2. Log in with the following parameters. It may take a few minutes to connect.
   Username: AFM
   Password: AFM
   Service: wgs_DATASERVER_ORCL
3. Once connected, try a SELECT statement, like the following:
   SELECT count (*) from afm_flds

Oracle 9i, Oracle 10, and Oracle 11

The previous example details the procedure for loading a project into an Oracle 9 database. To load a project into an Oracle 9i, Oracle 10, or Oracle 11 database you use a different set of files.

As with Oracle 9, the batch file executes the permission script file using Oracle's System/Manager program. This permission script file creates the Oracle tablespace, users, roles, and permissions.

Then, the batch file imports the ARCHIBUS schema and data using Oracle's Import program.

In editing and executing the batch and permission files, keep in mind that for Oracle 10, ARCHIBUS uses the Oracle 9 files. The files for Oracle 9i, 10, and 11 are: