Schemation 'Server' Installation steps.
Schemation has three main components:
 
  tick 1) The 'Server' (which does all the work),
    2) The 'Console/WebApp' (a browser-based interface that Schemation users use to administer their database environments, and
    3) The 'API' (the programatic) interface that provides developers full control over their environment.
 
This page dscribes the steps installing the 'Server' component.

Server Install
Prerequisites
i Oracle Install You will need an Oracle installation (10.2 or higher) and sqlplus.

ii 'SYS' user access You will need to have 'SYS' access to an Oracle 10.2 (or higher) installation. Note: This 'SYS' access is only required once to perform this installation.

iii Downloaded Install file Please visit our partner's website ( HKG Solutions ) to download the installation file.
Overview
iii Five minute install Installation of the Schemation 'Server' component comprises of two simple steps that need to performed by a DBA with appropriate ('SYS' access) privledges:

1. Create two tablespaces for your installation to reside in.
2. Execute a installation scripts as the 'SYS' user and follow the on-screen prompts (an example of which is provided below).

Steps
1 Create tablespaces. Create the following Tablespace using the code provided (which you may modify to suit your requirements). Don't forget to replace <DATA_FILE_HOME> with location where databases datafile are kept.


    CREATE TABLESPACE SCHEMATION
        DATAFILE '<'DATA_FILE_HOME>/SCHEMATION_01.dbf'
        SIZE 300M
        AUTOEXTEND OFF
        LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K
        SEGMENT SPACE MANAGEMENT AUTO;

    CREATE TABLESPACE SCH_TEST_100K
        DATAFILE '<DATA_FILE_HOME>/SCH_TEST_100K_01.dbf'
        SIZE 50M
        AUTOEXTEND OFF
        LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 100k;

    CREATE TEMPORARY TABLESPACE SCH_TEMP
        TEMPFILE '<DATA_FILE_HOME>/SCH_TEMP_01.dbf'
        SIZE 50M
        EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K;


2 Create Repository Copy and unpack the Schemation DEM distribution to your machine.

cp /Release_X_Y_Z.tar.gz /
cd
tar zxvf Release_X_Y_Z.tar.gz
Change to the database directory and log into sqlplus as follows:

cd /release_x_y_z/database
sqlplus /nolog

Run the install Schemation

@install_schemation.sql

Please enter the TNS Service Name...
(e.g. orcl)

Please enter the password of the SYS account for that database:
<password>

Enter the name of the account which is to own the Schemation Environment Manager [SCHEMATION]:
<press enter for default>

Enter the name of the account which is to be the Schemation WWW account [SCHEMATION_WWW]:
<press enter for default>

Enter the name of the account which is to be the Schemation Test account [SCHEMATION_TST]:
<press enter for default>

Enter the name of the account which is to be the Schemation Administration Account [schadmin]:
<press enter for default>

Enter the password for the Schemation Administration Account [change_me]:schadmin
<press enter for default>

"If these accounts already exist on this server, they will all be dropped without further query.
Are you really sure you wish to do this?: (Y/N) [N]:
y

Enter the name of the tablespace which is to hold the Schemation Environment Manager objects:
(e.g. SCHEMATION)

Enter the name of the tablespace which may be used for TEMPORARY storage by Schemation:
(e.g. TEMP)

You get message 'Schemation has now been installed successfully.'